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 Applications to store data.

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.

Window

Credit Card Mapping

Related Window Descriptions

Credit Card Mapping

Procedure

1. Open the Credit Card Mapping window.
2. Search or populate to find the relevant credit card type and go to the CSV tab.
3. In the Decimal Symbol field, select by what decimal symbol separates values in the CSV file (such as a card number, amount of currency, currency code etc.) If values are not separated, leave it empty.
4. In the Thousands Separator field, enter what character separates numbers over a 1000. You can use a list of values. If there is no separator, leave the field empty.
5. In the Column Separator field, enter what decimal symbol separates columns in the CSV file. You can use a list of values. If there is no separator, leave the field empty.
6. In the Date Format field, enter how the date is formatted in the CSV field (e.g., DD.MM.YYYY). It has to be a valid Oracle format.
7. In the Title Rows field, enter the number of rows at the beggining of the CSV file that is the document's title. These rows will not be considered as transactions.
8. In the Field Position fields, enter in what order information is listed in a single row of a CSV file. In the DB Column field you can see under what database columns this data will be filed.
9. Save your changes.