![]() |
![]() |
![]() |
![]() |
![]() |
Q: | What is DBP? |
A: | An example of useful publishing automation using AppleScript on the Macintosh platform. DBP can transfer data from your FileMaker Pro database to a Adobe InDesign document to create a catalog or to do a mail merge or... DBP can also handle pictures and even modify them on the fly using Adobe Photoshop. DBP is Open Source and Freeware. This means you can use it for free and if you want you can modify DBP to implement the features you need. So, you can use the DBP source code as an example to write your own program to do a similar job. |
Q: | How does it Work? |
A: | The DBP interface is simple. DBP has seven steps. Steps 1 through 6 are used for settings
(you'll have to tell DBP which database to use, which fields to transfer, etc.) Step 7 runs an AppleScript to transfer your data.
DBP gets the data from the first selected field from the first record. Then DBP goes to your InDesign document and searches for the first text frame with
a data tag. The data tag is a text string or place holder you specified. It can be anything as long as you choose a unique text string that doesn't occur
in the document at places where the text should not be modified. For example you could choose *[name]* as a data tag for a database field
that contains names. When DBP has found the data tag for a specific field it will replace the data tag with the contents of the database field.
Other text in the same text frame will remain untouched. DBP will repeat this until the data from all other specified fields for the first record is
transferred to InDesign. Then it proceeds to the next record and does the same trick again, etc.
When all data from all specified fields from all specified records is transferred, DBP saves the result in InDesign file format. Optionally you can let DBP
export the result automatically.
|
Q: | Who should use DBP and what are the limitations, advantages and disadvantages? |
A: | DBP was written as a hobby just for fun. It can be used for free, but there is no support. There are no guarantees that it will work. So you can use it only at your own risk! If it doesn't work the way it should or if you would like new features to be implemented you can either get Xcode (the Mac OS X Developers Tools), download the DBP source code and create your own custom solution... Yes, that means programming, but AppleScript is very easy to learn! Or you can also send me an e-mail and explain what doesn't work or what options you would like to see in a future release of DBP. If I can find some time I'll look into it, but I can't promise anything. As of version 4 InDesign comes with a data merge plug-in. This plug-in provides similar functionality as DBP, but there are differences too and both have their strenghts. I've compiled an overview of the differences between DBP and the InDesign data merge plug-in There are also some commercial products (mostly InDesign plug-ins) that can be used for database publishing. Their availability isn't great, their pricing is steep and although they are expensive most of them don't support images. Some of them do support a bidirectional link between FileMaker Pro and XPress or InDesign. This means you can transfer data from FileMaker Pro to XPress or InDesign and back. DBP only transfers data from FileMaker Pro to InDesign and not the other way around. The available commercial products are usually written using a programming language whereas DBP was written using a scripting language. Programming languages are usually much faster than scripting languages and hence the commercial products are usually much faster than DBP. In fact, DBP ain't quite a speed freak, but hey, it's free and it's still much faster than doing the job manually! Summarizing, if you need a product with support or when time = a lot of money, go get yourself a commercial third party InDesign plug-in. If speed is not crucial, take a look at DBP and the data merge plug-in that comes with InDesign. If you want to develop a custom solution, you might want to take a look at the DBP source code. The "Publishing Report" website (German only) has a good overview comparing many features of tools, programs and complete publishing solutions for InDesign and XPress. |
Q: | How do I get the files from the downloads page? |
A: | Download the *.dmg.gz or *.dmg.zip file. Just click the link and your browser should ask you where you want to save the file. If your browser loads a page with weird characters instead use the back button in your browser to go back to the link. Control-click (or use the right mouse button if you have got one) the link. From the contextual menu that pops up choose Download link target, Save link as, Download link to disk or something similar (differs in each browser). The *.gz files were compressed with Gzip and *.zip files were compressed with the built-in archive fuction of the Mac OS X 10.3+ Finder. You can decompress both file types using the free Stuffit expander from Aladdin Systems. After decompressing you should have a *.dmg file. This is a standard Mac OS X disk image that you can mount using the Disk Utility application located in the utilities folder of the applications folder. |
Q: | Is there a version for Mac OS 9? |
A: | Yes and No. The DBP project originally started on Mac OS 9 with Quark XPress. An old version for this platform is still available, but it is less stable and won't be updated anymore. See the next FAQ below for more info. There won't be a version for InDesign on Mac OS 9 (That would require another complete rewrite of the project). |
Q: | Is there a version for Quark XPress or some other page layout software package? |
A: | Yes and No.
The DBP project originally started on Mac OS 9 with Quark XPress 4.1. An old version for this platform is still available,
but it is less stable and won't be updated anymore. The old version includes some example files, but the documentation is very limited.
Quark XPress has a buggy AppleScript support. Even in minor updates of XPress lots of bugs in the implementation of AppleScript are solved
(and unfortunately also a bunch of new ones are introduced.) Therefore there are NO versions of DBP for Quark XPress 4.0 through 4.0.4 or 4.1.1.
I haven't tested DBP with XPress 5.0, but I would be surprised if it works...
I strongly recommend you use the new version for InDesign and Mac OS X, but if you really really really want to use
the old version for XPress and Mac OS 9 you can send me an e-mail to request a copy of this DBP version.
XPress 6.0 for OS X will have to have some freakin' awesome implementation of AppleScript to make me rewrite the entire project again.
UPDATE: Well, finally Quark has released XPress 6.0 for Mac OS X. I have tried the demo version. It has a large AppleScript dictionary,
but I couldn't find anything to get really excited about...
Other page layout software packages are not supported, but you can use DBP to let InDesign automatically export the generated document(s) to several file formats |
Q: | Is there a version for other databases or data sources? |
A: | No, but... FileMaker Pro can import various database formats. It even has a special option to turn a MicroSoft Excel document into a simple FileMaker Pro database. Or you can try to export your data in XML format and import that directly into InDesign. |
Q: | Is there a version for other platforms like Windows or Linux/UNIX? |
A: | No, there is no Windows version and there never will be one. FileMaker Pro, Adobe Photoshop and Adobe InDesign are available for the Windows platform, but the glue that holds DBP together is not. DBP is written in AppleScript, which is only available for the Mac OS platform. The Macintosh versions of FileMaker Pro, Adobe Photoshop and Adobe InDesign speak AppleScript making it possible to let these applications work together. The Windows versions don't speak AppleScript. They speak Visual Basic for Applications (VBA) instead. VBA on Windows might be used to write an application similar to DBP, but porting DBP to windows is impossible. It would require a complete rewrite of the code on an operating system, that I consider to be a pain in the *ss. (I've worked with Windows boxes for years so I know what I'm talking about!) There is also no Linux/UNIX version as FileMaker Pro, Adobe Photoshop and Adobe InDesign are not available for any Linux/UNIX flavour nor is AppleScript (the glue that holds DBP together). But who knows, maybe one day... |
Q: | Can I export the output to other formats than the InDesign file format? |
A: | Yes, you can!
DBP always saves it's result in InDesign file format.
In addition you can let DBP export the generated InDesign document automatically to any of these file formats:
|
Q: | Why is DBP so slow? |
A: | Well, DBP ain't a speed devil, but it is definitely faster than doing the job manually.
If you have to copy and paste data from FileMaker Pro to InDesign manually at the same speed as with which DBP does the job,
you'll have RSI within 10 minutes!
Other things to consider:
|
Q: | I selected a database, but I can't find the fields I want to transfer in the list of database fields. What is wrong? |
A: | You have selected the wrong database file. Sometimes a FileMaker Pro solution consists of many files. Usually, there is one main database file you open. This file might even contain only (a part of) the graphical user interface and no fields and records at all! Using FileMaker scripting this file can then open many other files. Therefore, navigate in FileMaker Pro to the layout that contains the cells whose data you want to transfer. Now take a good look at the window's title bar, because it shows you the name of the file, whose layout you are looking at. Locate this file and select it in DBP. |
Q: | I selected a template, but DBP can't find some of my / any data tags in the template file. What is wrong? |
A: |
All versions:
|
Q: | The data ends up in my InDesign document, but in the wrong order. How do I change that? |
A: | The order in which the data is transferred from FileMaker Pro to InDesign depends on 2 things:
|
Q: | Help, I think DBP crashed! Now what? |
A: |
Are you sure DBP really crashed? Especially creating pages and overriding the master page items on new pages to create page items can be slow.
If the progress bar is still getting longer from left to right, DBP and InDesign are still working hard to get your job done.
While DBP is running you can activate InDesign by clicking it's icon in the Dock. You can navigate through the document, zoom the document's window
and activate the pages palette to monitor the progress and see what is actually happening in InDesign.
(While a data transfer is in progress InDesign will respond slowly to your mouse clicks, so be patient...)
Don't do any other things in InDesign as it might interfere with what DBP is trying to tell InDesign to do and/or cause time outs.
Sit back, relax, have another drink and wait for DBP to complete it's job. If you want to make sure DBP is still running,
use something like Applications -> Utilities -> Activity Viewer or the unix tool top.
When you are sure you've crashed DBP (or running DBP caused FileMaker Pro, Photoshop or InDesign to crash) and it didn't quit unexpectedly, you can kill the application by pressing the [command]+[alt]+[esc] buttons or you can choose Force Quit from the Apple menu. Please send me a bug report if you can't find a solution yourself and if the error is reproducible. Preferably send me some example files, so I can reproduce the problem. I'll see what I can do... |
Q: | Help, I think I ran into a serious bug! Now what? |
A: |
Please go to the contact page and send me a bug report! I'll see what I can do... I develop DBP as a hobby in my spare time, so I don't have the time to reply to e-mails about problems whose solutions are from the RTFM category. |
Q: | Are there known issues / bugs in DBP? |
A: |
|