A way to import multiple tables via ZIP and replace existing tables?

  • Resolved dangrimes

    (@damonmaldonado)


    3 months, 4 weeks ago

    Good evening! My client exported their tables to CSV in a zip file. There is around 200 tables. They edited all the tables. If i manually import a table and click “replace existing table”, it replaces the table succesfully (I’m guessing because i can choose which table to replace.

    If i try to import the zip file to “replace existing tables”, and click submit, it says it was uploaded successfully but none of the tables were replaced.

    Is there something I am missing or is there not a way to replace multiple tables at one time on the site and have to do each 1 by 1? Thank you and look forward to hearing from you.

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi!

    Thanks for your post and sorry for the trouble!

    Replacing multiple tables in a ZIP file at once is only possible in two cases:

    1. The export format (and thus file ending) is JSON. (This means that the table ID to use as the table to be replaced is inside the file, thus making it possible to find which table to replace automatically.)
    2. Or, for non-JSON formats, like CSV, the table name (on the “List of tables” screen) exactly matches the full file name of file that is to be imported and used as a replacement. (CSV files only contain the table data, but not the original table’s ID, which is why only that file name and table name can be used to connect file and table.)

    Now, from your description, I unfortunately get the feeling that neither of these cases holds. You are using the CSV format, but most likely the table names are different than the file names.

    You would therefore indeed have to import these one by one, choosing the correct table each time (by the way: You can type into the selection field when choosing the table that is to be replaced, which might speed up finding the right table.). Or, you could edit each table’s “Table Name” to match the file name of the CSV file that you now already have. But this is probably more cumbersome than individual imports.

    Sorry for not having better news here.

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.