Categories
View Replies (25)

Resolved Problem with CSVI products import from Joomla 2.5

  1. stathisdim
    stathisdim
  2. RO CSVI
  3. Friday, 28 August 2015
  4.  Subscribe via email
Halloo...

I have CSVI Pro 6.1.1 for joomla 3...

I want to move all my products from an old Virtuemart webstore (joomla 2.5.7 with CSVI version 4.4 installed) to a new
Joomla (V 3.4.3) webstore with Virtuemart (v 3.0.9) and SCVI (V 6.1.1) installed...

When i try to import the products from Excell csv file i am geting this error message in red colored font ....
No supported fields have been found in the import file......

do you have an idea the reason that i geting this error???

To be more specific the fields i am exporting from CSVI 4.4 are the following list (using Quick Add from fields tab):

basepricewithtax
category_id
category_path
created_by
created_on
custom
customtitle
custom_param
custom_price
custom_shipping
custom_title
custom_value
discountamount
discountedpricewithouttax
file_url
file_url_thumb
hits
intnotes
layout
locked_by
locked_on
low_stock_notification
manufacturer_name
max_order_level
metaauthor
metadesc
metakey
metarobot
min_order_level
modified_by
modified_on
override
picture_url
pordering
pricebeforetax
pricewithouttax
product_availability
product_available_date
product_box
product_currency
product_desc
product_height
product_in_stock
product_length
product_lwh_uom
product_name
product_ordered
product_override_price
product_packaging
product_params
product_parent_id
product_parent_sku
product_price
product_sales
product_sku
product_special
product_s_desc
product_unit
product_url
product_weight
product_weight_uom
product_width
published
related_products
salesprice
shopper_group_name
slug
taxamount
virtuemart_product_id
virtuemart_vendor_id

Thanks very much...
0
Responses (25)
stathisdim
stathisdim
Accepted Answer Pending Moderation
the response of firebug gave me this

{"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message"
:"Duplicate entry 'l-oreal-dulcia-vital-dv2' for key 'slug' SQL=INSERT INTO `jos_virtuemart_products_en_gb
`\r\n(`virtuemart_product_id`,`slug`) VALUES \r\n(47, 'l-oreal-dulcia-vital-dv2')"}


the export log file

(it ends always with 324 lines)

____________________

https://www.dropbox.com/s/0zccepjt5qvf659/export%20log.txt?dl=0
  1. more than a month ago
  2. RO CSVI
  3. # 21
stathisdim
stathisdim
Accepted Answer Pending Moderation
the first problem is solved!! :cheer: :cheer:

With the help of this post
http://www.csvimproved.com/en/forum?view=topic&catid=44&id=32186
i added into csv a slug field and i gave to it a unique slug value for every enty....now the import completes with all of products in csv imported...

now the only problem is that with the fields i export exports only 324 products and not all of 1958 products...i have attached above the export log file .... what causes this???

The exported fields are:
product_sku
product_name
category_path
product_s_desc
product_desc
product_price
product_currency
slug

Thank you....
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

now the only problem is that with the fields i export exports only 324 products and not all of 1958 products...i have attached above the export log file .... what causes this???
That log is from CSVI 4.4, which is very old. You started this topic saying you are using CSVI 6. Is this from another site?

GROUP BY `product_sku`,`product_price`,`product_currency`
This should create a unique list of products assuming you have unique product SKUs.

You can check the list by executing this SQL query in PhpMyAdmin, replaceing #_ with your own prefix. 
SELECT `product_sku`, `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_product_categories`.`virtuemart_category_id`, `#__virtuemart_product_prices`.`product_price`, `#__virtuemart_currencies`.`currency_code_3` FROM #__virtuemart_products LEFT JOIN #__virtuemart_product_prices ON #__virtuemart_products.virtuemart_product_id = #__virtuemart_product_prices.virtuemart_product_id LEFT JOIN #__virtuemart_product_manufacturers ON #__virtuemart_products.virtuemart_product_id = #__virtuemart_product_manufacturers.virtuemart_product_id LEFT JOIN #__virtuemart_shoppergroups ON #__virtuemart_product_prices.virtuemart_shoppergroup_id = #__virtuemart_shoppergroups.virtuemart_shoppergroup_id LEFT JOIN #__virtuemart_manufacturers ON #__virtuemart_product_manufacturers.virtuemart_manufacturer_id = #__virtuemart_manufacturers.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_product_categories ON #__virtuemart_products.virtuemart_product_id = #__virtuemart_product_categories.virtuemart_product_id LEFT JOIN #__virtuemart_categories ON #__virtuemart_product_categories.virtuemart_category_id = #__virtuemart_categories.virtuemart_category_id LEFT JOIN #__virtuemart_currencies ON #__virtuemart_currencies.virtuemart_currency_id = #__virtuemart_product_prices.product_currency GROUP BY `product_sku`,`product_price`,`product_currency`
If this gives you the 324 entries, something is wrong with your SKUs. If you want to get the full list, you need to remove the GROUP BY and everything after that.
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. # 23
stathisdim
stathisdim
Accepted Answer Pending Moderation
CSVI 4.4 is the version that the old site has...the site from where i want to export products into my new site with csvi 6
  1. more than a month ago
  2. RO CSVI
  3. # 24
rolandd
rolandd
Accepted Answer Pending Moderation
CSVI 4.4 is no longer supported but give the option I give in my previous post a try.
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. # 25
  • Page :
  • 1
  • 2


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