mac AppleScript - Unable to open FileMaker Pro remotely

[DPaquin]

I've written the following applescript program to open my FileMaker Pro DBMS remotely. I get an AppleEvent time out error. Would someone know why?

 

Thanks!

 

tell application "FileMaker Pro"

set openDBs to {}

try

set openDBs to name of every database

end try

if openDBs contains "dbms.fmp12" then

show database "dbms.fmp12"

else

get remote URL "fmp12://batchuser@password/10.0.1.99/dbms.fmp12"

end if

end tell

 

 

[IdealData]

The databases are not open in FileMaker?

[DPaquin]

Thanks IdealData,

 

The database is sitting in FileMaker Server 12. What I am trying to accomplish is to replace having to open the DBMS remotely when sitting at the workstation. 

 

I do have staff for which opening a dbms remotely is an hard to concept to understand. What I wanted to do then was to write an applescript program which would remotely open the database. When the FileMaker Database is up, I would call a re-login for the user to enter his password.

 

I do have three mac which have to remotely open to the same dbms. 

 

I thought the get remote URL was the right command to use for this situation.  

 

Your help is greatly appreciated.

Daniel

[eos]

You want to open the databases as a client – but opening them with your AppleScript would result (if anything) in opening them as a host, which on an already hosted database would wreak all kinds of havoc (corruption, data loss etc.).

 

Create a launcher file (an FM database) that holds nothing but a script that opens the hosted database as a client (i.e. using “Open Remote”), then closes itself; distribute that to the workstations so your users can simply double-click it

[DPaquin]

Thanks eos,

 

I did not know about launcher file. It does exactly what I was looking for.

 

 

Daniel