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 – AmeliawpDataTables, 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 #1334087
Data import to wpdatatables
Closed

Comments

  • ccsnjf started the conversation

    Hello,

    I used version 1.7 lightly but not extensively.  One of the deficiencies I thought was an API or GUI to upload additional data rows - additional data - to an existing table. I have a data table which I regularly append new data to and the only way to do this was to interact directly with the MySQL tables.

    Is there any way to upload and append largish data sets (50,000 rows+) and keep appending to them within the plugin itself?

    Thanks

    Neil

  • [deleted] replied

    Hi Neil,

    We do have option to upload data from various sources to MySQL and create table from that data but, at this moment table like that could be updated only from the table editor of our plugin. We do not have option to upload new file to add new data to that table but through Excel like editor you have option to add more than one raw of the data at the same time.

    For 50k+ rows best approach would be to initially upload the data to MySQL with some database management system like phpMyAdmin to reduce some steps in process and prevent possible problems with memory and then create table in our plugin from it which you can update with new data through built in editors 

  • wiredlisa replied

    Is it possible to import data into the wordpress table that WP Tables creates using PhpMyAdmin or one of the available CSV Import Plugins? At a minimum it would be nice if a WP Table Format could be saved and then applied to an imported data table. This would save time and ensure uniformity. Almost all data gets old and has to be updated. Probably 99% of users are having to go thru what are often extensive formatting processes with every update.