We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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