Importing data into a form involves loading a data file and a target form, defining preferences for the import, and mapping data.
To import data into a form, you must have Change permissions for the fields to which you want to import data. For system fields such as Create-date, you must be the administrator or sub-administrator of the form.
To import data
- In Data Import, create or open a mapping file.
- Choose Import > Start Import.
If errors occur, the type of messages you receive depends on what you enter in the Bad Records field, as described in Defining Data Import preferences.
After the import ends, a results message appears and the import log is updated. You can use your imported data.
Stopping an import
You can stop an import before it ends. You are prompted to copy unprocessed records to the log. There must be enough disk space in the import log partition to copy the records.
If you are importing an empty value using the Data Import Tool, the value is persisted as a null value instead of an empty value. For more information, see SQL database considerations.