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.
Prerequisites
In order to perform this activity:
- A credit card type has to be registered in the system.
- Format of the credit card type has to be set to CSV.
- You need to know the CSV structure of an external CSV file.
System Effects
As a result of this activity, a credit card type will be automatically mapped
to read a relevant external CSV file.