Okay
  Public Ticket #3316720
refreshing data in manual table on a schedule
Closed

Comments

  • Stephen started the conversation

    I have a table which was created by a csv import. Is there a way to have that table automatically refresh from the csv file on a schedule? 

    Reading from csv is so slow. I do have caching on but it did not seem to make a difference. Im hoping to automatically/on a schedule "replace rows with source data" 

    Attached files:  2023-03-16 10_24_09-Window.jpg

  •  1,688
    Miloš replied

    Hi ,Stephen.

    1. When it comes to updating existing Manual Tables by uploading an updated CSV file to 'replace rows with source data',

    at the moment, we don't have any automated way to schedule the upload of the file,

    this process can only be done manually by user action.

    It is an interesting idea for a future option, though.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.



    2. The only alternative method i can think of, for this kind of use-case,

    and this only works if you don't have "too many rows"/ too large of a data set ( approximately less than 6 thousand rows);

    you could try to link the source CSV file to a table in our plugin,

    and activate our Cache and Auto-Update Cache option,  which helps with performance for non-server-side tables like that;

    Then with a cron job you can set up the time interval in which our plugin is going to pull any editing you do on the source file.

    But the limitations here are :

    1. As mentioned, the data set can't become too large, depending on the server performance, and the PHP limits that are set on it, approximately if it gets over 6 thousand rows, the page could become very slow or unresponsive


    2. Or, if you change the data structure on the source file;

    • Changing the column’s name,
    • Changing the column’s order,
    • Deleting the column, and
    • Adding a new column.

    then the connected table would break and you would have to make a new linked table.

    -

    Those are the current possibilities with our plugin's capabilities.

    Let me know if you have any questions.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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