CSV Import Configuration
API Name: CSVImportConfiguration__c
CSV Import Configuration
| Label | API Name | Type | Description |
|---|---|---|---|
| Name | Name |
Text(255) | |
| CSV Column Separator | CSVColumnSeparator__c |
Text(1) | |
| Character encoding | CharacterEncoding__c |
Text(255) | Define the character encoding of the csv file. If empty it defaults to unicode. |
| Currency Decimal Separator | CurrencyDecimalSeparator__c |
Text(1) | |
| Date Format | DateFormat__c |
Text(3) | Define the date format with a permutation of the three letters D, M and Y. Eg. YMD for 2015-12-31. |
| Field Mapping | FieldMapping__c |
Text(255) | Define a field mapping between CSV columns and PaymentEntry fields: I.e. a list of "column field" separated by semicolon. Column can be its header name or a number. E.g "0 BookingDate__c; 1 Reference__c; 5 Credit__c" or "MyDate BookingDate__c; SomeInfo Reference__c; amount Credit__c" |
| Filter Expression | FilterExpression__c |
Text(255) | Evaluate an expression for each csv row. If an expression evaluates to true, a payment entry will be created. E.g. "$1 > 100" |