Are you able to share your data file (or even a copy of it will only the header row remaining).
There is likely to be an error somewhere in the excel file, and it's going to be nearly impossible to diagnose without seeing it.
One thought: could a return character have been introduced to one of your column headers? That will surely mess things up in data merge.
Thanks for this.
But like I say it works fine in CS6. Has done for ages now.
Here's the XLS
And the CSV it exports as
Sounds like a line break in a cell
sorry, didn't see the rest of the thread before responding.
I have a similar problem. I already downloaded textwrangler, ultraedit, smultron, what have you, to create "proper" unicode (none of the programs can do that, btw) and save the file ever and ever again, but:
1) Indesign doesn't recognize the file, or
2) the error "the selected data source has one or more empty field names" or something similar appears …
UltraEdit--the only one on your list that I have/use--certainly does create proper Unicode text files.
Consider uploading a file to dropbox.com or the like.
Thanks for the file.
In UltraEdit--I don't know what to do in the other editors you list--reopen the CSV and save it as per the following:
When opening the file in ID, make sure to show options so you see this dialog box:
And set the Platform to Mac. Assuming you are using a Mac and assuming ID doesn't already have it changed to Mac.
And in ID with Preview of Data (which you should be careful of with multi-record per page merges).
STOP! IT IS WORKING!!
I don't know, what the problem was, but I rebuilt the design in a new InDesign file and now, with the news CSV-file, the data merge seems to work!!
Thank you VERY, VERY MUCH!
Great! BTW, using Preview like I mentioned can break merging. Don't know if that's what happened, but the only way past the problem is to do what you did, which is rebuild the template.