Just find a bug in the Excel-like view. I have a table with some editable columns. In the standard view, I can edit it both in back and front end. However, if I switch to an Excel view (both in back or front-end), editing the same column gives me an SQL syntax error. This means the Excel-like view version generates another (errored) SQL statement, despite in your documentation states that the two views "are equivalent," and the "data are the same". Any explanation / solution?
I am confused. Is it another way to edit in Excel-view than inline? In the same comparative table "simple" editing is supported. What is the difference? Is editing possible in front-end Excel-view at all? How? And what else the reason of an Excel like view could be than EDITING? In your tutorials the main reson for its creating was the batch editing/deleting. In fact, there are tons of links and tutorials which present how to EDIT tables in Excel view, just a few here:
All presented by YOUR company. Then you are coming with this comparative list where you deny all these tutorials. Doesn't seems this a flagrant contradiction? Does the left hand know what the right one does?
If you enable "in-line" editing, it will not work in Excel-like tables. However, if you disable that, and just leave the default editing settings it should work correctly.
I just tested one of my tables, though, and editing in Excel-like works regardless of "In-line" editing being enabled or not.
Can you tell me which table we're talking about, so I'll remote in and take a look?
Thanks, Aleksandar! This is the best solution, you have the credentials. The table is CRM. Most simply you could test it in back-end. Edit the first cell in the Notes column in standard view. Will work. If you switch to Excel view, try the same. It will not work.
I can't say what the issue is without taking a look at the database. The part of the documentation I sent you earlier about the limitations of Standard vs Excel-like mentions server-side processing for large tables doesn't work with Excel-like, so this can be the problem. Server-side processing tables work with Excel-like for sure (manual tables are server-side by default), but there's probably something different with server-side tables with a large amount of entries.
Is this a single table from your database, or is it a view that you created?
If it's a single database table, can you export it from there and send it to me? And if it's the view, would you be able to send me the dump of your whole database?
Hi, Aleksandar! The solution works in both back and front end. Thank you! I presume the next update will contain this fix too. Still, I am wondering why till now nobody noticed it.
You're welcome. It will be included in the next update, sure.
There are not a lot of people who use that combination - Excel-like + editing + Separate DB connection. That's probably why it was never reported to us.
Hello,
Just find a bug in the Excel-like view. I have a table with some editable columns. In the standard view, I can edit it both in back and front end. However, if I switch to an Excel view (both in back or front-end), editing the same column gives me an SQL syntax error. This means the Excel-like view version generates another (errored) SQL statement, despite in your documentation states that the two views "are equivalent," and the "data are the same". Any explanation / solution?
Hello Laszlo.
As you can see in our documentation, inline editing is not yet possible with Excel-like editor:
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Welcome back Aleksandar!
I am confused. Is it another way to edit in Excel-view than inline? In the same comparative table "simple" editing is supported. What is the difference? Is editing possible in front-end Excel-view at all? How? And what else the reason of an Excel like view could be than EDITING? In your tutorials the main reson for its creating was the batch editing/deleting. In fact, there are tons of links and tutorials which present how to EDIT tables in Excel view, just a few here:
https://wpdatatables.com/documentation/front-end-editing/excel-like-editor/
https://www.youtube.com/watch?v=C8HuDc-hFOo
https://www.youtube.com/watch?v=UoLLEom2A-g
All presented by YOUR company. Then you are coming with this comparative list where you deny all these tutorials. Doesn't seems this a flagrant contradiction? Does the left hand know what the right one does?
Hi again Laszlo, thanks. Good to be back.
I didn't formulate my answer very well.
If you enable "in-line" editing, it will not work in Excel-like tables. However, if you disable that, and just leave the default editing settings it should work correctly.
I just tested one of my tables, though, and editing in Excel-like works regardless of "In-line" editing being enabled or not.
Can you tell me which table we're talking about, so I'll remote in and take a look?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks, Aleksandar! This is the best solution, you have the credentials. The table is CRM. Most simply you could test it in back-end. Edit the first cell in the Notes column in standard view. Will work. If you switch to Excel view, try the same. It will not work.
Hi again Laszlo
I can't say what the issue is without taking a look at the database. The part of the documentation I sent you earlier about the limitations of Standard vs Excel-like mentions server-side processing for large tables doesn't work with Excel-like, so this can be the problem. Server-side processing tables work with Excel-like for sure (manual tables are server-side by default), but there's probably something different with server-side tables with a large amount of entries.
Is this a single table from your database, or is it a view that you created?
If it's a single database table, can you export it from there and send it to me? And if it's the view, would you be able to send me the dump of your whole database?
Kind regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Sure Aleksandar, I sent it to your private email.
Hi Laszlo
There's a bug when using Excel-Like and a separate DB connection.
Please go to file wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php, and on line 617 replace this:
with this:
It should work fine after that.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Aleksandar! The solution works in both back and front end. Thank you! I presume the next update will contain this fix too. Still, I am wondering why till now nobody noticed it.
All the best,
Laszlo
Hi again Laszlo
You're welcome. It will be included in the next update, sure.
There are not a lot of people who use that combination - Excel-like + editing + Separate DB connection. That's probably why it was never reported to us.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Maybe you should hire me as a tester :)
Yeah, I agree
We have a couple more users for our other plugin - Amelia - that seem to find all bugs in it
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables