🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.scripting.indesign
Article #17060

Creating a database driven catalog

#17060
From: Stephen Gilkes
Date: Thu, 03 Jul 2003 10:00
13 lines
1553 bytes
I would like to create a catalog from an Access database.

I had explored the idea of some kind of catalog plug-in but they are too expensive. Anyhow I have been reliably informed that I could make a better job of it using scripts (if only I could get my head round them).

The database is very simple, just consisting of the follwoing fields:

ProductCode, Manufacturer, Category, Retail Price, Sale Price, Description, ImageName (the "imagename" field contains the file name of the corresponding JPEG image of the product)

I would love to be able to create an InDesign layout showing all the enties in the database with the corresponding image.

I have put images of the table properties and an idea of how the catalog should look on a web page:

 <http://www.lemonpebble.co.uk/catscript>
Technical Details
Message-ID: <1de9c708.-1@WebX.la2eafNXanI>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,84b7037141554590,start
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2003-07-03 03:08:03 PST
From: "Stephen Gilkes" <stephen@faxshot.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.scripting.indesign
Subject: Creating a database driven catalog
Message-ID: <1de9c708.-1@WebX.la2eafNXanI>
Date: Thu, 3 Jul 2003 03:00:32 -0700
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit