FileMaker 11.0: Building web pages from FileMaker Pro and MySQL data

Duration: 1 Day

Objectives

Since version 9.0, FileMaker Pro has supported the integration of External SQL Data Sources (ESS) into the Relationship Graph. A huge step forward, this feature makes it easy to link your FileMaker data directly to remotely hosted MySQL tables, the open source technology used by web developers everywhere to build web pages. This FileMaker Authorised course teaches you how to use ESS to build and maintain a simple website, directly from within FileMaker Pro.

Pre-requisites

Delegates should be have at least a basic understanding of FileMaker Pro. No ODBC knowledge or HTML knowledge is required.

Course includes

Follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

This course is available as a private or customised course. Please phone us on 0208 269 4260 or email us for further information and to customise this course to your exact requirements.

"Very enjoyable, well-paced tuition, tailored and relevant to my workplace demands."

RAF

Course outline

Principles and Benefits
• Why use FileMaker to build a website?
• What is MySQL and why is it so popular with web developers?
• Using ODBC to incorporate MySQL tables into your Relationship Graph

Introduction to MYSQL and PHPMyAdmin
• MySQL table structure
• A popular tool to administer MYSQL data structures: PHPMyAdmin
• Creating a MySQL table using PHPMyAdmin
• Creating, editing and deleting fields using PHPMyAdmin

ODBC Connectivity
• Basic ODBC principles
• ODBC Drivers
• Creating an ODBC connection under Windows
• Creating an ODBC connection under Mac OS X
• Creating and configuring a Data Source Name (DSN) under Windows using the ODBC Control Panel
• Creating and configuring a DSN under Mac OS X using ODBC Administrator
• Installing drivers where necessary

Incorporating a MySQL Data Source into the FileMaker Relationship Graph
• Creating an External Data Source from an existing ODBC DSN
• Specifying a user name and password
• Explanation of the “Filter Tables” option
• Adding an ESS table occurence to the graph
• Synchronising an ESS table occurence when the source changes
• Limitation of field behaviour within ESS table occurences

Linking FileMaker data tables to ESS tables
• Identifying key fields
• Incorporating Cascading Deletes
• Creating layouts from ESS tables
• Creating, editing and deleting records in ESS tables through the FileMaker Pro interface
• Working with individual records versus an entire record set
• Using the “Flush SQL data source” script step
• Summary and review