Skip to content

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"