User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
Creating scripts to automate tasks
10-11
Importing scripts
FileMaker Pro allows you to import scripts from other
FileMaker Pro databases.
Many scripts reference fields (local and related), layouts, records,
and other scripts (local and in external files). In addition, some script
steps, such as Set Field, Insert Calculated Result, Replace, etc., may
have field references embedded in calculations. While these
references may be valid in the original file, it is possible that they will
be invalid in the file into which they are being imported.
To minimize the loss of information, FileMaker Pro attempts to map
field, relationships, scripts, and layout references based on their
names. Fields, relationships, scripts and layouts that cannot be
mapped are marked as unknown, and should be edited and corrected
before the script is performed.
When you import a script, you might need to edit the script to make
sure that all references are valid and appear as intended. Always
review your imported script prior to performing it for the first time.
To import a script
1. Open the file into which the script will be imported.
2. Choose Scripts menu > ScriptMaker.
3. Click the Import button.
4. Open the file that contains the script(s) you want to import.
5. In the Import Scripts dialog box, place a check mark next to the
script(s) you want to import.
6. Click OK, then click OK again.
Keep these points in mind:
1 During script import, the match for field and layout names is case
sensitive. If no match can be found, the word <unknown> will appear
in place of the missing field and/or layout name.
1 When importing a script that references a relationship,
FileMaker Pro assumes that
1 the names of the relationships are the same
1 the keys of the relationships are the same
1 the base fields’ names, types and keys are the same
If all of these conditions are not met, the unmatched items will have
the word <unknown> appended to them within the script.
1 When importing script steps that contain calculations (for
example, If, Set Field, and Insert Calculated Result), FileMaker Pro
matches field name and field type. If a match is not found, the word
<unknown> will appear in place of the missing field.
1 Information stored in scripts (for example, Find requests, Sort
order, Import field order, and Export field order) will attempt to be
mapped to original fields using the above rules. If no original
matching field can be found, the unmapped fields will be replaced
with the word <unknown>.
1 When importing scripts that contain the Perform Script step, the
link between scripts will be retained only if the linked scripts are
imported at the same time. If a script with the same name is already
present in the target file, no attempt will be made to link between the
two scripts. If the Perform Script step references an external script,
the imported script will also reference the external script.
Listing scripts in the Scripts menu
FileMaker Pro lists scripts in the Script menu and assigns keyboard
shortcuts, like Ctrl+1 (Windows) or Command+1 (Mac OS), to the
first ten scripts.
To change the order of scripts in the Scripts menu:
1. Choose Scripts menu > ScriptMaker.
2. In the Define Scripts dialog box, drag the double arrow to the left
of the script name to a new position.