Notions Catalogue created with Applescript

Objectives

Create an automated method to import raw spreadsheet data into QuarkXPress and format the data.

Allow catalogue to be created and updated in small sections.

Eliminate the need for the graphic artist to make revisions in QuarkXPress.

Program Features

applies paragraph and character style sheets

recognizes fractions and reformats them using the appropriate kerning, point size and vertical offset

style sheets applied in Excel are used to format QuarkXPress document

capitalizes words in product descriptions unless the word is in a list of exceptions

imports an EPS file for each barcode and resizes it if necessary

product and UPC number of missing barcodes are output to text file for easy batch creation

anchors and aligns imported barcodes

preferences to define capitalization exceptions and barcodes' location

removes additional spaces

links text boxes

adjusts modification date on document footer

removes extra pages from end of document, after prompting user

Notes

There was an overall increase in the efficiency of creating the catalogue for several reasons:

eliminates graphic artist's involvement in editing the description and other information

allows a much greater amount of typographical flexibility because the formatting is handled on a large scale by the computer

speed in producing a section of the catalogue is reduced from several days' work to a coffee break

Software

QuarkXPress 4.1, Microsoft Excel 98, MacOS 9.1, Applescript