Bulk Import Setup Category

The table below lists the profile options that are used for bulk import setup.

Bulk Import Setup Category

Profile Option Default User Access System Administration: Site System Administration: Application System Administration: Responsibility System Administration: User
HZ: Allow Import of Records with Disabled Lookups Yes Update Update View Only View Only View Only
HZ: Character Value to Indicate NULL During Import ! Update Update View Only View Only View Only
HZ: Date Value (DD-MM-YYYY) to Indicate NULL During Import 01-01- 4000 Update Update View Only View Only View Only
HZ: Numeric Value to Indicate NULL During Import -9999 Update Update View Only View Only View Only
HZ: Validate Flexfields During Import No Update Update View Only View Only View Only

HZ: Allow Import of Records with Disabled Lookups

Specify whether or not data that reference disabled lookups are allowed to be imported in the TCA Registry. Normally, data can be loaded only if validated against enabled lookups.

HZ: Character Value to Indicate NULL During Import

Specify a value that will overwrite the TCA column value with NULL. For example, if the profile option is set to !, and the column in the TCA table currently has @, then if you want to update the column with a null value, then you must pass "!" for that column in the interface table.

If an interface table column is null, the corresponding TCA column, whether empty or not, is not affected.

This profile is used in the Update mode of the Customer Interface program and during Bulk Import.

HZ: Date Value (DD-MM-YYYY) to Indicate NULL During Import

Specify a value that will overwrite the TCA column value with NULL. For example, if the profile option is set to 01-01-4000, and the column in the TCA table currently has an end date of 02-02-2005, then if you want to update the column with a null value, then you must pass 01-01-4000 for that column in the interface table.

If an interface table column is null, the corresponding TCA column, whether empty or not, is not affected.

This profile is used in the Update mode of the Customer Interface program and during Bulk Import.

HZ: Numeric Value to Indicate NULL During Import

Specify a value that will overwrite the TCA column value with NULL. For example, if the profile option is set to 9999, and the column in the TCA table currently has 1234, then if you want to update the column with a null value, then you must pass 9999 for that column in the interface table.

If an interface table column is null, the corresponding TCA column, whether empty or not, is not affected.

This profile is used in the Update mode of the Customer Interface program and during Bulk Import.

HZ: Validate Flexfields During Import

Specify whether or not flexfields are validated during the import process. These tables have flexfields: