Okay
  Public Ticket #3060132
Automatization
Closed

Comments

  • Miroslav started the conversation

    Dear support,

    is there any option how to update table automatically ? I mean based on time period or change of source file ?

    BR

    Miroslav

  •  1,846
    Miloš replied

    Hi, Miroslav 

    Thanks for this question.

    Yes, if you link a table to a data source, such as Excel, Google Spreadsheet, CSVJson , XML,  a PHP array, or by SQL Query,  the data will be read from the source every time the page loads.

    Important to note that these tables can not be editable from Wp-Admin side, or the front-end, except for SQL tables, they can be editable.

    8521394373.png

    For example , if you create a table linked to an Excel spreadsheet or Google Spreadsheet, in which case the table wouldn't be editable, but once you change the source file, the table will be updated. 

    Excel and CSV files are stored in wp-content/uploads/YEAR/MONTH/ folder, and you would need to replace the file in there, not making any changes to the filename or its structure, so only the data within the cells needs to be changed or updated. 

    As for Google Spreadsheets, when you modify or add new rows, the plugin will show those changes within 15 minutes (since there's cache on Google's side). If you don't want to face any issues with cache, you can use the Google Sheets API method.

    -

    -

    On the other hand, if you use editable tables such as Manual, or SQL tables;  they have an

    auto-refresh interval feature – If set to a value different from 0, tables will auto-refresh after each XX seconds interval.

    1389011707.png

    -

    Let me know how that sounds and if you have any questions. Thank you

    Additionally, I just wanted to point out that we have pages with Demos, that you can use to try out the plugin's features - https://wpamelia.com/demos/

    and there is a 15-day money-back guarantee period, so if you purchase the plugin, you can safely fully test it out,

    we would assist you with our support along the way, and if it doesn't fit your needs you can request and receive a refund in that period.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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