paul
08-09-2007, 06:53
I have an existing site for which i had to transfer all products images to new bluepark site. I just wanted to share the process of creating image paths as i think others transferring sites will go through this process.
if you have existing image paths for your old site eg http://www.mysite.com/image.jpg or similar path and you have these paths in an excel or csv file first you need to 'grab' the image filename. then you need to append to products/ or products/large/ etc to enter into the new csv file to import.
to grab the image name, highlight the cells containing the old filepath, select the 'text to columns' from the data menu in excel. select delimited and then 'other' and enter the '/' symbol. this splits the filepath text so you can copy the 'image.jpg' filenames.
then enter 'products/' or whatever filepath you want for the new csv import sheet in all cells for a new column in excel. in the next column copy all your image filenames.
then in the next column enter '=concatenate(a1,b1)' to join the text in cells a1 and b1. copy this formula down for all cells. then 'copy' and 'paste special' and select 'values' to paste the new filenames (eg products/image.jpg) into a new column. this is then ready to enter into your new csv file to import
this saves anyone thinking they need to write new filepaths from scratch!
if unclear let me know and i can edit to make clearer
if you have existing image paths for your old site eg http://www.mysite.com/image.jpg or similar path and you have these paths in an excel or csv file first you need to 'grab' the image filename. then you need to append to products/ or products/large/ etc to enter into the new csv file to import.
to grab the image name, highlight the cells containing the old filepath, select the 'text to columns' from the data menu in excel. select delimited and then 'other' and enter the '/' symbol. this splits the filepath text so you can copy the 'image.jpg' filenames.
then enter 'products/' or whatever filepath you want for the new csv import sheet in all cells for a new column in excel. in the next column copy all your image filenames.
then in the next column enter '=concatenate(a1,b1)' to join the text in cells a1 and b1. copy this formula down for all cells. then 'copy' and 'paste special' and select 'values' to paste the new filenames (eg products/image.jpg) into a new column. this is then ready to enter into your new csv file to import
this saves anyone thinking they need to write new filepaths from scratch!
if unclear let me know and i can edit to make clearer