[Plugin: WP-Table Reloaded] Change URLs within tables

  • Resolved rjh4242

    (@rjh4242)


    13 years, 11 months ago

    I’ve just put my website live, which has involved changing the url. I used SCR to change all the URLs in a database backup and imported the changed database backup. It worked for everything except the wp-table-reloaded tables containing images. I restored the tables from a wp-table-reloaded dump, so the tables now exist but the images within the tables still point to the images in the old locations.

    I tried dumping all the tables with the wp-table-reloaded dump tool, changing all the urls in the dump and importing the changed dump, but wp-table-reloaded told me the changed dump file was empty.

    Is there any way I can globally change the url for all the images at once, or am I going to have to go in and change each one by hand (200+ images…)?

    All suggestions welcome.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    unfortunately, there’s no such possibility at the moment ??

    This basically is a result of the data format that is used for storing the tables (so-called serialized arrays). That format stores the length of the content in each string (which it later needs to “read” the content), and exactly that length changes when you do a search and replace. Thus, the data can not be read from the database or dump file, which results in those error messages.

    The only chance to change those URLs are to either manually do it (e.g. by using the search in the browser), or to export each table as CSV, open that CSV file in a text editor (like Notepad), do the search and replace there and then re-import the CSV file.
    I know that this is kind of unsatisfactory, but unfortunately I learned about this drawback of the used data format too late, so that I now can’t really change it ??

    Regards,
    Tobias

    Thread Starter rjh4242

    (@rjh4242)

    Thanks for such a prompt response, Tobias. I had a nasty feeling that was the situation, having read your documentation and some of your other posts, but I was hoping there might be something I’d overlooked. I will try the export to CSV approach, as each table has several images in it, so it will probably be the fastest method.

    In any case, I’d like to thank you for such a great plug-in – it has been a life-saver on this website I am building.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    good to hear that you like the plugin – and sorry for this extra work with the exports/imports.

    Best wishes,
    Tobias

    I have exactly the same situation, so I have to change all those links manually 80 Tables in 5 languages and lots of images ?? (I was yelling at you in twitter today to ask the same that rjh4242).

    Tobias the Plugin is really great!!! Any preference on the Amazon Wish List? (I mean in priorities)

    I just found a little firefox addon that is called FoxReplace it works fine since is only a change of a URL, it acts like the wordprocessors.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Victor,

    nice that you found that addon. That’s a really nice idea, I will have to keep that in mind, so that others with the same problem can benefit from it. Thanks!

    For my wishlist: No, I don’t have any preferences there. I like to be surprised ??

    Best wishes,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Plugin: WP-Table Reloaded] Change URLs within tables’ is closed to new replies.