I created a data table manually. it was inserted into the webpage shown in the link above.
I want to upload more data to the table. how do i do that? I don't want to enter the data one row at a time. I prefer to upload data set which is in an excel file or the like.
If you want to bulk update the table you need to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from the Excel file.
If you need to make bigger changes to the table often we would suggest creating a table linked to an existing file.
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 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 file in there.
I hope this helps, do let us know if you need any further assistance.
help.
http://iptat.com/to37-rtc-t1-roa-due-pat-new/
I created a data table manually. it was inserted into the webpage shown in the link above.
I want to upload more data to the table. how do i do that? I don't want to enter the data one row at a time. I prefer to upload data set which is in an excel file or the like.
Hi James
Thank you for reaching out to us.
If you want to bulk update the table you need to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from the Excel file.
If you need to make bigger changes to the table often we would suggest creating a table linked to an existing file.
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 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 file in there.
I hope this helps, do let us know if you need any further assistance.