Applecripts on FM Server

[M Studios]

We have a server that is running FM Server. Additionally this server stores our current project folders, which are created by an Applescript from Filemaker. The script looks like this:

[color:gray]tell application "FileMaker Pro"

tell document "JobList"

tell current record

set JobNum to cell "JobNum"

end tell

end tell

end tell

tell application "Finder"

activate

make new folder at folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of startup disk with properties {name:JobNum}

make new folder at folder JobNum of folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of startup disk with properties {name:"Source"}

end tell

So, you can see that all this script does is create a folder named with the job number and then places a folder titled "Source" within it. Everything works great as long as we are running the script from the server. The problem is that when we run the script in our clients, FM will create the folders on the client machine.

Is there a way to tell FM to create these folders on the server so that no matter which work station we are using they will all end up in the same place on the server?

Any help is much appreciated!

[xochi]

I've run into this same dilemma, having moved a solution from FM6 (single user) to FM8 Server.

Some thoughts:

1. A trusted user can run these scripts from a client machine, so long as the folders to be saved are available via a network share (AFP or SMB). This is the solution I'm currently using. Just set up some standard pathname rules (e.g. "The server shall always be mounted as XYZ and the sub-folder called PDQ").

2. It is possible under Mac OS X to run FileMaker Client on the same machine as the FileMaker Server (though probably dangerous and scary).

3. It is possible under Mac OS X to run FileMaker client on the same machine as the FIleMaker server, but under a different user account (using Fast User Switching). Probably less dangerous than #2, and you'd have to have some way to deal with file / folder permissions issues.

4. can the actions be re-done as a shell script? you can run shell scripts on the server, and shell scripts can call applescripts...

5. It seems the real solution here would be for FM to allow scriptmaker scripts to be run on the server.

[Zero Tolerence]

We have a server that is running FM Server. Additionally this server stores our current project folders, which are created by an Applescript from Filemaker. The script looks like this:

[color:gray]tell application "FileMaker Pro"

tell document "JobList"

tell current record

set JobNum to cell "JobNum"

end tell

end tell

end tell

tell application "Finder"

activate

make new folder at folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of startup disk with properties {name:JobNum}

make new folder at folder JobNum of folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of startup disk with properties {name:"Source"}

end tell

So, you can see that all this script does is create a folder named with the job number and then places a folder titled "Source" within it. Everything works great as long as we are running the script from the server. The problem is that when we run the script in our clients, FM will create the folders on the client machine.

Is there a way to tell FM to create these folders on the server so that no matter which work station we are using they will all end up in the same place on the server?

Any help is much appreciated!

Can you make your server be a mountable drive? This would allow you to create the folders on the server always. Just use your applescript to mount the drive, create the folder, then unmount the drive.