-
1. Re: problems with datamerge and empty cells
P Spier May 21, 2014 9:54 AM (in response to CoGordo)What is the exact wording of the error message?
I suspect you have one or more records that have an extra field in them.
-
2. Re: problems with datamerge and empty cells
SRiegel May 21, 2014 10:00 AM (in response to CoGordo)It means that one or more columns contain data, but have no header. When I run into this, I go back to my Excel document, cut and paste the columns I need into a new worksheet, and then make a new csv.
-
3. Re: problems with datamerge and empty cells
Jeffrey_Smith May 21, 2014 10:11 AM (in response to CoGordo)The cell may have content, but the issue might be a space before the name in the header or an illegal character in the header. Also, how are you looking over the csv file, Excel or Text Editor? Excel might not reveal potential issue, and viewing csv in a text editor may help to find culprit.
-
4. Re: problems with datamerge and empty cells
CoGordo May 22, 2014 12:35 PM (in response to Jeffrey_Smith)Thanks guys. I ended up following Jeffery's advice and viewing the file in text edit and found the empty fields. @Sriegel cutting and pasting worked great once I knew where the empty fields where. You guys are awesome! My customers and I thank you.



