Categories
View Replies (2)

Resolved Virtuemart - Categories and CSV Export

  1. smithy73
    smithy73
  2. RO CSVI
  3. Tuesday, 29 July 2014
  4.  Subscribe via email
'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
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
smithy73
smithy73
Accepted Answer Pending Moderation
Excellent - thank you - I was hoping it was as simple as that.

Thank you again.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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