Ver: FMP 5.5

I have a menu db that launches sets of databases by opening them when needed. The down side is I need a Script for Each Database I wish to open. The file structure of my Main menu is one record per database, FMP doesn't allow you to reference an OPEN Script step to a global, you have to "HARD CODE" the open step to the script.

I was searching FMI web site for information to be able to dynamically script an OPEN with out hard coding. Thus the value of the fields in a record will open a hosted file.

Here is the answer:

code:
 FMP 5.5 installer registers FMP5 as an Internet protocol. 

Users can remotely open a shared database using a URL. 

The URL should follow this format:

[>][url:]FMP5://[[password@netaddress]/databasename[>]


The square brackets '[' and  ']' indicate optional parameters. 

URLs are not allowed to contain spaces in them, so the URL 

encoding for the space character in database names is the plus sign " ".


Valid Examples:


FMP5:///My Addresses.fp5

FMP5://12.34.56.78/My Addresses.fp5

FMP5://secret@/My Addresses.fp5

FMP5://[email protected]/My Addresses.fp5

<URL:FMP5://[email protected]/My Addresses.fp5>

---

Everything works great, but how do you pass the current user privileges along to the new file?

Or have you found any other way to open hosted files with out hard coding it in a script?

Clever, but I haven't have much luck using the fmp5:// method in OSX (i might just need to configure it)

You could combine this with a custom password system, keep the users log and pass in a database then combine them in a calculation script and send it to OpenURL -- but that isn't very smooth since you'd have to change a users password twice.

Or just use a complete password system but you'd still hae to do alot of scripting to pass the user name and password around the databases, so that defeats the point.

I have a question, do you have the specify the full path to the file to open or is it relative?

ie,

fmp5://Myharddrive/MyDocuments/MyDatabase.fp5

or

from the menu:

fmp5://MyDatabaseInTheSameFolder.fp5?

If you omit the ip address it will open any hosted file with that name. (Inside your network)

if you are opening a file locally, you only need

file://path/to/database.fp5