[Plugin: WP-Table Reloaded] Data Export

  • Resolved tfx2010

    (@tfx2010)


    15 years, 6 months ago

    Hi,

    I recently moved my WordPress site from my Mac OS X to Windows XP and before my site url was http://localhost:8888 on Mac and now is just http://localhost.

    After exporting the WP-Table Reloaded dump file from plugin options from my Mac, I viewed the dump file and noticed that it had the path http://localhost:8888, which is not correct as it now in Windows cannot find my images within the table cells.

    What is the best way to get the new path of just http://localhost reflected within the WP-Table Reloaded dump file as unfortunately editing the file manually causes the file to be invalid during an import?

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Tobias Bäthge

    (@tobiasbg)

    15 years, 6 months ago

    Hi,

    you mean that you have that URL as part of the cell content, e.g. in HTML for links and images?

    Then, yes you are correct, you must not change or edit the Dump File as that will corrupt the file.

    Your only chance is to manually edit the wrong URLs in your tables or to export each one as a CSV file, edit that CSV file (which will not get invalid by that) and then re-import the CSV file.
    I know, this procedure s*cks and is a lot of work, but unfortunately I don’t see a way around it 🙁 It is a result of the data structure I chose for the storing of the tables, when I first developed the plugin. This problem is one of the drawbacks of that data structure, but unfortunately I also only learned about it when it was too late…

    Best wishes,
    Tobias

    Thread Starter tfx2010

    (@tfx2010)

    15 years, 6 months ago

    No worries Tobias – that is exactly the problem I was having, i.e. within the cell.

    I tried updating the the wp_options table.option_value via phpMyAdmin and to no avail.

    Will do as you suggested.

    Thanks for getting back to me.

    Regards.

    Tobias Bäthge

    (@tobiasbg)

    15 years, 6 months ago

    Hi,

    sure, you are welcome.

    And yes, manipulating the wp_options table.option_value has the same effect as editing the Dump File: It corrupts the data.
    (That is the drawback of the mentioned data structure, that I was not aware of when choosing it.)

    Best wishes,
    Tobias

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

The topic ‘[Plugin: WP-Table Reloaded] Data Export’ is closed to new replies.