We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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,576
    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