Customs Formats

2025/05/21 • 3 min. to read

In this topic

Fields
Actions
Actions, Setup

With custom formats, you can import payment files whose structure is not covered by the standard formats. In the NCP Imports setup, you define for which purposes these formats can be used. When importing a payment file, the Custom Formats option is available, allowing you to select and use your own formats.

Fields
Code	Specifies the code for the custom format.
Description	Specifies a description for the custom format.
Active	Specifies whether the custom format is completely set up and active. Only active formats can be used in NCP Imports.
Bank Account No.	Specifies the bank account number for whom the format is valid.
Bank Account Name	Shows the bank account name. Note This field is filled in automatically if you enter the Bank Account No..
Bank Account IBAN	Shows the bank account IBAN. Note This field is filled in automatically if you enter the Bank Account Number.
Separator	Specifies the separator symbol for the fields.
Start Delimiter	Specifies the start delimiter for the fields.
End Delimiter	Specifies the end character for the fields.
Decimal Separator	Specifies the decimal separator for the fields.
No. of Fields	Shows the number of existing fields for this format. Note If you click in the field you will open the page NCP Imports Custom Format Fields.
No. of Assigned Import Fields	Shows the number of assigned import fields for this format. Note If you click in the field you will open the page NCP Imports Custom Format Fields.
File Structure	Shows the file structure with the separators of the import format.

Actions

Fields
Shows the list of the configured fields of the custom format, you can make the settings regarding the fields here.
Suggest Fields
With the function Suggest fields, the fields can be automatically read or suggested from the CSV file (header line). Each field in the file that is to be imported into the NCP Imports must then be assigned to a field number of the import.

Actions, Setup

Import
This action imports a file with a user defined format in CSV format. The file must start with a header line containing the field names. A row or record cannot be longer than 1024 characters. After creating a format and setting up the separators used in the CSV file, the fields of the file and their assignment to the NCP Imports can be set up. These files can be imported from other systems that you have already configured and exported using the export function.
Export
Use this action to export a custom format to a file. This exported file can be used for import into other databases.