I am looking for a Wordpress plugin that will allow administrator to import an Excel (.xlsx) file into an existing custom database table. Please confirm that this is part of the wpDataTables feature set. Also, please let me know if you offer a trial version before I commit to purchasing the software.
Did you create a table linked to an existing file or did you import the data/manually created the table?
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the source file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new source file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original CSV file.
We have Lite version of wpdatatables which you can try for free.
wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
We don't have a free trial, and if Lite version don't have features that you need from premium, but we do have 15-day money back guarantee. So if you purchase our plugin, and it doesn't fit your needs you can request and receive a refund in that period of time.
Dear Sir/Madam,
I am looking for a Wordpress plugin that will allow administrator to import an Excel (.xlsx) file into an existing custom database table. Please confirm that this is part of the wpDataTables feature set.
Also, please let me know if you offer a trial version before I commit to purchasing the software.
Thank you,
Serge
Hi Serge
Thank you for reaching out to us.
Did you create a table linked to an existing file or did you import the data/manually created the table?
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the source file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new source file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original CSV file.
We have Lite version of wpdatatables which you can try for free.
wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
We don't have a free trial, and if Lite version don't have features that you need from premium, but we do have 15-day money back guarantee. So if you purchase our plugin, and it doesn't fit your needs you can request and receive a refund in that period of time.