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:
|Name||A unique name for the custom setting record, will be selectable when importing a CSV file.||
|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.||
|Currency Decimal Separator||Specifies the decimal separator, depends on your locale.||
|Date Format||Specifies the order of day, month and year numbers, where
The date numbers in the CSV file must be separated by non-digit characters like hyphens or dots.
|Field Mapping||Specifies a field mapping between CSV file columns and payment entry fields. The syntax is
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.
|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
For more details, see Filter Expression Syntax Grammar.
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)*
■ 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
■ 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.
- In Setup, open Custom Settings.
In Salesforce Lightning, navigate to Custom Code > Custom Settings.
In Salesforce Classic, navigate to Develop > Custom Settings.
- Click Manage in the row of CSV Import Configuration.
- Click New.
- Specify the details as necessary.
See CSV Import Configuration Information.
- Click Save.