"Catbase has enabled us to complete projects at a fraction of both the cost and the time of doing so without the Catbase software. In addition the support that the Catbase team have given us has been superb"

– Chalvington Press

Publishing Workflow Example:

From MySql or Sql Server to InDesign

With CatBase it's very easy to produce a publication such as a catalogue, price list, or directory using data from a MySql or Sql Server database. You don't need to do any programming or write any scripts; you simply make selections in dialogue boxes in CatBase. Take a look at our short demonstration movie to see the process, and then read the rest of this Tutorial to find out more about how it's done.

CatBase integrates well with MySql!

This example shows how easy it is to extract data from an online MySql database and publish it with InDesign. But you can also publish data TO a MySql database. You can see an example here.

It also works with MS Sql Server

The process is exactly the same if your online database is Microsoft Sql Server: you can publish data to your SqlServer database and you can also extract data from a Sql Server database and publish it with InDesign or QuarkXPress.

See some more CatBase demonstration movies here.

Database publishing simplified!

CatBase makes it easy to produce your publication using InDesign. It does all the hard, boring work for you! The process, in a nutshell, goes like this:

  1. Get your data into the CatBase database. You can either enter it manually, import a delimited text file, or (Data Chameleon Edition) extract it from a MySql or ODBC-compliant database or spreadsheet (such as Microsoft SqlServer, MySQL, Access, etc.)
  2. Set up Publishing Style Sheets in the CatBase database. These tell CatBase what data you want to publish and how you want it sorted and formatted. You can have any number of Publishing Style Sheets, so you can publish your data in lots of different ways (and to various publishing destinations).
  3. Define a Set of records (for example, all records in the table; all people in Arizona; all products in a certain category; or all new products, etc.).
  4. Define a Publishing Project, which describes which Set of data to publish, which Publishing Style Sheet to format it with, and where to save the resulting file.
  5. Click on the Publish Data button on the main window to publish the data.
  6. Import the resulting file into your InDesign template. All the text is - magically - formatted exactly as you want it to be, with pictures included if appropriate!

What do do next ...

About Us | Site Map | Privacy Policy | Contact Us | ©2009 CatBase Software Ltd.