WordPress.org

1. Keri Thorpe
   Member
   Posted 9 months ago #
   

   Tobias,

   I need to migrate my site from a local host to a hosting service so I've been reading up on transferring the tables. I have a lot of images linked to URLs so I was hoping to export the table as a CSV file and do a find/replace to update the image file locations. Unfortunately, my export downloads as a CSV.HTML file. I opened it in TextMate and then tried copying and pasting the text into Excel, but the data is not properly delimited.

   I've come to conclusion that I'm going to have to import the dump file of each table and manually change the image file locations; but, I am hoping you have another suggestion.

   Thanks!
   Keri

   http://wordpress.org/extend/plugins/wp-table-reloaded/

2. TobiasBg
   Member
   Plugin Author
   Posted 9 months ago #
   

   Hi Keri,

   thanks for your post.

   This sounds really odd, as I have never received any issues with the *export* of tables to CSV.
   Can you try again by exporting and having the "Download" checkbox unchecked? This should give you a textfield with the table as CSV format. Then copy everything from that textarea into a file on your disk and save that as .csv.

   Also, does the export to HTML and/or XML work? Can you open these files in TextMate? If so, it should be possible to use these files for making the search/replace and then imported the edited files in the new site.

   Regards,
   Tobias

3. Keri Thorpe
   Member
   Posted 9 months ago #
   

   Thanks Tobias! Exporting as an HTML file seems to be the way the go for the data I have in my tables. And yes, the find/replace should work well in TextMate.

   Best,
   Keri

4. TobiasBg
   Member
   Plugin Author
   Posted 9 months ago #
   

   Hi Keri,

   great! That is good news! :-) Thanks for trying this!

   Best wishes,
   Tobias

Reply

You must log in to post.