FileMaker Pro 10 in Depth
, by Feiler, Jesse- ISBN: 9780789739469 | 0789739461
- Cover: Paperback
- Copyright: 2/11/2009
Jesse Feiler has worked with FileMaker since its beginnings. He has written a number of books about FileMaker as well as Mac OS X, the Web, and new technologies; his books have been translated into Japanese, Chinese, Polish, German, Spanish, French, Arabic, and other languages. As director of North Country Consulting, he has designed and implemented a variety of FileMaker solutions for small businesses and nonprofits in fields such as production, marketing, the arts, printing and publishing, food service, and construction. His most recent book is The Bento Book: Beauty and Simplicity in Digital Organization. His website is www.northcountryconsulting.com; the website for the book is filemakerindepth.com. You can find updates and file downloads there.
Introduction | p. 1 |
Welcome to FileMaker Pro 10 | p. 1 |
Best of Three Worlds | p. 1 |
How This Book Is Organized | p. 1 |
Getting Started with FileMaker 10 | p. 2 |
Developing Solutions with FileMaker | p. 2 |
Developer Techniques | p. 3 |
Data Integration and Publishing | p. 4 |
Deploying a FileMaker Solution | p. 5 |
Special Features | p. 5 |
Downloadable Files | p. 6 |
Who Should Use This Book | p. 6 |
FileMaker Overview | p. 7 |
FileMaker and Its Marketplace | p. 7 |
Rapid Application Development | p. 8 |
Low Total Cost of Ownership | p. 8 |
FileMaker Is a Seasoned Platform | p. 8 |
You're Not Alone | p. 8 |
Introduction to Database Software | p. 9 |
Database Software | p. 10 |
What Database Software Does | p. 11 |
Overview of the FileMaker 10 Product Line | p. 14 |
FileMaker Deployment Options | p. 16 |
Single User | p. 16 |
Peer-to-Peer Hosting | p. 16 |
FileMaker Server Hosting | p. 17 |
FileMaker Server Advanced Hosting | p. 17 |
Kiosk Mode | p. 17 |
FileMaker Single-User Runtime | p. 17 |
Extending the Functionality of FileMaker Pro | p. 17 |
What's New in FileMaker Pro 10 | p. 18 |
New Features | p. 18 |
FileMaker Database Architecture | p. 19 |
Technical Specifications | p. 21 |
Using FileMaker Pro | p. 23 |
Getting Started | p. 23 |
Registration | p. 24 |
Activation | p. 25 |
Software Updates | p. 27 |
Using the Quick Start Screen | p. 27 |
Getting Help | p. 29 |
Understanding FileMaker Databases | p. 29 |
Understanding Tables | p. 30 |
Understanding Records and Fields | p. 31 |
The FileMaker Pro User Interface | p. 31 |
Using the Status Toolbar | p. 35 |
Introducing the Status Toolbar | p. 35 |
Customizing the Status Toolbar (Mac OS X) | p. 37 |
Customizing the Status Toolbar (Windows) | p. 38 |
Working in FileMaker Pro | p. 39 |
Opening a Database | p. 40 |
Working with Records | p. 44 |
Working with Fields | p. 45 |
Field Types | p. 48 |
Data Validation | p. 51 |
Working with Related Data | p. 53 |
Finding Data with FileMaker | p. 56 |
Using Find Mode to Perform a Find Request | p. 58 |
Omitting and Showing All Records | p. 64 |
Saving Find Requests | p. 65 |
Sorting | p. 66 |
Printing | p. 67 |
Presenting Data with Summary and Subsummary Reports | p. 68 |
Importing and Exporting Data | p. 69 |
Saving PDF and Excel Documents | p. 69 |
Using the Web Viewer | p. 69 |
Troubleshooting | p. 70 |
FileMaker Extra: Becoming a FileMaker Pro Power User | p. 71 |
Technique 1: Using Your Keyboard for More Speed | p. 71 |
Technique 2: Working with Table View | p. 71 |
Technique 3: Replacing Data | p. 71 |
Technique 4: Inserting Specific Information | p. 72 |
Technique 5: Getting to Know Your Entire Database | p. 73 |
Technique 6: Using Multitiered Sorts | p. 73 |
Technique 7: Using Multiple Windows | p. 73 |
Technique 8: Applying Text Styling and Tabs | p. 73 |
Defining and Working with Fields and Tables | p. 75 |
Working Under the Hood | p. 75 |
New Databases Begin with Field Definitions | p. 75 |
Using the Manage Database Dialog | p. 75 |
Working with Tables | p. 77 |
Table Naming Conventions | p. 77 |
Creating New Tables | p. 78 |
Working with Fields | p. 79 |
Field Naming Conventions | p. 79 |
Adding Field Comments | p. 81 |
Creating New Fields | p. 82 |
Working with Field Types | p. 82 |
Text | p. 83 |
Number | p. 83 |
Date | p. 83 |
Time | p. 83 |
Timestamp | p. 84 |
Container | p. 84 |
Calculation | p. 85 |
Summary | p. 87 |
Working with Field Options | p. 89 |
Auto-Entry Field Options | p. 89 |
Field Validation | p. 94 |
Storage and Indexing | p. 96 |
Furigana | p. 100 |
Troubleshooting | p. 100 |
FileMaker Extra: Indexing in FileMaker | p. 102 |
Working with Layouts | p. 103 |
What's a Layout? | p. 103 |
Creating and Managing Layouts | p. 105 |
Creating a New Layout | p. 105 |
Layout Context | p. 108 |
Layout Setup | p. 110 |
Hiding and Reordering Layouts | p. 114 |
Layout Naming Conventions | p. 115 |
Working with Parts | p. 116 |
Adding and Ordering Parts | p. 117 |
Formatting a Part | p. 118 |
Part Definition | p. 118 |
Working with the Layout Status Toolbar | p. 120 |
Using the Layout Bar | p. 120 |
Using the Customizable Status Toolbar Tool Groups | p. 121 |
Using the Status Toolbar Items | p. 123 |
Working with Objects on a Layout | p. 123 |
Adding Objects to a Layout | p. 123 |
Positioning Objects on a Layout | p. 125 |
Naming Objects on a Layout | p. 129 |
Automatically Resizing Objects on a Layout | p. 129 |
Arranging Objects | p. 130 |
Aligning Objects | p. 132 |
Working with the Tab Control Object | p. 133 |
Adding a Tab Control Object to a Layout | p. 133 |
Working with Fields | p. 135 |
Adding Fields to Layouts | p. 135 |
Field/Control Setup | p. 136 |
Field Behavior | p. 137 |
Setting the Tab Order | p. 138 |
Merge Fields | p. 139 |
Tooltips | p. 140 |
Troubleshooting | p. 141 |
FileMaker Extra: Designing Cross-Platform-Friendly Layouts | p. 142 |
Relational Database Design | p. 143 |
Understanding Database Design | p. 143 |
Database Analysis | p. 143 |
Working with Entities and Attributes | p. 144 |
Entities Versus Attributes: A Case Study | p. 146 |
Design as an Iterative Process | p. 148 |
Understanding Relationships | p. 148 |
Representing Relationships in a Diagram | p. 148 |
Relationship Types | p. 149 |
Understanding the Role of Keys in Database Design | p. 151 |
Keys That Determine Uniqueness | p. 151 |
Keys That Refer to Other Tables | p. 152 |
Many-to-Many Relationships: Using Join Tables | p. 153 |
Attributes in a Join Entity | p. 154 |
Normalizing Data: What Goes Where | p. 155 |
First Normal Form: Eliminate Repeating Groups | p. 155 |
Second Normal Form: Eliminate Redundant Data | p. 155 |
Third Normal Form: Eliminate Fields Not Dependent on the Key | p. 156 |
FileMaker Extra: Complex Many-to-Many Relationships | p. 156 |
Working with Multiple Tables | p. 159 |
Multitable Systems in FileMaker Pro | p. 159 |
Creating a One-to-Many Relationship in FileMaker | p. 160 |
Creating the First Table in a Multitable System | p. 160 |
Adding a Table to a Multitable System | p. 161 |
Adding a Relationship | p. 163 |
Working with Keys and Match Fields | p. 164 |
The Database So Far | p. 164 |
Working with Related Data | p. 165 |
Using a Portal to View Related Child Data | p. 165 |
Using a Portal to Add Related Records | p. 168 |
Working with Related Parent Data in a Child File | p. 171 |
Creating a Many-to-Many Relationship | p. 172 |
Building the Structure | p. 172 |
Creating Value Lists | p. 173 |
Designing the Interface | p. 174 |
Rapid Multitable Development | p. 175 |
Troubleshooting | p. 176 |
Working with Relationships | p. 177 |
Relationships Graphs and ERDs | p. 177 |
Relationships as Queries | p. 177 |
Nonequijoins | p. 178 |
Adding a Table Occurrence to the Relationships Graph | p. 179 |
Defining a Relationship with Multiple Match Criteria | p. 180 |
Creating Self-Relationships | p. 184 |
Creating a Relationship with a Global Value | p. 185 |
Creating Cross-Product Relationships | p. 187 |
Working with Multiple Files | p. 187 |
Creating an External Data Source | p. 188 |
Adding an External Table to the Relationships Graph | p. 191 |
Troubleshooting | p. 192 |
FileMaker Extra: Managing the Relationships Graph | p. 193 |
Using Formatting Tools to Manage the Relationships Graph | p. 193 |
Using Table Occurrences to Manage the Relationships Graph | p. 194 |
Getting Started with Calculations | p. 197 |
Understanding How and Where Calculations Are Used | p. 197 |
Writing Calculation Formulas | p. 198 |
Uses for Calculation Formulas | p. 199 |
Exploring the Specify Calculation Dialog | p. 200 |
Writing the Formula | p. 200 |
Options | p. 204 |
Specifying Context | p. 207 |
Essential Functions | p. 210 |
The Parts of a Function | p. 210 |
Text Operations | p. 212 |
Nested Functions | p. 215 |
Number Functions | p. 216 |
Character Functions | p. 218 |
Working with Dates and Times | p. 218 |
Using Conditional Functions | p. 220 |
Aggregate Functions | p. 221 |
Learning About the Environment | p. 222 |
Get Function | p. 222 |
Design Functions | p. 224 |
Troubleshooting | p. 225 |
FileMaker Extra: Tips for Becoming a Calculation Master | p. 226 |
Getting Started with Scripting | p. 229 |
Scripts in FileMaker Pro | p. 229 |
Creating Scripts | p. 230 |
The Scripting Interface | p. 232 |
Script Editing | p. 233 |
Full Access Privileges | p. 234 |
Commenting Scripts | p. 235 |
Exiting a Script | p. 236 |
Using a Script Template | p. 236 |
Using Subscripts | p. 237 |
Importing Scripts | p. 238 |
Managing the Scripts Menu | p. 238 |
Common Scripting Topics | p. 239 |
Error Management | p. 239 |
Setting and Controlling Data | p. 241 |
Providing User Navigation | p. 243 |
Saved Script Options | p. 244 |
Using Conditional Logic | p. 247 |
Using Loops | p. 248 |
Working with Custom Dialogs | p. 250 |
Starting and Triggering Scripts | p. 251 |
Starting Scripts | p. 251 |
Triggering Scripts | p. 252 |
Working with Buttons on Layouts | p. 252 |
Troubleshooting | p. 253 |
FileMaker Extra: Creating a Script Library | p. 255 |
Getting Started with Reporting | p. 257 |
Reporting in FileMaker Pro 10 | p. 257 |
Deriving Meaning from Data | p. 257 |
Begin with the End in Mind | p. 258 |
Determine Report Requirements | p. 258 |
Generic Versus Specific Report Structures | p. 259 |
Working with Reports, Layouts, View As Options, and Modes | p. 260 |
Working with Lists of Data | p. 262 |
Using the New Layout/Report Wizard | p. 262 |
Using Summarized Reports | p. 265 |
Working with Subsummary Parts | p. 266 |
Calculations Involving Summary Fields | p. 268 |
Using Dynamic Reports | p. 270 |
Maintaining Sort Order | p. 270 |
Modifying Table Views | p. 271 |
Working with Dynamic Reports | p. 272 |
Customizing Layouts and Reports | p. 274 |
Alternating Row Color | p. 274 |
Sorting by Columns | p. 276 |
Sliding Objects | p. 277 |
Delivering Reports | p. 278 |
Save/Send as PDF | p. 278 |
Save/Send as Excel | p. 280 |
Send Mail | p. 281 |
Troubleshooting | p. 282 |
FileMaker Extra: Incorporating Reports into the Workflow | p. 283 |
Developing for Multiuser Deployment | p. 285 |
Developing for Multiple Users | p. 285 |
Sessions in FileMaker Pro | p. 285 |
Session-Specific Elements | p. 286 |
Global Behavior | p. 287 |
User Accounts and Session Data | p. 287 |
Concurrency | p. 288 |
The ACID Test | p. 288 |
Script Log | p. 290 |
Commit Versus Create and Serial IDs | p. 290 |
Record Locking | p. 291 |
Multicontext Locking Within Scripts | p. 293 |
Launch Files | p. 293 |
Troubleshooting | p. 294 |
FileMaker Extra: Development with a Team | p. 295 |
Implementing Security | p. 297 |
Approaching Security | p. 297 |
Identifying Risks | p. 298 |
Planning Security | p. 299 |
Maintaining Security | p. 302 |
User-Level Internal Security | p. 303 |
User Accounts | p. 303 |
Privilege Sets | p. 306 |
Extended Privileges | p. 314 |
File-Level Access Security | p. 316 |
Server Administration Security | p. 316 |
Security over the Network | p. 317 |
User Authentication | p. 318 |
External Authentication | p. 319 |
File List Filtering | p. 321 |
Troubleshooting | p. 321 |
FileMaker Extra: Working with Multiple Files | p. 322 |
Using the Web Viewer | p. 325 |
Introducing the Web Viewer | p. 325 |
Adding a Web Viewer to Contact Management | p. 325 |
Setting Web Viewer Options | p. 328 |
Setting Up a Web Viewer with the Templates | p. 329 |
Controlling the Web Viewer with the Set Web Viewer Script Step | p. 330 |
GetLayoutObjectAttribute with Web Viewer | p. 331 |
FileMaker Extra: Using the Web Viewer for Files | p. 332 |
Advanced Interface Techniques | p. 335 |
User Interfaces in FileMaker Pro | p. 335 |
FileMaker's Native User Interface | p. 336 |
Building Your Own Interface | p. 336 |
A Happy Medium | p. 337 |
Interface Look and Feel | p. 338 |
Single File Interface Versus Distributed Interface | p. 339 |
Working with Custom Menus | p. 340 |
Menu Sets Interface | p. 342 |
Customizing a Menu | p. 344 |
Loading and Activating Menu Sets | p. 346 |
Creating a New Menu from Scratch | p. 347 |
Conditional Formatting | p. 348 |
FileMaker Extra: User Interface Heuristics | p. 349 |
Advanced Calculation Techniques | p. 351 |
What's an Advanced Calculation Technique? | p. 351 |
Logical Functions | p. 351 |
The Let Function | p. 351 |
The Choose Function | p. 354 |
The GetField Function | p. 356 |
The Evaluate Function | p. 356 |
The Lookup Functions | p. 359 |
Text Formatting Functions | p. 362 |
Text Color, Font, and Size | p. 363 |
Text Style | p. 363 |
Removing Text Formatting | p. 364 |
Array Functions | p. 364 |
Working with Return-Delimited Data Arrays | p. 365 |
Stepping Through an Array | p. 366 |
The "Filter"-ing Functions | p. 367 |
The Filter Function | p. 367 |
The FilterValues Function | p. 369 |
Custom Functions | p. 370 |
Uses of Custom Functions | p. 371 |
Creating Custom Functions | p. 373 |
Examples of Custom Functions | p. 375 |
GetNthRecord | p. 380 |
Troubleshooting | p. 382 |
FileMaker Extra: Creating a Custom Function Library | p. 384 |
Matching Multiple Values | p. 384 |
Advanced Scripting Techniques | p. 387 |
What Is Advanced Scripting? | p. 387 |
Script Parameters and Script Results | p. 387 |
Script Parameters | p. 388 |
Specifying Script Parameters | p. 388 |
Retrieving a Script Parameter | p. 389 |
Passing Multivalued Parameters | p. 390 |
Strategies for Using Script Parameters | p. 393 |
Script Results | p. 394 |
Final Thoughts on Script Input/Output | p. 396 |
Script Variables | p. 396 |
About Local Variables | p. 397 |
About Global Variables | p. 399 |
Other Ways to Work with Variables | p. 400 |
About Dynamic File Paths | p. 400 |
Viewing Your Variables | p. 401 |
FileMaker Extra: Recursive Scripts | p. 401 |
Working with FileMaker Triggers | p. 403 |
Introducing FileMaker Triggers | p. 403 |
FileMaker Triggers Before FileMaker Pro 10 | p. 403 |
Triggers in FileMaker Pro 10 | p. 404 |
Trigger Targets | p. 404 |
Trigger Events | p. 405 |
Triggers and Underlying Data | p. 406 |
Triggers and Web Publishing | p. 406 |
Layout Triggers | p. 406 |
Object Triggers | p. 407 |
Using a Timer | p. 408 |
Trigger Functions | p. 409 |
The Self Function | p. 409 |
Char and Code Functions | p. 410 |
GetFieldName Function | p. 410 |
Get (TriggerKeystroke) and Get (TriggerModifierKeys) Functions | p. 410 |
FileMaker Extra: Using Triggers for an Interactive Interface | p. 411 |
Advanced FileMaker Solution Architecture | p. 413 |
Window Management Techniques | p. 413 |
Multiwindow Interfaces | p. 414 |
Tool and Function Palettes | p. 415 |
Rich Dialog Windows | p. 416 |
Go to Related Record | p. 420 |
GTRR Basics | p. 421 |
Predicting the Found Set | p. 422 |
Jumping to Disconnected Table Occurrences | p. 422 |
Dedicated Find Layouts | p. 423 |
Dedicated Find Mode Layouts | p. 423 |
Script-Driven Finds | p. 424 |
Troubleshooting | p. 424 |
Debugging and Troubleshooting | p. 427 |
What Is Troubleshooting? | p. 427 |
Staying Out of Trouble | p. 427 |
Understand Software Requirements | p. 427 |
Avoid Unclear Code | p. 428 |
Planning for Trouble | p. 431 |
Troubleshooting Scripts and Calculations | p. 432 |
Handling Errors in Scripts | p. 432 |
Tracking Down Errors | p. 434 |
Troubleshooting in Specific Areas: Performance, Context, Connectivity, and Globals | p. 435 |
Performance | p. 435 |
Connectivity and Related Issues | p. 438 |
Context Dependencies | p. 439 |
Globals | p. 442 |
File Maintenance and Recovery | p. 443 |
File Maintenance | p. 446 |
Using the Database Design Report | p. 446 |
Creating a DDR | p. 447 |
Using the Script Debugger | p. 448 |
About the Script Debugger | p. 449 |
Placing Breakpoints | p. 450 |
Using the Data Viewer | p. 451 |
Converting Systems from Previous Versions of FileMaker Pro | p. 453 |
Migration Choices | p. 453 |
Converting Files | p. 454 |
Converting Single-File Solutions | p. 455 |
Converting Relational Solutions | p. 456 |
Preconversion Tasks | p. 457 |
Document Your Solution | p. 457 |
Fix File References and External Data Sources | p. 458 |
Do Some Housekeeping | p. 460 |
Post-Conversion Tasks | p. 460 |
Security | p. 461 |
Relationships | p. 462 |
Scripts | p. 463 |
Fields and Formulas | p. 465 |
Layouts | p. 468 |
Triggers | p. 468 |
Troubleshooting | p. 468 |
FileMaker Extra: Converting Web-Enabled Databases | p. 469 |
Instant Web Publishing | p. 469 |
Custom Web Publishing with CDML | p. 470 |
Connecting to External SQL Data Sources | p. 471 |
ODBC Basics | p. 471 |
SQL | p. 471 |
FileMaker Architecture | p. 471 |
ODBC Architecture | p. 472 |
Setting Up FileMaker Databases for ODBC | p. 473 |
Setting Up and Administering ODBC | p. 473 |
Installing Drivers | p. 474 |
Administering ODBC | p. 476 |
Example: Setting Up a DSN on Mac OS X to Connect to MySQL | p. 479 |
Example: Setting Up a DSN on Windows to Connect to FileMaker | p. 483 |
Importing ODBC Data into FileMaker | p. 484 |
Using External ODBC Data Sources with the Relationships Graph | p. 485 |
Specifying the Data Source | p. 485 |
Adding the External Data Source to the Relationships Graph | p. 486 |
Using Supplemental Fields | p. 489 |
Troubleshooting | p. 492 |
Importing Data into FileMaker Pro | p. 493 |
Working with External Data | p. 493 |
Flat-File Data Sources | p. 493 |
Choosing the Target Table | p. 494 |
Initiating the Import | p. 494 |
The Import Field Mapping Dialog | p. 494 |
Updating Records with Imported Data | p. 497 |
Importing from Another FileMaker Pro File | p. 498 |
Using an Import to Create a New Table | p. 499 |
Importing from a Microsoft Excel File | p. 500 |
Setting Import Options and Reviewing Status | p. 500 |
Importing Multiple Files from a Folder | p. 501 |
Importing Text Files | p. 502 |
Importing Image Files | p. 503 |
Importing Photos from a Digital Camera | p. 505 |
Using a Script to Import Data | p. 506 |
Using Bento Data Sources | p. 508 |
Troubleshooting | p. 508 |
FileMaker Extra: Exploiting the FileMaker-to-FileMaker Import | p. 509 |
Duplicating a Found Set | p. 510 |
Duplicating Between Tables | p. 510 |
Moving, Consolidating, and Re-creating Tables | p. 510 |
Exporting Data from FileMaker | p. 511 |
Getting Out What You Put In | p. 511 |
The Basic Mechanics of Exporting | p. 512 |
Choosing a Source Table | p. 512 |
Choosing an Output File Format | p. 512 |
Selecting Fields to Export | p. 512 |
Exporting Issues to Consider | p. 513 |
Export File Formats | p. 514 |
Character Transformations | p. 514 |
Formatting Exported Data | p. 516 |
Exporting Related Fields | p. 516 |
Exporting Grouped Data | p. 517 |
Exporting to Fixed-Width Formats | p. 517 |
Working with Large Fields and Container Fields | p. 518 |
Scripted Exports | p. 519 |
Instant Web Publishing | p. 521 |
An Overview of Instant Web Publishing | p. 521 |
What Is IWP? | p. 521 |
Getting Started with IWP | p. 523 |
Enabling and Configuring IWP | p. 524 |
Configuring FileMaker Pro for IWP | p. 524 |
Configuring FileMaker Server Advanced for IWP | p. 527 |
Sharing and Securing Files via IWP | p. 529 |
Designing for IWP Deployment | p. 532 |
Constraints of IWP | p. 532 |
Scripting for IWP | p. 533 |
Layout Design | p. 535 |
Container Fields | p. 537 |
Application Flow | p. 538 |
Using an IWP Solution | p. 542 |
Browse Mode | p. 542 |
Edit Mode | p. 543 |
Find Mode | p. 543 |
Sorting Records | p. 544 |
Troubleshooting | p. 544 |
Custom Web Publishing with XML/XSLT | p. 545 |
About Custom Web Publishing | p. 545 |
Custom Web Publishing Versus Instant Web Publishing | p. 546 |
Preparing for Custom Web Publishing | p. 547 |
Getting Your Databases Ready for CWP | p. 548 |
Getting FileMaker Server Ready for Custom Web Publishing | p. 549 |
Publishing FileMaker Data as XML | p. 549 |
Preparing for XML Publishing | p. 549 |
Introduction to XML Publishing | p. 550 |
Understanding Query Strings | p. 552 |
Performing Specific Searches with CWP URLs | p. 553 |
Applications of Custom Web Publishing with XML | p. 557 |
About Server-Side XSLT | p. 558 |
Preparing for XSLT Publishing | p. 558 |
Using the XSLT Site Assistant | p. 559 |
Build the Site with the Site Assistant | p. 559 |
Explore the Generated Site | p. 562 |
Basic Cleanups | p. 564 |
Writing Your Own XSLT Code | p. 565 |
Format of the XSLT URL | p. 566 |
Embedding Query Parameters in a Stylesheet | p. 566 |
Using Tokens to Share Data Between Stylesheets | p. 567 |
Other Custom Web Publishing Commands and Parameters | p. 568 |
Other Query Commands | p. 568 |
Other Query Parameters | p. 569 |
About the FileMaker XSLT Extensions | p. 571 |
About Sessions | p. 572 |
Troubleshooting | p. 573 |
FileMaker Extra: An XML Interface File | p. 574 |
Custom Web Publishing with PHP | p. 575 |
Choosing a Custom Web Publishing Technology | p. 575 |
Preparing for Custom Web Publishing with PHP | p. 576 |
Getting Your Databases Ready for Custom Web Publishing with PHP | p. 576 |
Getting FileMaker Server Ready for Custom Web Publishing with PHP | p. 577 |
Placing Files on the Web Server | p. 578 |
Using the PHP Site Assistant | p. 578 |
Building the Site with the PHP Site Assistant | p. 579 |
Troubleshooting | p. 586 |
Deploying and Extending FileMaker | p. 587 |
FileMaker Deployment Options | p. 587 |
Renaming Files | p. 587 |
Runtime Solutions | p. 589 |
Solution Options | p. 590 |
Removing Admin Access | p. 593 |
Polishing Your Custom Solution | p. 594 |
Error Log | p. 594 |
Developing Kiosk Solutions | p. 595 |
Preparing a Kiosk Interface | p. 595 |
Maintaing a Kiosk Solution | p. 596 |
Plug-ins | p. 596 |
Understanding Plug-ins | p. 597 |
Using FileMaker's Sample Plug-in | p. 598 |
Installing Plug-ins | p. 598 |
Deploying Plug-ins via FileMaker Server | p. 599 |
Configuring and Enabling Plug-ins | p. 599 |
Troubleshooting | p. 600 |
FileMaker Server and Server Advanced | p. 601 |
About FileMaker Server | p. 601 |
The FileMaker Server Product Line | p. 601 |
FileMaker Server Versus Peer-to-Peer Database Hosting 602 | |
FileMaker Server Capabilities | p. 603 |
FileMaker Server Requirements | p. 604 |
Installing and Deploying FileMaker Server | p. 607 |
The Installation Process | p. 608 |
The Deployment Process | p. 611 |
Running FileMaker Server | p. 616 |
Starting and Stopping FileMaker Server | p. 616 |
Hosting Databases | p. 616 |
Using Admin Console | p. 617 |
FileMaker Server Overview | p. 617 |
Administration | p. 618 |
Configuration | p. 623 |
Automatically Updating Plug-ins | p. 626 |
Preparing FileMaker Server | p. 626 |
Preparing FileMaker Pro | p. 628 |
Performing the Auto Update | p. 628 |
Putting It All Together | p. 632 |
FileMaker Extra: Best Practices Checklist | p. 633 |
Determine Network Infrastructure | p. 633 |
Purchase Hardware | p. 633 |
Install Software | p. 633 |
Configure FileMaker Server | p. 634 |
Deploy Databases and Schedule Backups | p. 634 |
Monitor Usage Statistics | p. 634 |
Recheck Performance | p. 635 |
Stay on Top of Java | p. 635 |
Monitor Log Viewer | p. 635 |
Keep Current with Software Updates | p. 635 |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.