Job Step ImportKeyValueMapping

Import or delete a key/value mapping in the Generic Mapping high-performance data store.

Key/value mappings are exposed through Script API class dw.util.MappingMgr. See Generic Mapping

Execution Context:

Organization

Parallel Execution:

Not Supported

Always execute on restart:

Supported

Input Parameters

AfterImportFileHandling : String Required

What to do with the import file after successful or failed import. The handling is not performed if ImportFailedHandling is ERROR and the file failed to validate. Ignored if using import mode 'Delete'.

Allowed Values: Keep, Delete, Archive, Archive Zipped

Default Value: Archive

ArchiveFolder : String Optional

Folder to store archived import files. Used when 'AfterImportFileHandling' is 'Archive' or 'Archive Zipped'. Folder location relative to 'IMPEX' folder. If not defined, 'IMPEX/archive' is used. Ignored if using import mode 'Delete'.

Default Value: archive

FileNamePattern : String Optional

Regular expression pattern to select the import files, e.g. 'import_.*\.csv'. Matching files are imported in alphanumerical order. If not defined all files in working folder are imported. Ignored if using import mode 'Delete'.

ImportFailedHandling : String Required

WARN - Skip malformed files. Perform action specified by AfterImportFileHandling on files. Use Exit Status WARN. ERROR - If invalid file is found, do not perform action specified by AfterImportFileHandling and abort immediately with Exit Status ERROR. Ignored if using import mode 'Delete'.

Allowed Values: WARN, ERROR

Default Value: WARN

ImportMode : String Required

Replace - Create new mapping or replace existing mapping, Merge - Create new mapping or update/create values in existing mapping, Delete - Delete specified mapping. All import file related parameters are ignored.

Allowed Values: Replace, Merge, Delete

Default Value: Replace

KeyCount : Long Optional

Number of columns in CSV file that are composite key columns, from left to right. Default is 1, which indicates that the first column in CSV file is a key. All other columns are an aggregated list of values. Ignored if using import mode 'Delete'.

Default Value: 1

MappingName : String Required

Name used to access the mapping. Example: 'backend-to-web-skus' or 'web-products-to-backend'.

WorkingFolder : String Optional

Folder containing import files, relative to 'IMPEX/src'. If not defined, working folder is 'IMPEX/src'. Ignored if using import mode 'Delete'.

Exit Status

OK

Import or deletion finished successfully.

ERROR

File validation problem and parameter 'ImportFailedHandling' is 'ERROR', or other persistent error.

WARN

File validation problem and parameter 'ImportFailedHandling' is 'WARN'.

NO_FILES_FOUND

No matching files were found.