RULES FOR BATCH PAYMENTS
Batch payment data can be imported using a CSV file:
- The first line of the file must contain all headers separated by the semicolon ; - Each of the csv lines represents a payment.
- All lines need to have the same amount of fields (so, the same amount of tabs).
- Any file name can be used for the csv file as long as it has the csv file name extension;
- A field or line can be left blank.
- It is recommended to put all fields in double quotation marks. this is recommended, because in this case the separator can be used in fields without causing problems. Let us take, for example, the description of the payment: Invoice 123; tuition fee. It should involve it like this: "Invoice 123; college tuition" to prevent our software from dividing it into two values, since the semicolon is a separator of values.
- Import is case-sensitive.
CSV FILE EXAMPLE
"user";"amount";"description"
"user2";"2,55";"Test 2"
"user3";"3";"Test 3"
"user4";"4,23";"Test 4"
"user5";"5,76";"Test 5"
"user6";"6";"Test 6"
NOTES:
1. In the field "user" you must indicate the public identifier of the account of the payment recipient.
2. Decimal places are defined with a comma. You can not use a point to separate decimal places from the unit. Example: 3.55 will be read as 355, transferring € 355.00 instead of € 3.55.