Categories
View Replies (3)

Resolved Trouble with CSVI Pro

  1. carlosl
    carlosl
  2. RO CSVI
  3. Thursday, 16 May 2019
  4.  Subscribe via email
Hi!
I have some mistake to export & import my virtuemart products, my website it is in spanish, when i imported a file, this was incomplete to many errors (duplicate entry '0' for key 'primary' , Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=') & he dindt resprect spanish caracter for example this word like alimentación but **** alimentaci?n:****. And how can i expor & import category & products with images?. I hope u can help me to resove. Thank you!

i want to transfert this page [lifemedic.com.mx] category & product to this one [test.healthandhome.com.mx]
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
duplicate entry '0' for key 'primary'

This error means that you are importing an id field with value 0. You have neither posted the debug log or import file to check. If you are using virtuemart_product_id in your import remove that, you should only be using product_sku field. Fields ending with _id are mostly primary key fields and should not be imported. These fields will be managed by database.

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=')

Take a look at Deal with different collations in MySQL document to get details on this error. I think your file may not be UTF-8 encoded. Check your file with CSVI Analyser as explained in the document and see what errors you see in there.
Kind regards,

Tharuna

=========================
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
carlosl
carlosl
Accepted Answer Pending Moderation
And how can i expor & import category & products with images?

BOM (Byte Order Mark) found ??
Data lines have less fields than the header ??
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
And how can i expor & import category & products with images?

Take a look at Import VirtueMart images document to import product with images. For export you need to add file_url(main image) and file_url_thumb(thumb image) field along with other fields to export product images.

For import and export of category take a look at VirtueMart categories document.

BOM (Byte Order Mark) found ??

Your file is not UTF-8 encoded. You need to correct your CSV file. To do that check point 4 of the Troubleshooting import errors document.

Data lines have less fields than the header ??

This error means that the number of header columns is less than the data columns in your import file. This could be a cause of your file not UTF-8 encoded. Check if this issue is also solved once you correct your CSV file using the document linked above.
Kind regards,

Tharuna

=========================
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
  • Page :
  • 1


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