Import file preparation

If the user himself is going to manufacture the import file from a export from a debit system, the easiest way to do this is using a spreadsheet program such as Excel or similar, unless the debit program supplies the data directly in the intended format.

 

1.       Import the data to the spreadsheet program.

2.       Arrange the data in columns in the same sequence as shown in Figure 1 above.
See Customer data field description below.

3.       Calculate the field values not obtained from the debit program in

the spreadsheet program, or enter an appropriate default value. Check att the max. number of characters in each field is not exceeded.

4.       Open the control panel and national settings. As a 

list separator, enter the character ¤ under the tal [figures tab

5.       Save the spreadsheet in semicolon-delimited format with a TXT extension.

6.       Close the spreadsheet.

7.       Reset the list separator in national settings to its regular value.