Data merge issue - more files than in excel

Forum|Forum|3 years ago
January 4, 2023
4 replies
378 views

Hi everyone.

I'm trying to export certificates that includes the users name, their role, and a small blurb. When I come to export my data merged PDFs I have 14,043 PDFs when there are only 14,041 entries in the excel.

I can't tell where these extra 2 come from and part way through the PDFs they do not seem to match fully with the entries in excel.

Any help that can be given would be appreciated!

Import and export

This topic has been closed for replies.

Correct answer Peter Spier

Could also be caused by a return character in a cell...

Robert at ID-Tasker

Legend

If you are able to find the page where the info is wrong - then you need to examine previous record in the Excel file - for comma(s) or enter/return.

Peter Spier

Correct answer

Community Expert

Could also be caused by a return character in a cell...

M

Mike246740048oqbAuthor

Participant

This was it! I had done some searches of returns and it didn't flag anything. Turns out there were 2 which were causing the issue. Thanks for this as it made me double check!

J

Jeffrey_Smith

Community Expert

If using csv for source file, make sure there are no commas, this will create a new record. If there are commas, then use tab-delimited .txt for source file.