How to: |
When uploading data from a delimited or Excel file, a format conversion error can occur, such as when a numeric field contains a non-numeric value. You have load options to control how to process rows that contain format errors, and to control how many format errors are allowed before processing stops.
The following conversion error load options are available when uploading files:
You can select options Reject or Ignore. Reject, the default value, skips rows with incorrect data, and gives a warning message. Ignore replaces the values causing errors with default values, and continues processing the records.
You can enter values of 0 to 999999. This sets a limit for the number of records allowed with warnings about data conversion errors. 0 is the default value, which allows unlimited warning messages.
These load options are available when uploading files in the Simple Mode or the Advanced Mode.
The Uploading Data page opens, as shown in the following image.
The More File Options dialog box opens. Under Source Load Options, the conversion error options display, as shown in the following image.
You can select Accept or Ignore from the Conversion error processing dropdown menu. You can also enter a value in the Conversion error limit field.
The Uploading Data page opens, as shown in the following image.
The Load Options dialog box opens. Under Source Load Options, the conversion error options display, as shown in the following image.
You can select Accept or Ignore from the Conversion error processing dropdown menu. You can also enter a value in the Conversion error limit field.