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 #3040313
synchronise with excel
Closed

Comments

  • Pete Stevens started the conversation
    May 9, 2022 at 3:41pm

    Hi, I have been asked to investigate ways of simplifying and speeding up the process of adding and updating data held in wp data tables for display on the http://www.ww1bradford.org/ website e.g table: http://www.ww1bradford.org/those-who-served-and-died/ .

    The site currently uses version 2.0.2 and the purchase code has expired so looking to see if it is worth renewing to get the following functionality.

    The user would like to make changes to the data on an excel spreadsheet locally and then upload this to the server REPLACING the data held in the current associated wp data table thereby automatically update the data displayed on the website. In effect synchronising the excel spreadsheet with the wp data table. 

    As far as I can make out it seems that it is not currently possible to upload replacing a table, it's only possible to upload creating a NEW table.

    Am I correct?... 

    please can you suggest a recommended method, the current method of editing on the website is undesirable especially with the proposed implementation of a new table which will have around 40,000 rows.

    One option if it cannot be done through wp data tables might be to find a plugin that can upload csv format directly into the relevant mySQL table perhaps.

    Thanks

    Pete


  •  2,576
    Aleksandar replied
    May 10, 2022 at 11:17am

    Hello Pete

    Thank you for reaching out to us.

    In order to use a file this big, you would need to import it, and once it's imported, wpDataTables reads the source file and creates a database table that can be edited. However, it cannot be updated by uploading (replacing) the source file since the file was read only at the moment the table was created - it is no longer being used to display the data of the table.

    You're correct that you'd need to create a new table by uploading the modified file in order to see changes. I am not aware of any plugins that would allow you to upload a file and overwrite/add data to the corresponding database table, though.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

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