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

Data Merge not bringing in data from all the fields consistently

Explorer ,
Sep 12, 2023 Sep 12, 2023

Copy link to clipboard

Copied

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

Views

75

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

Community Expert , Sep 12, 2023 Sep 12, 2023

Check for carriage returns in your data...

Votes

Translate

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

Copy link to clipboard

Copied

Check for carriage returns in your data...

Votes

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

Copy link to clipboard

Copied

That did it, thanks!

Votes

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

Copy link to clipboard

Copied

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.

Votes

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