I have a bit of an issue with data merge. I have about 35 product sell sheets, all with the same categories. I am trying to do this via data merge in indesign (ind cs6). Now the csv file that I am using is very large. It has about 75 columns in it. Some of the columns have a lot of text like the ingredients for each product which can be up to 200 words or more. My problme is that when I create a merged documnet I am only getting the first 6 columns to populate the document.
I have tried everything: taking out all myspaces in the header rows, eliminating all the empty columns etc. Funny thing is when I delete the first 6 columns and try again, the next 6 will populate just fine.
Is there some sort of column imit in the csv file?
I cannot figure this out for the life of me and have read every forum I can get my hands onbut they all seem to talk about business cards, envelopes or building a simple catalog template, nothing that includes this much information to be merged.
Any help at all would be greatly appreciated, thank you.
I do an association directory once a year with data merge and it has about two dozen fields ( and the first time I did it I used the client's Excel file with another two dozen irrelevant columns as the source), so no, the number of columns should not be an issue.
Can you show us a screen shot of your template? Are you using the Preview feature?
well I just took out all the periods, (), %, and everything else. Still the same result. I even shortened all of my header titles so I didn't have any overflow text. I know the solution has to be staring me in the face.
How did you create the .csv? Have you also tried Tab-Delimited .txt? Are there any line breaks inside any of the fields (your descriptions, for example)?
Again, are you pressing the preview button before you merge? If you are, try without.
I created the csv file by going to the site I have my clients fill ot the form with (formassembly.com) and download a straight csv file. I then clean it up in excel.
I have tried tab delimited.txt as well and get the same result, and yes there are plenty of line breaks in the descriptions underneath my header rows. You think that could be a problem?
and yes i have tried previewing it before hand and not previewing it before.
SAUTEED VEGETABLE PUREE MIX (CARROTS, ONIONS, CELERY), SALT, SUGAR, MALTODEXTRIN, CORN OIL, LESS THAN 2% OF AUTOLYZED YEAST EXTRACT, WATER, POTATO STARCH, XANTHAN GUM, NATURAL FLAVORS, CARROT JUICE CONCENTRATE.
the text above is what comes through in the ingredients in one of my data rows. It's the last thing that works out of the 6 columns that are getting carried over properly.
so you're saying to replace all the long text with breaks with something like "ingtxt" then do a find and replace? I'll try that.
I actually tried that too. and same thing, I get all the ay to the 6th column before it quits importing. It has to be somethign in that ingredients column I think. But if I go into that csv file and delete the first 6 columns, I get the next 6 columns to go through but nothing more. I'm at a loss.
What is the file's format in the sense of ASCII, ANSI, UTF-8?
As a last resort, can you share the CSV file via dropbox.com? If you cannot share it publically, consider uploading it to dropbox.com and providing a link to it via a private message.