Categories
View Replies (10)

Resolved No Virtuemart export

  1. peterva
    peterva
  2. RO CSVI
  3. Friday, 31 July 2015
  4.  Subscribe via email
My config: Joomla 3.4.3, VM 3.0.9 and CSVI 6.0.1, the Virtuemart extension + the 6.0.1. example templates

I cannot export Virtuemart products. Whether I use my own template (from CSVI 5) or the example order export template, I get the same error:

Error
Unknown column 'skip' in 'field list' SQL=SELECT `klpd_virtuemart_products`.`virtuemart_product_id`, `klpd_virtuemart_products`.`product_parent_id`, `skip` FROM `klpd_virtuemart_products` LEFT JOIN `klpd_virtuemart_product_prices` ON `klpd_virtuemart_products`.`virtuemart_product_id` = `klpd_virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `klpd_virtuemart_product_manufacturers` ON `klpd_virtuemart_products`.`virtuemart_product_id` = `klpd_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `klpd_virtuemart_manufacturers` ON ... etc.

Any ideas?
0
Responses (10)
rolandd
rolandd
Accepted Answer Pending Moderation
This would happen if an unknown field is in the template. See if you go to Maintenance -> Available fields and click Update and then run the export if it exports. It should work at least with the example templates.
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
peterva
peterva
Accepted Answer Pending Moderation
This would happen if an unknown field is in the template. See if you go to Maintenance -> Available fields and click Update and then run the export if it exports. It should work at least with the example templates.


Nope, it didn't work, also with the example templates I got the same error.

So ... I deleted the CSVI tables, uninstalled CSVI pro, cleared the cache and did a complete new install (CSVI 6.0.1 + Virtuemart addon + example templates). Also, updated available fields.

Now, I do not see 1 example template at all, only 1 template called 'no name' (see attachments).

I seem to be able to re-create my templates from scratch, but I'd like to import the example templates and my existing templates.

Can you help me out here?
Attachments (2)
csvi1.jpg csvi1.jpg
csvi2.jpg csvi2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
peterva
peterva
Accepted Answer Pending Moderation
So ... I started rebuilding my existing templates from scratch. First a simple VM product price/quantity export for Amazon.

This goes ok, except for 1 thing: all products are exported twice.

My filter settings (under options):
category: lowest category available (so no underlying child categories exist)
include subcategories: no
parent products only: no
child products only: yes

Further filters: sku filter empty, stock levels empty, all shopper groups, all manufacturers

Any hints of why I get double lines? I am attaching the output CSV.
Attachments (1)
Amazon_DE_PricesStock.txt
  1. more than a month ago
  2. RO CSVI
  3. # 3
peterva
peterva
Accepted Answer Pending Moderation
I created a new template with settings: Action = Export, Component = Virtuemart, Operation = Product. This works ok.

I noticed that when I change to Operation = Price, I get the same error: Unknown column 'skip' in 'field list'

So maybe the operation type of my CSVI 5 templates isn't converted correctly in CSVI 6?
  1. more than a month ago
  2. RO CSVI
  3. # 4
peterva
peterva
Accepted Answer Pending Moderation
I applied your patch for the category names and double item export:
http://www.csvimproved.com/media/kunena/attachments/3/patch_categoryname_20150720.zip

Now it's working fine.
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Any hints of why I get double lines?
By default CSVI doesn't do any grouping on fields that are the same. You can set this yourself on the Fields tab under Group fields.

I noticed that when I change to Operation = Price, I get the same error: Unknown column 'skip' in 'field list'
If you are changing the operation, you will need to change the fields as well. You don't have all the product export fields available in the price export.

So maybe the operation type of my CSVI 5 templates isn't converted correctly in CSVI 6?
That is something I can check but perhaps it may be a type of field as well. Do you have a copy of your CSVI 5 templates? If so, send them over via private message and I will check it out.
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. # 6
peterva
peterva
Accepted Answer Pending Moderation
By default CSVI doesn't do any grouping on fields that are the same. You can set this yourself on the Fields tab under Group fields.


Just a quick hint please: how do I group VM product fields so that I don't get double lines?
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
how do I group VM product fields so that I don't get double lines?

You can set this yourself on the Fields tab under Group fields.
You click on the Select button after the word Group fields. Is that clear enough?
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. # 8
peterva
peterva
Accepted Answer Pending Moderation
Not really but in another forum post you explained the following:
- open template, click on the fields tab
- click on the select button after group fields
- choose product_sku (<-- this was the information I needed)

Thanks, works great now!
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
It doesn't have to be product_sku, it all depends on how you want to filter. That is something that depends on the data being exported. Good to hear product_sku works for you.
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. # 10
  • Page :
  • 1


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