Categories
View Replies (4)

Resolved Multi-language shop and import products

  1. fraucci
    fraucci
  2. RO CSVI
  3. Thursday, 26 March 2015
  4.  Subscribe via email
Hello, when I import the products in multi-language shop and site, the data of the products are not imported but the products are created correctly.
In the list of products of Virtuemart, in the name field, it says:

Language Missing id #product_id


where #product_id is the id of product, all other fields are empty. Where am I doing wrong?


Joomla! 3.4.1
VirtueMart 3.0.4
CSVI Pro Version: 5.20
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Where am I doing wrong?
I need you to post me the debug log and a sample of the file you are importing as requested at the top of the page. Now I can't tell you what is going wrong.
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. # 1
fraucci
fraucci
Accepted Answer Pending Moderation
Here is the log file.
Attachments (1)
com_csvi.log.1427361697.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The log file tells me your import file is pretty strange.

text_enclosure: ç
I doubt that is the text enclosure. Why not use the standard comma or semi-colon as field delimiter and " as text enclosure? Any spreadsheet can deal with that.

CSVI has trouble reading your file as the product SKU looks like this
§SAUCE JAR 140§


The product name for this SKU is added as well:
UPDATE `bonnie_virtuemart_products_it_it` SET `product_s_desc`='',`product_desc`='',`product_name`='§SAUCE JAR 140§',`slug`='sauce-jar-140' WHERE `virtuemart_product_id`='1'
to the Italian language table.

If something is missing, make sure you import the translations for the other languages as well. If you are looking at VM in English and there is no English translation, the missing language is to be expected.
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. # 3
fraucci
fraucci
Accepted Answer Pending Moderation
Yes, the problem was the text_enclosure. I used ç, I have now changed and Use " as text_enclosure and $ as field_delimiter. Strange though, in the past I never had problems using $ and ç. Thanks for the reply.
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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