I've been trying all day to get my database to execute a shell script...

I originally had this process working with applescript but filemaker server wouldn't run the applescript, thats why im trying to use shell scripting.

the shell script works. I typed it in a text doc and dragged it into a terminal window hit return and it executes.

but no combination of options in the 'Send Event' script step would run the shell script.

I tried it sending 'do script' with 'document' and with 'script text'. I also tried making an automator action into an application that just runs the shell script, but choosing that seemed to do nothing, target application was still .

what am i doing wrong? please help!

AppleScript running in a Perform AppleScript step can run shell script. It runs on the client machine. The phrase you use in AppleScript to run a shell script is:

do shell script "commands here"

You can also mix AppleScript variables into the command line, but you have to use quote marks to separate them. Such as:

set theText to quoted form of "some text with spaces and stuff"

do shell script "echo -n " & theText

Not very exciting, but notice the "quoted form of", which makes the spaces in the text safe for command line.

ok, is there any way to get the applescript 'do script' to execute on the server instead of the client?

I have both mac and windows filemaker clients that need to use this script.

Isn't it contradictionary? Explain what task at hand needs to be done on server... as it is am I pretty sure you're barking up the wrong tree.

--sd