The only way to accomplish this with a datamerge is to modify the data source. You would have to change data so one record is on one row and look like this:
N1 P1A P1B P1C N2 P2A P2B P2C N3 P3A P3B P3C N4 P4A P4B P4C
completely agree with Jeffrey_Smith. Can be done, but it's all how the header row is presented.
at the moment i'm guessing that the header row is:
NAME PHONE1 PHONE2 PHONE3
The header row as it is won't work because indesign's data merge doesn't have the "next record" feature that Microsoft Word's "Mail Merge" has. Instead, you would have to do as Jeffrey_Smith suggests, which is:
NAMEA PHONE1A PHONE2A PHONE3A NAMEB PHONE1B PHONE2B PHONE3B NAMEC PHONE1C PHONE2C PHONE3C NAMED PHONE1D PHONE2D PHONE3D
in the top left text box, add the fields into the text box as such:
PHONE1A PHONE2A PHONE3A
PHONE1B PHONE2B PHONE3B
PHONE1C PHONE2C PHONE3C
PHONE1D PHONE2D PHONE3D
so far as the 4-up, i'm assuming that this is for the purpose of imposition for trimming later. If that's the case, simply copy and paste the textboxes to their desired positions.
hope this helps.
CDFlash, you're correct--The header row is Name, Phone1, Phone2, Phone3
The actual application is for a GET OUT THE VOTE effort. (Helloooooo, grassroots!)
The four-up will be printed on a single sheet of paper, and on election day, one section will be torn off at four differnt times during the day.
Reformatting the Excel (::CSV) file is certainly an option, albeit not one I'm thrilled with. I've simplified the data above for the purposes of this thread. In reality, I have four fields for name (first, middle, last, suffix) and 3 fields for phone numbers.
I won't get the final CSV files until very last-minute, so I'll be working on a very tight deadline.
CDFlash- When you suggest adding that info into the top left text box, are you suggesting to reformat this in the Excel file?
I'm currently looking into ways AppleScripting might take out some of the manual work, whether in InDesign or in the Excel file. Again, open to any/all suggestions!
1 person found this helpful
rather than try to explain in this forum, i've made a demo of what i think you're after, as well as the indesign file and associated text file. go to http://colecandoo.files.wordpress.com/2012/11/namequestion.pdf which features the results I think you're after, and in the Attachments component of the PDF (look for a little paperclip item) the associated indesign file plus the text file it is using for the data merge.
put simply, indesign works with a one to one database relationship. what you're asking is a one to many database relationship, which indesign can't do.
there is another solution involving data merge which doesn't require redoing the database, BUT it requires post-processing the merged file and has many critical control points which may cause issues.
That method is to make a textbox IN INDESIGN FILE AT FINAL TRIM SIZE which has the data merge fields for one record only e.g.
<<PHONE1>> <<PHONE2>> <<PHONE3>>
then merge the file using the multiple record feature so that four records are returned for each page.
From here, follow the instructions in this post: http://colecandoo.wordpress.com/2011/10/28/theres-more-than-one-way-to-cut-and-stack/
ultimately, how easy/hard this task can be is determined by whether or not the artwork is imposed or not. Is this something that is going to be printed on a desktop printer in your own office; or something handed off to a commercial printer to print? if the latter is the case, I would let the printer handle the imposition as they have dedicated software for that purpose.
hope this helps.
I'll be starting with 5 separate Excel files, needing to produce 5 separate documents. Lucky for me, there's no crossover in the data. It just means I need to find a workflow, and repeat it with 5 sets of data.
This is going to be printed on a desktop printer. After some noodling around, it looks like multi-page importer is going to work just fine.
For any folks with similar problems, my final workflow:
- Create InD doc (a mere 2.75" tall!) with one set of data in one text box.
- DataMerge (multiple records), which produces 4 records per tiny page.
- Save the DataMerged InD file
- Add any necessary elements to the A-master (page numbers, labels, etc)
- Export a PDF of that file.
- Create new InD doc the size of my paper.
- Run multi-page import, placing the PDF in the upper left corner.
- Run multi-page import a second time, placing the same PDF file, but offset (2.75", in my case)
- Run multi-page import a third and fourth time, placing the same PDF file, changing the offset. (5.5" and 8.25", in my case)
When I downloaded the multipage importer script, it didn't have any instructions as the link said it would.
You can then access this script in InDesign by going to Window>Utilities>Scripts.
Thanks to cdflash for pointing the way!
glad i've been able to help.
the original author of the script (Scott Zanelli) originally wrote instructions for the script and they are available from the SECOND link on the indesignsecrets.com page, as well as the script: http://www.indesignsecrets.com/downloads/MultiPageImporter2_5.zip
however, Scott has moved into other work so his work has been carried on by another author who didn't include the instructions.
nevertheless, glad a solution was reached