Append Data

  • Resolved mcollen

    (@mcollen)


    4 years, 3 months ago

    If your source is an uploaded Excel file, can the new data be added to the file by replacing the old excel file and uploading the new one? Each month I would like to add new data to the table and am wondering the best approach. If I upload a new file will I have to redo an customizations I made to the table?

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    4 years, 2 months ago

    Hello again, and thanks for reaching out!

    All Excel and CSV files need to be on the same server. By default, when you create a table linked to either of these two sources, they are saved in ../wp-content/uploads/YEAR/MONTH/ folder, so if you keep the structure of the file (same number of columns, same order of columns, and same headers of the columns), you would be able to remove the original file, and replace it with another file of the same name.

    In that way, the plugin will only update the data within the file, while keeping its structure and settings intact.

    If you add, remove, rename or reorder columns, there’s a chance the table generated from the file will break. Our development team already made progress with this, so it’s way harder to break the table in this way, but it’s still a possibility.

    Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Append Data’ is closed to new replies.