FORUMS: list search recent posts

Merge from Tab Delimited or other Formats

COW Forums : Adobe InDesign

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Tak West
Merge from Tab Delimited or other Formats
on Apr 30, 2009 at 11:20:12 pm

I am thinking of switching from Quark to InDesign just to keep the whole Adobe workflow happening.

Is it possible to set up a system to merge tab delimited, or Filemaker or Excel info into an InDesign layout?

Essentially I have a series of Eight Cards on a page. I have a data base of Trivia Questions in Filemaker. I'd like to automate the insertion of Questions on these cards and then answers on the reverse side of the cards , kinda like Trivial Pursuit cards.

I have five thousand Questions and Five Thousand answers so automating would certainly save me time.

Is something like this possible? Thanks

TAK



Return to posts index

Terry Mikkelsen
Re: Merge from Tab Delimited or other Formats
on May 1, 2009 at 12:44:47 am

Sure it is possible, but also easy to do. You simply do your layout the way you want it. Put in "dummy" info so you can format it (colors, fonts, etc..). Once it is beautiful, you select "Window>Automation>Data Merge". This will bring up a new palette. Here you select the data source. (I've only used Excel and txt tab delimited data, so not sure about the FileMaker compatibility) After the source data is loaded, the headers will show in the palette. Simply highlight your "dummy" data and then double click the corresponding header name. It will place the text "<>" in that position. Once all the data is placed, you click on the check box in the palette labeled "Preview". This will show your the first page of your doc, and you can use the arrows in the palette to see the other pages. If it is to your liking, you then select "Create Merged Document" from the palette. This will make a completely new document with all the pages (however many were in your source data) laid out nicely.

It really does take 10 times longer to explain it, than to actually do it. It is quite easy. I do this quite often for short run numbering such as raffle tickets or invoices.

Tech-T Productions
http://www.technical-t.com


Return to posts index

Tak West
Re: Merge from Tab Delimited or other Formats
on May 2, 2009 at 5:03:11 am

Thanks... I am about to make the switch and start taking the Lynda.com tutorials...

TAK






Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2017 CreativeCOW.net All Rights Reserved
[TOP]