Skip navigation
joshuasamuel
Currently Being Moderated

data merge malfunction

Nov 23, 2012 10:22 AM

I have an Excel file (which I export as a csv) and an indesign file that's set up perfectly in my opinion, but I don't know.  I've put Paragraph styles on it and have he csv file in the images folder. the csv file has the right set up with @images etc... but it is just working for the first one.  when I go to "Create Merged" then choose multiple record, the preview comes up wrong. Ive tried without doing preview and it still comes out bad. Ive filled all the blanks with "---" as place holders, still won't work. 

 

Basically my first product comes in great, but then the rest of them come in mixed up. For instance the description will go to the title or the "type" will go to the "Title" etc... Its just having issues and I can't pin point it. I have a client who is waiting for his product cataloge and I am struggling. hopeing I dont have to do it all by hand, but I really need help. 

 

Any ideas? 

 

Thanks so much either way,  josh

 

http://f1.creativecow.net/4990/csv

 

I can put on the image files and the indesign file too, but I feel like its a problem with my Excel file.

 

I am using a mac, indesign cs5

 
Replies
  • Currently Being Moderated
    Nov 23, 2012 10:38 AM   in reply to joshuasamuel

    Try merging without pressing preview first. There are some bugs....

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2012 10:50 AM   in reply to joshuasamuel

    Did it work?

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2012 10:55 AM   in reply to Peter Spier

    I looked at your file. Multiple record mereges only work with single-page masters, as far as I know.

     

    Try going back to Doucmtn setup, uncheck facing pages, and assign the None master to the document page, then run the merge without doing a preview.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2012 12:44 PM   in reply to joshuasamuel

    Might be an obvious one, but you haven't got tabs or comma's in any text you're trying to bring have you? that would mess up the placement as the data merge would see the commas/tabs as seperation markers...

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2012 2:47 PM   in reply to joshuasamuel

    I downloaded your excel file and I'm pretty sure that's where the problem is. Not only do some fields have text containing commas, making .csv a poor choice for format, but some also appear to have line breaks, and those just aren't properly supported when you save as text formats, so you've got records that are short fields and others that start with the second line of waht was the last field in the previous record, and that sort of thing. I didn't spend a lot of time poring over the file, but I think if you clean up the data, the merge will probably work.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 24, 2012 10:06 AM   in reply to Peter Spier

    Would a tab delimited data file work for this instead of CSV?

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 24, 2012 10:43 AM   in reply to Larry G. Schneider

    I actually saved one from the excel file inthe first link and that failed as well. As I said, I didn't comb through the file, but I I did see at least one cell with two lines of data separated by a balnk line, all within the same cell, and I suspect there may be more than one. Though I'm not sure how you enter the data with the breaks, Excel does allow them.

     

    I've take another look and the description cell are rampant with this (and with commas). I've also looked again at the CSV that Joshua linked, and it has the same problem. There's jut no way ID is going to accept those breaks in those positions.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 24, 2012 10:45 AM   in reply to Peter Spier

    Thanks for the reply, Peter.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points