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

Data Merge not bringing in data from all the fields consistently

Explorer ,
Sep 12, 2023 Sep 12, 2023

Hi! I created a template for a Data Merge in Indesign, and am using an Excel .csv file for data source (including image paths). Everything seems to be going swimmingly, BUT THEN... I see that some fields aren't being brought in on just a few of the entries. So I have it set up for name, title, company, and email address, but on some of them the title is missing or the email is missing, even though those entries DO have titles or emails in the correct fields. Data merge is also creating 2 completely empty instances on the second-to-last page, then the last entry shows up all by its lonesome on the last page. Any ideas what might be going on? Thanks.

TOPICS
Bug
249
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 , Sep 12, 2023 Sep 12, 2023

Check for carriage returns in your data...

Translate
Community Expert ,
Sep 12, 2023 Sep 12, 2023

Check for carriage returns in your data...

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
Explorer ,
Sep 12, 2023 Sep 12, 2023

That did it, thanks!

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 ,
Sep 12, 2023 Sep 12, 2023
LATEST

When I need multiple paragraphs in a field I use a character or combination of characters that otherwise won't appear in the document in place of the break, then use Find/Change after the merge to find them and replace with the required break.

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