indesign, data merge and subfolders

New Here ,
Jun 30, 2020 Jun 30, 2020

Copy link to clipboard

Copied

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.

TOPICS
How to

Views

141

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Community Professional , Jun 30, 2020 Jun 30, 2020
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 )

Likes

translate

Translate

Translate
Adobe Community Professional ,
Jun 30, 2020 Jun 30, 2020

Copy link to clipboard

Copied

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 )

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 30, 2020 Jun 30, 2020

Copy link to clipboard

Copied

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

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 30, 2020 Jun 30, 2020

Copy link to clipboard

Copied

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

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 30, 2020 Jun 30, 2020

Copy link to clipboard

Copied

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 )

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jul 10, 2020 Jul 10, 2020

Copy link to clipboard

Copied

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

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 07, 2021 Apr 07, 2021

Copy link to clipboard

Copied

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?

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines