Resolved Error when importing using 6.1

Hello,

After updating CSVI, you also need to update the VirtueMart plugin as there is a new version of that as well. That will fix the issue.

Hello now i got this error

Duplicate entry 'Size-product-com_virtuemart-import' for key 'component_name_table' SQL=INSERT INTO `qjniw_csvi_availablefields` (`csvi_name`,`component_name`,`component_table`,`component`,`action`) VALUES ('Size','Size','product','com_virtuemart','import'),('Size','Size','product','com_virtuemart','export'),('Fitting','Fitting','product','com_virtuemart','import'),('Fitting','Fitting','product','com_virtuemart','export')

also i'm trying to get backup for the templates and i got this error

Unknown column 'section' in 'field list' SQL=SELECT `name`,`action`,`ordering`,`plugin`,`plugin_params`,`section` FROM `qjniw_csvi_rules` AS `r` LEFT JOIN `qjniw_csvi_templatefields_rules` AS `t` ON `t`.`csvi_rule_id` = `r`.`csvi_rule_id` WHERE `t`.`csvi_templatefield_id` = 61

Hello,

Duplicate entry 'Size-product-com_virtuemart-import'

This means you have custom fields in VirtueMart with the same name. Is there a reason to have the Size field more than once?

also i'm trying to get backup for the templates and i got this error

That has been fixed in this thread.

i have an old one with the same name and i already delete it but with the same error

what i notice that the first product is imported but when try to import the second product i got this error

You only have 1 custom field called Size now? If you run the Update available fields, you get the same error?

Edit: I see you posted a second time. Which error do you get running the import?

Ok here is the final states that i have
i delete all the products make sure that i have only one custom field called size run the Update available fields with no error
but when i try to start the import i got this error

Duplicate entry 'Size-product-com_virtuemart-import' for key 'component_name_table' SQL=INSERT INTO `qjniw_csvi_availablefields` (`csvi_name`,`component_name`,`component_table`,`component`,`action`) VALUES ('Size','Size','product','com_virtuemart','import'),('Size','Size','product','com_virtuemart','export'),('Fitting','Fitting','product','com_virtuemart','import'),('Fitting','Fitting','product','com_virtuemart','export')


back to the product page i notice that only one product imported
attache the log
and a sample from my csv file

witting for your kindly help

Hello,

With your file I was able to reproduce the error you see and created a fix for it. You can load the patch file and after that the import will continue.

One more thing, for the child products you should not fill the multi_variant_title and multi_variant_fields fields. See the documentation for importing multi variant custom field for more information.

Thanks for your help this solve the problem

Hello,
it's long time but after i apply your patch i can't import the multi vernti values

If you updated to CSVI 6.1.2 please do not use this patch above because it is old. You can use this patch.

so if i already apply the old one can the new one fix it ??

The old one should be reverted, easiest is to install CSVI again via the Extension Manager and then apply the patch.