Solved

InDesign CS6 Data Merge Problems

Posted on 2014-02-09
20
1,767 Views
Last Modified: 2014-02-25
Hello!

I am working on a draft guide, and all of the info from my client has been compiled in a excel document.

I have exported the file as a csv and have done a data merge in Indesign CS6; however, I am getting odd blanks and breaks within my file when I created the merged document.

Please see the attached InDesign file for reference.

Since I'm dealing with a document involving multiple pages, I'd love to figure out the issue instead of having to correct everything by hand.
0
Comment
Question by:halipe
  • 10
  • 10
20 Comments
 

Author Comment

by:halipe
ID: 39846344
PDF of the indesign file is attached as well as the excel sheet with data needed for the data merge
Copy-of-SlantData-2014.xlsx
The-Slant-04-2013.pdf
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39846714
Can you post the indd file? So I can check the result using my computer.
0
 

Author Comment

by:halipe
ID: 39846926
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39847023
The Problem is in the data source.

If you look in the Excel file, for ex in cell E3, you'll see that it has 2 lines of text:
Oviedo, FL
Oviedo, Fla

When converting to csv, those cause a line break, thus breaking that row into 2 lines that Indesign import into 2 pages.

There were several paragraph characters inside your data source. Removed them and attached the csv.

Did not see any more problem pages in Indesign

HTH,
Dan
Copy-of-SlantData-2014.csv
0
 

Author Comment

by:halipe
ID: 39847065
You are a lifesaver! Thank you SO much. This fixed it!

I have about 100 other entries that will be coming my way. Is there any way you can tell me how exactly you fixed the file, so that I'll know what to do moving forward?

Thank you again. You have saved me HOURS.
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39847082
The easiest way is to look inside the csv using a text editor.
I use Notepad++, but plain/old/vanilla notepad will do just fine.

Just make sure Format->Word wrap is NOT selected.

Then just look at the beginning of the lines: if it's a player's name, it's ok. If not, then probably that line was cut because of an end line character in Excel.
Put the cursor at the beginning of the line and press backspace, to join the line with the previous one, where it belongs.

You'll get quickly the hang of it. It took me about 30 sec on your file.
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39847330
Here's a quicker way: in Excel, press CTRL+H (Find and Replace).
Click in the Find box and press CTRL+J. The cursor will change to a dot (.)
Click on the Replace box and press SPACE.
Then click on Replace All

What you just did is delete all the line breaks in the file and replace them with spaces, so now you can save as csv and all will be ok.

HTH,
Dan
0
 

Author Comment

by:halipe
ID: 39868650
So, the CTRL+J does not work in Mac Excel 2011. Any thoughts on how to do this?
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39868680
Have you tried COMMAND + J? I don't own a Mac, but usually you can substitute CTRL with COMMAND and ALT with OPTION.

If it does not work, try inserting it manually as OPTION+010 or OPTION+013.

HTH,
Dan
0
 

Author Comment

by:halipe
ID: 39868688
Got it to work using dreamweaver as my text editor and your previously mentioned advice.
The Option 010 wont work either

Thanks!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39868709
You're welcome.

You could ask someone with a PC to make the substitutions in excel...
0
 

Author Comment

by:halipe
ID: 39886881
So, it appears this will no longer work!!! Any suggestions on how to fix it?

https://www.dropbox.com/s/dbjp2sq91cash8l/TheSlant-DraftGuide-2014-PlayerSheet.indd

Wishing the client had had me do all the merging at once, as I feel the going back in multiple times has caused issues.

If i try to update the source with the next round of info. all of the fields in my data merge go blank.....
Copy-of-SlantData-2014-WR.csv
0
 

Author Comment

by:halipe
ID: 39886895
Just figured it out. the line of code with the data merge titles had gotten erased.
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39886901
I see you updated the indd with Indesign CC. I only have Indesign CS6, so you will need to do a save as and choose "Indesign CS4 or later"
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39886904
Good, cause your csv file looked OK :)
0
 

Author Comment

by:halipe
ID: 39886929
Seriously - cannot thank you enough for all of your help with this. You've saved me SO much time!

I do have two fields that I will need to go back through and enter for all of the pages. Any suggestions on the best way to go about doing this? Will I have to go in page by page and do it by hand, or could I figure out a way to data merge it? (it's the vertical and bench press that were just recorded at the combine....)
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39886959
Are those 2 new fields or fields that were already on the page, but you had them blank in the csv?

If they are new, redo the template and then re import the data.

If they were in the template, but with no content on the csv, empty the template and then re import the data, cause it's faster.
0
 

Author Comment

by:halipe
ID: 39886980
they are two fields that are already on the page but they're blank

Empty the template within indesign and just code for those two fields? It wont touch anything I've already merged, right?

But how do i get it to do this for all the pages? Originally if i tried to data merge on a multi-page document it would not work....
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39886989
No, empty the template and re import all your data. You will lose any manual formatting you've done so far.
It won't work to import just those 2 fields.
0
 

Author Comment

by:halipe
ID: 39887013
well poo. there are 125 pages currently. grrrrr.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I. Introduction In a previous article (http://www.experts-exchange.com/Web_Development/Document_Imaging/A_6537-PaperPort-Upgrade-How-to-download-and-install-updated-versions-of-PaperPort-11-and-12.html) (now deprecated), I discussed how to upgrad…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
The goal of this is to tech the user how to export photos out of Lightroom and the different options they have. Select which photos you want to export : Select where you want to export and with which options : Export :
The goal of the tutorial is to teach the user how to remove a natural vignette your photos and how to add vignette to your photos.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now