Data Merge Breaking Rows Into Multiple Records

Community Beginner ,
May 21, 2021 May 21, 2021

Copy link to clipboard

Copied

Hello! 

 

Let me start by saying I use data merge pretty often and I don't have anything weird going on like images, so this is a total mystery to me. I'm not even trying to have multiple records show up on the same page. It's an easy peasy data merge. 

 

So I have a spreadsheet with 133 columns (woof I know) and only 4 rows. See screen shot. 

Screen Shot 2021-05-21 at 2.26.44 PM.png

I have no trouble importing the document; all the fields show up correctly and I was able to successfully build the (rough version) of the final document I want to merge. See Screenshot. 

Screen Shot 2021-05-21 at 2.29.28 PM.png

The problem happens when I preview the entries. Instead of getting 4, I get 36! All of the data is mismatched and scattered across all these records. I've checked and it's nothing to do with there being blank cells. It's totally arbitrary.

 

I remember there used to be an option for something like "read rows across" or something to that effect, but I can no longer find that import option. I've tried also importing as a txt file (I'm using csv) and that doesn't help either. Could it be an issue of not having enough data? I'm really getting frustrated here! 

TOPICS
Bug, How to, Import and export, Performance

Views

285

Likes

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
Participant ,
May 21, 2021 May 21, 2021

Copy link to clipboard

Copied

Try create a new indesign document. Copy all stuff over and re-create the data merge. There's a known bug that might occur here.

Likes

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 Beginner ,
May 21, 2021 May 21, 2021

Copy link to clipboard

Copied

Thank you for the response! I did this, but I'm having the same issue. When you mean copy, do you mean just copy the text I have already written with the merge fields? That's what I did but I'm just making sure! Any information you could provide about the bug would be super appreciated. Thanks again! 

Just going to include another screen shot to full explicate what I mean by the fields are not aligning correctly. 

Screen Shot 2021-05-21 at 4.34.37 PM.png

Screen Shot 2021-05-21 at 4.33.59 PM.png

Likes

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
Adobe Community Professional ,
May 21, 2021 May 21, 2021

Copy link to clipboard

Copied

Try doing the merge without doing a preview.

Likes

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
Adobe Community Professional ,
May 21, 2021 May 21, 2021

Copy link to clipboard

Copied

But start with a new, clean document, not a copy, to be sure you haven't introdcued the bug.

Likes

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 Beginner ,
May 24, 2021 May 24, 2021

Copy link to clipboard

Copied

Thanks! So can I copy the text over or just have to start from scratch?

Likes

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
Adobe Community Professional ,
May 24, 2021 May 24, 2021

Copy link to clipboard

Copied

My recollection is that once a data merge file has been damaged by the bug that appears when previewing (and I'm going back to CS6, so this bug may be different) you need to recreate the merge template from scratch.

 

For what it's worth, if you absolutely need to do a preview, it used to be OK to imediatley UNDO after the preview, but most times merging is so quick I don't see a reason to bother with a preview -- just do a  merge and check it.

Likes

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 Beginner ,
May 24, 2021 May 24, 2021

Copy link to clipboard

Copied

Hi Peter,

 

Thank you SO MUCH for your continued help. Unfortunately, a new document and just going straight to merge still resulted in 36 very janky merges. Really not sure what to do! 

Likes

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
Adobe Community Professional ,
May 25, 2021 May 25, 2021

Copy link to clipboard

Copied

Are you able to share the data file?

Likes

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
Adobe Community Professional ,
May 25, 2021 May 25, 2021

Copy link to clipboard

Copied

LATEST

And a copy of the template so we can see waht you are doing, exactly.

Likes

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