Skip navigation
Currently Being Moderated

Data Merge Multiple Records Per Page Greyed Out

Jun 4, 2012 3:25 PM

Tags: #cs5.5 #merge #indesign_cs5

I am using InDesign cs5.5. I am attempting to create a catalog with the data merge option. I am attempting to do a data merge from the Master Page.

Data Merge 1.png

As you can see in the image, I have inserted my fields from the data source file. All images, original file, and data source file are in the same folder. I am inserting this info on the left sheet of the master file. When I select "Create Merged Document" the "select multiple records per page" is greyed out, however, there is plenty of room on the page for the 8 records I want it to show. See image below.

Data Merge 2.png

 

After watching tutorials, reading, etc. I made sure that my document does not have facing pages. I deleted my "page 2" to avoid that conflict. I made sure that the placeholder "allows overwrite from the master". I also deleted my "cache"/settings" by doing "ctrl, alt, shift" when reopening the program. I read that it may be because the files need to be on the right hand sheet of the master, however, when I move my info to the right sheet, I get the following message.

 

Data Merge 3.png

 

I have watched the tutorial videos, read the entire help section regarding data merge, and have correctly created my data source file. I've tried everything I've seen on the forums, apart from uninstalling and reinstalling. Please tell me that someone can help me figure this out as soon as possible. I'm in crunch time!

 

Thanks a lot.

 
Replies
  • Currently Being Moderated
    Jun 4, 2012 3:31 PM   in reply to Ali_Rauch

    Multiple record merges are limited to one page layouts. Your master still seems to have two pages. I think if you start with a single page master you'll be able to do your merge, and you can apply a different master to the merged file when finished.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 7:17 AM   in reply to Ali_Rauch

    It looks like your problem is with the banners and grid. In my experience, Data Merge will repeat everything that is on your page. Set up a document with a one-page master containing ONLY your repeating elements and fields. Then add the rest of the elements to the meged document afterwards.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 7:29 AM   in reply to Ali_Rauch

    I've yet to try a data merge in CS6, so I'm speculating. First, SRiegel may be correct. Since you can change the master after the merge, I's start with a master that has nothing on it but a single set of your placeholders. From a master page I don't believe the merg should duplicate anything other than the frames that contain fields, and other objects that are grouped with them, but you never know.

     

    Given that your preview looks correct, though, this might be a bug that was present in CS5 or 5.5. The workaround for that is to either take a leap of faith and not use preview at all -- just go straight into the merge -- or to hit undo after the preview if you are nervous. If you undo, it seems to work the same as if you never previewed and the merge should proceed normally. You might want to give that a try.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 7:47 AM   in reply to Peter Spier

    My opinion: Preview bug. The vertical graphic - whether it is grouped to the variable frames or not will not allow a multiple record merge.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 12:06 PM   in reply to Ali_Rauch

    I've never had a merge go over a few minutes for a few hundred records. Is your machine slow in general?

     

    Any third party plugins (including a font manager)? Waht version of Windows are you running?

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 12:40 PM   in reply to Ali_Rauch

    I'm not sure another program that's slowing down ID would necesarily show high CPU usage. What sort of usage is ID showing? How much RAM?

     

    Does ID perform well in general on other tasks?

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 5, 2012 12:43 PM   in reply to Ali_Rauch

    Ali_Rauch wrote:

     

    FYI - After trying the data merge with only the placeholders on the page, and only 30 records, it worked like a charm. It does, however, hang up when trying to do the same merge with all records (182). It gets about 1/3 of the way through the progress bar and then just hangs there...

    OK, that sounds like there might be a problem in one record. Try merging half the records, then the other half. You may be able to isolate which record is causing the hangup fairly quickly by dividing the half that hanges repeatedly, then check for something odd in that record in a plain text editor like Notepad.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 6, 2012 3:35 PM   in reply to Ali_Rauch

    I was recently under a tight deadline to get a document together using data merge. I needed to have two of the records show up per page and no matter what I did, I could not figure it out.

     

    Today, I'm pulling up another document based on that previous file I used. It's a completely different layout (just need to get photos of people set up on a sheet, nothing fancy) and it the multiple records option still didn't work.

     

    I found out why! I had a hidden layer that I used as a guide for what I wanted everything to look like. That hidden layer took up the space needed in order for my records to show up multiple times per page.

     

    If anybody else is having troubles with the multiple record data merge option not working properly, check your layers! =)

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 19, 2013 2:13 PM   in reply to Peter Spier

    Hi Peter,

    I'm attempting to do this multiple record data merge project that will the basis for our publications. I have successfully merged 536 records with 6 records on a page, now I want to apply a different master page to the merge document. Would you recommend that I create a completely different master or can I modify the existing Master A in the merge document?

    I'm grateful for any help you can give.

    thanks,

    Lina

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 19, 2013 2:51 PM   in reply to LinaD36

    I'd probably create a new master, but I don't think it really matters based on the minimal info I have so far. If you edit the current master you run the risk any existing master objects taht were overridden during the merge will be re-asserted, but I think that's unlikley.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 19, 2013 4:58 PM   in reply to Peter Spier

    Thanks, that sounds like the right plan. I had to load the masters I had

    created into a different file because I forgot that I had created two test

    merge files: One where I had merged the data into paragraph styles and one

    where I hadn't. When I didn't rename the masters, it looked like some of

    the data had been overridden.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 10:26 AM   in reply to LinaD36

    Peter,

    I very close to making this work for me. So I've merged all the pages and threaded all the texts together. I've applied a new 2-page facing master to the 1-page merged data, but I can't get the spreads to display as facing pages. The document is set up to have facing pages. Is there a simple way to do this other than to drag the pages from side to side?

    Lina

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 10:42 AM   in reply to LinaD36

    Is facing pages checked in Document Setup?

     

    If you select all the pages in the pages panel, then open the panel menu, is shuffling allowed for both document and selected spreads?

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 10:44 AM   in reply to LinaD36

    Peter, I was able to do this by dragging the pages together, it didn't take that long. But if you have a faster, more automated way, I'd love to hear it.

    Lina

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 10:51 AM   in reply to LinaD36

    Checking facing pages in Document setup and allowing shuffling should do automatically...

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 10:53 AM   in reply to Peter Spier

    Sometimes I have to de-select and then re-select Allow Pages to Shuffle to get it to take on Data-Merged documents.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 27, 2013 1:04 PM   in reply to SRiegel

    Yes, facing pages was checked and the new master applied was a 2-page facing pages master. I checked the Allow Pages to Shuffle checkbox several times and then just hand maneuvered them myself.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

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