Home | FMGreet Members | My Account           Listing of Devcon sessions - Leave comments about sessions. All Sessions | Thursday | Friday | Saturday | Sunday (Login into FMGreet to add SMS notifications for these sessions) 07/16/2008 8:00 AM Design / Develop Intermediate Matrixes & Grids: Tricky Layouts Demystified John Sindelar Learn how to create grid based layouts without going crazy. We’ll look at different approaches to building these tricky displays and arrive at techniques that make them easier to build and maintain. 08/13/2009 8:00 AM FTS Intermediate Calculation Functions John Mark Osborne Learn how to implement a calculation to filter a phone number. From the Data Viewer to validation, this session will cover the entire process of designing a calculation that works in every scenario. The complete formula will include checks and balances for 7 and 10 digit numbers, a discussion of the interaction between auto-enter and validation, Custom Functions, the Self function and much more. 08/13/2009 8:00 AM PreCon Intermediate Intro to PHP Jonathan Stark PHP is arguably the most popular and ubiquitous scripting language on the web. FileMaker Server 10 supports Custom Web Publishing with PHP natively, so it's time to get to know PHP. 08/13/2009 8:00 AM FTS Intermediate Data Modeling Scott Love This session begins by introducing some of the basic concepts that underlie data modeling. It will delve into such concepts as entities, attributes, and relationships. The second half of the session will show you how to apply these concepts to get effective and useful work done in FileMaker Pro. 08/13/2009 8:00 AM PreCon Beginner Designing FileMaker Solutions Katherine Russell For many of us, developing with FileMaker is an organic experience, growing out of a need for a quick solution. But quick doesn’t have to mean dirty, and it doesn’t have to mean skipping important requirements. This session offers basic tools for rapidly assessing the structure of a new solution, creating a model on which to base the solution, and producing a solution that provides a high-quality user experience. 08/13/2009 10:30 AM FTS Intermediate Working with Layouts Bob Bowers In this hands-on session, attendees will gain practical experience working with layouts in FileMaker Pro. Specifically, you will learn how about field formatting and field behavior options, as well as how and why to set script trigger options for layouts and objects. You will also learn how to set auto resize options for layout objects. This workshop is intended for beginning to intermediate developers. 08/13/2009 10:30 AM PreCon Intermediate Effective and Reliable FileMaker Security Steven Blackwell In challenging economic times it is exceptionally important to have confidence in the reliability of the technologies we utilize. The adverse impact on an organization of unreliable technologies can range from mild to catastrophic. If FileMaker Pro solutions are unreliable this has a host of consequences for organizations that use them. The core purpose of FileMaker Pro security is to preserve the Confidentiality, Integrity, and Availability of databases and of the business processes these databases manage and enforce. This program is designed for beginners to mid-level intermediate developers and users and will examine the underpinnings and foundations of the modern FileMaker security system. High level intermediate to advanced level developers may also find it useful for review and emphasis on core elements. 08/13/2009 10:30 AM PreCon Beginner Functions and Formulations: An introduction to FileMaker Calculations Darren Terry 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, and 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. 08/13/2009 1:30 PM PreCon Philosophy of Scripting 101 John Mark Osborne Scripting is much more than navigating between layouts. This session will uncover the philosophy of scripting in order to develop a completely scripted interface for your FileMaker solution. With techniques like the Ultimate Find, you’ll learn the importance of scripting to create a professional solution. 08/13/2009 1:30 PM FTS Beginner Reporting Cristoffer Ippolite One of the key features of FileMaker Pro is its powerful reporting capabilities. As a developer, you can use these capabilities to create reports that allow users to better understand and analyze their data. An effective report can be anything from a simple list view to a basic subsummary or even a complex HTML report. This module will guide you through the process of building several types of reports in FileMaker Pro and demonstrate various uses of each type. Also, a web viewer can calculate the URL for tracking a package based on data stored in a tracking number field. Other uses include embedding access to search engines, looking up stock quotes, and generating reports and graphs. In this lesson, you will learn how to add a web viewer to a layout and about the options for configuring it. You will also learn how to control the contents of a web viewer using the Set Web Viewer script step. 08/13/2009 1:30 PM PreCon Intermediate SQL and ODBC Basics for FileMaker Developers Greg Lane FileMaker 10 provides a variety of ODBC-related features for sharing data with other applications and database systems. This session is intended for any FileMaker developer who needs to gain a fundamental understanding of ODBC, SQL, and ESS and how these technologies can be used to make your organization’s data more valuable. We’ll unravel the acronyms and demonstrate practical examples of how to access information in other database systems from FileMaker and how to access information in FileMaker from other systems. Learn the pros and cons of each of the different ODBC-related capabilities FileMaker 10 has to offer. We'll explore FileMaker's SQL Query Builder for creating simple queries and learn how to extend these generated SQL statements to create more potent results. We’ll cover practical uses for each type of SQL statement supported by the FileMaker ODBC client drivers. Learn about important SQL expression elements including various operators, functions, and constants. Learn about ODBC data types and how to convert between data types. 08/13/2009 3:30 PM PreCon Intermediate Philosophy of Scripting 101 Part 2 John Mark Osborne Scripting is much more than navigating between layouts. This session will uncover the philosophy of scripting in order to develop a completely scripted interface for your FileMaker solution. With techniques like the Ultimate Find, you’ll learn the importance of scripting to create a professional solution. 08/13/2009 3:30 PM FTS Intermediate Advanced Techniques Scott Love This session will focus on the list-detail/preview pane functionality described in Lesson 9-3. We will explore the lesson in good detail; students will learn how to work with global fields, develop for multi-user scenarios, learn conditional formatting, use multi-line match fields, and gain some advanced scripting best practices. This 'deep dive' will synthesize material presented in prior sessions and use a specific real-world element of functionality to pull together the fundamentals of FileMaker Pro into one hands-on example 08/14/2009 9:00 AM Session Core Intermediate The Year in Review John Sindelar 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 10. 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. 08/14/2009 9:00 AM Integration / Web Intermediate Securing Your FileMaker Web Applications Jonathan Stark When publishing FileMaker data online, there are many considerations that need to be handled quite differently than in the normal FileMaker client/server world. Security is arguably at the top of the list. In this session, you will learn the big do's and don'ts of web publishing with FileMaker.php, as well as recommendations and best practices. 08/14/2009 9:00 AM Workshop Beginner Making a Case for FileMaker Pro Stephen Gallagher Making the case for FileMaker, selling FileMaker to IT, working effectively with FileMaker personnel, and understanding FileMaker licensing in order to grow your consulting business will be covered in this highly interactive session. If you are a developer working with or inside of an educational institution or corporate enterprise and would like to enjoy more success in gaining the acceptance of your ideas, then this session will be very worthwhile. 08/14/2009 9:00 AM Workshop Intermediate Bridging UI Differences: Redesigning Layout Embrace the New Interface Lee Lukehart This workshop provides hands-on opportunity to apply suggested tactics for embracing the new user interface. Whether you think it boon or bane, incorporating the modernized Status Toolbar (formerly Status Area) requires new thinking about layout design and user interaction options. Its re-location and newly available buttons and features change the rules, especially when upgrading existing solutions or in cross-version deployments. 08/14/2009 9:00 AM Design / Develop Advanced Modern FileMaker Development Techniques Darren Terry In this session, you’ll learn various innovative development techniques that can help you extend your skill set and improve the efficiency of your solutions. Topics covered will include: Universal Scripts, "Scripted Functions", Customized Export, Layout-level calculations and File Manipulation. In this session, you will learn techniques derived from real world solutions developed using the latest version of FileMaker software. These techniques will be immediately applicable to your solutions today. 08/14/2009 10:30 AM Core Advanced Extend and Optimize FileMaker Pro Search Matt Navarre Take search to the next level, inspired by the success of online search tools. Learn where FileMaker search performs best, what slows it down, and how to optimize for speed. Categorize data before you search: Is the search term a date or date range? Phone number, e-mail address, integer or decimal? Learn methods to show results from multiple tables without searching through a relationship. Learn methods to rank search results, and highlight text in found records that matches search. Basically, build web-inspired search in FileMaker. These methods are all designed to deliver the results the user expects and is already trained for. 08/14/2009 10:30 AM Integration / Web Intermediate Understanding Remote Connections to FileMaker Server Rick Colcock If you ever wanted to connect multiple offices, give live database access to remote sales people, or just work from home in fuzzy slippers, this is the session for you. Learn how to SKIP the task of creating a web site for you or your employees to remotely access work. Stick with what you know, and do it with FileMaker Pro. This session will cover the different options in accessing FileMaker databases from outside your local network. You should leave this session with the knowledge you need to make informed decisions about remote access. Security concerns and popular SOHO networking equipment will be discussed and possibly demoed. 08/14/2009 10:30 AM Design / Develop Intermediate Introduction to Script Triggers in FileMaker Pro Steve Romig Script triggers are one of the new, exciting features of FileMaker Pro 10. This session will explore how to get the most out of script triggers starting from the basics and what a script trigger is what it can do for you and your solutions to troubleshooting the usage of script triggers in your solutions. Each script trigger will be discussed in detail, including usage and how the different triggers interact with each other. If you are thinking about integrating script triggers into your solution, this session is for you. 08/14/2009 10:30 AM Workshop Advanced Developing Plug-ins - Resources for the First Time Plug-in Developer Jake Traynham This workshop is designed to teach first time plug-in developers how to get started writing a FileMaker plug-in. We will go over the technologies used to create a plug-in from the various plug-in templates available as well as using a plug-in from within FileMaker Pro. The workshop will begin with nothing and end with a completely compiled template with at least one additional function. 08/14/2009 1:30 PM Design / Develop Advanced Advanced Script Triggers in FileMaker Pro 10 Bill Heizer This session will explore some of the important behaviors of script triggers. We will examine the importance of script result, differentiating pre-event and post-event triggers, choosing the right trigger, the attributes of Install On-Timer Script, and revisit some of the triggers we've had prior to version 10. Through demonstration and discussion we will uncover the depths of script triggers. Check your regulator and fill your tanks before entering the water. 08/14/2009 1:30 PM Core Beginner Backup Strategies for FileMaker Server Jesse Barnum Incorrect backup strategies can be catastrophic to your business. Learn the do's and don'ts of setting up your FileMaker Server backups, how you can use new features in FileMaker Server 10 to do constant incremental backups, and some third party products that can help ensure the safety of your data. 08/14/2009 1:30 PM Integration / Web Advanced Advances ESS Security and Performance Techniques Lee Snover Learn how to leverage the capabilities of ESS in FileMaker Pro to achieve increased performance, security and auditing capabilities using FileMaker and your SQL database. ESS is an incredibly easy to implement feature in FileMaker, but using it to it's full potential with large SQL databases can be frustrating without a proper strategy and a good understanding of how ESS and SQL interact. In this session you will learn advanced techniques to allow you to better integrate FileMaker and SQL databases while maintaining excellent performance and security metrics, which are key to working with large and sensitive data. 08/14/2009 1:30 PM Workshop Advanced Developing Plug-ins - Advanced Topics Jake Traynham This workshop is designed to expand the knowledge of new plug-in developers. This workshop will build on the knowledge gained from the first time plug-in developers workshop, but anyone with previous plug-in development experience can attend. We will cover passing parameters to a plug-in and returning results from a plug-in in great detail. We will also discuss alternate ways to talk to FileMaker including calling scripts, evaluating calculations, and working with the SQL interface. Finally, we will wrap up with discussions on Server and WPE plug-ins. 08/14/2009 3:15 PM Design / Develop Intermediate Empowering Users with FileMaker Pro 10 Features Rosemary Teitge Empowered users are happy users. The user-focused features of the FileMaker Pro 10 family can make a developer’s life easier while improving the experience of solution users. In this session you will learn how to customize FileMaker 10’s status toolbar; the ins and outs of saved finds; how live summaries, persistent sort order, and simple script triggers work together to create powerful reports; and all about enhanced table view. By leveraging the modern toolbar in FileMaker Pro 10 and other new features, developers can spend less time building layouts and reports and more time enhancing the overall productivity of the workgroups they empower. 08/14/2009 3:15 PM Core Beginner Real World In-House Development Challenges and Solutions Jeff Benjamin Within FileMaker, we have similar challenges as many large companies do with in-house development. You will be shown a few in-house developed FileMaker solutions and how you are able to get them developed on time, on budget and to the liking of our in-house customers. 08/14/2009 3:15 PM Integration / Web Beginner Virtualization 1: FileMaker Server Scott Karch This session will focus on different technologies that can be used to virtualize FileMaker Server, VM Ware, Hyper-V, MS Virtual Server, Parallels Server and Virtuozzo. We will cover the advantage gained by using virtualization to reduce costs, increase your backup and disaster recovery ability, speed up deployment of new servers and monitoring of multiple servers. Session will end with demonstrations of live virtual servers. 08/14/2009 3:15 PM Workshop Advanced Advances ESS Hands On Lee Snover This workshop will give attendees a hands-on opportunity to work with FileMaker and SQL using ESS. The goals of this workshop will be to allow attendees to use advanced ESS techniques in a hands-on environment, including development of SQL Views and Stored Procedures. Learn how to synchronize FileMaker to SQL data in real time using FileMaker 10's new script triggers. Discussions will be facilitated around optimizing security and performance when integrating FileMaker with SQL based data. 08/14/2009 4:45 PM Integration / Web Intermediate FileMaker 10 and the iPhone Kirk Bowman The iPhone is the hottest mobile computing platform. Learn four different ways to integrate FileMaker with the iPhone: iPhone Theme and the PHP Site Assistant; synchronization with fmTouch; synchronization with Address Book, iCal and Outlook; and third-party iPhone web site tools. Learn the strength and weaknesses of each and what is necessary to deploy them. 08/14/2009 4:45 PM Core Intermediate File Maintenance and Recovery: New Tools and Best Practices Alexei Folger Database corruption happens. If you are responsible for developing, deploying or maintaining FileMaker solutions, it is very important to plan for disasters, to keep more minor mishaps from becoming disasters, and to take steps to minimize the chances of either in the first place. When the unfortunate does happen, you need processes—and tools—to get up and running again. The good news: FileMaker 10 has some important new features to help you be more successful in handling file corruption. This session will cover best practices for good database "hygiene," and provide an in-depth overview of FileMaker Pro 10's expanded options for file recovery. 08/14/2009 4:45 PM Design / Develop Intermediate Taming The Graph - Techniques for Graph Modeling Ray Cologon The FileMaker Relationships Graph has been the subject of many theories and opinions and a few orthodoxies. Let's look at the realities and expose a few of the myths. As well as reviewing some of the Graph modeling approaches that can be used as the basis of a successful solution, this session will review and compare different methods as well as exploring some alternative techniques that can provide the basis of innovating Graph design. 08/14/2009 4:45 PM Workshop Beginner Virtualization 2: FileMaker Pro Client Scott Karch This session will focus on the different ways to virtualize FileMaker Pro client, Citrix, Terminal Services, GoGlobal and App-V. It will also explain business reasons for virtualizing FileMaker Pro client and have live demonstrations of different technologies. 08/15/2009 3:15 AM Core Intermediate Lose Your Robots - Leveraging FileMaker Server 10 Richard Carlton A number of FileMaker solutions use "robot" computers to autonomously process "back end" tasks to save end users time. Roots are great from running long scripts, so the end user doesn't waste their valuable time, waiting for the same long scripts to run on their local computers. Computer users today demand quick responding applications, and will often refuse to use systems that are slow. The down side of the robots is that they need a bit of parental supervision to ensure they keep running smoothly. Now you can lose the robot and turbo charge your users by leveraging FileMaker Server 10's built in ability to run scripts, including import and exporting data, and event sending e-mail notifications. 08/15/2009 9:00 AM Design / Develop Beginner FileMaker 10 Live Reports and the Art of Information Display Doug Gardner FileMaker Pro has fantastic reporting capabilities, but they often go overlooked and when they are used, rarely are they used to their fullest. This session will begin with some reporting fundamentals, then move from simple summary and sub-summary reports directly into an examination of ways they can be made interactive in FileMaker 10, all with an eye toward the art of information display. Along the way you'll be confronted by reporting problems of varying degrees of difficulty, including some problems that are easy to understand but very challenging to solve. 08/15/2009 9:00 AM Core Advanced The Idiom of FileMaker, What’s New, What’s Old, What’s New Again! Albert Harum-Alvarez FileMaker continues to grow as an application. If FileMaker were a musical instrument, we'd say that you can play a much wider range of music with it than you ever could before. In other words, FileMaker's "idiom" is evolving. There are certain things that are still a "stretch" to do in FileMaker, but the features of the new version of FileMaker Pro are a big leap forward. We'll take a look at FileMaker's growing and evolving idiom by feature, and by viewing case studies that show how leading developers—some of whom have been using the new version since before it was released—are playing this new instrument. What are developers doing with script triggers, and should they be used to "fake" an actual database trigger? How is "Set Field by Name" changing code? How are "live" subsummary parts changing the idiom of FileMaker reports? Will Saved Finds change the way users query databases? We'll see how the best FileMaker designers are answering these questions. 08/15/2009 9:00 AM Integration / Web Beginner Web Services with FileMaker Pro Jesse Barnum Web Services have become the universal glue between modern IT organizations. Now you can tap into this universe of interoperable data with FileMaker Pro to do things like zip code lookups, CRM integration, and automated shipping. You'll also learn how you can publish your own XML Web Services using what you already know about FileMaker scripting. Attendees should understand basic XML concepts and be familiar with using FileMaker plugins. 08/15/2009 10:30 AM Core Beginner DRY FileMaker: Techniques to Keep Scripts Error-Free and Manageable Geoff Coffey This session will help intermediate scripters tackle large and complex scripting challenges without ending up with a mess. By focusing on the powerful design philosophy called "DRY," we'll talk about how to realistically handle error conditions, keep each script small and efficient, and structure a complex script for maximum maintainability. You'll learn about "context free scripting," a technique to squeeze as much flexibility and reusability as possible out of every script. And you'll discover how to bring all these techniques together to start making more manageable scripts right away. 08/15/2009 10:30 AM Integration / Web Intermediate Accounting Integration for Mac & Windows Linda Pitts Attendees will get an overview of ways to share data and integrate with three popular accounting software products on Mac and Windows and will learn about two FileMaker accounting products available. Examples of user interfaces and developer tips will be shared and time frame for development will be discussed. 08/15/2009 10:30 AM Design / Develop Intermediate All Aboard! Anchor-Buoy Tips and Tricks John Howell Learn how anchor buoy can simplify your development. Discover when it does and doesn't make sense to adopt. See advanced A/B tips that even experts often miss. After you attend this session, you'll know how easy it is to build complex relational diagrams in FileMaker Pro. Anchor-Buoy is probably the easiest to learn and most intuitive approach to relationships in FileMaker Pro. 08/15/2009 10:30 AM Ten Software Product Development Lessons I Wish I Had Learned 10 Years Ago David Johnson Think you've developed a solution in FileMaker that you can sell over and over again? Facility Wizard Software is an Independent Software Vendor (ISV) that has several FileMaker-platform software applications, 25 employees, over 650 customers, and has grown over the past 18 years to generate over $3 million in annual revenues. In this session, Dave Johnson, the company's President and CEO will outline ten key product development lessons that he wishes someone would've told him ten years ago. Topics will range from programming standards and version-tracking to software hosting and web-based applications. 08/15/2009 1:30 PM Workshop Advanced The Idiom of FileMaker: Applying a Growing Feature Set to Your Current App Albert Harum-Alvarez As a developer, you might be thinking about revising an application in the latest version of FileMaker Pro. You've got a lot of new potential to consider. Which part of the new idiom of FileMaker will truly help your users, and which of your new design ideas might be more of a distraction than a help? We'll put your work up on the screen and hear about your plans. Then, kindly but honestly, your workshop leader will give you his honest critique, based upon his long years of software design experience and 11 years of giving the same kind of counsel in the FileMaker Design Master Class. 08/15/2009 1:30 PM Design / Develop Intermediate Americas Top Separation Model Matt Navarre Separating your solution into two files provides some great benefits. For example, you can deploy a new interface file in mere minutes. This session covers the mechanics of separation: Clone the file, create an External Data Source in the clone, and update each occurrence to use this source. Then delete all the tables in the interface file, and all the scripts and layouts in the Data file. We'll cover these steps in detail, focusing on the tricky aspects such as value lists, relationships that must remain in the Data file, calculated fields, and security considerations. 08/15/2009 1:30 PM Integration / Web Intermediate Introduction to the API for PHP Douglas Flinn This session will be a case study of the FileMaker, Inc. Webstore and the new Developer Relations Web site. We'll discuss writing multi-use PHP scripts in an object-oriented environment, developing in an Model-View-Controller architecture, and adding features to an existing system. We'll also discuss some advanced Web development technologies including AJAX (AJAH) scripting and Data Encryption. 08/15/2009 1:30 PM Core Advanced FileMaker Server Configuration: Performance Monitoring Matt O’Dell As developers and system architects, one of the most important topics to those sharing an application with FileMaker Server is server performance and health. Performance Monitoring is the standard technology for viewing hardware usage and overall server performance. By collecting and studying Performance Monitors, we are able to view how our hardware is performing, diagnose problems or bottlenecks, and make educated decisions on developing techniques and hardware purchases. One topic of discussion will be how to setup Performance Monitoring on Windows and Mac. PerfMon has been built into Windows for years, so a simple solution will be given for Mac as well. The next topic would cover the different counters associated with FileMaker Server and how they tie to server performance. This will segue into how to use these monitors to diagnose problems, and also give real world examples of these same problems with monitors gathered from the field. Performance Monitors are giant windows into the health and stability of a server, so if you are a developer with a solution hosted on FileMaker Server, this is the session for you. 08/15/2009 1:30 PM Workshop Intermediate Accounting Integration - Share Data with MYOB Linda Pitts Attendees will see techniques and examples for how to prepare formatted exports that will import into MYOB accounting software for Mac and Windows. Additionally, we will discuss how to make the user interface simple while processing data in hidden layouts with scripts and calculations. Finally, we will discuss considerations for automating the process of import/export with ODBC and AppleScript. 08/15/2009 3:15 PM Integration / Web Intermediate Slicker Custom Web Publishing Sam Sehnert Are you building Custom Web Publishing (CWP) solutions for FileMaker? Do you want to make your CWP sites more compelling and easier to use? Learn how some simple "AJAX" techniques can be used with the FileMaker PHP API to create professional, modern web applications. You will learn the basic theory behind the technology and pro's & con's of some freely available JavaScript Libraries. After your brief introduction, we will discuss in detail two example implementations, which demonstrate the capability of this technology. You will walk away with some great ideas, and the source code of the examples to dissect at your leisure. 08/15/2009 3:15 PM Design / Develop Intermediate Quantum Scripting Debi Fuchs This session is about modular scripting. If you are familiar with FileMaker scripting, and are looking for ideas to make your scripts more flexible and reusable, then this session is for you. You will learn to design rock-solid, modular, "building-block" scripts that you can call again and again within your own custom solutions. In the process, you will hear about real design principles from computer science (abstraction, modularity, encapsulation, etc.) and apply them to FileMaker (using script parameters, script results, error codes, subscripts, and variables). You will see actual code gathered from the larger community of FileMaker developers, and take home several scripts that can be building blocks in your own custom solutions. 08/15/2009 3:15 PM Workshop Intermediate Integrating FileMaker Pro Into Your Web / Email Marketing Strategy Randall Mauro With FileMaker Pro It has become extremely easy to communicate with other web platforms to interact with your Internet users and gather data about them or to provide them information. This session will discuss ways that FileMaker Pro can be used in a larger web marketing initiative. We will discuss examples of how companies have used FileMaker Pro for this types of web initiatives. Examples will be shown of things that can be done in a FileMaker Pro database acting as a back end. Finally, we will discuss the best way to host your data. 08/15/2009 4:45 PM Integration / Web Intermediate Integrating Your CSS Into the PHP Site Assistant Session Steve Lane The purpose of this session is to help the attendees learn about the PHP Site Assistant (PHPSA) and its generated code namely the CSS it generates with the goal of demonstrating how one can integrate their own CSS files into the generated site. This session will also give a basic understanding on how to use the PHPSA and a quick overview of what is generated. Developers who are curious about the PHPSA or have a need to integrate their own CSS files will find this session beneficial. Basic background in CSS is recommended. 08/15/2009 4:45 PM Core Intermediate Good System Gone Bad - Fixing Stability Issues in FileMaker Steve Sykora This session will define a strategy and describe a method to identify problems, isolate issues, and select and implement solutions for performance and stability concerns. It will also discuss some of the new tools that FileMaker 10 provides for addressing these issues. Make sure to attend the related workshop for a real-world walk-through of the strategy and method discussed in this session. 08/15/2009 4:45 PM Workshop Intermediate Scripting in The Gaps Brinsley Barreto Scripting in FileMaker allows you to automate a process, and thus help the user interact with the database more efficiently. Although, you can accomplish automation through a basic understanding of scripts, you can take the user experience to the next level by delving further into the features FileMaker Pro offers through Manage Scripts. In addition, through the use of the Script Debugger in FileMaker Pro Advanced you can thoroughly test and debug the scripts you have written. All of this will be discussed in this workshop. 08/16/2009 9:00 AM Workshop Beginner Client Satisfaction 101: How to Keep Your Clients Happy Molly Connolly Great programming skills are not necessarily related to happy clients. You can make the best database in the world without it meeting your client's needs and expectations. This session will walk you through the full cycle of a client engagement and give you business and project management tips on how to more effectively design, build and implement a solution that meets your client's needs. 08/16/2009 9:00 AM Design / Develop Intermediate Practical Script Triggers Geoff Coffey Script Triggers are the most significant advancement in FileMaker Pro 10, and one of FileMaker's biggest power-ups in years. At the same time, these automatic actions can be fraught with pitfalls your first time out. In this session, you'll learn how script triggers can help you build better databases with less code, and avoid the traps along the way. 08/16/2009 9:00 AM Core Intermediate ESS Under The Hood Galt Johnson Have you ever wondered exactly what FileMaker is doing behind the scenes when using a SQL Datasource via ESS? Come and find out how it manages data, how transactions are managed. This session will help you to understand just what to expect from ESS data sources as well as help you steer clear of potential problems. (Repeat of the 2007 session of the same name). 08/16/2009 9:00 AM Integration / Web Intermediate Create Rich -Text and HTML E-Mail from FileMaker Kirk Bowman Sending compelling e-mail messages is an important need for any organization. Learn how to create and send Rich-Text and HTML e-mail from FileMaker Pro with a plug-in. Survey several third-party tools to send e-mail from FileMaker Pro. Walk through calculations and scripts that can be adapted to work with several of the products available. 08/16/2009 9:00 AM Workshop Intermediate The Web Viewer Unleashed Sam Sehnert Developing complex Web Applications for use within the Web Viewer is not without its challenges. If you are planning on adding rich user interfaces to your database using the Web Viewer, this workshop is a must. You will learn advanced techniques, which will be invaluable when integrating complex web apps with FileMaker. There will be a focus on JavaScript event handling issues, related to working with the Web Viewer. We will also be going over some important differences between Mac and Windows browsers, and how this can affect the Web Viewers content both visually and functionally. Additionally you will learn about the 'Set Web Viewer' script step, and effects of the different options this provides. 08/16/2009 10:30 AM Integration / Web Intermediate Real World Examples of Using ESS Richard Carlton This session cover updates to the ESS (External SQL Source) feature for FileMaker 10, and provides a case study for how ESS is being used by developers today. We will show ESS's role in connecting FileMaker order management systems to online shopping carts systems and opensource CRMs. We will look at how organizations can now use ESS to allow FileMaker Pro to connect to existing data management systems for the purpose of creating customized reports or data automation. Finally, we will look at "one fact, one place"—using data from a larger enterprise database within a custom FileMaker solution (sales, personnel, etc.) without replicating (replicating would make the information exist in two different places, one of which could be out-of-date.) 08/16/2009 10:30 AM Workshop Beginner Relationship Rescue: Mastering The Relationship Graph Doug Gardner Have you ever been in a FileMaker calculation window and not been able to figure out which context or relationship to use for the calculation? What does it mean in the Set Field script step when it says "This calculation will be evaluated based on context determined at runtime."? What is context, anyway? What do layouts have to do with the relationship graph? What's the difference between defining a sort in the relationship graph and defining it in a portal? In this workshop you'll learn the answers to all these questions, and learn how to create a relational structure that scales from the smallest to the largest projects without becoming more difficult to read or use. With a little counseling, you'll never get lost in the world of relationships again. 08/16/2009 10:30 AM Core Intermediate Extending Solution Functionality with FileMaker 10 Ray Cologon FileMaker Pro 10 provides significant features and product enhancements that open up some exciting new opportunities for developers. In this session, you will be taken on a tour of some of the highlights of the latest release, with pointers to some of the ways the new features can help you to get the most out of your solutions. The session will include demonstrations of a number of techniques that show the power of the expanded feature set. You will get to see code and coding techniques that unlock hidden powers in this new release. 08/16/2009 10:30 AM Design / Develop Intermediate Let’s Get Normal: Database Normalization - Basics of Relational Design John Howell This session will help you clearly understand the concepts of database normalization. You will learn the different normal forms, when to apply them and how to plan for a well formed database system. Database normalization is essential to working as a professional database developer. You will discover how to build more efficient, solid and extensible systems. You will also learn practical examples of when to denormalize databases for special circumstances. 08/16/2009 10:30 AM Workshop Intermediate Good System Gone Bad: Finding and Fixing Performance Stability Issues Steve Sykora Highly complex and dynamic FileMaker solutions often have a downside—stability and performance that erode over time. Maybe your users see the coffee cup icon too frequently, maybe the system inexplicably hangs or is slow to redraw, or, worst of all, the system "crashes" frequently. This workshop will walk through a strategy and method to identify problems, isolate issues, and select and implement solutions for performance and stability concerns. It will also demonstrate some of the new tools that FileMaker 10 provides for addressing these issues. Make sure to attend the related session prior to this workshop for the background discussion on this topic. 08/16/2009 1:00 PM All Intermediate Under The Hood - Pro and Server Performance Jon Thatcher We'll take a look "under the hood" at how the database engine performs requests in FileMaker Pro and FileMaker Server, and how this can impact your solutions. This session should help you understand some of the ways—both big and small—that you can get the best performance out of your FileMaker databases. 08/16/2009 2:30 PM Closing Session FileMaker Executives Closing Session with FileMaker Executives Bill Epling and Ryan Rosenberg   Created by FMWebschool with FMStudio. Hosted by FMGateway.