Replace or update multiple tables

  • Resolved alasitis

    (@alasitis)


    9 years, 10 months ago

    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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter alasitis

    (@alasitis)

    9 years, 10 months ago

    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 TobiasBg

    (@tobiasbg)

    9 years, 10 months ago

    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

    (@alasitis)

    9 years, 10 months ago

    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 TobiasBg

    (@tobiasbg)

    9 years, 10 months ago

    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.