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

Data merge not recognizing text from csv

Community Beginner ,
Aug 17, 2022 Aug 17, 2022

Hi All,

I'm trying to do a data merge trial, from a simple excel .csv, with some text and a picture, before moving onto a much larger scale merge. However, when I merge into InDesign, the merge considers the text as a picture and is then not showing the text as image and is showing the below error message. Any help would be massively appreciated! I don't know if it's a problem with my InDesign or my spreadsheet...??

 

issue.pngexpand image

TOPICS
Bug , How to , Import and export
445
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

correct answers 1 Correct answer

Community Expert , Aug 17, 2022 Aug 17, 2022

The reason the merge is seeing the text as a picture is that you have named all of your columns with an initial @ symbol. 

Remove the @ symbol from the columns that should be text. That symbol at the start of a column header tells InDesign that the column contains image names and/or paths. 

Translate
Community Expert ,
Aug 17, 2022 Aug 17, 2022

Are the images all in the same folder?

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 17, 2022 Aug 17, 2022

The reason the merge is seeing the text as a picture is that you have named all of your columns with an initial @ symbol. 

Remove the @ symbol from the columns that should be text. That symbol at the start of a column header tells InDesign that the column contains image names and/or paths. 

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 Beginner ,
Aug 17, 2022 Aug 17, 2022
LATEST

AMAZING! Thank you so much, worked a treat!

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 17, 2022 Aug 17, 2022

Note, that the image files must be in the same folder with the data source file, your currently used csv file, if the data there is not using file paths and just file names.

 

Regards,
Uwe Laubender
( Adobe Community Professional )

 

 

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 Beginner ,
Aug 17, 2022 Aug 17, 2022

Thanks. The images are actually working and are in the same folder as the csv file. It's just the other columns.

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