Import multiple CSV files

  • Resolved StevenW123

    (@stevenw123)


    6 years ago

    Hi Tobias,

    I need to import around 100 tables (CSV files) into my site to replace current out-dated tables. Is there a way to upload all the files into a folder using FTP at the same time instead of having to import/replace each table individually through the Tablepress interface, please?

    Hope all is well for you and your plugin.

    Thanks,
    Steve

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    6 years ago

    Hi,

    thanks for your question, and sorry for the trouble.

    No, sorry, that’s not directly possible. While you can import multiple files at once (by putting them in a ZIP archive and importing that), you can not replace existing tables with that method.

    Regards,
    Tobias

    Thread Starter StevenW123

    (@stevenw123)

    6 years ago

    Hi Tobias,

    Thanks for getting back to me so quickly.

    That’s a pity because that option would be really, really useful. And not just for me, but for anyone with more than one table to update. I hope you might be able to make that feature available at some point.

    Thanks again,
    Steve

    Plugin Author TobiasBg

    (@tobiasbg)

    6 years ago

    Hi Steve,

    the problem here is that it’s not really possible to store the reference of table ID to file inside the CSV file.

    However, all this is already possible in the JSON format. This can store a corresponding table ID inside the file, so that bulk replacing multiple tables at once is possible.

    Regards,
    Tobias

    Thread Starter StevenW123

    (@stevenw123)

    6 years ago

    Hi Tobias,

    Thanks for the extra info.

    Unfortunately, I don’t know anything about JSON. Google shows online resources to convert files for free, but that would take as much time as uploading direct. It’s a pity Excel doesn’t have an option to save in that format. I don’t suppose you know of software that can bulk convert files, please?

    Thanks again,
    Steve

    Plugin Author TobiasBg

    (@tobiasbg)

    6 years ago

    Hi,

    sorry, I’m not aware of a converter for this. JSON is not a fixed format, but more of a description language. So, yes, this might not be directly helpful in your case. Sorry 🙁

    Regards,
    Tobias

    Thread Starter StevenW123

    (@stevenw123)

    6 years ago

    Thanks.

    Plugin Author TobiasBg

    (@tobiasbg)

    6 years ago

    Hi,

    sure, no problem!

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Import multiple CSV files’ is closed to new replies.