Getting It Together with PageMaker 7

Adobe endowed PageMaker 7 with the ability to merge information in from external files, giving us the best DTP solution yet for tasks such as integrating data for catalogues. Luisa Simone shows how to exploit Data Merge to its fullest.
Written by Luisa Simone on August 20, 2001

Related Reading

You don't have to limit PageMaker's Data Merge function to a simple address list. If you collect meaningful information about your customers you can use the Data Merge function to personalize your promotional pieces. In Figure 4, for example, you can see three different ways we personalized this sale announcement. The customer's first name was employed in the salutation. A custom field ("Shoes") was used to identify the kind of shoes that the customer purchased last. And finally, a unique coupon number was created to encourage the customer's next purchase. A quick preview of the data merge (Figure 5) shows how the live data integrates with normal paragraph text in PageMaker.


Figure 4: Data Merge lets you insert field names into standard text to personalize the content of your mailings.

Figure 5: Previewing the data merge shows how live data will appear in your document.

At output time, use the Merge Records command on the Data Merge palette menu to permanently replace the field names with live data. PageMaker does not alter the current document, which remains intact and linked to the external data source. Instead, PageMaker creates a new document.

The Merge Records dialog box (Figure 6) contains a number of powerful options that control the structure of the final publication. For this project, we chose the default options, which incorporate all of the records in the data source and limit the publication size to 50 pages. This last option is very important. When PageMaker generates the final document, it duplicates all pages in the original document for each record in the data source. If you are mailing a two-page personalized letter to 500 recipients, for example, you could unwittingly create a 1,000-page document.


Figure 6: The Merge Records dialog box controls the structure and size of a new publication that includes live data.

More than Mail Merge
Up to this point, we have used the Data Merge function to retrieve only text-based information. But PageMaker's Data Merge can also handle images, by reading the path and filename of the images from your external data file. In order for PageMaker to correct identify path names, the image field must be identified with an @-sign at the beginning of the field name, such as "@Image" as shown in Figure 7.


Figure 7: Including an @ symbol in a field name of your data file signals that values of that field are file and path names -- to images, for example.

The following common-sense tips will allow you to merge images into your PageMaker publications without a hitch.

  1. Ensure that the @ sign is correctly interpreted as text. In some applications -- spreadsheets, for instance -- you will be required to type an apostrophe (') before the @ sign.
  2. When entering data into an image field, follow the file-naming and pathname conventions for your particular operating system. Mac pathnames, for example, will not be recognized on Windows.
  3. Remember that file and path names are case sensitive, so pay attention to capitalization.
  4. Prep the images you plan to use in your publication in an image editing program, such as Photoshop. Convert all images to an appropriate color space (such as CMYK for print output) and to a single consistent size.

In our sample catalog, we created frames to contain text information such as product name, an ID number, price, and descriptive copy. We formatted the text placeholders using standard PageMaker paragraph styles. We also created a frame for an image, which we sized, positioned, and formatted with a black rule. With the frame selected, we clicked the @Image fieldname in the Data Merge palette. We confirmed that we wanted to create a floating image placeholder in the dialog box that appeared. As you can see in Figure 8, PageMaker displays an empty box (rather than the fieldname) for frames that contain images. But the actual image data will appear when the records are previewed or merged.


Figure 8: Image placeholders appear as a nondescript box (near the upper right corner above) rather than as a fieldname.
1

Pretty cool feature

This is a neat upgrade for PageMaker. We use xdata/xcatalog for QuarkXPress to keep a live connection between FileMaker databases and documents and you're talking over a grand for the whole thing. We're a publishing firm.

If you're a savy small business user, this feature is pretty cool.

Thanks for showing this feature. Can you write a PageMaker script for it?

xdata/xcatalog and QuarkXPress are all AppleScriptable which is a major drawing point.

2

Other alternatives

"the best DTP solution yet for tasks such as integrating data"?

Ventura has had better publishing solution from database for years. Even Corel Draw can merge data direct from database.

3

Nice tutorial. Good thought starter on how I could use PageMaker

I switch between Quark and PageMaker depending on the project. PageMaker 7's Data Merge feature could be very helpful for me.

4

Data Merge is old news

This new feature might come in handy once in a while, but Filemaker has been doing the "graphical database" for years. My pick for best feature in PageMaker 7 is the dandy content CD packed with the Plus version. It's got lots of good EPS clip art and a useful thumbnail catalog.

Post a Comment

  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <p> <div> <br> <center> <img> <h2>
  • Lines and paragraphs break automatically.
  • Use <!--pagebreak--> to create page breaks.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.