Export From FileMaker Using FMP Variable Name

[kdickhaus]

Hello,

First post. I am trying to write a script to run from inside a FMP script that accomplishes the following:

Creates a folder in a target folder named for a FMP variable $Folder

Creates a sub-folder inside that folder named for a FMP variable $NameFIle

Saves the exported merge file as a text document $Name.txt inside the folder $NameFile

Returns to the FMP script. Using FMP 10.

All help appreciated. I am loving the Applescript coding, but I am a little rusty with my code writing, so thanks for any help.

Browser: Safari 533.17.8
Operating System: Mac OS X (10.6)

[clemhoff]

Hello,

try this in FileMaker’s ScriptMaker:

Set Variable [$_pathToTargetFolder; Value: Get ( DesktopPath )]]
Set Variable [$_subFolderName; Value: “mySubFolder/”]
Set Variable [$_fileName; Value: “FM_Export.txt”]

create folder.

Set Variable [$_pathToSubFolder_px; Value: “/Volumes” & $_pathToTargetFolder & $_subFolderName]
Set Variable [$cmd; Value:"try¶
do shell script "mkdir -p" & space & quoted form of " & Quote ( $_pathToSubFolder_px ) & Ҧ
on error err number errnum¶
beep¶
display dialog "Could’nt create folder ." & return & err with title "Error# " & errnum buttons "OK" default button 1 with icon 0¶
error number -128
end try”]

calculated AppleScript.

Perform AppleScript[$cmd]

export field contents.

If[Get ( LastError ) = 0]
Set Variable [$_pathToExportFile_fm; Value: “file:” & $_pathToTargetFolder & $_subFolderName & $_fileName]
Export Field Contents [YOUR_TABLE_OCCURRENCE::YOUR_FIELD; “$_pathToExportFile_fm”]
End if

Operating System: Mac OS X (10.6.4)
FileMaker Pro Advanced: 10.0v3/11.0v2

[kdickhaus]

Excellent! Thanks so much. Makes clear where I was going wrong in my attempt. Thanks.