Data Merge fails to properly populate data on merge

New Here ,
Aug 13, 2022 Aug 13, 2022

Copy link to clipboard

Copied

Working on cards for a boardgame im designing. Got my data merge all set up doing multiple records per page. 30 lines in my CSV file to make 30 cards. Everything looks perfect in the merge preview but when I hit merge it just does the data from around line 25 and just repeats it on cards 1-25 and then does the last few correct.

 

Multiple columns in the CSV and images linked as well. the placement is all great except that its the wrong data in the final merge

TOPICS
Bug , Import and export

Views

84

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

correct answers 1 Correct answer

Community Expert , Aug 15, 2022 Aug 15, 2022

Your data sheet has some "dirt" potential; a lot of blank cells, A2 looks like it could be merged with B2, + symbols and ampersands can be problematic in some cases. Your unique identifier appears to be [Class Name]. While it should work with that column in any position, it's most logical for the unique identifier to bet first read, positioned in the A column, with all other fields for the given record following. As it stands, your data contains records that, effectively,  start with an empty fi

...

Likes

Translate

Translate
New Here ,
Aug 14, 2022 Aug 14, 2022

Copy link to clipboard

Copied

2022-08-14 14_47_39-Unit Cards.csv - Excel.pngHere's the csv2022-08-14 14_52_44-_Unit Cards.indd @ 82%.pngThe preview (Sometimes the background shows in the preview)2022-08-14 14_52_20-_Unit Cards-1 @ 80%.pngFinal merge wit different info then the 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
Community Expert ,
Aug 14, 2022 Aug 14, 2022

Copy link to clipboard

Copied

I would take a look at your database. The rows seem inconsistent. Remember that you are using a CSV and that your data needs to have the same number of elements in the record sets to import correctly. Without playing with your file a bit I cannot be certain but I would be willing to bet that your record sets are the issue.

maxwithdax_1-1660539870225.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
Community Expert ,
Aug 15, 2022 Aug 15, 2022

Copy link to clipboard

Copied

Your data sheet has some "dirt" potential; a lot of blank cells, A2 looks like it could be merged with B2, + symbols and ampersands can be problematic in some cases. Your unique identifier appears to be [Class Name]. While it should work with that column in any position, it's most logical for the unique identifier to bet first read, positioned in the A column, with all other fields for the given record following. As it stands, your data contains records that, effectively,  start with an empty field. Consider some cleanup actions there, and try saving as tab-delimited (.txt) rather than .csv.

 

It might also help to show us your pre-merge layout.

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 Expert ,
Aug 15, 2022 Aug 15, 2022

Copy link to clipboard

Copied

LATEST

@JangoFett140 wrote:

 Everything looks perfect in the merge preview but when I hit merge it just does the data from around line 25 and just repeats it on cards 1-25 and then does the last few correct.


 

There may be other issues, but the preview being different from the merge output points to this being a result of the long-standing preview bug in multiple-records-per-page data merge. For many years now, previewing a multiple-record layout introduces permanent corruption in the template page. 

The only way forward is to rebuild the template in a new document, and process the merge without previewing. 

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