Title: Replace or update multiple tables
Last modified: August 21, 2016

---

# Replace or update multiple tables

 *  Resolved [alasitis](https://wordpress.org/support/users/alasitis/)
 * (@alasitis)
 * [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/)
 * Hi,
 * I have over 100 Excel tables that I converted to .csv and imported to Table Press.
   The tables are linked in Excel so any changes I make can effect many tables. 
   Most were imported as a .zip file using “Add as new table.” They all work and
   display perfectly. But I can’t see how to update them efficiently.
 * I installed the “Table Auto Update” extension but none of the preset time intervals
   work for me. Also, since there is no “Select All – Un-Select All” Auto Import“
   Active” buttons option, I would have to select or un-select almost 100 buttons
   individually each time I want to turn them on or off. (I don’t want them to be
   updated when I haven’t made any changes.)
 * What I need is a way to update or replace all of the tables at the same time 
   whenever I have made changes in them — which could be anytime from one day to
   one month or whenever. Importing a .zip file with all of the tables would work
   if there was an option to replace all of the tables included in the .zip file.
   Is that possible?
 * As always, any help will be greatly appreciated.
 * Thanks,
    Alasitis
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

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

 *  Thread Starter [alasitis](https://wordpress.org/support/users/alasitis/)
 * (@alasitis)
 * [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/#post-4958852)
 * Hi again,
 * Is there a way to “Select All” and “Un-Select All” Auto Import “Active” buttons?
   If so, that would work for me.
 * As always, any help will be greatly appreciated.
 * Thanks,
    Alasitis
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/#post-4958865)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Yeah, bulk-updating tables from a ZIP file would be super cool, but unfortunately,
   that is harded to implement than I thought. The problem is that there’s no direct
   way to determine which file should replace which table, except maybe if the plugin
   tries to determine the target table ID from the file name of the CSV files in
   the ZIP file — which is not that reliable though.
 * So, the Auto Import Extension should be the best way to bulk-import tables for
   you here.
    Unfortunately, there’s no “Select all”/”Un-select all” button yet (
   good idea though, I’ll try to add one in the future), but there are some simple
   JS commands that you can use to do this: In your browser, while being on the “
   Import” screen of TablePress, open the JavaScript console (in Chrome that’s as
   easy as pressing “Ctrl+Shift+J”), and then type/paste in
 *     ```
       jQuery('.cb_auto_import').prop('checked', true);
       ```
   
 * to check all checkboxes. A value of `false` instead of `true` would uncheck all
   of them.
 * Regards,
    Tobias
 *  Thread Starter [alasitis](https://wordpress.org/support/users/alasitis/)
 * (@alasitis)
 * [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/#post-4958916)
 * Perfect! Well almost perfect.;-) It works and that’s what matters. Perfect will
   be a “Select all”/”Un-select all” button but that is not a major issue.
 * I’m using Firefox and Firebug and the jQuery command works.
 * Thanks Tobias,
    Alasitis
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/#post-4958917)
 * Hi,
 * very nice! Great to hear that the JS command will work as a workaround for now!
   🙂
    I’ll then add a “Select all” button for an upcoming version of the Extension
   soon.
 * Best wishes,
    Tobias

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

The topic ‘Replace or update multiple tables’ 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/)

 * 4 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/replace-or-update-multiple-tables/#post-4958917)
 * Status: resolved