Skip to content

CSV Import Configuration

JustOn allows for tracking collections for invoices. To this end, you can import payment entries from CSV files.

The custom setting CSV Import Configuration controls the payment entry import.

CSV Import Configuration Information

The custom setting CSV Import Configuration includes the following information:

Field Description Examples
Name A unique name for the custom setting record, will be selectable when importing a CSV file. bank ABC
CSV Column Separator Specifies the character that separates the columns in the CSV file. ;
Character Encoding Specifies the character encoding of your CSV file. If empty, defaults to UTF-8. ISO-8859-1
Currency Decimal Separator Specifies the decimal separator, depends on your locale. ,
Date Format Specifies the order of day, month and year numbers, where D = day, M = month, Y = year.
The date numbers in the CSV file must be separated by non-digit characters like hyphens or dots.
YMD for 2017-12-31
DMY for 31.12.2017
Field Mapping Specifies a field mapping between CSV file columns and payment entry fields. The syntax is <column> <field>, that is, a column name (as defined in a CSV header row) or a column number (starting with 1) + space character + API name of the payment entry field. Multiple mappings are separated by semicolon.
Column names in the CSV file must not contain spaces. With column numbers, the CSV file must not contain a header row.
For more details, see Field Mapping Syntax Grammar.
date BookingDate__c;reference Reference__c;debit Debit__c;credit Credit__c
1 BookingDate__c;2 Reference__c;3 Debit__c;4 Credit__c
Filter Expression Specifies an expression to be evaluated for each CSV row. If an expression is true, the row is kept and a payment entry will be created. The syntax of a comparison expression is $<column> <operator> <value>. Multiple comparison expressions can be coupled with & (logical AND) or | (logical OR), where & takes precedence. Column numbers start with 1 or A. Strings are enclosed in single quotes, like 'some text'.
For more details, see Filter Expression Syntax Grammar.
$1 = 'IMPORT'
$'abc' >= 100 & $'abc' <= 200
$1 > 20 & ($3 = 'S' | $4 = 'Y')
Field Mapping Syntax Grammar

The field mapping syntax is based on the following grammar:

Column_Mapping = (Column_Name | Column_Number) " " PaymentEntry_APIFieldName
Mapping = Column_Mapping (";" Column_Mapping)*

Examples:

■ Field mapping with column names:

date BookingDate__c;reference Reference__c;debit Debit__c;credit Credit__c

■ Field mapping with column numbers:

1 BookingDate__c;2 Reference__c;3 Debit__c;4 Credit__c
Filter Expression Syntax Grammar

The filter expression syntax is based on the following grammar:

Expr := CompareExpr | '(' Expr ')' | Expr LogOp Expr;
LogOp := '&' | '|'
CompareExpr := Value CompareOp Value;
CompareOp := '=', '<', '>', '!=', '>=', '<=';
Value := String | Number | Column | ColumnName;
Column := '$'Number;
ColumnName := '$'String

Examples:

■ Import rows where the first column matches with the text value "IMPORT":

$1 = 'IMPORT'

■ Import rows where the value in the column "abc" is between 100 and 200 (both inclusive):

$'abc' >= 100 & $'abc' <= 200

■ Import rows where
a) the value of the first column is larger than 20 and
b) the value of the third column is S or the value of the fourth column is Y:

$1 > 20 & ($3 = 'S' | $4 = 'Y')

Defining CSV Import Configuration

Depending on your organization's requirements, you must define one or more specific CSV import configurations.

  1. In Setup, open Custom Settings.
    In Salesforce Lightning, navigate to Custom Code > Custom Settings.
    In Salesforce Classic, navigate to Develop > Custom Settings.
  2. Click Manage in the row of CSV Import Configuration.
  3. Click New.
  4. Specify the details as necessary.
    See CSV Import Configuration Information.
  5. Click Save.