No product created when image file doesnt exist

[ISL]

I have a problem where some of my products are not created when importing because their image file does not exist (i havnt created one yet :) )

Is there a way to make Actinic import the products and ignore the fact that the image file does not exist?

[taliesyn]

Why not just make a transparent .gif or .png, and point all of the products you don't have images for yet to that.

It's a roundabout way of doing it, but it should work :)

[ISL]

Thanx for your reply. Cant really do that though.

Picture this scenario -

Importing from an excel sheet of 18,000 products each has an image with same filename as product reference and images are sent to us from supplier. So ive added a field called image filename and it automatically enters the value of the product reference and adds the .jpg extension (eg 01256.jpg)

Now some pictures did not get sent to us and i would like to include the products in the import but it wont let me coz it says image filename does not exist.

I could go back to excel sheet and remove the value in image filename field of all the products it had a problem with, but seen as theres about 2000 of these its a long process to do this everytime i have to update actinic lol

[taliesyn]

Well if you're using Excel to automatically fill in the field with a value derived from the product reference then you're sunk by the sounds of it, unless someone can come up with a cunning way of checking whether the filename exists before updating the field.

[ISL]

so theres no way that actinic will import a product if the image doe snot exist?

[Nadeem]

Hi there

If you specifiy an image in the import file, but that image does not exist on the pc , then it will not import the product, I'm afraid.

Similarly within the Actinic software you cannot add a product with a non existant image, as an error will appear saying "The selected image file does not exist"

Kind Regards

[Jan]

You could write a program to read through the excel spreadsheet and copy a default image to the image name specified for that product if the image doesn't exist.

Regards,

[Galeenet]

I don't know the syntax for english excel but :
IF(REFCELL_LINENUMBER<>"",CONCATENE(REFCELL_LINENUMBER;".jpg");"invisible_image.gif")
should work.