The Tools images/U2192.jpg border=0> Developer Utilities command looks so insignificant and benign to the unsuspecting person, but behind it lurks a vast array of powerful features. There are developer utilities for all of the following techniques:
In fact, you can (and often want to) do several of these things at once. Here's an example: You build a beautiful interactive product catalog, complete with pictures and an easy-to-use ordering screen. You then want to set up a kiosk computer at a trade show where attendees can use the database to see what you have and place their orders. Using the developer utilities, you could do all this:
19.7.1. Using the Developer Utilities
The most confusing thing about the developer utilities is that you have to close your files before you work with themjust the opposite of every other command in FileMaker. So close the files you want to modify, and then choose File images/U2192.jpg border=0> Developer Utilities. You behold the Developer Utilities dialog box (Figure 19-14).
In the Developer Utilities window, you first choose which files you want to work with. Click Add to put a file on the list. In Mac OS X, you can select several files at once in the Open File dialog box using your Shift and keystrokes. Alas, in Windows, you have to pick just one file, and then click Add again to add the next one. Keep on adding until every file you want to change is in the list. If you accidentally add the wrong file, select it and click Remove.
You have to pick one file to be your main file. This file is the one that opens first if you create a runtime solution, for example. To set the main file, just double-click it in the list. FileMaker shows a red squareit looks surprisingly like a script break-pointby the main file.
126.96.36.199. Renaming files
Of course, you can always rename a file in Window Explorer or the Mac's Finder. But those interfaces let you change only the file name. Developer Utilities makes that look like child's play. When it changes a file name, it also looks inside the file and updates any internal file references to match the file's new name. If you've ever tried to open two versions of a multiple file solution at the same time (to test some scripts that delete data and on a copy of the files, say), you know that FileMaker sometimes gets confused and keeps multiple copies open even after you try to close one set. You can eliminate the crossover problem by renaming one set in Developer Utilities. You can test your scripts without a problem, since the scripts in the copy files automatically inherit the correct new file names.
To rename a file or set of files, add them to the Solution File list (Figure 19-14). Select a file, type the new name in the "Rename file" box, and then click Change. FileMaker shows the new name in the New Name column.
Next, you need to pick the project folder. This folder is the one where FileMaker saves the finished files. Just click the Specify button under "Project Folder" and pick any folder you wish. If the folder already contains files with the same names as the ones you're about to create, you get an error messageunless you turn on "Overwrite matching files within the Project Folder." When you click Create, FileMaker Advanced makes copies of the files with their new names, leaving the originals untouched.
To complete the example above (your kiosk product catalog), you would turn on "Create Runtime solution application(s)," "Remove admin access from files permanently," and "Enable Kiosk mode for non-admin accounts." Only the first option needs to be configured.
188.8.131.52. Create Runtime Solution application(s)
To create Runtime Solutions, add the files to the Solution Files list, and then select a project folder, just as you did above. Don't type a new name for the Runtime in this window, though. Click the Specify button under Solution Options. You see the Specify Solution Options dialog box, as shown in Figure 19-15.
When you tell FileMaker you want to build a runtime solution, it generates a special program that you need to include with your databases. This program can do most of what FileMaker Pro can do, but it can't modify tables, fields, layouts, or scripts. You get to decide what this program is calledjust type it in the Runtime Name box. Along with the runtime program, FileMaker creates new copies of each of your files to go with it, and changes all the file name extensions to something other than .fp7. Tell FileMaker what extension to use in the Extension field.
Warning: Your computer's operating system uses file name extensions to figure out which program files belong to. The Developer Utilities let you assign any extension you want, but you should avoid common extensions like .doc, .jpg, .mp3, and so on. You know computersthey get confused easily.
The new files don't just have a new name; they are also modified internally so they're bound to the runtime program, and the runtime program in turn can open only properly bound files. In other words, when you send people a runtime program, they can't use it to open any old FileMaker Pro file.
To facilitate the binding process, FileMaker asks you to provide a bindkey. FileMaker stores this value in both the runtime program and any database files in the Developer Utilities window. The value you use for the bindkey is entirely unimportant, and there's no need to keep it secret. But if you later want to bind new databases to the same runtime program, you'll have to use the same bindkey.
Finally, when users exit the runtime program (in other words, when they close your database system), they see a "Made with FileMaker" splash screen. Normally, this screen looks like the one in Figure 19-16. You can also control how long the splash screen shows by putting the number of seconds in the Delay box. Unfortunately, you can't make it go away entirely.
184.108.40.206. Remove admin access from files permanently
The "Remove admin access from files permanently" option doesn't actually remove the accounts that have full access. Instead, it modifies the [Full Access] privilege set so that it no longer truly has full access. If you log in with an account that normally has full access, it doesn't have access to the Define Database window, Layout mode, or ScriptMaker, and its access to Accounts & Privileges is limited to the Extended Privileges tab. This option has no settings.
220.127.116.11. Enable Kiosk mode for non-admin accounts
If you turn on Kiosk mode and then open the new file using an account that has full access, you don't see any changes. But if you log in with a lesser account, everything changes. The screen goes completely black, except for the content area of your database window. You can see an example in Figure 19-17.
When you use Kiosk mode, you typically hide the status area and let people control everything from buttons on layouts. Alternatively, you can use custom menus (Section 19.5.3) to hide all the menus and commands that would let nosy people poke around in your file. Remember to troubleshoot your file before creating a custom runtime from it, because any problems in your file (broken links, missing data, bad scripts) also show up in the runtime. But once you've suppressed all the normal FileMaker commands, folks have no way of getting around these problems.
18.104.22.168. Databases must have a FileMaker file extension
Sometimes people, Mac types especially, create databases without the .fp7 file extension, only to regret that decision later. An extension is computers' most accurate way to identify a file. So turn on "Database must have a FileMaker file extension," and FileMaker adds ".fp7" to the end of every file name that doesn't already have it.
22.214.171.124. Create error log for any processing errors
While FileMaker processes your files, applying your options, building runtime programs, or renaming files, it might encounter problems. Turn on "Create error log for any processing errors" so you can see what went wrong. FileMaker saves error messages in a file on your hard drive (you get to pick where it goes and what it's called).
126.96.36.199. Loading and saving settings
If you maintain a database system that other people use, you may well run your files through developer utilities every time you send out a new version. To save you the tedium of configuring the Database Utilities dialog box again and again, FileMaker lets you save all your settings to a special filejust click Save Settings. Later, when you're ready to process your files again, click Load Settings and select the same file. FileMaker sets up everything in the dialog box for you. All you have to do is click Create.
19.7.2. Delivering a Runtime Solution
If you build a runtime solution with FileMaker Advanced in Mac OS X, it runs only in Mac OS X. Likewise, if you build from Windows, your runtime solution is limited to Windows. If you need a runtime solution for both platforms, you must buy FileMaker Advanced for Mac OS X and for Windows and build a separate runtime solution on each kind of computer.
Part I: Introduction to FileMaker Pro
Your First Database
Organizing and Editing Records
Building a New Database
Part II: Layout Basics
Advanced Layouts and Reports
Part III: Multiple Tables and Relationships
Multiple Tables and Relationships
Advanced Relationship Techniques
Part IV: Calculations
Introduction to Calculations
Calculations and Data Types
Part V: Scripting
Part VI: Security and Integration
Exporting and Importing
Sharing Your Database
Part VII: Appendixes
Appendix A. Getting Help