1. athenacraftsltdltd
  2. RO CSVI
  3. Thursday, 09 March 2017
  4.  Subscribe via email
I'm trying to import product and category data into a new VirtueMart website. I can import the test product file I'm using but the category file is failing. I've hit a number of similar errors so I've tried clearing down the VM database and removing any duplicates from the csv file but to no avail.

The file is pretty big: deduplicated it still contains over 11000 rows. The error occurs when the import show it has processed 9000 rows.

An error has occured during the import. Below the information received from the server.
Duplicate entry 'Products/Bunting/70mm/Decoration & Embellishments/Bunting' for key 'slug' SQL=UPDATE `#__virtuemart_categories_en_gb` SET `category_name`='Bunting',`category_description`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='Products/Bunting/70mm/Decoration & Embellishments/Bunting' WHERE `virtuemart_category_id`='9557'

I do have a log of this processing but in the interests of corporate sensitivity I'd prefer not to post it on a publicly availble forum. Let me know if you need me to send it over somehow.
Accepted Answer Pending Moderation
Well, I've tried sending by email but the log is massive, even zipped. If you don't receive it can you let me know where I can upload it please?
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hello Ian,
With our email conversation, the issue was because of duplicate slug entries in your database and setting Recreate alias to Yes in your import template settings has solved the duplicate entry error. Please confirm if your issue has been solved.
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. # 22
  • Page :
  • 1
  • 2


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