Resolved Import Based On...

Hello,
You can directly add product_mpn to "Import based on" field and do the import. Pulldown list with custom sku and custom column name field are removed from CSVI 6 version.

Hello,

I filled out the "Import Based on" filed with product_mpn, but didn't worked.

In the log i found this line: ICEcat mon reference not found

I imported before the icecat_index and the maufacturer index.

Hello,
Can you load patch file attached and see if you are able to import?
patch_virtuemart2015-12-31.zip

Thank you for the patch, but i see the same message in the log

Hello,
Please try the updated patch attached here and let me know how it goes.
patch_virtuemart_2016-01-01.zip

Hello,

thank you for the patch! It works, but error with image gallery.

I send the log, and an error message.

Hello,
The Image url in the gallery is wrong, the image is saved with complete ICEcat URL. To solve this, Edit template, on image tab try setting "Save images on server" to yes and do the import.

Hello,

i changed the settings, it's works, but...
maybe some Icecat link is wrong. ( http://images.icecat.biz/img/gallery_lows/17546899-Nedis-CMP-SOUNDUSB12König-6153.jpg )

And other problem: by generate some thumbnail is wrong too.

Hello,
Can you try loading the patch file and see if the thumbnail link works?
patch_vm_2016-01-08.zip

Hello,

Now download and generate the images and thumbnails, but i see not a single image in the virtuemart database. The files in the product folder are ok.

Can you write an error handling routine in picture import, when the icecat image link is worng, then stoped the import now with error.

Thanks

Hello,

Can you write an error handling routine in picture import, when the icecat image link is worng, then stoped the import now with error.

This is not going to be implemented, if there is an error, CSVI should continue. If there is an issue for CSVI the issue will be logged and can be checked afterwards in the log.

To not see these image issues you can go to System -> Global configuration -> Server -> Error reporting and set it to None.

You said you don't see any images in the database, that sounds incorrect because we can see the images are imported:

UPDATE `ejrta_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='24408815-2911.jpg',`file_description`='24408815-2911.jpg',`file_meta`='24408815-2911.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/24408815-2911.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/24408815.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='1'

this looks all good to me.

Hello,

I set the Error reporting to None, In php setting diplay error is off, but the messages comes, even one or more record will be imported.By ending first import session (i probed 1, 5 20 lines per import) the impurt interrupted.

"( ! ) Warning: imagejpeg(C:/wamp/www/ut01/images/stories/virtuemart/product/http://images.icecat.biz/thumbs/24408815.jpg): failed to open stream: Invalid argument in C:\wamp\www\ut01\administrator\components\com_csvi\helper\image.php on line 971"

The records in the virtuemart database are ok.

Thanks

Steve

Hello Steve,

Please see my directions in this thread that should solve the issue of the warning showing.

Helo,

Thanks for the idea, now works without warning, but the import run now with endless loop..

In my test xml are 102 records, and i stopped the import after 800th resord.

Hello,
This could be a problem with Javascript conflicts. Please look at Using firebug to analyse problem document to see if you can get any information on the error. Also send us a screenshot on the same.

Hello,
We have found and fixed the issue causing the endless loop with xml file. Can you try importing after loading the patch file attached here?


patch_csvi_2016_02_01.zip

Hello,

Thanks for the patch, the import work, but i can't fully tested, becose i have problem with my icacat account.

Hello,

The patch is also included in the CSVI 6.5.0 release, so you can update and have the changes as well.

Tanks,

My Icecat account did not work.

Now works the import with existing product fine, but when in my database is a record which not exist in a free icecat database, then import the previos content for the new product.

Kind Regards
Steve

Hello Steve,
Please try to load the attached patch file and try doing the import.


patch_vm_icecat_2016-03-17.zip