Running Server Scripts

[Richard_N]

I just installed Filemaker Server 9.0v2 and need some advice how to setup server side scripts. I would like to run a script on a hosted database but I believe there may be an issue that will prevent me from doing this.

The script basically deletes all records and then imports records from a .csv file. This is a download from another system and I cannot access it. It is my understanding that Filemaker Server can only run Web compatible scripts (Delete and import are not web compatible).

Any suggestions as to how I can accomplish this? What I want to do is keep my Filemaker database in sync with an AS400 database.

Thanks for listening

[Wim Decorte]

You are correct that import is not a supported script step for server-side scripts.

Any change of connecting to the AS400 through ODBC or JDBC? Then you can make this a looping script and update data that way after shadowing the AS400 tables inside FM (using the new External SQL Sources feature).

Alternative is to set up a robot machine running FMP and trigger an import script through the OS, or with an event plugin.