[Plugin: WP-Table Reloaded] Import CSV to DB

  • Resolved pleasereplyme

    (@pleasereplyme)


    15 years, 1 month ago

    Hi Tobias,

    Thanks for coding this brilliant plugin.

    To import a CSV file to the DB using WP-Table Reloaded, is there other ways beside going to WordPress WP-Table Reloaded Tools – Import a Table page?

    I’ve a WP Upload Public Form that allows users to upload a CSV file into the server, and after that, I would like call your import function in the background and convert that particular CSV and import it into the DB.

    Alternatively, after the CSV file has been uploaded. The user has to click on a hyperlink e.g (www.abc.com/YourTableReloadedScript.php?CSV=TheNewUploadedCSVFilePathNameFile.csv), thus the CSV is imported to the DB.

    Hope you can give me some solutions!

    Thanks once again,
    Tommy

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 1 month ago

    Hi Tommy,

    thanks for your post.

    Unfortunately, I have bad news 🙁 There’s no possibility at the moment to trigger an automatic import of a CSV file. It can only be done manually from the WP-Table Reloaded Import screen.

    Regards,
    Tobias

    Thread Starter pleasereplyme

    (@pleasereplyme)

    15 years, 1 month ago

    Thanks Tobias for your reply. : )

    I’ll look for other solutions/plugins if they have such features!

    Take care!

    Cheers,
    Tommy

    Thread Starter pleasereplyme

    (@pleasereplyme)

    15 years, 1 month ago

    Hi Tobias,

    Quick one.
    I couldn’t find the tables created via your plugin in my MySQL – (view via mysqladm)

    Anyway, idea why?

    Thanks,
    Tommy

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 1 month ago

    Hi Tommy,

    the tables are stored as serialized strings in the “wp_options” table, with names starting like “wp_table_reloaded_data_…”.
    The plugin does not use its own database table, but existing WordPress Options API.

    I strongly discourage editing the database fields though, as the serialized strings will likely be corrupted (a known drawback of the format).

    Regards,
    Tobias

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

The topic ‘[Plugin: WP-Table Reloaded] Import CSV to DB’ is closed to new replies.