Hi, I get error 800 in the "Export Records" script step when executing it as PSOS.

The file path is set in a variable ($path) as a calculation:

Get(TemporaryPath)& "tmp.fmp12"

This script works well when executing it to save the file to the local temporary folder (OS X El Capitan), but returns an error when executing it as PSOS (Windows Server).

I believe it can be a permissions issue, but I thought the temporary path was accesible from FM Server "by default". Anyway, any insights are appreciated, thanks!

 

 

FileMaker Server is not able to export in FileMaker Pro format. This is documented on the Export Records script step here: 

https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/export-records.html

Note the "partial" support for FM Server.

Mike

Thank you very much! that was it, I just learnt about that and was about to post it here... I changed it to export as xlsx and it works perfectly.

On 8/10/2017 at 6:23 PM, TJ53 said:

Thank you very much! that was it, I just learnt about that and was about to post it here... I changed it to export as xlsx and it works perfectly.

What is your use of the exported data? Is this a temp thing that you import in the next step?

Like populating an invoice from an order, i e

Then using unformatted XML may be faster than XSLX.

Edited September 20, 20178 yr by ggt667

Thank you for the tip.

Yes, this is used to then import into a temporary table for running a report, that is faster than a loop.

It works fast enough now (it takes about two seconds), but I'll consider your suggestion for the future, thanks.