Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

DATA MERGE INDESIGN-EXCEL

New Here ,
Aug 09, 2023 Aug 09, 2023

"Hello friends, I'm having trouble using the data merge feature in InDesign. Is there anyone who can help me with this issue?" 

I saved the table I prepared in Excel as a .csv file, but only 2 out of 5 images are being included along with all the text. Moreover, even though the headers are labeled as '@image, they appear in the Data Merge panel but cannot be linked to the project files. What might be the issue? Can you please help me?

Ekran Resmi 2023-08-09 17.41.17.png

Ekran Resmi 2023-08-09 17.38.57.png

Ekran Resmi 2023-08-09 17.35.22.png

TOPICS
Print
403
Translate
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
Community Expert ,
Aug 09, 2023 Aug 09, 2023

Every column needs a unique header name -- all your columns for images appear to be using the same name.

Fix that and see if it solves your problem. If not, come back and we'll see what else might be causing problems.

Also, please post a screen capture of your template page showing the data merge placeholders.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

Image columns, I believe, have to be named "@IMAGE" and then InDesign will interpret multiple fields. You can see it in the screen shot as it adds 1, 2, 3, etc to the field names.

 

As I said in my reply to the OP, I think the issue is in the lack of a path to the images.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

I haven't done a data merge project with images since 2008, and that had only one image field, but it was not named @IMAGE, but rather @FileNamePath, so for the moment I'm sticking with having unique names for each field.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

I wonder if it's the @ sign that does it. But I did one with a client a last year with multiple @ image fields all with the same name and it worked perfectly.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023
LATEST

It is indeed the @ that does it. From: Merge data to create form letters, envelopes, or mailing labels in Adobe InDesign 

At the beginning of the data field name, type an “at” symbol (@) to insert text or paths that refer to image files. 

The @ symbol is required only in the first line; subsequent lines should include the image paths. Paths, which are case-sensitive, must follow the naming conventions of the operating system in which they’re stored.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

Add the full path to image and try again.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

adding the full path can't hurt, certainly, but should only be necessary if the images are not in the same folder as the document. We have no idea, at the moment, what the image locations are but since two were found I'm going to guess they are not scattered across multiple folders.

Translate
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
Community Expert ,
Aug 10, 2023 Aug 10, 2023

I think we've reached the "waiting for the OP" stage of things.

Translate
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