The input file is updated daily

Hello, Haim
– If you wish to connect the source Excel data to a dataTable in our plugin, and to have the table update with any changes you make on the source Excel file, in that case, you can use this method :

 Create a table linked to an existing Excel file,

if you choose to Create a wpDataTable and upload the Excel file :

 in which case you get to select the file (upload it) that’ll be used to pull the data.

 This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. 

The file on that location can be changed/edited, but the column structure can’t. 

So, if you have the file with the same name,

?the same number of columns, same headers, and the same order of columns – you’d be able to replace the original file with the new file, and wpDataTables would pick that up.

Alternatively, if you select “URL from any domain”

Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file. 

The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,

and when you want to edit the source file,   you don’t have to edit the one that is now in your Media Library folder,

but you can edit on the original source file.

–

Now, depending on how big your data set becomes,
if it becomes more than a couple thousand rows, then you will notice the table become slower on the front-end page,
in this case you can try our caching feature, which can help with loading speed of tables linked to a data source like this.
Please check more about our Caching data and auto-update cache here.

Let us know if you have further questions. Thanks

Thanks! I had created my table from an existing excel file what I had uploaded into my wordpress. It works fine!

How may I modify this uploaded excel file within wordpress? You say “The file on that location can be changed/edited“. – How can this file be changed/edited? Where and how can I access it to add new line every day?

thanks and greetings

Tamás

• This reply was modified 1 year, 9 months ago by Haim.

Hello,
you’re welcome, we are happy to help.
–
In regards to editing the rows on the source file which is connected to the table,
if you uploaded it via WordPress, in that case,
?this file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder.
Find the source file there, and you can add/edit/delete rows,
you can open and edit the file with any Excel Editor software of your choice, and when you save changes, they will reflect the connected dataTable.
Just make sure not to change the structure, such as Header names, reordering columns, adding new column, removing column, or changing file name.
–
But later on, if you wish to use a new file with a different structure,
you can do this from the plugin’s table back-end settings of this existing connected table;
in the “Data source” tab,
you will be able to change the selected “File location”, from ‘WordPress Media Library’ to ‘URL from Any Domain’, and vice-versa;
and you can also change the “Input file or URL” path here,
then if you hit “Save Changes”, a new data source will load and the table will not break.
Let us know if you have any questions.

View post on imgur.com

• This reply was modified 1 year, 9 months ago by wpDataTables.