I am trying to import categories to Virtuemart, but I recieve this error:
Duplicate entry 'methanolxx-d4xx' for key 'slug' SQL=UPDATE dev2_virtuemart_categories_cs_cz SET category_name='Methanolxx D4xx',category_description='\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Jméno Methanolxx D4xx
\r\n
*I.E (Isotopic Enrichment) = istop obohac
',metadesc='',metakey='',customtitle='',slug='methanolxx-d4xx' WHERE virtuemart_category_id='170304'
//
Any hint please?
I tried patch from here: https://www.csvimproved.com/forum?view=topic&catid=44&id=32789
But it didn't help.
Hello,
It seems like you are trying to import duplicate slug name in your import file. Which version of CSVI are you using? Can you send the import file used?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
It looks like, but I don't think so.
I have version 6.5.2
I don't want to upload the file here, publicly. If you want, I can send you the file by e-mail and please don't publish it anywhere. Please send me your e-mail, if you agree.
Hello,
Send email to tharuna@csvimproved.com
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Try importing loading the attached patch file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you, it works now.
Just a little note... I am not sure if it's a problem, but it says this:
Import file contains 5312 lines
But when it's done, the result is this:
Processed 357
Shouldn't it be 5312 too?
Hello,
Have a look at the Manage timeouts document as I am sure your server won't be importing over 5000 records within 30 seconds :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you for your suggestion.
I set number of lines to 200. But nothing changed. The import is fast and at the end it always says Processed 357.
Import was slow first time, but I guess that now it"s not really importing, because everything is the same. I don't know.
Hello,
Can you post or send in a private message the debug log of your import?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Your csv file has content till 5312 lines and so you are seeing that count but the actual number of category records are only 357. Please check into your categories, all are imported till the end and there is no problem at all.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
You are absolutely right. I didn't realize, that there are more lines then categories.
Thank you.
Log in to reply to this topic.