smower

Running Script Schedules on Server from FileMaker Script or FileMaker php api

Discussion created by smower on May 23, 2018
Latest reply on May 24, 2018 by wimdecorte

Is it possible with FileMaker curl commands to run a FileMaker schedule from a FileMaker script?

 

I have been using the base elements plugin for years to do this using the Base Elements plugin like this and running this script from php FileMaker api executescript command:

 

Set Variable [ $schedule; Value:Get ( ScriptParameter ) ]

 

Set Variable [ $schedules; Value:BE_ExecuteSystemCommand ( "\"" & "C:\Program Files\FileMaker\FileMaker Server\Database

 

Server\fmsadmin.exe" & "\"" & " -u myusername -p mypassword list schedules") ]

 

Set Variable [ $schedulenumber; Value:RightWords ( WordParse ( $schedules; "ID"; $schedule); 1) ]

 

Go to Layout [ “Scripts” (Scripts) ]

 

Set Field [ Scripts::schedules; $schedule & " - " & $schedulenumber // & "¶" & $schedules ]

 

Set Variable [ $schedules; Value:BE_ExecuteSystemCommand ( "\"" & "C:\Program Files\FileMaker\FileMaker Server\Database

 

Server\fmsadmin.exe" & "\"" & " -u myusername -p mypassword run schedule " & $schedulenumber) ]

 

Set Field [ Scripts::ScriptResult; $schedules ]

 

 

However the script over the past week or two has stopped working and just gives timeout errors if run from curl and just seems to do nothing anymore even on basic simple scripts that can run within a second or so.

 

I am using FileMaker Server 16 and FileMaker Advanced 16 and FileMaker php execute script commands.

 

I am not sure if a Windows update disabled Base Elements plugin access to the command line or if the Base Elements plugin stopped working or if FileMaker did something to prevent this.  Any help how to accomplish running schedules again would be greatly appreciated.

 

I have tried perform script on server also, but it doesn't seem to work when I have scripts that call scripts in other files.

 

Does anyone know why this script would work for years and then just stop working all of a sudden?

 

Thanks in advance for any help.

 

Thank you,

 

Shawn

Outcomes