User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 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
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- 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
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- 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 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 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
- 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
- Publishing databases on the web
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
106 FileMaker Pro User’s Guide
In most cases, you can correct problems in converted files. If the log
file indicates that there is a problem that would be complicated and
time-consuming to fix after conversion, you may want to try
correcting the problem in the original file using a previous version of
FileMaker
Pro, and then convert the file again.
Important The Conversion.log file may not indicate every item in the
file that needs to be corrected. Before you begin using a converted
database solution, you should test it thoroughly to make sure every
aspect has converted successfully. For example, make sure every
script works as you expect, and that accounts and privilege sets
provide the required file security.
Solving basic conversion problems
Here are some suggestions for correcting problems that could occur
during conversion.
FileMaker Pro 8 can’t open my file
FileMaker Pro 8 can’t convert databases that were created with
FileMaker
Pro 1.x or 2.x. For more information, see the next section,
“Converting FileMaker Pro 1.x and 2.x databases.”
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 the
previous section,
“Reading the Conversion.log file.”
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 8.
The converted file won’t accept my password
Passwords are case-sensitive in FileMaker Pro 8. 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. For more information, see
“Passwords” in the next
section.
Converting FileMaker Pro 1.x
and 2.x databases
FileMaker Pro 8 cannot convert databases created with
FileMaker
Pro 1.x or 2.x. To use these files with FileMaker Pro 8, you
must convert them using FileMaker
Pro 3.x, 4.x, 5.x, or 6.x, and then
convert them again using FileMaker
Pro 8.
Note Pre-7.0 versions of FileMaker Pro for Windows can convert
only 2.x files. If you need to convert a 1.x file, convert the file on a
Mac
OS computer using FileMaker Pro 3.x, 4.x, 5.x or 6.x.
If you don’t have a pre-7.0 version of FileMaker Pro with which to do
the conversion, you can download a trial version of FileMaker
Pro 6
from www.filemaker.com and use it to convert files.