OS 10.8.3 - CS5
I have been using Data Merge for simple tasks, but now I have run into problems.
I have about 100 records and about 22 colums for each.
I try to create single page of each post.
The labels come in fine in Data Merge Window, but as I try to Create a merged document I get the message:
"There is at least one data placeholder that cannot be found in the data source. Make sure all the placeholders correspond to the fields in the data source."
And the placeholders do correspont to the fields.
The content in each record consists of running text of about 1000 characters - is this no go?
Thank you for tip. I have tried and I have tried saving the .txt file as UTF-16.
Now I get no error messages.
However I only get the first few fields (containing names and titles) and the first field containing running text - the following fields doesn’t appear.
I checked the text file and I cannot find the consequens how each text field is marked up.
The first text (which appears) is marked only tab" and the following (which doesn’t appear) "tab"
So - I tried changing all field to be marked tab" - but no succes.
Do you know what is the correct markup for running text?
There could be a limitation, because the text is several lines long? I would have to see the file to be certain.
That is one of the reasons we use HP Smartstream, a more sophisticated plugin for datamerge and inposition.
Perhaps you could send the file through a PM, so I can look at it.
Does your running text have line breaks? Data merge cannot handle line breaks within a field, but the result is usually scrambled output, though it might well generate the error that you have a field with no heading in the data file.
Peter, Thanks - I supposed so - I removed the line breaks and that allowed me to get the result described in post 6. Up to longer running text I could not make the text appear.
I think Data Merge I not the solution for this task.
I have more than 100 returned forms which I imagined could be layoutet through Data Merge. But too much cleaning up if possible at all.
Laubender - Yes I have updated many times and the names doesn’t change.
Bravenboer - Thanks, but I think the solution isn't Data Merge, I need linebreaks and up to 1500 characters.
XML might be a solution. Without a copy of your data file (the Excel file) I wouldn't be certain if it would work for you. Excel creates pretty unnecessary garbage in its XML, but using an XSLT transform, it can be cleaned-up for import to ID.
If you would like me to try, upload the file to dropbox.com and PM me a link.
Take care, Mike
When I have data file with linebreaks I substitute some otherwise unused character or character combo as a tag and run find/change after the merge to change the codes to the breaks. But that doesn't solve the 1500 character problem. I typically work in Excel, and I find it truncates long blocks when saving as .csv or .txt, but I don't think there's any reason you cannot have as many characters as you like if you are working directly in a text editor.
That said, Data Merge is not terribly sophisticated. It's really meant for things like address labels, and more complex documents would probably do better with xml or one of the commercial catalog plugins.
I agree with MikeWenzloff that XML would be a more appropriate solution for this task.
Data Merge is great for business cards, direct mail items... simple stuff... but for instances where line breaks have to be preserved and there's lots of data... XML is the go. The learning curve is really steep though and there are few resources on the issue. Best one is this book by Jim Maivald: http://www.amazon.com/Designers-Guide-Adobe-InDesign-XML/dp/0321503554
Just as a declaration, I recommend the book as a resource and have no commercial interest in it at all.