Jump to content
Sign in to follow this  

fmp12 FMSDIFM: take your FileMaker solutions to a new level with WAN connections

Recommended Posts


I just posted a new entry on 1-more-thing blog, presenting a 'revolutionary' technique allowed by FileMaker 12.

It completely changes my life as a developer, and makes it possible to create very efficient online solutions using FileMaker Pro/Go.

It's all explained in this video.

  • Like 2

Share this post

Link to post
Share on other sites

Great stuff Fabrice! Currently running a cue service on the server but not for instant things as such. Definitely has me rethinking some stuff.

Thanks for sharing!

Share this post

Link to post
Share on other sites

That's a great technique. I'm working on a solution now that requires reports to be generated by scripts, and this could be an ideal way to reduce the processing time of the reports.

The same thing could be done pre-FM12 using a web viewer. There is a working sample file here: http://fmforums.com/forum/topic/82704-server-side-schedules-globals/#entry383783

Share this post

Link to post
Share on other sites

It could, and a long time before that with URL plugins, but it required a refresh window on FileMaker Go.

But what's more, FileMaker Server was not as powerful as it is now: 64bits (and consequently support of a lot of RAM) and 200 web connections are key factors to this technique viability.

For your report issue, it can help to create records containing only the required information so they are faster to sort and so on, but it's more the kind of things that need to run on the client side, because it has to do with display, printing, pdf stuff...

In combination with a plug-in like ScriptMaster, if can indeed produce a pdf report for you.

Share this post

Link to post
Share on other sites

Liking the sound of this a lot as it sits well with some of the ScriptMaster stuff I do with PDF, looking forward to getting the two things together.

Well done Fabrice.

Share this post

Link to post
Share on other sites

I haven't implemented this method yet, but here are my notes on how I plan to do it...

  • each script that want's to use this setup needs to have two parts to it: client side and server side. The client side section is run by default. The server side section is run with a param: "is_ServerSide".
  • client-side control script

    • this script would open a new window, go to a ServerScripts layout, create a record, set script name, parameter, date/time field values, then commit the record record
    • modify window name to include the new recordID (so the window name is unique)
    • then it would call the server-side control script with a param of the current records ID.

      • in FM12 this can be done with insertURL
      • could always be done with a plug-in, but I don't like that requirement
      • setting a web-viewer is also always an option, and is nice because it doesn't require waiting for the server-side script to finish running

      [*]alternativly, it could run the server-side script on the client, under certain situations

      • conditions to do this:

        [*]would need a plug-in that can call a script by name

      [*]optionally wait for server-side script to complete? (by testing if timeFinished field contains a value)

    • file is not hosted
    • debugging mode is on

  • should test this via an onTimerScript on the unique window opened by this script - this allows the script to run in the background

    • the first test should be done without using the onTimerScript

      • and with a pre-defined wait period?

    [*]what should it do when it's complete?

  • this script is run client-side, so it can only call a user-defined script if a plug-in is used - which I don't want to have to be a requirement
  • show message to the user? This could be user-defined (by parameters to this script)

  • params:

    • ServerScriptId: id of record that was created with script name to run, script parameter, etc.

    [*]go to ServerScripts layout, find specified record id

    [*]call script with param, as specified by record contents

    [*]set script return result to field in that same record, set timeFinished field

  • Like 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Similar Content

    • By Richard Carlton
      FileMaker Coaches' Corner-Tip 8-Converting from fp7 to fmp12-FileMaker-FileMaker Experts
      Download the free PDFs to see FileMaker’s documentation: http://bit.ly/2nSg7BM
      Get up to speed with the FileMaker Pro 16 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton.  
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions.  The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker 
      developers and supporting web designers. He has offices in California, Nevada, and Texas.

      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving 
      FileMaker for Startups and Entrepreneurs, and client server integration.

      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.

      RCC and LearningFileMaker.com are headquartered in Santa Clara, CA.

      Please feel free to contact us at support@rcconsulting.com
      If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store.
      Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      For More Free FileMaker Videos Check out Http://www.filemakerfree.com
      Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training.
      Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There.

      Please Comment, Like & Share All of Our Videos.

      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media

      Filemaker Pro 16 Training Videos
      FileMaker 16 Videos
      Filemaker Pro 16 Video Course
    • By ndgates
      Hi All,
      I have been using Filemaker since ver3 but only for my own use, at work and at home, but only for my needs. Currently I've created a couple apps that I would like to share with my coworkers when they are out in the field so I bought a little server and am trying to download filemaker server 16 onto it. I bought it specifically with windows 7 pro because I had read that was a good os for it but after trying to install and it not working, I see now I should have purchased windows server. 
      Can I get some help as to what I actually need. I would like to run my apps through web browser or fmp go and I would like to not spend a lot. I would appreciate any advice.
      Thank you. Also, please note that although I'm not completely new to fmp or computers, I am not strong at anything beyond a personal use level, so if you would, please  keep your assistance to vocabulary that will make sense to me.
    • By john renfrew
      This has long been an issue, I have no idea why it happens and it is making life quite difficult
      Win Server 2012 FMS 16 (current but this happens on other configurations)
      With ScriptMaster installed 
      run a script which resets the server ( SMReset) and then loads jars and functions return to you the result of SMGetRegisteredModules and show it in a dialog box
      run another script on the server which just returns to you the result of SMGetRegisteredModules and show it in a dialog box
      dialog 1 SHOWS the modules you installed
      dialog 2 is EMPTY
      fmsadmin restart fmse
      do the above again, same result
      this means you can not do a test on the server to see if a particular function is loaded before you want to use it.... in fact there is no test you can do to see if the ScriptMaster has fallen over as far as I can tell.
      Any solutions???
    • By jcarter
      Hi Guys,
      I've been using CloudMail for a couple of years now to send marketing campaigns for my company. Just recently I have moved to remote hosting with AWS and now my server is offsite I have noticed some performance issues with cloudmail and a few other areas of my solution.
      To address these issues I have started using server-side scripts to perform labour intensive tasks such as creating bulk records (20,000) at one time. This has resulted in excellent performance once again.
      The problem I can't seem to fix is sending my email campaigns using server-side scripts. I have confirmed the plugin is installed etc on the server and with quite a bit of trial and error, I am still unable to send the campaigns.
      Does anyone have a sample script they use, or any advise how I can get this working?
      I appreciate any help and thanks in advance
    • By sal88
      Hi all
      I have three backup schedules: hourly, daily and weekly.
      To reduce any lag experienced by end users during the day I am wondering if I should do away with the verification step for the hourly one, which would speed up the backup.
      I would keep it on the other two and would be emailed by FMS if there were an issue.
      But if there were a crash and I wanted to restore from the hourly one, how do I know the data integrity is OK?
      Obviously if there were an issue I would use the older daily one, but that is a risk I'd be willing to take if it sped things up.

Important Information

By using this site, you agree to our Terms of Use.