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
- Open the Credit Card Mapping window.
- Search or populate to find the relevant credit card type and go to the
CSV tab.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Save your changes.