Multiple Table Import

  • Resolved BillyLabs

    (@billylabs)


    6 years, 10 months ago

    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 TobiasBg

    (@tobiasbg)

    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

    (@billylabs)

    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 TobiasBg

    (@tobiasbg)

    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.

Tags