Magmi Base Image Getting Excluded about magmi-git

[dweeves]

This is normal, since magento base image import would do the same. So if you wand to explicitely include , put a + before image URL (ie: before the http, not before the image name) for remote images as described in the manual. what are the warnings that appear ?

[soamjena]

Tried the same way , putting + in front of the 1st image on media_gallery, but it failed.

Then tried placing the + in image column too, it failed.

Both ways, it fails.

On Thursday, 29 May 2014 at 11:00 pm, Sebastien Bracquemont wrote:

This is normal, since magento base image import would do the same. So if you wand to explicitely include , put a + before image URL (ie: before the http, not before the image name) for remote images as described in the manual. what are the warnings that appear ?

—
Reply to this email directly or view it on GitHub (#40 (comment)).

[soamjena]

Shall I post a excel with one record ?

There is some problem, which we are not able to find out.
We have defined multiple images on the media gallery, but only 1 image shows up.

This is happening for one particular record and we are not able to find out, what exactly is going wrong, as Magmi debug says nothing. It says, imported.

[dweeves]

Yes, put a csv with one record so that i can see what goes wrong

[soamjena]

Okay, will send one CSV file with one record today.

Another question, how do we get such description imported,
http://cl.ly/image/3y1a0Z2K224

[soamjena]

And here is the csv file,
http://cl.ly/3L352m2Q3f2X

[soamjena]

here is another csv too with another record, which has same problem.

The media gallery images doesnt import at all,
http://cl.ly/170K3w460h11

[soamjena]

any update ?

Is there a way we can remove the EXCLUDE from all the products at once, by running some SQL command or something ?

[YorickH]

Any news on this issue, I'm having the same problem. I tested it once by adding the + for the first image in my image gallery column. This one time, it worked. Afterwards when changing the path for the small file it crashed on me and did not showed the first image (which is the base image).

I use the following for the image, thumbnail, small_image and media_gallery columns:

"+22/1821-n.jpg","22/1821-n.jpg","22/1821-n.jpg","+22/1821-n.jpg;22/1821-n_open.jpg"

[bialy7]

After importing product with images. I try edit one off the imported product when i change images order and push save:
All images disappear

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (demo.catalog_product_entity_media_gallery_value, CONSTRAINT FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID FOREIGN KEY (value_id) REFERENCES catalog_product_en), query was: INSERT INTOcatalog_product_entity_media_gallery_value(value_id,store_id,label,position,disabled`) VALUES (?, ?, ?, ?, ?)

[inpresif]

Same here, any word on this yet?

[mrk741]

Same error also base image can't show in product page

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nxemvwyhwr.catalog_product_entity_media_gallery_value, CONSTRAINT FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID FOREIGN KEY (value_id) REFERENCES catalog_product_enti), query was: INSERT INTO catalog_product_entity_media_gallery_value (value_id, store_id, label, position, disabled`) VALUES (?, ?, ?, ?, ?)