PSOS Export Records Error 800

[TJ53]

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!

 

 

[Mike Duncan]

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

[TJ53]

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.

[ggt667]

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, 2017 by ggt667

[TJ53]

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.