Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 525
10. In the Import Records Summary dialog box, note the number of imported records and any
data that was skipped. Then click OK.
The Import Records Summary dialog box displays three statistics detailing the imported records
and any skipped data:
Notes
• If you’re importing a large amount of data, you may see an Importing dialog box that shows
the progress of the import process. To stop importing, click Stop. Records that were already
Specify how to import data
from repeating fields in the
source file
Select:
• Keeping them in the original record to maintain the field(s) as
repeating fields.
• Splitting them into separate records to import each repeating
value into a separate record. (Use this option to work with
individual values in repeating fields, such as to sort or
summarize them.)
Note When you split repeating field data into separate records
any non-repeating fields that you import are duplicated in each
separate record. For example, if a record in the source file has
values in three repetitions, splitting them into separate records
imports three records, each identical except for the values in the
repeating fields.
To Do this
Statistic Description
Total records
added/updated
The total number of records added and updated in the target file during the
import process.
Note This number will include multiple updates of the same record if you’re
updating matching records and more than one record in the source file matches
a record in the found set of the target file. See the Notes section in
Methods of
importing data into an existing file.
Total records
skipped due to
errors
The number of records in the target file that were skipped due to:
• Privilege errors: Access privileges prohibit modifying one or more records.
• Locked records: One or more records cannot be modified because they are
being accessed elsewhere, either in another window by the same user or (if
the file is shared) by other
clients.
• Validation errors: One or more records cannot be modified because record-
level field validation requirements are not met, and the record could not be
committed. See
About validating data during import.
Total fields skipped
due to errors
The number of fields in the target file that were skipped due to:
• Validation errors: One or more fields cannot be imported because the data
does not match the validation requirements defined for the field. See
About
validating data during import.
• Privilege errors: Access privileges prohibit modifying one or more fields.
Skipped fields do not prevent the updating of other fields in the same record.