DevCon is over; summer vacations are finally wrapped up.
Back in July, I presented a preview webinar of one of my DevCon presentations: FileMaker and the Cloud: Integrating with Google Apps. We are now making that webinar recording available, as well as making the sample file available for download.
A few things to make note of:
The sample file is actually the one I used at DevCon, instead of the abridged one used in this preview webinar. So it looks a little different, and includes the extra material I covered in the DevCon session, but all the same scripts and custom functions are in there.
The file uses ScriptMaster from 360works, and compiles Groovy scripts as external functions. If you decide to use a different plug-in for HTTP requests, you’ll need to make changes to all references to the ScriptMaster functions in the scripts.
The custom functions for parsing XML are fairly complex. But what did you expect? ![]()
To download the files, you’ll need to be registered as a visitor with our site and logged in. The webinar requires the requires the WebEx WRF Player.
filemaker_googleapps_webinar.zip (20.9 MB)
filemaker_googleapps_files.zip (455 KB)
Olly Groves
10/14/2010
Many, many thanks for this Chad, you’ve saved me (and others) a whole load of sweat, tears and frustrating headbangs on desk I’m sure.
Dick Impens
05/10/2011
It sounds like a great solution, I’ve downloaded it and tested it, having ScriptMaster plugin installed, but cannot go past the login (google), comes back with error that it can’t login. What am I doing wrong?
Chad Novotny
05/10/2011
@Dick: Do you have FileMaker Pro Advanced, to run the script debugger and data viewer? I’d start by running the whole “Login” script, and then examine the first subscript, “Login to contacts [‘cp’] (email; password)”. The third step there sets a variable $result to the response from Google. Do you know what that says? It SHOULD start with something like “SID=DQAAAOQAAACVz5CytLCk29VYqBmUrGX7AfdP7…”
If you don’t have FileMaker Pro Advanced, try defining a global text field and inserting a new step in the “Login to contacts” script, setting the new global to $result before the last Exit Script step, to see what kind of response you are getting.
Log in as a member to comment...
Nigel Peters
09/26/2010
Thank you !