I downloaded your plugin, and I saw how to create a database table from an excel file. I couldn’t find how to add new data to an existing table by importing an excel file. Is there any way I can do it with your plugin? Or do you know any other way to do it?
What I’m trying to do is adding data to the database table from a new excel file. So if I have an existing table with 3 records, when I upload 3 rows from a new file, I’m expecting to see 6 rows in the database table.
So far, I cannot do that because if I upload a new file, it overwrites the previous records.
Sorry for not responding but our working time is from 10:00 to 17:00 CET not including weekends.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
I logged in successfully and I can see what is the "problem".
When you are importing the excel file and creating table 9 the third option from the table wizard) the table will be saved in the database. After that the table in the database will not be updated if you add a new records in the file or if you import another excel file, that data will be overwritten.
When the table is created for the first time, that settings are applied and that data is saved in the database, the only opinion to add more data is to use our editing function where you can add , edit and delete the data from the plugin page. Importing the new file will cause the "issue" like you have below and unfortunately this is how our plugin is working at the moment.
We have a plan to change this logic so when you update the new file the table in the database will be updated also.
Hi,
I downloaded your plugin, and I saw how to create a database table from an excel file. I couldn’t find how to add new data to an existing table by importing an excel file. Is there any way I can do it with your plugin? Or do you know any other way to do it?
Thanks,
Michael
Hi Michael,
Thank you for your purchase.
You can take a look at our documentation where you can see how you can make editable tables from imported excel files.
Best regards.
Kind Regards,
Miloš Jovanović
[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 Bogdan,
thank you for your quick answer.
What I’m trying to do is adding data to the database table from a new excel file. So if I have an existing table with 3 records, when I upload 3 rows from a new file, I’m expecting to see 6 rows in the database table.
So far, I cannot do that because if I upload a new file, it overwrites the previous records.
Michael
Hi Bogdan,
any news?
HI Michael
Sorry for not responding but our working time is from 10:00 to 17:00 CET not including weekends.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[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 Michael,
I logged in successfully and I can see what is the "problem".
When you are importing the excel file and creating table 9 the third option from the table wizard) the table will be saved in the database. After that the table in the database will not be updated if you add a new records in the file or if you import another excel file, that data will be overwritten.
When the table is created for the first time, that settings are applied and that data is saved in the database, the only opinion to add more data is to use our editing function where you can add , edit and delete the data from the plugin page. Importing the new file will cause the "issue" like you have below and unfortunately this is how our plugin is working at the moment.
We have a plan to change this logic so when you update the new file the table in the database will be updated also.
Best regards.
Kind Regards,
Miloš Jovanović
[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 Bogdan,
I really need to update database data in this way. Could you tell me where I can find the function to create a table so I can edit it by myself?
Thanks,
Michael
Hi Michael,
You can take a look at our documentation where you can see how you can make editable tables from imported Excel, CSV and Google Spreadsheet files.
Best regards.
Kind Regards,
Miloš Jovanović
[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