CatBase full review
Getting data into a database is the easy part; creating an output template so that minimal work is required once imported into the publishing program is a totally different problem. In this department, CatBase excels and provides full QuarkXPress, PageMaker and Multi-Ad Creator2 support for print, HTML for Web and RTF (Rich Text Format) for any other applications. Database output often consists of a repetitive set of data. For example, a catalogue may have a company’s name and details followed by a list of its available products. CatBase uses Style Sheets to define all aspects of how information will export. For QuarkXPress, this includes font size, style and colour, tracking, baseline shift, scaling, indents, leading, drop caps – in essence, every paragraph function that would usually be set manually. Text box creation – anchored and unanchored – with columns, text inset, frame style, alignment – the list is almost endless. The next step is to decide what each output paragraph consists of. Some of these will be Style Sheets – such as a company name and address; simple punctuation – such as a line feed or tab; a formula or calculation; fixed text or a picture. The last item tends to cause many problems with data output as, in QuarkXPress, it requires an XTension called Xtags (£175, Digital Toolbox, 0181 961 6622) whose command-set is rather difficult to use. In keeping with the general ethos of the program, CatBase hides such complexities, allowing you to set frame details and then call in an existing picture. The final result is an export file that flows seamlessly into a DTP or Web program, requiring minimal further tweaking. CatBase offers integration with a number of existing products, each of which can be purchased as an optional extra. The 4DWrite word processing plug-in (£95; ACI, 01625 536 178) can create emails, faxes and mail-merged documents; the FaxExpress plug-in (£50; Glenwarne, 01628 667 702) can send faxes directly from the database. There is also built-in support for Indextension (£99; CatBase, 0700 228 2273), an indexing XTension for QuarkXPress, and OCR (Optical Character Recognition) that comes bundled with Xerox TextBridge 8 (£69; Digital Toolbox, 0181 961 6622). More exciting is the fact that CatBase can be run as a completely self-contained Web server. This adds significantly to the value of the package.