Categories
View Replies (6)

Resolved exporting/importing all product media in VM3

  1. ptrouw
    ptrouw
  2. RO CSVI
  3. Friday, 06 February 2015
  4.  Subscribe via email
Hi,
Exporting all media works fine using the default example template. With 6 fields.
But I have added, SKU and file_ordering to it, and then it doesn't work any more. It generates a file with rubbish, a kind of html output.
Using these fields.
product_sku
file_type
published
file_url
file_title
file_description
file_meta
file_ordering

If I unpublished SKU and ordering the output is following:
"product";"1";"images/stories/virtuemart/product/audi-a1-11-car-bags-1.jpg";"Audi A1 3d '11- reistassen set";"";"Audi-A1-11-Car-Bags-1.JPG"
"product";"1";"images/stories/virtuemart/product/audi-a1-11-car-bags-2.jpg";"Audi-A1-11-Car-Bags-2";"";"Audi-A1-11-Car-Bags-2.JPG"

The strange thing is, I would expect a similar export layout as the mandatory import file, were I have to use |-sign for multiple images in combination with file_ordering as well. And I need SKU to link to right product!
Hope you clarify this?

PS reading your VM2 explanation, I assume it is still the same?
"product_sku", "file_type", "published", "file_url", "file_title", "file_description", "file_meta", "file_ordering"
"H0123", "product", "1", "hammer.png|hammer2.png", "Hammer|Hammer side", "A great hammer|Side view", "hammer,tool|hammer,tool", "1|2"
0
Responses (6)
ptrouw
ptrouw
Accepted Answer Pending Moderation
Just did this test:
"product_sku", "file_type", "published", "file_url", "file_title", "file_description", "file_meta", "file_ordering"
"H01", "product", "1", "hamer1.jpg|hamer2.jpg", "Hamer een|Hamer twee", "Hamer een groot|Hamer twee rubber", "hamer,tool|hamer,tool", "1|2"

Error message in debug file.
2015-02-06 10:24:11 1 [DEBUG] Constructed file URL: images/stories/virtuemart/product/hamer1.jpg|hamer2.jpg
2015-02-06 10:24:11 1 [DEBUG] File not found: /public_html/images/stories/virtuemart/product/hamer1.jpg|hamer2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 1
ptrouw
ptrouw
Accepted Answer Pending Moderation
Just tested this, and works. Perhaps you hae to update Q&A on this!

"product_sku", "file_type", "published", "file_url", "file_title", "file_description", "file_meta", "file_ordering"
"H01", "product", "1", "hamer1.jpg", "Hamer een", "Hamer een groot","hamer,tool", "1"
"H01", "product", "1", "hamer2.jpg", "Hamer twee", "Hamer twee rubber","hamer,tool", "2"

So only export problem still exist, with 2 additional fields, SKU and Ordering!
  1. more than a month ago
  2. RO CSVI
  3. # 2
ptrouw
ptrouw
Accepted Answer Pending Moderation
One more thing. Title/description/meta is language depended. How can I solve that?
Will all you other import script you can select default and target languages.

I am not sure VM3 is supporting this?

There is a field called file_lang, if your add Languages at the Languages field in the media tab within the administrator, it adds this to the media table: de-DE,fr-FR,nl-NL,en-GB.
But these values, whatever they do, are not language changeable per individual languages. Whatever you put in the backend, it count for all languages.
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

It generates a file with rubbish, a kind of html output.
That sounds like an error in the query. Can you post that file for me to check?

The strange thing is, I would expect a similar export layout as the mandatory import file, were I have to use |-sign for multiple images in combination with file_ordering as well. And I need SKU to link to right product!
Hope you clarify this?
You don't say which import/export routine you are using but the |-sign is only used on the product import/export. The File import does not use the |-sign, to import multiple images with the File import, it is one image per row.

One more thing. Title/description/meta is language depended. How can I solve that?
That is explained in the Setting up a VirtueMart 2 multi-language shop.

Will all you order import script you can select default and target languages.
Can you explain what you are asking here?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
ptrouw
ptrouw
Accepted Answer Pending Moderation
- attached is the output file. I used the default Example export media files template, and added 2 extra fields: sku and file_ordering. Then it stops working.
I just removed the file, to many sensitive information in!

- Your explanation on your website on importing multiple images, is still VM2. That is the place with saw the |-sign, between multiple images. Anyhow I got it to work fine in VM3 now. But perhaps you should explain the VM3 method as well on your site.

- Yes I am working fine with 4 languages. See my other post reply on this topic.

- Spelling mistake :)
With all you other import scripts you can select default and target language. This should also be the case with adding Title/description/meta per language.
But have a look at my other reply, could be that this isn't supported by VM3 yet. Or it isn't clear to me how to use this strange language field which is part of the media tab within the product back end. It saves it data to file_lang field in table vm_medias.
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
I just removed the file, to many sensitive information in!
No problem, I had seen it and I see where the problem is. When you added the product_sku it passes through a section of code that requires the product_id. Apparantly you have records in your media table that have no product ID and that is why it fails. If you load the attached patch file that will deal with this issue of having no product ID.

Your explanation on your website on importing multiple images, is still VM2. That is the place with saw the |-sign, between multiple images. Anyhow I got it to work fine in VM3 now. But perhaps you should explain the VM3 method as well on your site.
There is a mixup I think between 2 different imports. There is the Media import which does not support multiple images on a single row because it is the media import. Each row should contain 1 media item and it's details. The product import does support multiple images on a single row because it is the product that is 1 item per row. In the Media items tutorial it doesn't say anywhere you can use the |-sign to add multiple images on a single row. The Import VirtueMart 2 images tutorial could be clearer that you need to choose the Product import as type and not the Media import.

With all you other import scripts you can select default and target language. This should also be the case with adding Title/description/meta per language.
But have a look at my other reply, could be that this isn't supported by VM3 yet.
Correct, there is no multi-language support for the image data. These fields can be added with both the Media and Product import.
Attachments (1)
patch_media_sku_20150206.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!