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 Aleksandar
I have to assign identification numbers to employees.
To avoid duplicate entries I added UNIQUE constraint to the column containing identification numbers -
ALTER TABLE `dbj66npcuyxch3`.`hr_wpdatatable_14` ADD UNIQUE `din` (`din`);
After that successfully imported over a thousand records into the table (from .sql file). But now it gives "cannot insert new row" error while trying to create a new entry.
This is a known issue in MySQL, but is there a work around it so that I can have the column not allow duplicate entries and the table be able to import multiple records when required?
With Regards
Srinath das
Hello again Srinath
Have you configured that column as a Primary column in the database? And also - have you listed that column as the "ID column for editing" in the "Editing" tab above the table?
The plugin needs to have one primary, auto-increment column so the table can be editable. Importing multiple records can be done either through the database (by importing data into the table), or selecting a range in Excel, and copying over the data in the "Excel-like editor" of wpDataTables.
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