Export script running on the server - error 800
I have a simple export script that works using the FM Pro 12 client, but is failing when I attempt to schedule using the server. Essentially, I am trying to export some records every night to an Excel file and where I store it is not important to me (although, very important to FM....as I'm learning).
Here is the script:
Set Variable [$Path; Value:Get (DocumentsPath) & "test.xlsx"]
Export Records [No dialog; "$Path"; Unicode (UTF-16)]
Any idea why when the server executes this script I get the 800 error, but when I run it from the client I get no error and the file is created locally.
I figured it out. Needed correct permissions on the server side directory
/Macintosh HD/Library/FileMaker Server/Data/Documents
need to perform the following:
chown fmserver <export file>
chgrp fmadmin <export file>