Solved

Using a Filemaker database with Quark?

Posted on 1998-08-11
3
1,161 Views
Last Modified: 2008-03-17
Can anybody around here tell me how I can make a Quark document contain Filemaker infos?
I would like to write a letter to  several persons have Quark do the addressing automatticly.
0
Comment
Question by:bickel
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
gormenghast earned 100 total points
ID: 1539961
Hi
QuarkXpress and FileMaker Pro are both scriptable, so you could create an AppleScript to generate your Quark documents. The address information can be accessed from your database and the content of the letter can be accessed from a text file/another Quark document or a database. This can then all be put together and formatted into as many separate Quark documents as required.
This will require some knowledge of Applescipt of course, but it is not too dificult and well worth learning.

Alternatively there is a QuarkXpress Xtension called XCATALOG which offers a comprehensive database linking scheme between databases and Xpress documents but is rather expensive.  

     Check out
     http://www.xpsi.com/
     for more details of Xtensions for QuarkXpress





0
 
LVL 2

Expert Comment

by:Osiris010898
ID: 1539962
Also if you visit Apple's Applescript website, there are online lessons/tutorials that show you how to import Filemaker Database info into Quark, by creating the actual scripts.

Here's the address:

http://applescript.apple.com/applescript_overview/dbase_lessons/DBASE_LESSON.00.HTML

Here's a description of the lessons:

Lesson Descriptions

   The following tutorials are designed to be followed sequentially. The topics and examples build in complexity and often rely on information presented in a previous lesson. Therefore, we urge you to follow them from the beginning, starting with Lesson #1.

      Lesson #1  The Mail Merge
           This lesson covers the most basic elements of database publishing: transfering information from a database to a QuarkXPress layout. Data from a field in FileMaker Pro is used to replace targeted text placeholders in a QuarkXPress document and placed in specified textbox containers. The ending example is a mail merge between a names and addresses database and a form letter.

  Lesson #2  Slugging & and Building
      This lesson describes a valuable techinque for automating the production of exisiting custom and grid-based layouts. Both picture box and text box containers in a QuarkXPress document are assigned names containing a unique identifier value from a specified field in the database. The script then finds the named boxes in the QuarkXPress document and retrieves the data from a record in the FileMaker Pro database that contains the unique identifer found in the box name. The retrieved data is then placed in the designated box and formatted.

               Lesson #2A The BUILDER
          The BUILDER is an applet created with the FaceSpan interface application that will connect any FileMaker Pro database, Canto Cumulus image database, and QuarkXPress layout together in an automated workflow. The BUILDER is a floating palette with complete controls for automating different importing options. Use it as is to save time and money!

  Lesson #2B Parsing a Database Snapshot
        A short example of how to use the data from a database saved in standard comma-delimited ASCII format as the source for a slug & build workflow.

  Lesson #3 · Transfering Styled Text
       This lessons demonstrates how to use XPress Tags to transfer styled text information from the database to the QuarkXPress ayout. Included are sample databases and step-by-step scripts and instructions.

       Lesson #4 · Multiple Layouts from a Single Data Source This lesson, while incorporating all the previous techniques, introduces the concept of helper applets or "buddies" which act as traffic cops and administrators controlling and overseeing the workflow. This lesson includes a complete description of how to define and create an Apple Event mechanism for both initiating the actions and transferring the data.

  Lesson #5 · Scriptable XTensions: ItemMaster, Xdata, Xtags, BeyondPress, Tableworks

  Lesson #6 · Using AppleScript to control Windows-based computers
Scripting Insignia Soft Windows Scripting Timbuktu Pro 4.0

 Lesson #7 · The Small Business CGI for connecting FileMaker Pro to the Web


hope this helps
0
 
LVL 2

Expert Comment

by:Osiris010898
ID: 1539963
Lesson #1 would be the one for you, I've tried it, it's real easy to create, and works good. There are third party Xtensions to do this but I found them to be way to expensive.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question