indesign, data merge and subfolders

[apcoinc]

Is there a way too have Indesign pull images from subfolders when using data merge?

I have 6,000+ images in multiple folders, to help keep them organized. eg. H:\Images\JKL\K02501.psd

My InDesign file is on my local computer.

[Laubender · Accepted solution]

Yes to your question.

But you have to state the full path of every single image file in your data source file.

FWIW: Perhaps it would be easier to run your data merge with a data source file that is in the same folder with duplicates of all your 6,000+ images? Then you would only need to list the file names. Not the whole path.

Regards,
Uwe Laubender

( ACP )

[Laubender]

FWIW: It does not matter where your InDesign template document for data merge is.

The position of the data merge data source file is counting.

Regards,
Uwe Laubender

( ACP )

// EDITED FOR CLARITY

[apcoinc]

Yes your correct I would not waant to copy paste every image path into my spreadsheet.

Do you think in my spreadsheet I could write a formula that would place the last folder location into the path name? eg. H:\Images\KLMN\myimage.psd, I already have the have the first part of the path which is static as "H:|Images\" written in the @Image column then concatenate the file name "myimage.psd" on the end. I could write an if/else the file name begins with a K or L or M or N, look in the KLMN folder else look in OPQR folder and so on. Obviously I didn't write that correctly but you should get the jist of it. It would be a very long string. lol

[Laubender]

Hi apcoinc,

I would simply try this. Start with a couple of file paths only and do a test with data merge.

Regards,
Uwe Laubender

( ACP )

[Sheena Kaul]

Hi there,

I hope your issue is resolved already but in case you need more assistance please reply to this thread. 

Else, if the solution above helped, please confirm. 

Regards,

Sheena

[ataurr18597239]

Hello Sheena,

I am facing a different issue. I try to merge data using CSV file, but when I do data merge some pictures go missing from the InDesign generated document. I tried to copy same pictures link for all the cells, but still pictures fails to import. 

There are certain pattern of this issue, like some pictures from a row do not get imported, at some places some pictures in a column fais to import.

May I know the possible reason?