I have tables created but when I receive new data I would like to upload the document to overwrite the current table instead of creating a brand new table.
To update the table by importing the CSV 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 CSV file in there.
Another option would be to view the table in Excel-like mode in back-end, and then bulk select; copy and paste the data from Excel.
There's no way of updating the existing table by just uploading the new CSV file. The plugin doesn't have those options yet, so updating it through the database, or copying a range of cells into Excel-like view is the only solution for now.
Thank you for responding. That clears it up. Also, is there a way, when setting a URL column that you can embed video or website page in to the column?
You can add iframes to the table by setting the column type to multi-line string and then pasting the iframe code to the row where you want to have it appear.
I hope this helps please don't hesitate to contact us if you need further assistance.
I have tables created but when I receive new data I would like to upload the document to overwrite the current table instead of creating a brand new table.
Hi Nicholas
Thank you for reaching out to us.
Is your table created by importing a CSV file?
To update the table by importing the CSV 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 CSV file in there.
Another option would be to view the table in Excel-like mode in back-end, and then bulk select; copy and paste the data from Excel.
There's no way of updating the existing table by just uploading the new CSV file. The plugin doesn't have those options yet, so updating it through the database, or copying a range of cells into Excel-like view is the only solution for now.Thank you for responding. That clears it up. Also, is there a way, when setting a URL column that you can embed video or website page in to the column?
You are most welcome
You can add iframes to the table by setting the column type to multi-line string and then pasting the iframe code to the row where you want to have it appear.
I hope this helps please don't hesitate to contact us if you need further assistance.