product images lost when moving from vm1 to 2

[jphellemons]

my site was running joomla 1.5.23 and virtuemart 1.x (latest). I migrated to vm 2.0.20 (Because that was the latest version for joomla 1.5.x) and afterwards I used jupgrade to move to joomla 2.5. and i upgraded virtuemart to 2.0.22c (latest) afterwards. I used the db migration option and tried to move all categories, products etc. everything worked nice BUT.... the product images are 'lost'
both in joomla 1.5 vm2 and in joomla (jupgrade) 2.5 with 2.0.22c. The files are in the right folder (images/stories/virtuemart/product/ and jupgrade/images/stories/virtuemart/product/) but there is no reference from the product to the jpg's...
I have no idea how to resolve this...
can someone help me with this last part of the migration?

thanks in advance,
JP

[Maxim Pishnyak]

The more reliable and simple method in your case is to use CSVI Improved:
- export product image data in 2.0.20
- import image data in 2.0.20c

[jphellemons]

Thanks Maxim,

I have installed csvi 1.9.2 on joomla 1.5.23 and vm 2.0.18 but have no idea how to export the product images... could you give me a few pointers?

the new installation has cvsi 5.11 joomla 2.5.14 and vm 2.0.22c

I also have no product images on the old joomla 1.5.23 and vm 2.0.18
I had images before joomla 1.5.23 upgraded from vm 1.x to 2.0.18 and I have found the jpg's.

[Maxim Pishnyak]

I have installed csvi 1.9.2 on joomla 1.5.23 and vm 2.0.18 but have no idea how to export the product images... could you give me a few pointers?

I could help if you say what specific issues you have with tutorials on CSVI Improved web site.

[jphellemons]

well first of all:
http://www.csvimproved.com/csvi-documentation/tutorials/842-export-virtuemart-2-products
requires joomla 2.5, csvi 4 +
and I have joomla 1.5.x and csvi 1.x (Because 5 is not supported on joomla 1.5.x)

so when I click csvi and export I get these two options:
CSVI Product Export
CSVI Product files export
the products are already migrated. it is just the images that are missing (also on the joomla 1.5 and vm 2.0x)

[Maxim Pishnyak]

1. CSVI Product Export
2. CSVI Product files export

1. This is for attaching first image to specific product.
2. For additional images.

You could use as csv delimiters:
^ - for field delimiter
~ - for text delimiter

[jphellemons]

Ok, I did option 1 since we do not have secondary images for products.
Now I have these columns:
~product_sku~^~product_parent_sku~^~category_path~^~product_name~^~product_s_desc~^~product_desc~^~product_price~^~product_full_image~^~product_thumb_image~^~product_availability~^~product_available_date~^~product_currency~^~product_discount~^~product_discount_date_end~^~product_discount_date_start~^~product_packaging~^~product_publish~^~product_special~^~product_tax~^~product_url~

The jpg names are in the CSV! (but do not show up on joomla 1.5, vm 2.x old installation) Thanks for this!! Now my last step is to find out if I have to manually rename columns in the csv to match the fields in csvi 5.

In csvi 5 I went to the process option and manual import -> import -> virtuemart -> product import -> go ->
and there is no 'product_full_image' but there is a field called 'file_url'
what fields are required for the thumbnails and full images? do I need more fields for just the images? and how do I specify the primary key which has to match? or does this feature not merge it, but just add it as new product?

Thanks so far for all the help. I am almost there!

[Maxim Pishnyak]

Ok, I did option 1 since we do not have secondary images for products.

For import you need
0. Have images in target folder of course
1. CSVI Product Medias import (first)
2. CSVI Product Import (second)

Use this for step 2.
~product_sku~^~product_full_image~^~product_publish~

Right, use 'file_url'.

For step 1:
file_url^published^product_sku^file_is_product_image
or
file_url^published^product_sku^file_is_product_image^file_meta^file_title^file_description

Primary key is sku - check your product import settings. Check all available image related import settings btw (and CSVI Improved will create image thumbs for you).

Backup before import.

And..

I have installed csvi 1.9.2 on joomla 1.5.23 and vm 2.0.18 but have no idea how to export the product images... could you give me a few pointers?

I could help if you say what specific issues you have with tutorials on CSVI Improved web site.

What CSVI Improved tutorial wasn't helpful for you?