3.4.3. Field Mappings

3.4.3. Field Mappings
	3.4. Atlas Settings for Import

3.4.3. Field Mappings

The Field Mappings area is where the individual data points in the map are specified. If you want to customize the data you are importing, you will need to make changes to the field mappings. Each row in the field mappings represents a single field in the destination table―or API view―you are importing into. The various components of the map are described below:

Key Field

Specifies if this field should be treated as a key field for the purpose of update and append maps. (Note: This feature is not currently implemented.)

Field

Name of the field on the destination table in the database.

Type

The type of data for the field.

Required

Indicates if this field is required in the database schema. Sometimes the default value in these fields is sufficient to meet the database requirements, while other times the default value is not sufficient.

Use Value

These options indicate what value should be used for this field:

Default: The default value according to the database schema is used.
Use Column: The column specified in the Column # field is to be used.
Use Empty String: An empty string is to be used for this field.
Use Alternative Value: The value from the alt. value is to be used.
Use Null: Uses a "NULL" value.

Column #

The column # specified is to be used from the CSV file.

If Col. Null

If the value read from Column # results in a "NULL" value, then you can provide additional processing using one of the following criteria:

Do Nothing: Use the "NULL" value.
Use Default: Use the default value according to the database schema.
Use Empty String: Use an empty string.
Use Alternative Value: Use the value specified in alt. value.
Use Alternate Column: Use the value specified in alt. column #.

Alt Column #

The column # specified is to be used from the CSV file if the first column was "NULL" and the If Col. Null action was Use Alt. Column.

Alt. if Null

If the value read from the Alt. Column # results in a "NULL" value, then you can provide additional processing using one of the following criteria:

Do Nothing: Use the "NULL" value.
Use Default: Use the default value according to the database schema.
Use Empty String: Use an empty string.
Use Alternative Value: Use the value specified in alt. value.

Alt Value

This is any text you want to be passed to the field if the option Use Alternate Value is specified.


3.4.2. Pre and Post Processing		3.5. Importing Files

xTuple Wholesale Distribution Product Guide

3.4.3. Field Mappings