Data merge with different images

[Ronald Pronk]

Hello, i have a flyer wiht 16 different versions which i need to create again and again. I would need to mannualy update the images of each flyer. So i created a 16 page document and i am looking for a feuture to use my date merge on this 16 pages, in word there is a command next record which you can place on the next page. So i don;t like to use the create documents in the date merge window, i like to implement the data merge on the existing pages. 

Is that possible?

Thanks, 

Ronald

[Jens Trost · Accepted solution]

Hi Ronald,
you can use data merge with images if you add a "@" at the beginning of the column name and put the path to your images in different rows.
Then you need to create just one version and apply the different images via your csv/txt-file.

See https://helpx.adobe.com/indesign/using/data-merge.html

Is that what you need?

[Ronald Pronk]

THANKS!!! Not exactly the workflow whoch i am lokkonh for but this will work, awesome!!!

Have a great day

[Ronald Pronk]

Oeps sorry for the typos, my keyboard went crazy 

[Ronald Pronk]

Excell does not allow me to use @ in the cell, it thinks it is a formula. Any tips on that?

[vladan saveljic · Accepted solution]

write '@

[Ronald Pronk]

I got it working, thank you so much!

Have a great day

[Ronald Pronk]

Oeps one problem left. Somehow there is a very thin line where the image is placed. The images are all psd files with transperency. On the edges of the image, on the export there is a small line. The psd files are clean.
You can see the line just above the head of the dj, cutting trough the logo. 

Is there someway i can crop this line out? In all 16 files the lines are there.......

[Ronald Pronk]

found it, there was a 1 pixel stroke on the image placeholder. 
SOLVED
Thanks

[StevePinder]

I am doing the same thing currently but cant use images and text at the same time and in the same CSV file. is there a work-around for this?

[Ronald Pronk]

You can! In the excell.csv file you place the file location of the file. If you like i can try to find the turorial which i used. But this week not time to look for it. 

I made one directory, named my files like this "image1.psd, image2.psd etc

So in the excell file i had links like
HD/users/username/documents/imagefordatamerge/image1.psd
HD/users/username/documents/imagefordatamerge/image2.psd
HD/users/username/documents/imagefordatamerge/image3.psd

Worked like a charm 

[StevePinder]

worked beautifully. Thanks

[StevePinder]

so much for that. I cant replecate the file. it worked 1 time and wont work on any other file I try it on

[Ronald Pronk]

You have to open the date merge window and reconnect your data file each time. I don't know why that is, but it is neccesary. It's just a few clicks

[StevePinder]

ive done that repeatedly and still cant get the images to show up

[StevePinder]

ive checked all my formatting and can only get it to work on my first csv file

[Ronald Pronk]

I remember there is also an issues with the csv format. I think only ; or only , work. I think i mannualy editted my csv file with a wordpad and used a find a replace command to change this

[StevePinder]

I am using '@name for the column name, then linking the image in row 2

[Ronald Pronk]

i lost the file from last time, but i need to create a new one anyhow for 116 dj flyers. If you are not in a rush i can do that in a week or so and then i can tell more about the steps it needs to have

[StevePinder]

I will probably figure it out by then, but thanks

[Ronald Pronk]

Just tried to re-create a file and worked. 

[StevePinder]

it may be working for you, but not for me. something is missing somewhere

[Ronald Pronk]

does your excell file look like mine? @Deleted User as header for the image kolum and the file path?
Did you drag the photos layer from the data merge window to your document?

[StevePinder]

I didn’t have to drag them on my first file

Get Outlook for iOS<>

[StevePinder]

i tried dragging them and it didnt work either