Match Database Columns with CSV Field Positions

Explanation

This activity is used to match information provided in a CSV file with relevant database columns used by the IFS Cloud to store data.

Credit Card Mapping page for format type CSV is used for this purpose. The following settings can be configured using this activity.

Decimal Symbol is used to separate values in the CSV file. The field can be left empty, if the values are not separated by any decimal symbol.
Thousands Separator is used to separate thousands in the amount fields. The field can be left empty, if there is no separator.
Column Separator is used to separate columns in the file. The field can be left empty, if there is no character to separate.
Date Format is used to define the date format in the CSV file. This must be a valid oracle format. (e.g. DD.MM.YYYY)
Title Rows is used to define the number of header rows in the file that show the titles. These rows will not be considered as transactions.
Migration Job ID is the ID of the migration job created during uploading.
Continue with Errors option is used to continue importing transactions from the file even if any errors occur during the migration job.
The system defined DB Columns can be matched with the external CSV file to fetch appropriate data.
- Mandatory option allows user to map the column before uploading the mapping.
- Field Position allows user to enter the index number of the information once a single row is separated by the column separator.

In order to perform this activity:

As a result of this activity, a credit card type will be automatically mapped to read a relevant external CSV file.