I am making a CSV file table. The table is updated once each minute via FTP.
If I use "Create a data table linked to an existing data source" the table works at first but fails when the file updates.
We do not have a static header on our CSV file, just raw data, perhaps this is the issue. I don't believe it is possible to have a static header on our file type.
I also believe that's what's causing the issue. When you create a table linked to the CSV file, the structure of the table is saved in wp_wpdatatables and wp_wpdatatables_columns database tables. So, if the source file changes the structure (adds, removes, renames or rearranges column headers), the table created in wpDataTables will break.
Tables linked to an existing data source need to have static headers in order to work.
I am making a CSV file table. The table is updated once each minute via FTP.
If I use "Create a data table linked to an existing data source" the table works at first but fails when the file updates.
We do not have a static header on our CSV file, just raw data, perhaps this is the issue. I don't believe it is possible to have a static header on our file type.
Hello Jim
Thank you for your purchase.
I also believe that's what's causing the issue. When you create a table linked to the CSV file, the structure of the table is saved in wp_wpdatatables and wp_wpdatatables_columns database tables. So, if the source file changes the structure (adds, removes, renames or rearranges column headers), the table created in wpDataTables will break.
Tables linked to an existing data source need to have static headers in order to work.
Kind Regards,
Aleksandar Vuković
[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