FileMaker DevCon 2011

Go Farther

August 2-5 - San Diego, CA - Hilton San Diego Bayfront

Register Now

Wednesday, August 3 FTS  |  Tuesday  |  Wednesday  |  Thursday  |  Friday  |  Vendor Demo
Time Session Name Track  Level
iCal 9:00 a.m. Under the Hood WAN Performance Session - Core General
Jon Thatcher (FileMaker, Inc.)

Session Description Getting the best performance out of your solution can be difficult, particularly when running over a wide area network. In this session we will look "under the hood" to find out why the speed of some FileMaker operations varies so much between local and wide area networks.

Products & Technologies

  • FileMaker Product Line

What You Will Learn

  • Diagnose performance problems using FileMaker Server statistics and logs
  • Concrete ideas on how to improve the performance of your database solutions

iCal 9:00 a.m. Automated Conversion of FileMaker Pro Databases to CakePHP Web Applications Using FmPro Migrator Service - Vendor Demo General
David Simpson (.com Solutions Inc.)

Session Description Rather than spend over $1000 per layout for offshore PHP web development, FileMaker developers can use the PHP Conversion feature within FmPro Migrator Platinium Edition. During this session, a FileMaker Pro to CakePHP application will be generated using FmPro Migrator. The resulting web application uses the existing FileMaker Pro layouts to build functional web forms having the same look and feel as the original database. FmPro Migrator supports 12 different database servers, including FileMaker Server Advanced. When using FileMaker Server Advanced, the generated CakePHP applications uses the FileMaker ODBC driver, providing significant performance enhancements compared to the FileMaker PHP API.

Products & Technologies

  • FileMaker Pro Advanced
  • FileMaker Server Advanced
  • ODBC
  • PHP
  • CakePHP
  • SQL
  • MacOS X
  • Windows

What You Will Learn

  • Pre-migration database schema changes which are required
  • Convention not configuration, the CakePHP development philosophy
  • CakePHP MVC (model, view, controller) architecture overview
  • Generation of CakePHP models from the original database schema and relationships, CakePHP views from FileMaker Pro layouts, and CakePHP controllers

iCal 10:45 a.m. What's Up With FileMaker Go Session - FileMaker Go General
William Heizer (FileMaker, Inc.)

Session Description Working with FileMaker Go has proven to be a revolutionary experience. Since its release FileMaker Go, and the community around it, have changed to enhance the full featured FileMaker client. This session is designed to introduce you to the product, look deeply at some of the key features and behavior changes, and finally a few examples of 3rd parties that are supporting this new platform.

Products & Technologies

  • FileMaker Go

What You Will Learn

  • The latest features of FileMaker Go
  • Best optimizations for your solution to deliver a great iOS experience

iCal 10:45 a.m. Analysing Your Solution with BaseElements Service - Vendor Demo General
Nicholas Orr (Goya Pty, Ltd.)

Session Description Nicholas Orr from Goya will be demonstrating BaseElements and showing how you can use this essential developer tool to expertly analyse your solutions and make your development easier. He will show how BaseElements works and how to use it to your best advantage, as well as hidden tips and tricks that speed up searches and cross referencing.


iCal 10:45 a.m. FileMaker Business in Latin America Special Meeting - Special Meeting General
Julie Sigfrinius (FileMaker, Inc.)

Presentation of different Latin America business models and success cases. Ibrahim Bittar, Eiknosys (Mexico) - "Making money with FileMaker in Latin America?" Yes, it's possible. Henrique Bilbao, Hi Soluções (Brazil) - "FileMaker + Apple Servers for Small Companies". Mac Mini Servers in FileMaker development projects creates a profitable model for small and medium companies at Brazil. Jose Lopez Rosario, Solutions Cay & Nelson Santos, Palm PC Solutions Corp (Puerto Rico) - "Thousand pounds less with FileMaker Go". A solution for a medical equipment provider deployed on fifteen iPads, eliminating over a thousand pounds of paper and hours of tedious work. Diego D'Alessio, Soluciones FileMaker (Argentina) - "A Latin American Year in Review". With FileMaker Go, the market and goals grew more than we could ever imagine. Solutions for the medical, industrial and corporate business using FileMaker Go on the iPhone and the iPad. We'll share tips and code!

  • Latin America business models
  • Showcases of FileMaker Go and FileMaker Server

iCal 10:45 a.m. Simplifying the Relationship Graph Session - Design/Develop Intermediate
Chad Novotny (The Support Group, Inc.)

Session Description Spider graphs... anchor-buoy... functional TOGs. FileMaker Pro's relationship graph can get complicated, and there are a number of philosophies on how to manage an ever-growing number of table occurrences in the graph. Is is possible to get back to the graph being a pure Entity Relationship Diagram, easy to grasp and maintain? Probably not completely, but certain development techniques, as well as features of recent releases of FileMaker Pro, can help us get pretty close. Using filtered portals, script triggers, modular UI elements, and perhaps even a plug-in, we will demonstrate taking a once-complicated relationship graph and dramatically simplifying it.

Products & Technologies

  • FileMaker Pro Advanced
  • SQL Plug-in (ScriptMaster)

What You Will Learn

  • Why it can be better to store logic in the presentation level rather than the graph
  • Using filtered portals effectively (and when to rely on the graph instead)
  • Scripts and calcs to get subsets of related data without encumbering the graph
  • When to embrace list and table views instead of portals

iCal 10:45 a.m. FTS: Reporting Session - FTS Intermediate
Bob Bowers (Soliant Consulting, Inc.)

Session Description This session will be based on materials from the first two lessons of Module 7 of the FileMaker Training Series (FTS) materials. It will focus on the mechanics of creating both basic and advanced subsummary reports, including how to use layout and summary fields. Attendees will also learn how to use scripts to incorporate reports into the user workflow. Note: An additional fee is required for all FTS sessions. Attendees will receive one DVD of the FTS materials for one or more sessions (includes modules, videos, exercise and demo files).

Products & Technologies

  • FileMaker Pro

What You Will Learn

  • How to create basic and advanced subsummary reports
  • How to incorporate a report into the user workflow
  • How to work with layout parts
  • How to work with summary fields

iCal 10:45 a.m. Introduction to FileMaker Pro and SQL Integration Session - Integration/Web Intermediate
Paul de Hallé (Linear Blue Ltd.)

Session Description In an Introduction to FileMaker Pro and SQL Integration, we will be looking at how to setup a basic MySQL environment and then integrate this directly into a FileMaker Pro 11 solution. We will cover areas such as naming conventions that work for both your FileMaker Pro and SQL solutions, how to setup and configure your ODBC drivers, on Mac and Windows, and how to utilize FileMaker Server 11 scripting for automating data transfers. This session is designed for beginner to intermediate users with no previous SQL knowledge required.

Products & Technologies

  • FileMaker Pro 11
  • FileMaker Server 11
  • ESS
  • MySQL 5

What You Will Learn

  • Basic MySQL & ODBC Setup
  • How to setup and configure FileMaker Pro ESS
  • Automating data transfers with FileMaker Server
  • Naming conventions when working with FileMaker Pro and SQL

iCal 12:00 p.m. K-12 Education In-house Developer Discussion Special Meeting - Special Meeting General
Leslie Kareckas (FileMaker, Inc.)

Join this special discussion for K-12 school- or district-based in-house developers attending DevCon. This is a great opportunity to network with other educators that are developers to learn about how they are using FileMaker Pro in their schools and districts. Meet new people, exchange ideas, and learn more about FileMaker Pro and K-12.


iCal 12:00 p.m. Medical Professionals Using FileMaker Pro Special Meeting - Special Meeting General
Stephen Gallagher (FileMaker, Inc.)

If you are a physician, medical researcher, or if you work in the medical industry, you are welcome to attend this afternoon luncheon to discuss and network with other fellow medical professionals using FileMaker Pro. Seating is limited.


iCal 12:00 p.m. Legal Update on Software & Internet Issues Session - General General
John Pinheiro (FileMaker, Inc.)

Learn about recent legal issues affecting FileMaker, Inc. and your business, including FileMaker's licensing terms, web site and domain name issues, other current topics, and Q & A to address other areas of interest. Come with your questions. This will be an interactive session. (Lunch will be provided)


iCal 2:00 p.m. FileMaker Security Session - Core Intermediate
David Head (FileMaker, Inc.)

Session Description Security of databases is important for a number of reasons. In this session, you will learn how to secure a FileMaker Pro file and explore the vast range of options available in Privilege Set configuration. Examples will be provided for many common security scenarios. As a FileMaker developer, it is essential that you fully understand the security model that FileMaker provides.

Products & Technologies

  • FileMaker Pro 11

What You Will Learn

  • Securing a FileMaker Pro file
  • Account and Privilege Set management
  • Conditional record viewing, editing and deletion
  • External File Access Security

iCal 2:00 p.m. FileMaker Go Sync Strategies Session - FileMaker Go Intermediate
Richard Carlton (Richard Carlton Consulting Inc.)

Session Description Syncing between FileMaker Pro databases has never been more important than with the release of FileMaker Go. Maximizing user satisfaction with a mobile solution may require use of a local database independent of 3G network connections. Keeping remote databases synchronized with databases running on FileMaker Server can present interesting challenges to FileMaker developers. This session will explore techniques for data synchronization between hosted FileMaker Pro files and local files running in FileMaker Go. A real world sync deployment will be reviewed, including the decision making process that led to the final sync design.

Products & Technologies

  • FileMaker Go
  • FileMaker Server
  • Amazon EC2 hosted FileMaker Servers

What You Will Learn

  • Different Strategies for data Sync between FileMaker Server and FileMaker Go.
  • Strategies for surgical Sync methods versus broadly based sync
  • Ideas for prioritizing conflicts, and establishing master records.
  • Key Field Management with remote clients

iCal 2:00 p.m. FTS: Intermediate & Advanced Techniques Session - FTS Intermediate
Aaron Gutleben (Soliant Consulting, Inc.)

Session Description This session presents specific techniques that FileMaker Pro developers often face in real-world situations. The techniques presented focus on sorting portal records, implementing custom menus and designing a dynamic sub-summary list view. This is a hands-on session where attendees will implement the discussed techniques into an existing FileMaker database. Note: An additional fee is required for all FTS sessions. Attendees will receive one DVD of the FTS materials for one or more sessions (includes modules, videos, exercise and demo files).

Products & Technologies

  • FileMaker Pro Advanced

What You Will Learn

  • Learn how to sort records within a portal
  • Understand a technique for creating a "filtered sub-summary list"
  • Learn how to implement custom menus in a FileMaker Pro solution

iCal 2:00 p.m. Trigger Happy (2.0) Session - Design/Develop Advanced
David Knight (Angel City Data)

Session Description Script Triggers are one of the most exciting additions to FileMaker Pro in years, yet very few people use them at full power. Come explore with us as we uncover numerous creative uses for script triggers that you can add to your solutions. Faster sorting/reporting to improve your Go solutions. Cool search widgets that let users find data more effectively. Clever alert methods that help capture attention. Slick workflow ideas that let users dance through sticky processes. Hidden gems in FileMaker that explode with the help of Script Triggers. And yes...there will be some surprises!

Products & Technologies

  • FileMaker Pro
  • FileMaker Pro Advanced
  • Mac or Windows

What You Will Learn

  • Discover Creative, Powerful Script Triggers You Can Add To Your Solutions
  • See Triggers That Can Improve System Performance Over LAN, WAN & 3G Networks
  • See Workflow Samples Using Triggers That Make Your Databases Easier & More Fun To Use
  • Uncover Hidden Gems In FileMaker That You Can Enhance With Script Triggers

iCal 2:00 p.m. FileMaker Feud by MightyData Service - Vendor Demo General
Kirk Bowman (MightyData)

Session Description Come join MightyData for some FileMaker trivia fun! Two teams will complete for the first-ever title of FileMaker Feud Champion. Each team will consist of one FileMaker coach from MightyData and DevCon attendees. Try to pick the most popular answer to questions on common FileMaker topics including layouts, calculations and scripts. If your team advances to the final round, you earn the opportunity to complete for an awesome prize in the Bonus round. This is your chance to have some fun, test your FileMaker knowledge and laugh together with the MightyData team. To "audition" for a spot on FileMaker Feud, visit our web site, complete the audition form, and let's play the Feud!


iCal 3:45 p.m. Understanding Custom Functions Session - Design/Develop Beginner
Thomas Kunetz (FileMaker, Inc.)

Session Description Custom functions allow developers using FileMaker Pro Advanced to add to the tools available to them for writing calculation formulas. Developers can create new calculation functions, name them, establish inputs (parameters), and write code that will be available throughout the database. This session will describes how to create and use custom functions. Attendees will learn what custom functions are and why they're such a great advantage to FileMaker Pro development process. You'll learn where and when to use custom functions, and how they differ from regular calculation fields. You'll learn how custom functions help keep your solutions more abstract and flexible. You'll learn the specificities of Custom Functions and how to understand the concept of recursion. This session is a good foundation for starting using and creating your own custom functions.

Products & Technologies

  • FileMaker Pro 11 Advanced

What You Will Learn

  • Learn Custom Functions basics
  • Where and when to use custom functions
  • Create Custom Functions to perform iterative tasks
  • Custom Functions best practices

iCal 3:45 p.m. HTML5: An Overview Session - Integration/Web Intermediate
Matthew O'Dell (FileMaker, Inc.)

Session Description In recent history HTML5 has become a familiar buzzword in technology news. Besides being the next generation of the backbone coding language of the web, what is HTML5? This session will cover the beginnings of HTML5 and the problems it is trying to solve. It will show popular examples as well as some simple frameworks to get started easily. Lastly it will show ways to enhance your FileMaker Pro and Go solutions using Custom Web Publishing and Web Viewers to develop engaging user interfaces.

Products & Technologies

  • HTML5
  • CSS
  • JavaScript
  • FileMaker Pro
  • FileMaker Server
  • Custom Web Publishing
  • PHP

What You Will Learn

  • Discuss the rationale behind HTML5
  • See examples of exciting uses of HTML5
  • Explore common frameworks to get up and running quickly
  • Learn ways to extend your FileMaker Pro solution using HTML5 and Custom Web Publishing

iCal 3:45 p.m. The Year In Review Session - Core Advanced
John Sindelar (SeedCode)

Session Description A fast paced survey of the coolest FileMaker work we've seen over the past year, with a focus on the amazing things our peers are doing in FileMaker Pro 11. We'll look at the scripts, solutions, and interfaces that have blown me away, and we'll extract a few principles you can apply in your own projects.

Products & Technologies

  • FileMaker Pro 11 along with a few plug-ins and 3rd party products.

What You Will Learn

  • A fast paced look at the most interesting FileMaker work I've seen in the last year
  • Check out the techniques and insights employed by some of the most innovative developers out there
  • With a special focus on groundbreaking techniques made possible by FileMaker Pro 11
  • Learn new ways to think about FileMaker so you can apply the principles behind these innovations to your own projects

iCal 3:45 p.m. Inherit Another Developer's Code With Speed and Grace Session - Design/Develop Advanced
Chad Adams (Skeleton Key)

Session Description There seems to have been a lot of talk and books and sessions about how to work and develop and function in such a way to make handing off a project to another developer easier/better. Instead of talking about how to change your practices to make these hand offs easier (an activity that has to be there from the very beginning of the project or you've lost it), we will discuss some lessons, tips, tricks, and lessons learned that will help that second developer to work with a system that has been developed by someone else.

Products & Technologies

  • FileMaker Pro
  • FileMaker Pro Advanced

What You Will Learn

  • Make sense of the method
  • Identifying the "gotchas"
  • Tools to help get up to speed

iCal 3:45 p.m. Go Farther with Cloud Computing, Migration Bundles, and RAD toolkits by Worldcloud Service - Vendor Demo General
Joe King (worldcloud)

Session Description This is a fast paced, three part session which is designed to be light on propaganda and rich in content. The first part is a brief overview of the products and services at worldcloud and how cloud hosting differs from traditional hosting. The second part of this session, we will look at the worldcloud Rapid Application Development & Migration Tools and demonstrate how it can make you a better developer while helping you concentrate on business functionality as opposed to 'housekeeping'. We will also discuss how a RAD toolkit differs from a template system. Lastly, we will demonstrate and discuss the value of offering your solutions as SaaS offerings and technical considerations/options for protecting your intellectual property. Charge clients monthly- without significant up-front costs: easier to sell, easier to manage, and you generate residual income. You may even offer full FileMaker Pro-centric services to users which do not/ can not install FileMaker- Macs, PCs, iPads, Android Tablets, and many more...