open remote with AS or FMPscript?

[SuperMacGuy]

I couldn't find a completely satisfactory answer with my search, soooo..

Can anyone explain how I can open a remote file via applescript or a Filemaker script? I have several files, on an OSX box. I want a script to call open a file named "A-scans" on our remote hosting unit using a script and a pre-defined password. I do not want to show the user any "open remote" dialog boxes or any password dialogs. There may be as many as 30 databases opened and searched with the Applescript/FMPscript, so speed and user simplicity is important.

TIA,

Chris

[SuperMacGuy]

Well ima dork. Scripting guide:

get remote URL: Opens a hosted FileMaker Pro database

get remote URL

Result: string -- The URL specification for the opened database in the form "FMP5://[host]/filename"

[SuperMacGuy]

OK I still need to know how I can bypass the dialog box that opens up when I call for another db file to open... can I use a "with password" with "get URL".. ?

[jfmcel]

Best use a local opener FM file containing the required (default) password and an opener script that will open the FM file on your server. Your applescript can open the file (and/or run the opener script).

[hfinger]

Can I join in here? This is almost the exact question I have.

I want to be able to open an "unopened" FM5 file on the host using a script on an opened host database accessed from a remote site. When I try and use an Applescript inside a FM Script I get an error message: "Data being accessed by another user, script, or transaction. (error -10011)."

If this is a different problem, I apologize for jumping in.

[spragueg]

don't know if anyone still care about this thread but...

tell application "FileMaker Pro"

getURL "fmp7://user:pass@host/file.fp7

end tell