Hello InDesign Community.
I've recently started using Data Merge function for InDesign and it's been working wonderfully, up until now. I'm not sure what's causing this, but the data is being not-merged or merged in the wrong places. It appears like the csv might be corrupted, however, I've spent hours troubleshooting the issue, including rebuilding the template, recreating the csv files, basically anything and everything. I'm starting to believe it's a glitch in the program.
Please advise! I have files I can send over if required further clarification.
1 Correct answer
I don't think your csv is corrupt, but I do think there is a problem with how it is built.
Any paragraph returns within a cell will cause InDesign to see the start of new Record.
The places where you have listings like
94 pts Wine Advocate
90 pts Wine Enthusiast
90 puts Wine Spectator
with a return after each within the same cell, it throws the whole thing off. Put some kind of placeholder symbol in the spreadsheet to indicate the returns, and then do find-and-replace to get the returns into the InD
...
3
Replies
I wish that was the case. The "94 pts Wine Advocate" portion is its own data ( <<Proscore>> ) and is only separated by a space in the InDesign template. In the csv, there are no paragraph returns within any of the cells. I'm mainly concerned with the consistency of the information within the cells being inserted or replacing other data placeholders. It's strange because I've been duplicating the same csv and switching around the information for the last 5 projects and they've all been fine, except for this current one. If anyone has ANY direction on what I should do, please please help!
I'm starting to wonder, is it a cache or a memory related issue?
Here is the csv in word form.
AdChoices