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 catalogue, but there are all kinds of reasons why you might want to be publishing your data.
Xdata for QuarkXPress 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 Xdata can perform mail merges, very much like those within Microsoft Word, the term mail merge doesn’t even begin to tell the story of Xdata. It provides full automation of price lists, catalogues, directories, and even one-to-one marketing pieces using your customer data.
Xdata is a sophisticated data publishing product for use with QuarkXPress. It automates the formatting of documents containing repeating data units such as catalogues, directories, mailing labels, price lists, and schedules, supporting both text and graphics. Formerly, each separate element in such documents had to be formatted by hand.
Xdata automatically applies the format you specify to each element of information as it is imported from the original data source. Xdata 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.
Xdata operates as an XTension to QuarkXPress, automatically becoming part of the XPress publishing system once it is installed. Xdata runs from inside of QuarkXPress, under its own menu, and imports and formats text into normal XPress publications. It is not a stand-alone porgramme which must be run separately from QuarkXPress, and no special additional files are required.
Using Xdata involves three elements
- A raw data file, containing the records to be imported and formatted using Xdata and QuarkXPress, exported from a database or spreadsheet application, or prepared by hand using a word processing porgramme. 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 QuarkXPress pasteboard.
- A QuarkXPress document, either designed from scratch or created by opening a template.
- An Xdata prototype, which tells Xdata how the imported records are to be placed and formatted. The prototype is not a separate file, but rather exists as text within the QuarkXPress publication.
Xdata 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 Xdata, 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 Xdata, 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 sising
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 sising 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 Xdata with scripts for automation of repetitive single jobs, as well as large, complex jobs involving multiple imports in multiple documents.
Team up with Xcatalog
Build your templates with Xcatalog links embedded. Later, using Xcatalog, 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 Xdata, the reduction of time and frustration make them well worth the investment from the very first job.