Title: Multiple Table Import
Last modified: January 26, 2018

---

# Multiple Table Import

 *  Resolved [BillyLabs](https://wordpress.org/support/users/billylabs/)
 * (@billylabs)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/multiple-table-import/)
 * Good day Tablepress team (Tobias),
 * I have been using Tablepress for a little project of mine. It contains a few 
   databases that were created via manually from a template of a Tablepress table
   and the import function worked marvelously to have all .json tables imported 
   through a zip file. Kudos to you and what you have offered with Tablepress!
 * I have encountered a minor issue and hope it can be clarified – either I am doing
   it wrong or not fully understanding the capabilities.
 * Assuming that I need to make a bulk modification on all tables. I would expect
   the following:
 * -Export function allowing me to export all Databases as json files. (OK)
    -Performing
   the modification on the json files and add to zip archive. (OK) -Import function
   allowing me a bulk upload of all selected tables within zip archive (Not OK)
 * When choosing a .ZIP file with multiple tables to update – the only functional
   radio button option is “Add as New Table” – which effectively re-creates a new
   set of tables.
 * “Replace Existing Table” would be the option I figure I need but when I choose
   this, the select table option is required (omitting the fact that I chose a .
   zip archive with multiple tables to replace). “Append rows to existing table”
   offers the same scenario and can only be applied for 1 table from the dropdown
   menu.
 * Noteworthy is that if I delete the original tables and upload as new, new table
   id’s are generated from the last generated ID and forces a lot more manual work
   updating the pages (or all db’s to their original ID’s).
 * Am I missing something here or is there another way to update multiple tables
   simultaneously?
 * Thank you kindly in advance,
    -Billy

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/multiple-table-import/#post-9906904)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Indeed, when uploading multiple tables (in a ZIP file), only the “Add new” option
   will work properly. I haven’t yet found a good way to implement the replace and
   append options for the multi-table case.
 * However, with the JSON format, you should actually be able to make the “add new”
   option work, after deleting the tables. With a full JSON file, the table ID from
   the file should actually be reused in that case…
 * Regards,
    Tobias
 *  Thread Starter [BillyLabs](https://wordpress.org/support/users/billylabs/)
 * (@billylabs)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/multiple-table-import/#post-9910727)
 * Hi Tobias,
 * Thank you kindly for your prompt response.
 * Indeed as you mention, the import function works as intended by reusing old DB
   ID’s as long as the old database is deleted, thanks for that.
 * I recall having faced blank import error messages when uploading multiple files
   at the beginning but that was more of an annoyance to not know at which table
   the upload had failed at. I also thought it had generated new tables/ID’s in 
   the same scenario but that turned out to not be the case.
 * I guess my last request – would it be possible for you to consider a more detailed
   error system that would identify at which table the import processed failed rather
   than just saying something along the lines of “Syntax Error – invalid syntax”?
 * Thanks again for all your work on Tablepress!
 * Best regards,
    -Billy
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/multiple-table-import/#post-9910804)
 * Hi Billy,
 * I can try that and will add it to my list of ideas, but I can’t make promises
   that this will be available soon, sorry 🙁
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Multiple Table Import’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 4 months ago](https://wordpress.org/support/topic/multiple-table-import/#post-9910804)
 * Status: resolved