User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Displaying data in charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Index
140 FileMaker Pro User’s Guide
You can convert a single file or convert multiple files at once:
1 Use the single-file conversion method for standalone database files that don’t display related data from
other files. For more information, see Help.
1 Use the multi-file conversion method to convert all the files in a relational database. For more
information, see Help.
Solving basic conversion problems
Here are some suggestions for correcting problems that could occur during conversion.
My file didn’t convert properly
1 If you are converting a copy of a file, make sure that the original file was closed before you copied it. Otherwise,
the copy will not convert correctly.
1 Check the Conversion.log file located in the folder with the database you are attempting to convert. For more
information, see Help.
1 Try recovering the file first, using a previous version of FileMaker Pro and then convert the file again.
I received a consistency check or auto-repair message when I opened my original file using my previous version
of FileMaker
Pro
Try recovering the original file using your previous version of FileMaker Pro. Then open the recovered file using the
same version of FileMaker
Pro, close the file, and then try converting it with FileMaker Pro 11.
Converting passwords
During conversion, passwords are converted into accounts in FileMaker Pro 11. There are two common
password conversion issues:
1 For each converted account, both the account name and the password in the converted file are initially set
to the password from the original file, which makes all passwords visible to anyone who has Full Access
privileges. For security reasons, you should either change each account name so that it no longer matches
its password, or change each password so that it no longer matches its account name. (You could also set
an option for each account to require a password change by the user upon the next login.)
1 Passwords are case-sensitive in FileMaker Pro versions 7, 8.x, 9, 10, and 11. Make sure you enter your
password exactly as it was created in a previous version of FileMaker
Pro. If you are the owner of the
original file or the database administrator, open the original file using a previous version of
FileMaker
Pro and look at the password in the Define Passwords dialog box. If you are not the owner of
the file or the database administrator, consult your database administrator for password information.
Application support changes in FileMaker Pro 11
If you have been using an earlier version of FileMaker Pro, please note the following information about
FileMaker
Pro 11 support for QuickTime and (Mac OS only) third-party plug-in applications.