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
Hello,

do you have an idea the reason that i geting this error???
There is no debug log, so I can't tell. The only guess I can make is that your file has a different delimiter than your template has.

following list (using Quick Add from fields tab):
So, you don't really have a clue why you are exporting these fields. I can tell you looking at the list there are a lot of fields you don't need or should use unless you know what you are doing. You better start with a list of fields you know what they are for. This way it isn't going to work and with a list of fields you know what they mean, it will be a lot easier to maintain and solve possible issues.
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
I exported from joomla 2.5 using as field delimiter ; and Text Enclosure "....

How can i set template delimiters in CSVI Pro 6.1.1 so to test if the export delimiters matches the import template delimiter??

I attached you the log file if it can helps you...

Thank yo for your answer...
Attachments (1)
log.txt
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
How can i set template delimiters in CSVI Pro 6.1.1
In your template on the File tab you have an option called Auto-detect delimiters, set this to No and you can specify your delimiters. Looking at your log it seems your file has a BOM. Not a problem but you can't use the auto-detect delimiters.
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
It worked but now i have the problem that when i press the4 import button it ends the process with the error message in screenshot i attach below...

These fields have been found but are not supported by CSVI:
product_currency
product_box
product_desc
product_name
product_override_price
product_price
related_products
Attachments (1)
error.jpg error.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
stathisdim
stathisdim
Accepted Answer Pending Moderation
I also attached the log file...
  1. more than a month ago
  2. RO CSVI
  3. # 5
stathisdim
stathisdim
Accepted Answer Pending Moderation
any answer to this ?
  1. more than a month ago
  2. RO CSVI
  3. # 6
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. # 7
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. # 8
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. # 9
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. # 10
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. # 11
stathisdim
stathisdim
Accepted Answer Pending Moderation
the import file
Attachments (1)
proiontaneo3.csv
  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
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. # 14
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. # 15
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. # 16
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. # 17
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. # 18
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. # 19
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. # 20
  • Page :
  • 1
  • 2


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