I try to update the vm slugs with csvi 6.3.0 and vm 3.0.10
The values in my csv file are ignored. I've found this old post:
http://www.csvimproved.com/en/forum?view=topic&catid=24&id=31343
But this is also not working. I've deleted all existing slugs and tried again the import with csvi, but then the new slugs are only numbers like -1, -2, -3,...
How can I update the product slugs?
Best Regards,
Maik
Hello,
As per the debug log there is a column name test in the query which makes query not to work, not sure why this has been used but please check into it.
"UPDATE jhkjso_virtuemart_products_de_de SET product_s_desc='',product_desc='',product_name='12er Pack Wild, Kaninchen mit Erdapfel & Wildbeeren',metadesc='',metakey='',customtitle='',slug='-12',test='' WHERE virtuemart_product_id='117'"
Thank you.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Tharuna,
I've deleted the column test, but the result is still the same. The slugs are only numbers like -1,-2,-3,... and not the values from my csv file.
Any other suggestions?
Best Regards,
Maik
Hello Maik,
Can you please send the new debug log and the screenshot of preview page?
Thank you.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Maik,
Sorry for delayed response but this seems to be a issue from our end and it is being worked out. Please PM us with your site details and we will get it fixed for you.
Thank you.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Maik,
Please try to apply the attached patch file as explained here Updating a patch file to solve your issue.
Thank you.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Tharuna,
thanks for the patch. But the file is not working. I get this error on import:
Fatal error: Can't use method return value in write context in /administrator/components/com_csvi/addon/com_virtuemart/table/productlang.php on line 108
Best Regards,
Maik
Hello Maik,
I have imported your file without a problem on my test system. Can you please load the attached patch file and see if that works for you. If not, please post the new debug log. I have added some more logging in this patch as well, so it should give us a better understanding of what is going on.
Thanks.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
there is no error with this new patch, but the problem is not solved.
If I've slugs, the slugs are not overriden by the new values.
If I delete the slugs in my db and import again, the result is stil -1,-2,-3,...
Attached the last 2 logs. The first with existing slugs in my db, the second without slugs in my db.
Best Regards,
Maik
Hello Maik,
Can you private message or email me login details for Joomla and FTP?
If I delete the slugs in my db and import again, the result is stil -1,-2,-3,...
That is the intriguing part, before the - it should be the product name. I wonder why it doesn't find your slug from the import file, that is what I want to check on your site. Thanks.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Maik,
The issue has been fixed now, the fix will be included in the next release. Thanks for your assistance.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.