Date: November 29, 2008 11:53:17 PM MST
Subject: Import and export from Applescript variables into Filemaker Pro
To be more explanatory, part of my script is as follows:
tell application "Finder" -- Script Debugger 4.5
activate
set the clipboard to ""
activate document file "Test Solver.xls" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk
select window of desktop
activate document file "NHANESIII_Database Graphs&Indices.fp7" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk
select window of desktop
set FNr to 0
set BCnr to 0
set SqNr to 0
tell application "FileMaker Pro"
activate
--go to field SEQN --- The variable SEQN is not defined.
--copy field {SEQN, NHANESIII - Spirometry} --- The variable SEQN is not defined.
set value of field SEQN of document file "NHANESIII_Database Graphs&Indices.fp7" to SqNr
-- FileMaker Pro got an error: Object not found.
end tell
-- When SqNr was copied in 2 seconds by a Filemaker script into the clipbord,
-- and then pasted by a macro on row 17 of column 17 the next on Excel worked fine:
tell application "Microsoft Excel"
activate
activate object workbook "Test Solver.xls"
set (value of row 17 of column 17) to SqNr
wait 2
set FNr to (value of row 17 of column 16) -- with an addition of ".csv" by a cell formula.
set (value of row 25 of column 11) to SqNr
wait 2
end tell
-- WHY NOT IN FILEMAKER? Not to speak yet about so many Applescript variables
-- with Excel calculation values, which have to be imported into Filemaker fields.
-- I could not find help in "Filemaker Pro.app's" dictionary from Script Debugger 4 or 4.5.
-- But who am I?
end tell
Willem Vriend.