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)
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. # 1
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. # 2
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. # 3
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. # 4
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. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

First of all, your import file looks good to me.

it stops (stucks) after 3 seconds of last server response field...
Have a look at the Using Firebug to analyze import problems to see if you can find anything why it stops. There seems to be no reason to stop from the CSVI point of view. It could also be a plugin that interferes with CSVI.

When i am trying to import the same csv file but without product_sku values(prointa teliko export TEST), it completes the import it but it imports only 50 lines of 324...
Without the product_sku, nothing will happen as CSVI won't have anything to add/update.

another question i want to make is what are the apropriate fields i have to export for virtuemart products so that all of my 1958 products to be in the csv and not only the 324 products....
Post the debug log of your export, so we can see what is there. If the export is not always 324 but the number is different all the time, it is the server killing the export.
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
stathisdim
stathisdim
Accepted Answer Pending Moderation
i want to mention that due to my latest tests if i delete the product_name field-column (and values) in the csv (prointa teliko export TEST_1) the import is done correctly....

is there any problem with product_name values???
  1. more than a month ago
  2. RO CSVI
  3. # 7
stathisdim
stathisdim
Accepted Answer Pending Moderation
hello again...

when i am trying to import the csv tha i have attached (prointa teliko export TEST_1) it stops (stucks) after 3 seconds of last server response field...

When i am trying to import the same csv file but without product_sku values(prointa teliko export TEST), it completes the import it but it imports only 50 lines of 324...

in the csv file (prointa teliko export TEST_1) i have entered a unique sku for every product, but why the import stucks after 3 seconds?(whats the problem with that??? (the csv prointa teliko export TEST_1 is encoded during save as in openoffice to utf-8 for greek characters)

another question i want to make is what are the apropriate fields i have to export for virtuemart products so that all of my 1958 products to be in the csv and not only the 324 products....



_________________________
---log file prointa teliko export TEST_1

https://www.dropbox.com/s/zdp64e0jxsz9nia/com_csvi.log.208.php?dl=0

---log file prointa teliko export TEST

https://www.dropbox.com/s/l466dt9us89dh15/csv%20prointa%20teliko%20export%20TEST.txt?dl=0

---prointa teliko export TEST file

https://www.dropbox.com/s/0dz960112b5978k/prointa%20teliko%20export%20TEST.csv?dl=0

---prointa teliko export TEST_1 file

https://www.dropbox.com/s/qt8pjkuwly2wkbe/prointa%20teliko%20export%20TEST_1.csv?dl=0
  1. more than a month ago
  2. RO CSVI
  3. # 8
stathisdim
stathisdim
Accepted Answer Pending Moderation
Thank you Ronald very very much for your time....

It worked and all products in the csv file imported into virtuemart by simply generating a unique SKU number for every product in csv file...

Thanks a lot...
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
and the reason that this happens?
because you haven't set any SKU for the product. You will need to have a unique code for the product to be able to identify it, otherwise CSVI has no clue how to update/add products.

or i should manually set a unique value in csv file after exporting it??
It should only be done once, so that products can be identified.
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
stathisdim
stathisdim
Accepted Answer Pending Moderation
and the reason that this happens?

I can fix it setting the appropriate export properties, or i should manually set a unique value in csv file after exporting it??
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Your product_sku field is empty for most products and the products that does have a product SKU have a weird value. The value is In Stock, Out Of Stock and Κατόπιν Παραγγελίας. This is why you have 3 products imported.

The SKU needs to be the unique product code, not a stock indicator. If you give every product a unique SKU, the import will give you all the products.
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. # 12
stathisdim
stathisdim
Accepted Answer Pending Moderation
and the debug log file...

i uploaded it to dropbox because its size is 907 kb so i couldnt attach it to the forum...

https://www.dropbox.com/s/zi31vdex3xthtxi/virtuemart%20log.txt?dl=0

I also want to ask if i should import virtuemart product categories separately from products and then import products...

thank you!!!
  1. more than a month ago
  2. RO CSVI
  3. # 13
stathisdim
stathisdim
Accepted Answer Pending Moderation
the import file
Attachments (1)
proiontaneo3.csv
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
Accepted Answer Pending Moderation
Where is the debug log and the new file you used for import?
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. # 15
stathisdim
stathisdim
Accepted Answer Pending Moderation
i deleted the field that had _id at the end

Now it complete the process with only 4 products added from the list in csv file (those with unavailable images)

why only those 4 producted are added from tha csv???
Attachments (2)
virtuemartscreen.jpg virtuemartscreen.jpg
virtuemartproducts.jpg virtuemartproducts.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 16
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You should not be using the virtuemart_product_id field or any other field that ends with _id unless you really know what it does. The vendor ID field can be removed as well, CSVI defaults to using vendor ID 1.
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. # 17
stathisdim
stathisdim
Accepted Answer Pending Moderation
The csv file i am trying to import is the attached...i have as few fields as i can...

Do you think it is correct?
Attachments (1)
proiontaneo.csv
  1. more than a month ago
  2. RO CSVI
  3. # 18
rolandd
rolandd
Accepted Answer Pending Moderation
There is no log file nor did you post the file you are trying to import so I can only take a wild guess.

If the list of fields in your screenshot is the complete list of fields in your import file, you are missing the product_sku field which is required.

The list contains supported fields so it looks like your available fields list is not up-to-date. Go to Maintenance -> Available fields and click on Update. That should give you all the special fields as well. If you don't see them, go to Maintenance -> Tasks and click Reset and confirm. After that run the Update of the fields again, now they really should be there.
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. # 19
stathisdim
stathisdim
Accepted Answer Pending Moderation
any answer to this ?
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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