Okay
  Public Ticket #2332579
Does wpDataTables support pulling data from a CSV dataset live ?
Closed

Comments

  • Alexander started the conversation

    Hello,

    I have a multiple external CSV datasets endpoints that are updated daily.

    Can your plugin pull data form external CSV URLs, organise, create charts and update charts as soon as data is updated in the endpoint? So that I would have to log in, manually update data and edit the charts.

    In addition to that, I need to be able to reorganise the data, cause some of the data is unnecessary for the charts.

    For now, I am doing all this with google spreadsheet. I'm pulling raw CSV data, reorganise it in a different Sheet and then create charts based on that reorganised data.

    Maybe I could just pull data from that reorganised sheet into your plugin and create charts from that?

    Will it pull new data automatically? For now, in google spreadsheet, I have a script that refreshes my tables and datasets every hour. So my charts always updated.


    Thank you

    Alex

  •  2,572
    Aleksandar replied

    Hello Alex

    Thank you for your interest in wpDataTables.

    Excel and CSV based tables that are linked to an existing data source use the files you upload to ../wp-content/uploads/YEAR/MONTH folder. However, you can use an URL to create tables linked to an existing CSV file if that URL is on the same domain, and you include the full path instead of the actual URL (so /home/www/html.....).

    The charts use the data from existing tables, so whatever the tables are displaying, charts will follow if you enable "Follow table filtering".

    Please note that the plugin stores the table's settings in wp_wpdatatables_columns table in the database, so these changes are highly not recommended:

    • Changing column's name
    • Changing the structure (existing column order)
    • Deleting columns
    • Adding new columns

    If you make any of the changes, your table will break, and you will need to recreate it again.

    There is an option to create tables linked to Google Spreadsheets as well, but the same logic applies regarding changes in the tables.

    If you need to change the data, and keep the columns as they are - you will have no issues with the table(s).

    Kind Regards, 

    Aleksandar Vuković
    [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

  •   Alexander replied privately
  •   Aleksandar replied privately