Xojo Conferences
MBSOct2019CologneDE

« Five months till Euro… | Home | Matrix functions for … »

Run fmsadmin from script


On your server you may need to run fmsadmin to query or change a setting from FileMaker Server. You can do that with Shell functions in MBS FileMaker Plugin. Just run fmsadmin.exe with various parameters and read standard / error output. For Windows, please pass the full path of the exe file as there is no cmd.exe running to lookup shell variable PATH to find the applicaiton for you.

Here is a little script to query version and pass the credentials:

Set Variable [ $shell ; Value: MBS( "Shell.New" ) ] 

Set Variable [ $s ; Value: MBS( "Shell.Execute"; $shell; "C:\Program Files\FileMaker\FileMaker Server\Database Server\fmsadmin.exe"; "-v"; "-u"; "admin"; "-p"; "xxx") ] 

If [ MBS("IsError") ] 

Show Custom Dialog [ "Failed to run" ; $s ] 

Else

# Loop while app runs and collect messages

Set Variable [ $s ; Value: MBS( "Shell.Wait"; $shell; 5) ] 

Set Variable [ $result ; Value: MBS( "Shell.ReadOutputText"; $shell; "UTF-8") ] 

Show Custom Dialog [ "Result" ; $result ] 

End If

 

Set Variable [ $r ; Value: MBS("Shell.Release"; $shell) ] 

For MacOS or Linux, you may need a different path for fmsadmin command line tool.

28 05 19 - 07:55
No comments

  
Remember personal info?

Emoticons / Textile


Notify:
Hide email:

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.