do Filemaker script

Question

Level 1

25 points

do Filemaker script

here's my Applescript:

tell application "FileMaker Pro"
activate
do script "script name"
end tell

does not do script
get "Object not found"

??

Mac Mini, Mac OS X (10.6.4)

Posted on Aug 29, 2010 10:09 AM

Reply

Answer 1

Best reply

Camelot

Level 9

54,333 points

Aug 29, 2010 10:48 AM in response to swanker

Filemaker scripts are stored within databases. You need to tell Filemaker which database to run the script from:

tell application "FileMaker Pro"
tell database "database name"
do script "script name"
end tell
end tell

That's partly because you could have multiple databases open, each with theor own 'script name', so Filemaker needs to know which one to run.

Reply

Answer 2

swanker Author

Level 1

25 points

Aug 29, 2010 10:54 AM in response to Camelot

still doesn't work

tell application "FileMaker Pro"
activate
tell database "lists.fp7"
do script "pub to web"
end tell
end tell

gets "error "Object not found." number -1728"

Reply

Answer 3

Aug 29, 2010 4:12 PM in response to swanker

I believe you need the full path to the database--

tell application "FileMaker Pro"
activate
tell database "Macintosh HD:Users:swanker:Desktop:lists.fp7"
do script "pub to web"
end tell
end tell

Reply

Answer 4

swanker Author

Level 1

25 points

Aug 29, 2010 5:11 PM in response to Matt Broughton

thanks, but still no go

here's my script:

tell application "FileMaker Pro"
activate
tell database "Mac Mini:Users:steve:Public:New DCA Database:lists.fp7"
do script "pub to web"
end tell
end tell

result: error "FileMaker Pro got an error: Object not found." number -1728 from "pub to web"

??

Reply

Answer 5

Aug 29, 2010 6:47 PM in response to swanker

Perhaps the database needs to be open to run the script. Try

tell application "FileMaker Pro"
 activate
 open file "Mac Mini:Users:steve:Public:New DCA Database:lists.fp7"
 do script "pub to web"
 end tell
end tell

Reply

Answer 6

Camelot

Level 9

54,333 points

Aug 29, 2010 11:14 PM in response to swanker

Since it's highlighting 'pub to web' I have to infer that it can't find the script in question. Are you sure that's the right name, and that the script does, indeed, exist in this database?

Reply

Answer 7

swanker Author

Level 1

25 points

Aug 30, 2010 6:01 AM in response to Camelot

thanks

yes, I thought of that when this first occurred, and I double-checked: it's there

would it be better to know the script id number and use that?

Reply

Answer 8

swanker Author

Level 1

25 points

Aug 30, 2010 11:16 AM in response to Camelot

I created a test script and it does work IF the database which holds the script is the foremost window

so, the question becomes--- what is the wording for AppleScript to open that database and bring it foremost?

here's the script that wqorked:

tell application "FileMaker Pro"
activate
do script "pub to web"
end tell

Reply

Answer 9

swanker Author

Level 1

25 points

Aug 30, 2010 12:08 PM in response to swanker

Filemaker Support sent me the answer

this works:

tell application "FileMaker Pro"
activate
show window "lists"
do script "pub to web"
end tell

Message was edited by: swanker

Reply