| PreCon Sessions (Included in Gold Package) |
 8:00 a.m. |
The Fundamentals of Exceptional Interface Design: The Design Process |
PreCon |
Intermediate |
|
Session Description
Exceptional user interfaces solve the right problems, are easy to learn, and are efficient to use. Last year in this session, I introduced a repeatable process that developers can use to design exceptional interfaces and applications. Using new client examples, this session will expand on the process introduced last year and will also examine the decisions you must make to develop a solution from a problem statement to a successful implementation.
Products & Technologies
- FileMaker Pro
- FIleMaker Go
What You Will Learn
- A repeatable process to use when designing FileMaker databases
- How to identify the right problems to solve with personnas and scenarios
- How to develop the framework of a solution
|
| 8:00 a.m. |
Bare Bones PHP - Part 1 |
PreCon |
Intermediate |
|
Session Description
Using PHP is the most flexible way to publish FileMaker data to the web; it also has a steep learning curve. This session will dispense with the theory and focus on writing basic PHP code in a text editor. The first 50 attendees who bring a laptop will be able to connect to a FileMaker Server via WiFi and work through the session lessons hands-on.
Products & Technologies
- FileMaker Server
- FileMaker API for PHP
What You Will Learn
- How to connect to a FileMaker database with the FileMaker API for PHP
- How to search a FileMaker database with the FileMaker API for PHP
- How to display search results with the FileMaker API for PHP
- How to handle search errors with the FileMaker API for PHP
|
| 10:30 a.m. |
Building a Solid Foundation: FileMaker Pro Relational Database Fundamentals |
PreCon |
Beginner |
|
Session Description
In this session we will cover all the basics: data modeling, relational design, calculations, scripting, user interface and interaction design. By the end, you'll have a solid foundation in building a solid foundation-you'll know how to create the core of a database that is flexible and allows for growth for years to come. You'll understand the relationship graph and how table occurrences are intimately tied to layouts, which in turn provides the context for evaluating calculations. Because calculations are at the core of 80 percent of FileMaker Pro script steps you'll be able to see how it all ties together.
Products & Technologies
- FileMaker Pro 12
- FileMaker Pro Advanced 12
What You Will Learn
- How to create a relational database that provides a solid foundation for future growth and development
- How to plan and build a database that doesn't get slower or harder to work with as it grows
- How to understand calculations and scripting in the context of your database
- How to incorporate the needs of the end-user into your database to achieve their goals and yours
|
| 10:30 a.m. |
Bare Bones PHP - Part 2 |
PreCon |
Intermediate |
|
Session Description
Using PHP is the most flexible way to publish FileMaker data to the web; it also has a steep learning curve. This session will dispense with the theory and focus on writing basic PHP code in a text editor. The first 50 attendees who bring a laptop will be able to connect to a FileMaker Server via WiFi and work through the session lessons hands-on.
Products & Technologies
- FileMaker Server
- FileMaker API for PHP
What You Will Learn
- How to add a record to a database with the FileMaker API for PHP
- How to edit a record in a database with the FileMaker API for PHP
- How to display related records with the FileMaker API for PHP
- Techniques for debugging code for the FileMaker API for PHP
|
| 1:30 p.m. |
Functions & Formulations: An Introduction to FileMaker Calculations |
PreCon |
Beginner |
|
Session Description
FileMaker Pro is a very powerful yet easy to use database development environment. Everyone knows that it's easy to start building a database right away. FileMaker Pro comes equipped with a calculation engine that lets the database do a lot of the heavy lifting for you when it comes to data manipulation. But accessing that power can be a daunting task for the uninitiated.
This pre-conference session is a beginner-level survey of calculations in FileMaker Pro. The goal of the session is to familiarize you with the elements that go into making a successful calculation formula. Topics covered will include:
- Introduction and overview of the calculation dialog box and its elements
- Introduction of key concepts involved in calculations (functions, parameters, expressions, operators)
- Examination of such key concepts as calculation result types and conditional logic
- Tips on calculation troubleshooting and how to format your formulas to make them easier to maintain in the long run
By the end of this pre-conference session, you will have a working database with example calculations that can easily be replicated in real-world solutions.
What You Will Learn
- Learn the basics of FileMaker Pro calculations -- techniques that you can apply to your solutions today
- Learn the anatomy of calculation functions and expressions
- Discover how to let FileMaker Pro do the heavy lifting of data manipulation for you
- Unravel the mysteries of subjects like conditional logic and data parsing
|
| 1:30 p.m. |
SQL Basics for FileMaker Developers |
PreCon |
Intermediate |
|
Session Description
FileMaker has continuously improved its SQL-related features and with the addition of the ExecuteSQL function in FileMaker 12, every developer can benefit from knowing a bit of SQL. This session will focus on the basics of writing SQL queries and how to use those queries within FileMaker calculations and scripts. We'll also look at practical examples of how to use SQL to integrate with other systems and to leverage FileMaker data within calculations with freedom of context.
Products & Technologies
- FileMaker Pro 12
- FileMaker Go 12
- ODBC
- SQL
- plug-ins
- Mac OS X
- Windows
- iOS
What You Will Learn
- Learn to write basic SQL queries
- Learn about ways to use SQL with FileMaker Pro 12 and FileMaker Go 12
- Discover ways to use FileMaker to integrate data with other systems
- Explore techniques using the ExecuteSQL function to simplify your relationships graph and use data from any context
|
| FileMaker Training Series (Included in Gold Package) |
| 7:30 a.m. |
FTS: An Introduction to the FileMaker Training Series Track (No Fee Required) |
FTS |
General |
|
Session Description
This session will be open to all DevCon attendees and is designed to discuss the FileMaker Training Series (FTS) track and various topics covered in the particular sessions. Attendees will be introduced to the sessions and also how they may help you prepare for FileMaker Certification. This session is ideal for anyone attending the FTS Track or for those interested in enhancing their skills and learning directly from FileMaker Authorized Trainers.
What You Will Learn
- Preview the FTS track sessions
- Introductions to the track speakers
- Housekeeping announcements
- Q&A on FTS Track
|
| 8:00 a.m. |
FTS : Data Modeling |
FTS |
Beginner |
|
Session Description
This session will cover data modeling topics from the FileMaker Training Series materials module 3. We'll start by demonstrating how to systematically explore and break a real-world problem down into its constituent parts. Then we'll map those elements into a data diagram and discuss how that design is eventually expressed in a FileMaker Pro file. Finally, we'll review some of the specific benefits and features offered by the relational toolset in FileMaker Pro, and we'll discuss the pros and cons of sorting and filtering relationships as well as common data-modeling approaches.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Pro
- FileMaker Go
- FileMaker Pro Advanced
What You Will Learn
- How to break down a real-world scenario into a set of entities and their attributes
- How to create an entity-relationship diagram (ERD) and understand how it differs from FileMaker's Relationship Graph
- How to create simple, complex and filtered relationships between FileMaker Pro tables
- How to exploit the benefits of bi-directionality and other specialized data-modeling constructs
|
| 10:30 a.m. |
FTS: Working With Fields |
FTS |
Beginner |
|
Session Description
In this session you will become comfortable creating fields and working with various field options. FileMaker Pro supports several different data types including: text, number, date, time, and timestamp. You can specify many options to automatically enter data into a field when a record is created and/or modified. Setting field validation and storage options provides an additional layer of control over data entered into your systems. And finally, you'll learn how to use container fields in your system to manage complex data such as images and binary files.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Defining fields using both the Manage Database dialog and Table View
- Specifying auto-entry and validation options for a field
- The importance of indexing
- Creating and formatting container fields for multiple uses
|
| 1:30 p.m. |
FTS: Connectivity |
FTS |
Intermediate |
|
Session Description
One of the great strengths of FileMaker Pro software is its ability to share data with other applications. Not only can FileMaker Pro make its own data available, via technologies compatible with Open Database Connectivity (ODBC), it can access data stored in other systems as well.
This session covers the ways in which FileMaker Pro can share data using ODBC, a database interchange technology. Using ODBC, you can import data from sources, such as SQL databases, into your FileMaker Pro solution. Likewise, you can make data from your FileMaker Pro solution available to other programs that use ODBC. The session will also cover connecting through the External SQL Sources (ESS) feature in FileMaker Pro, where you can directly access certain kinds of SQL-based data from within a FileMaker Pro system. Attending this session will also help prepare you for the FileMaker certification exam in regard to Connectivity questions.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Different ways of interacting with other data sources using ODBC technologies
- The requirements and procedures for configuring Data Source Names (DSNs) to connect to specific ODBC data sources
- How to use the ESS feature to integrate SQL data sources directly with FileMaker Pro solutions
- The requirements and procedures for using a FileMaker Pro solution as an ODBC data source
|
| Special Meetings |
| 3:30 p.m. |
DevCon Orientation |
Session - General |
General |
|
FileMaker Developer Relations Team (FileMaker, Inc.)
Session Description
Attending DevCon for the first time? The FileMaker Developer Relations team will provide guidance in choosing the sessions that are right for you, recommend events you won't want to miss, and give you tips on how to get the most out of DevCon.
|
| 4:30 p.m. |
Welcome Session and Latin American DevCon Agenda Overview |
Special Meeting |
General |
|
Julie Sigfrinius (FileMaker, Inc.)
Session Description
Review of FileMaker meetings and agendas specific to Latin America at DevCon. Leo Puppo & Assoc. will provide an overview of meetings taking place at DevCon focusing on FileMaker in the Latin American region.
|
| 6:30 p.m. |
Opening Keynote |
Session - General |
General |
|
Executive Staff (FileMaker, Inc.)
Session Description
FileMaker executives will showcase FileMaker products and technologies for today and beyond.
|
| 8:00 p.m. |
Welcome Reception |
Networking - Event |
General |
|
Hosted by FileMaker, Inc.
Session Description
Following the Opening Session is the Welcome Reception to top your first day at DevCon. Join FileMaker staff for great food and beverages. Visit the exhibitors showcasing their new FileMaker products and services. This is a great opportunity to meet other developers from around the world and set the tone for your DevCon 2012 experience.
|
