If you have data in a spreadsheet, data in a database (or just a list of a whole bunch of data that you need to format), how can you make it look good quickly? It might be a directory, or a catalog, but there are all kinds of reasons why you might want to be publishing your data.
InData for InDesign can set up a prototype, then you can point it at a data source (a plain text file that’s been exported), and it can make one long, flowing story, generating additional pages as necessary, containing all the records formatted according to your prototype. It can also optionally add running headers and footers.
While it’s true that InData can perform mail merges, very much like those within Microsoft Word, the term mail merge doesn’t even begin to tell the story of InData. It provides full automation of price lists, catalogs, directories, and even one-to-one marketing pieces using your customer data.
InData automatically applies the format you specify to each element of information as it is imported from the original data source. InData accepts data in the major Macintosh and Windows data exchange file formats, enabling you to use it with textual data created in all major database and spreadsheet packages, or even with data created by hand in a word processor.
InData operates as an Plug-in to InDesign, automatically becoming part of the InDesign publishing system once it is installed. InData runs from inside of InDesign, under its own menu, and imports and formats text into normal InDesign publications. It is not a stand-alone program which must be run separately from InDesign, and no special additional files are required.
Using InData involves three elements
- A raw data file, containing the records to be imported and formatted using InData and InDesign, exported from a database or spreadsheet application, or prepared by hand using a word processing program. Generally, these records are stored in an external file, but they may also be imported from the clipboard or from a text story on the InDesign pasteboard.
- A InDesign document, either designed from scratch or created by opening a template.
- An InData prototype, which tells InData how the imported records are to be placed and formatted. The prototype is not a separate file, but rather exists as text within the InDesign publication.
InData does far more than just import text. The real power lays in the support of Boolean expressions. The most well-known examples of Boolean expressions are the and, or, and not operators. Use this to check the content of a field and then perform an action. For example, you could check the field that contains gender information and if the content indicates male for a single record, you could set the salutation of your letter to Mr. and if the gender indicates female, set the salutation to Ms.
With InData, you can:
Publish automatically using a “prototype” (template) for your records
In your template text, use bracketed names to identify each incoming data field, e.g., name, address or description, and style each field with appropriate text and paragraph attributes. You can weave in static and dynamic text and pictures, include your fields in any order, or omit fields entirely.
Get results as either a beginner or an expert
Do simple jobs easily, and still tackle the toughest and most complex jobs with power.
Import pre-sorted delimited text files
Sort and then export from your database application, spreadsheet applications (e.g., Excel), or download from the web or your corporate information systems, and then import the resulting data file with InData, fully formatted.
Enjoy unlimited data
Use as many fields and records as is practical, with each being as long as needed.
Do sophisticated picture importing and sizing
Import related graphics into picture frames anchored in the incoming text. You can size the graphic to the picture frame or the frame to the graphic, using one of several sizing options.
Calculate and store information for later use in the prototype, or for use in later records.
Use conditional statements
Create more sophisticated record templates that apply different formats to a field, based on its or another field’s value. For example, you can print heads and subheads only when they change, or generate a page break, given a change of value indicating a new section or subsection.
Use repeat loops
Loop over data elements (character or words or lines), looking for particular information, or even repeat whole portions of the prototype.
Build with automated headers and footers
Create multiple, independent “dictionary-style” headers and footers on each page or spread, with sophisticated controls over the header/footer contents.
Apply multiple master pages
Based on incoming data, use different page layouts by applying master pages.
Drive InData with scripts for automation of repetitive single jobs, as well as large, complex jobs involving multiple imports in multiple documents.
Team up with InCatalog
Build your templates with InCatalog links embedded. Later, using InCatalog, you can update fields in place from updated data, or extract any document updates to your data.
Enjoy full Unicode support
In your data to be imported, use the full Unicode character set in various encodings (auto-detected at input time).
Do not perform repetitive tasks. Using InData, the reduction of time and frustration make them well worth the investment from the very first job.