DevCon Webinar: FileMaker and Google Apps

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? grin

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)

Nigel Peters
09/26/2010

Thank you !

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...