Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

  • Free upgrades for 1 year
  • Extended replacement rules
  • Advanced XML support
  • Multiple component support
  • Automatic import/export
  • Advanced import/export features
  • Forum access for 1 year
  • Forum access for 10 days
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Looking for a useful answer?

Read this first and make sure you checked all steps: www.csvimproved.com/frequently-asked-questions/635-troubleshooting-import-errors

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* VirtueMart version
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial (www.csvimproved.com/frequently-asked-questions/390-how-to-collect-debug-information) has been written to help you collect your debug information. For CSVI 3, there is a video available (www.csvimproved.com/downloads/file/18-collect-debug-information)
  • Page:
  • 1
  • 2

TOPIC: Export not working w/ joomla 1.5.6 and CSVI 1.9.5

Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27801

  • Courtland
  • Courtland's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
I havent been able to export any of my data from my virtuemart database. I was able to get the column titles which allowed me to import my products. I tried to make a template to export out the bare minimum but that also returned an error. In my log for CSVI it says ........
"Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT `product_name`, `product_url`, `product_desc`, jos_vm_product.product_id AS main_product_id, jos_vm_product.product_sku, jos_vm_product.product_full_image, jos_vm_product_price.product_price, jos_vm_product_price.product_currency, jos_csvi_currency.currency_code, jos_csvi_currency.currency_rate, mf_name AS manufacturer_name, `product_width`, `product_weight`, `product_length`, `product_in_stock`, `attribute` FROM jos_vm_product LEFT JOIN jos_vm_product_price ON jos_vm_product.product_id = jos_vm_product_price.product_id LEFT JOIN jos_vm_product_mf_xref ON jos_vm_product.product_id = jos_vm_product_mf_xref.product_id LEFT JOIN jos_vm_shopper_group ON jos_vm_product_price.shopper_group_id = jos_vm_shopper_group.shopper_group_id LEFT JOIN jos_vm_product_discount ON jos_vm_product.product_discount_id = jos_vm_product_discount.discount_id LEFT JOIN jos_vm_manufacturer ON jos_vm_product_mf_xref.manufacturer_id = jos_vm_manufacturer.manufacturer_id LEFT JOIN jos_vm_tax_rate ON jos_vm_product.product_tax_id = jos_vm_tax_rate.tax_rate_id LEFT JOIN jos_vm_product_attribute ON jos_vm_product.product_id = jos_vm_product_attribute.product_id LEFT JOIN jos_vm_product_attribute_sku ON jos_vm_product.product_id = jos_vm_product_attribute_sku.product_id LEFT JOIN jos_vm_product_category_xref ON jos_vm_product.product_id = jos_vm_product_category_xref.product_id LEFT JOIN jos_vm_category ON jos_vm_product_category_xref.category_id = jos_vm_category.category_id LEFT JOIN jos_csvi_currency ON jos_vm_product_price.product_currency = jos_csvi_currency.currency_code GROUP BY `product_name`, `product_url`, `product_desc`, `product_sku`, `product_price`, mf_name, `product_width`, `product_weight`, `product_length`, `product_in_stock`, `attribute` ORDER BY jos_vm_product.product_sku"

Any ideas what any of this means?
The administrator has disabled public write access.

Re: Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27811

  • rolandd
  • rolandd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14885
  • Thank you received: 631
  • Karma: 298
Any ideas what any of this means?
Did you search the forum? You would see this has been posted before. See this post for details.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
The administrator has disabled public write access.

Re: Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27939

  • Courtland
  • Courtland's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
When I click "post" it says I don't have permission to view that page...
The administrator has disabled public write access.

Re: Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27950

  • rolandd
  • rolandd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14885
  • Thank you received: 631
  • Karma: 298
My mistake, that link goes to the registered users forum. What it says is you can use the Phoca collation tool to correct the collation on your tables.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
The administrator has disabled public write access.

Re: Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27964

  • Courtland
  • Courtland's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Ok, I see whats going on with that tool. All I have to do is upload the file and call it with the right database info plugged into it. When I get to work tomorrow I'm going to give it a shot and I'll post my success or failure here.
The administrator has disabled public write access.

Re: Export not working w/ joomla 1.5.6 and CSVI 1.9.5 1 year 1 month ago #27965

  • ejd
  • ejd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
I am on Joomla: Version 1.5.25
CSVI 1.9.2

I just used the Change Collation tool you described and ran it successfully.

Still cannot export the VM User Tables.
My CSV only has the header in it with no data.

Oddly enough, the templates that come with CSVI export just fine.

~activation~^~address_1~^~address_2~^~address_type~^~address_type_name~^~block~^~cdate~^~city~^~company~^~country~^~custom~^~customer_number~^~DEFAULT~^~extra_field_1~^~extra_field_2~^~extra_field_3~^~extra_field_4~^~extra_field_5~^~fax~^~first_name~^~full_name~^~gid~^~id~^~lastvisitDate~^~last_name~^~mdate~^~middle_name~^~name~^~params~^~password~^~perms~^~phone_1~^~phone_2~^~registerdate~^~sendemail~^~shopper_group_desc~^~shopper_group_discount~^~shopper_group_id~^~shopper_group_name~^~show_price_including_tax~^~state~^~title~^~username~^~usertype~^~user_email~^~user_id~^~user_info_id~^~vendor_id~^~vendor_name~^~zip~
Last Edit: 1 year 1 month ago by ejd.
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: rolandd
Powered by Kunena Forum

TESTIMONIAL

Well worth the money!
5 stars
2012-11-09
CSVI Pro is well worth the money. I upgraded from the free version to the pro version and am glad I did. Not only do you get an upgrade to more powerful software, you get excellent tech support. I highly recommend this product!

STAY INFORMED


Stay informed with the CSVI newsletter.