SymptomsTo be able to convert external payment data to the CSV format (what is necessary for the further data import to PBA), customers need to implement a special conversion script by themselves.
CauseDifferent customers can use different formats of data exchange with their banks.
ResolutionThe conversion script must be implemented as a Unix program taking these two input parameters:
- an input file name
- an output file name
The input file format is not described here because we are unaware of its format.
The format of the output file is described in the "Importing Payments from CSV File" section of PBA 5.5 Provider's Guide.
For the CIS market payments conversion, the following additional requirements to the output file content are actual:
- the field separator is mandatory a comma ","
- the file encoding is UTF-8
- dates are in the "YYYY.MM.DD" format
- decimal delimiter is a period "."
Here is an example of the output file:
2,1,USD,10.00,Open,,,1000001,"Order number is 1000001/2",2013.11.18,"Document - 2"
5,1,USD,15.00,Open,,,1000001,"Order number is 1000001/5",2013.11.18,"Document - 5"