Server export failing

Discussion created by mark.stuller on Jul 14, 2014
Latest reply on Jul 15, 2014 by mark.stuller

I have diagnosed this enough to know I'm at the end of my limited ideas. Hoping someone may have solved the riddle.


I would like to have a scheduled script that emails the contents of records, including attaching the contents of a single container field to users.




# Find all records needing an email sent

Perform Find [Restore]

if ( get ( foundcount ) )


set $pathName // to get ( documentspath) & getcontainerattributes ( containername ; "filename" )

export field contents to $pathName

Send email with attachment $pathName

Set field 'sent' to 1

goto next record; exit after last

end loop

end if


The email gets sent without the attachment. The $pathName file never gets created and so can't get sent. If I manually place a file in the documents path (testfile.txt below), that is sent successfully. The export field contents line generates error #3 Command is unavailable (for example, wrong operating system, wrong mode, etc.)


I suspected permissions, but here are those and they look correct.


filemaker5$ cd /Library/FileMaker Server/Data/Documents

filemaker5$ ls -al

total 0

drwxrwxr-x 2 fmserver fmsadmin 68 Dec 12 2012 .

drwxrwxr-x 9 fmserver fmsadmin 306 Jan 28 10:45 ..

filemaker5$ touch testfile.txt

filemaker5$ ls -al

total 0

drwxrwxr-x 3 fmserver fmsadmin 102 Jul 14 13:25 .

drwxrwxr-x 9 fmserver fmsadmin 306 Jan 28 10:45 ..

-rw-r----- 1 iss fmsadmin 0 Jul 14 13:25 testfile.txt


Any other ideas?


Mac OS X 10.9.1 (under VMWare EXSI); FileMaker Server


TIA Mark