1 of 1 people found this helpful
Our MBS Filemaker Plugin works on the server.
If you have questions, please email us.
I am running the Baseelements plugin on a FM Server and using it with scripts that do SQL functions. This is on FM Server 11 Advanced.
Regretably, when I tried the Base Elements plugin, Filemaker Server 12 refused to recognise ANY server side plugins. Removing it resulted in the other plugins appearing again.
Andrew : Following your comment that it ought to work, I bit the bullet andI rebuilt my old 10.7 Server today, with a pristine 10.8 Server, and FileMaker Server 12v4, and now Base Elements Plug-in works fine. My old installation started throwing permissions errors that Disk Utilty said it was fixing, but actually wasn't, and I think this was the source of the problems I had getting server side plugins to work. So now Base Elements is executing an embedded SQL UPDATE (as part of an unstored calc) when it finds the record I want. Good so far. A script that does a find request on the table works as expected, either when run as a server side schedule, or on a client that has Base Elements plug-in installed. However, when run from a FileMaker Go client, it fails. I suspect that the server side plugins only work for schedules, not all the time for the database engine. This breaks Jake Traynham's technique unfortunately. I only now realised that I didn't link to Jake Traynham's original article, so for reference, it's here:
This has been a fun exercise, and working my way through the various options in building the test file has been educational, so it's a pity that it doesn't work on 12 after all.
Unfortunately, my technique/hack no longer works under FM12 because of the separation of the Scripting Engine from the Database Server. The only way I know of to work around that at the moment is to enable the Web Publishing Engine and use the Insert From URL script step to call a script on the server to do whatever it is you need to do. Note that this requires a 64-bit plug-in to work under the Web Publishing Engine.