Skip to main content
Solved

Import Bank Statement example

  • November 9, 2020
  • 2 replies
  • 494 views

krestensb
Sidekick (Customer)
Forum|alt.badge.img+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

Best answer by dsj

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

View original
Did this topic help you find an answer to your question?

2 replies

dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • 844 replies
  • Answer
  • November 9, 2020

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


krestensb
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 40 replies
  • November 9, 2020

Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings