🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.scripting.indesign
Article #20849

Re: Access Database

#20849
From: Shane Stanley
Date: Sat, 01 Jun 2002 22:38
35 lines
2196 bytes
in article ef8d1e0.11@WebX.aaQKaf7vad4, steve budzynski wrote:

> I've been told that through Applescript, ID2 can read Filemaker fields and
> populate an ID2 document with that information. For example, a product that
> can do this for Quark is Xcatalog from EM Software. Unfortunatly, my
> department does not have the $$ for more software or I would have already
> pursued that option. Am I dreaming or can this be done?

It can be done. Here's a simple example that assumes you have an InDesign
document open with a whole lot of pages all containing a frame labelled
"Name", and a database open, also with a field named "Name":

tell application "FileMaker Pro"
 set recCount to count of records of database 1
end tell
repeat with i from 1 to recCount
 tell application "FileMaker Pro"
  tell database 1
   set theName to cell "Name" of record i
  end tell
 end tell
 tell application "InDesign 2.0.1"
  tell document 1
   set contents of text frame "Name" of page i to theName
  end tell
 end tell
end repeat

The big differences between this approach and Xcatalog -- or InCatalog, for
InDesign -- are (a) speed, and (b) X/InCatalog maintains live links, so you
can later update things more quickly and easily. Both methods have their
place.

-- 
Shane Stanley,  sstanley@myriad-com.com.au
Technical Details
Message-ID: <B91F89F5.31BA1%sstanley@myriad-com.com.au>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!213.73.101.75.MISMATCH!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
References: <ef8d1e0.-1@WebX.aaQKaf7vad4> <ef8d1e0.11@WebX.aaQKaf7vad4>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,575c492b1935dbd8
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2002-06-01 16:07:24 PST
From: Shane Stanley <sstanley@myriad-com.com.au>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!213.73.101.75.MISMATCH!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.scripting.indesign
Subject: Re: Access Database
Message-ID: <B91F89F5.31BA1%sstanley@myriad-com.com.au>
Date: Sat, 1 Jun 2002 15:38:14 -0700
References: <ef8d1e0.-1@WebX.aaQKaf7vad4> <ef8d1e0.11@WebX.aaQKaf7vad4>
Lines: 43
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.3
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit