It's possible, but you have to jump through a lot of extra hoops. Client side is much simpler. I use a "robot file" to automate this process on my servers.
Here's a knowledge base article on importing via server scheduled script: http://help.filemaker.com/app/answers/detail/a_id/7035/p/874%2C953/session/L3NpZC9lRjdKZVpjaw%3D%3D
Thanks for the quick response Phil.
A robot file ? as in a spare computer runing a client that is running this import script via the script timer ? if so, I could do that - ... it's frustrating though -
So (correct me if I am not getting this)
I can NOT run a server side schedule script that imports from one hosted file to another ... but I COULD export (a txt file) to the server 'dox' directory and import from the same ?
You got it. A number of us have complained that server scheduled scripts are much too limited in this area and others.
I actually have FileMaker installed on the same machine as the server and use Windows TaskManager to launch the robot file after hours. The script in this file is set to run when the file is opened and it uses Perform Script to call the import script on the hosted file, then uses Exit Application to shut FileMaker Pro back down.
Thanks for the clarify Phil - I hadn't thought of running fmp11a on my server - ... appreciate your 'know how' on this -
Note that in my case we do not publish to the web from this server. I may be remembering incorrectly, but seem to remember that installing FMP on a server machine that publishes to the web may create some problems.
innteresting - thanks for the heads up - we don't publish either - (instant is too weak and php/html is too much work)
BUT we ARE bringing out Fm go in a big way for our outside sales teams - so that is sort a web publishing - I'll play with it - either way I will need a dedicated box to keep out key app listing for fms exports of order pieces - ...