Does anyone know of a way to run a script that updates every so many minutes / hours etc. automatically. I am running a script on each users computer that brings in Postgres data from a management system. I want to update the tables in Filemaker to avoid user having to constantly manually run the script.

Run the script on a schedule from FMS.

I have tried running this as a script from FMS but my import records script step is not web compatible. Is there a way around this?

I'm sorry, I didn't notice the "brings in" and so didn't see the need for import.

The old way to do this was to dedicate a workstation and have it be an import robot, if you will. There are event trigger plugins available.

LaRetta, are you listening? I think you've got tons of experience with this, if I'm not mistaken. What is the best way?

I don't know the best way, Barbara. I only know ways I've used and whether THEY work or not. I don't feel we have enough information to give a solid answer here.

I am running a script on each users computer

This makes no sense to me. I have no idea where the data comes from. brantc? Are you saying that each client station receives their OWN data and it must be merged into a table which is hosted by FileMaker Server?

Well, one option is to use Windows Scheduler (I'm sure Mac has similar or better). You would use a client station with a simple FM file which works similar to an Opener file ... its only purpose is to open, call a sub-script in your main file (in your case Import) and then close itself. It could reside either only on one client station or each station (if the data resides individually on each). This file would be scheduled to run whenever you needed it. Depending upon your import, ie, if only Add and not update, it could probably be ran at any time.

But again, we would need more information. I have never used a looping paused script which continually runs. The thought of it gives me the creeps and makes me feel exhausted just thinking about the resource drain of a perpetual loop. :crazy2:

Edited June 18, 200817 yr by Guest
Added sentence. Surprised?