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