'evening all,
CSVI: 5.18
Virtuemart: 2.9.8.a
Joomla: 3.3.3
PHP: 5.3.28
I've searched, prodded, poked, reset, reinstalled - and read - but please if I've missed a link somewhere please let me know.
Two different bits:
Importing categories.(book9.csv)
I've read bits and pieces (including the category tut) to no avail - trying to see what I'm messing up.
When I import the attached file without the category column - the products import fine. When I add the category_path or category_name the import fails with an error 1 Failure with the category Unsupported.
CSV Export - product_export(3).csv
The csv file attached is the result of exporting the default "Example Virtuemart Product Export" with export type set to CSV I was hoping to get the product list exported to see if helped answering my other issue.
Quite simply CSVI remains a staple as far as any installs I do - keep up the great work!
Thank you in advance
Hello,
That is a funky export but looking at it I can see what the problem is as there is an error in the file
Error: 1054 Unknown column 'jos_virtuemart_product_customfields.custom_value' in 'on clause' SQL=SELECT `jos_virtuemart_products`.`product_sku`
FROM `jos_virtuemart_product_customfields`
LEFT JOIN `jos_virtuemart_customs` ON `jos_virtuemart_customs`.`virtuemart_custom_id` = `jos_virtuemart_product_customfields`.`virtuemart_custom_id`
LEFT JOIN `jos_virtuemart_products` ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_customfields`.`custom_value`
WHERE `jos_virtuemart_customs`.`field_type` = 'R' AND `jos_virtuemart_product_customfields`.`virtuemart_product_id` = '1'
GROUP BY `jos_virtuemart_products`.`product_sku`
The problem is that you are using an unsupported and unofficial release of VirtueMart. Version 2.9.8a has incompatible changes compared to the 2.6.6 release. There are a bunch of changes that needs to be done to make CSVI work with that release because they renamed some core table fields. The plan is to have that in the next release even though 2.9.8 isn't released then and hoping not more things change ;)
As it stands, you can only use version 2.6.6 at the moment since that is the latest official release.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Excellent - thank you - I was hoping it was as simple as that.
Thank you again.
Log in to reply to this topic.