Server Self Import

[rivet]

I have a very simple test file with two tables: A and B

I have a very simple script: Import A into B

File is hosted on FMPS12

Script works when executed from client side but not server side (schedule)

I am sensing that it might be the file path.

'file:import-test' is what I have now should it be different when running from the server (via schedule)

[Agnes Riley]

FileMaker server can only import from the documents and temporary path. See article: http://help.filemaker.com/app/answers/detail/a_id/7035/~/import%2Fexport-script-on-filemaker-server

So, you have two choices:

1. You can export from table A and then import from the export file into table B
   
2. Script the record generation from table A to table B
   

Hope this helps.

[rivet]

Very helpful, thanks Agnes!

[brian rich]

Hi rivet

If you are importing and exporting server-side, you will not be able to use FMP files (unless that has changed in FMP12) - you will need to use Tab delimited, merge or CSV files. I think that XML works too, but I can't locate my notes when I was wrestling with this problem

If your data includes repeating fields, you can only import and export in merge format.

HTH

Brian