Solved

Import Bank Statement example

  • 9 November 2020
  • 2 replies
  • 409 views

Userlevel 3
Badge +8

Hi,

I’m trying to import a bank statement into IFS 9 without any luck.

I’m using the external file assistant.

When I run the import I get the error: “No unpacked data found, check load file id”, and the log doesn’t tell me anything.

I think the format of the import file is wrong. But I’m having trouble understanding how to read the file type.

The file type has tree record types:

Each record type has a column definition. Here is the one for the HEADER:

 

Do I need to include all tree types in my imput file?

Do I need to include all columns when non of them are mandatory?

How do I understand the destination column?

Is it possible to export an example of how the import file should look like?

 

Best regards Kresten

icon

Best answer by dsj 9 November 2020, 12:18

View original

2 replies

Userlevel 7
Badge +20

Hi Kresten,

 

To understand the input file format, you can use DescribeInput file type and it will output an readable explanation of the file type.

 

For your example,

Step 1 : choose Online

Step2:

 

Step 3:

 

Output is a readable explanation of the input file format as attached.

Regards,

Damith

Userlevel 3
Badge +8

Thanks!

Reply