[TazmanDman]

I'm trying to write a script to automatically open Filemaker, look up a remote host, and open the different database windows without having to do it manually every day.

I've started it, but I can't get it to open even 1 object that I tell it to.

Here's what I've got so far:

tell application "FileMaker Pro"
activate
get remote URL "FMP6://XYZ.com"
end tell

what do I do from here? I need to get it to actually open XYZ.com and then access those database windows. right now it just opens up remote hosts and doesn't select XYZ.com automatically

any help is definitely appreciated
- Taz

[Camelot]

Checking the FMP dictionary, 'get remote URL' returns the URL of a database - it doesn't have anything to do with opening the database.

Instead, try:

getURL "fmp://xyz.com/database"

[grahamb]

Instead of doing this with AppleScript, why not create an "opener" database? We use this at my workplace to open our POS system. I find that I usually get spinning beachballs when I try to open databases through AS, especially using the "with password" argument.

The database has no fields and one script. The script has a bunch of Open script steps in it to open the files off the FM server. The script is set to run when the file is opened (in the document preferences).

If the remote databases are password-protected, you can give your opener database the same password. FileMaker will attempt to use the password for all files opened through the script.