I have created a plugin using ScriptMaster Advanced that I want to use on the server but it is not working.

To be sure it is registered I ran a registration script using the admin console that also entered the result in a field so that I can verify that it is registered, but I am getting no success. The function I am using is the ExecuteSQL function. it works fine if I have the same plugin installed on the FileMaker client, the server is set to use plugins and it is enabled in the admin console.

What am I missing?

Thanks

Has anyone managed to get a plugin created with ScriptMaster Advanced to work on the server?

This is the simple calc I want to work

ExecuteSQL("Select zkUIDp from Organisations where zkDeleted=0 and lower(name) LIKE 'b%'")

I have tried as stored and unstored, no difference.

Thanks

Tim

I have created a plugin using ScriptMaster Advanced that I want to use on the server but it is not working.

To be sure it is registered I ran a registration script using the admin console that also entered the result in a field so that I can verify that it is registered, but I am getting no success. The function I am using is the ExecuteSQL function. it works fine if I have the same plugin installed on the FileMaker client, the server is set to use plugins and it is enabled in the admin console.

What am I missing?

Thanks

Also for completeness I have tested as an autoenter calc with registration as part of the calc - all I get is a '?'

Anyone have anything to say?

Thanks

Tim

Has anyone managed to get a plugin created with ScriptMaster Advanced to work on the server?

This is the simple calc I want to work

ExecuteSQL("Select zkUIDp from Organisations where zkDeleted=0 and lower(name) LIKE 'b%'")

I have tried as stored and unstored, no difference.

Thanks

Tim

A "?" means that you do not have the plugin installed or it may not be enabled. Remember that you need to install the plugin in your FileMaker Pro deployment even if the database is being hosted on FileMaker Server. If you want to use a plugin in a server scheduled script you will need to install it in the FileMaker Server Extensions directory, and the the WPE/Plugins directory if you want to use it in IWP. Check out documentation.html file which comes with your download of the plugin for full installation instructions.

Aha, I think we have the answer!

'Remember that you need to install the plugin in your FileMaker Pro deployment even if the database is being hosted on FileMaker Server'

That seems counter-intuitive, but must be the reason it is not working. I wanted to have the plugin on the server to perform some functions without the client having the plugin. I have clearly misunderstood the scope of Server based plugins if the client also has to have the plugin. Is this the case for all plugins on the server?

Thanks

Tim

A "?" means that you do not have the plugin installed or it may not be enabled. Remember that you need to install the plugin in your FileMaker Pro deployment even if the database is being hosted on FileMaker Server. If you want to use a plugin in a server scheduled script you will need to install it in the FileMaker Server Extensions directory, and the the WPE/Plugins directory if you want to use it in IWP. Check out documentation.html file which comes with your download of the plugin for full installation instructions.