Running scripts on server?

[gephry]

Can you run scripts on FileMaker Server 5.5?

This may sound bit odd, but here's why I'm asking:

I have a plug-in (Troi Activator: phenomenal!) that allows you to schedule things to take place (i.e. running scripts, backups, etc.). I have programmed my databases so that it'll do certain functions on a preset schedule, but these scripts have to take place on the server. Is this possible?

[Reed]

you can't do scriptmaker scripts with filemaker server. server only serves files, nothing else. As far backups though, server 5.5 has the ability to schedule live backups of served databases. To run the scriptmaker scripts on a schedule, you have to have a client machine that is always connected to the server, and then use Troi to schedule the scripts on the client machine.

[gephry]

Ah, I was wondering about that. Let me ask this then:

I have a database that stores all my settings in global fields. Unfortunately, since globals are relative/local to the current machine, whenever the global settings are changed, they don't change on the server. Is there a way for me to be able to change the global values on the server machine so it applies to the entire network, or is there something else I could/should do?

Thanks!

[Reed]

The only way to change the global defaults is to take the file off the server, open it locally in FMP, change the values and close the file.

A different way to handle this would be to create a dedicated file for global values. Except that the fields wouldn't be globals, they would be plain fields, and there would only be one record in the file, so any changes made to the fields would be seen be all users.

The trick will be in creating the constant relationship to the file from your other files so that the values can be referenced from other layouts.

[gephry]

Yes, that's the conclusion that I've come to. What I've figured out is that I'll have normal fields with the settings that people change. Then, when the user opens the file, an On Open script will set the identical global fields to the values of the stored normal fields so the settings are the same no matter what the relationship is.

Follow up: is it possible to run scripts in any of the more recent versions of Filemaker Server?

Thanks so much for your help!

[gephry]

Dang. Why can I not use:

Set Field[ gEnsembles-4, "GetRepetition( Ensembles, 4 )" ]

It won't set any repetitions of global fields greater than the first repetition. It also won't paste into any repetition of a global field except for repetition 1. How do I get around this??

[-Queue-]

Set Field[ gEnsembles-4, Ensembles ] should work. When setting the same repetition as you are referencing, there is no need to specify the repetition number in the calculation.

There is a bug when using GetRepetition, but it only becomes a problem when setting a different repetition than the one being referenced, such as setting the third repetition of a field with the second repetition of another.