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 #1962528
Import records to table
Closed

Comments

  •  1
    DEBRA started the conversation

    I have created a wp datatable from a .csv file.  I need to import new records into the table.  How can I do this?

    Clicking "new entry" is not acceptable due to volume and propensity for errors.

    I cannot simply delete and create a new table because the underlying table name in the database is changed.  


  •  2,576
    Aleksandar replied

    Hello Mardeebo.

    Once you create a table by importing an external data source (CSV, Excel, Google Spreadsheet), that data source is being imported and once the operation completes that's all the plugin has to do with the file. It is being stored as a "Manual" table, which you can modify only manually.

    If you wish to have a dynamic table, created from an external data source, you can create it using the first option (Create a table linked to an existing data source). You wouldn't be able to edit the table from the plugin, but only modifying the source file. Also, if you use the source file located on your desktop - the plugin will make a copy of it in your media library, and will not use the file from the desktop. So, let's say you use the file from your desktop. In order to change the table in the plugin, you would have to open the file located in ../wp-content/uploads/YEAR/MONTH.


    Please note: Once you create a table from a CSV file, changes in this file like:

    • Changing the column’s name,
    • Changing the column’s order,
    • Deleting the column, and
    • Adding a new column.

    are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.

    So, you can add content to existing columns, but not anything mentioned above.

    Best regards.

    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