Data Exchange Definition

(1) Share

Report

Posted on by stephenm171

123

Having issues with creation and import of bank import FLAT TEXT file. Configuration appears to require a column separator even though Flat File is selected.

Categories:

Financial Management

All responses (5)

Answers (0)

Suggested answer

stephenm171 123 on at

Like (1)

Report

Data Exchange Definition

This issue was solved by setting the Reading/Writing Codeunit instead of the Reading/Writing XMLport.

In terms of the number format, as the amount is as Decimal and then multiple by 0.01.
Suggested answer

Jun Wang 6,908 Super User 2024 Season 2 on at

Like (0)

Report

Data Exchange Definition

did you set up the text padding , padding character correctly?
Suggested answer

Dallefeld 11,419 User Group Leader on at

Like (0)

Report

Data Exchange Definition

Your data exchange definition shows that the file should have a column separator of comma. Have you tried changing that setting?
stephenm171 123 on at

Like (0)

Report

Data Exchange Definition

Thanks Judy - but this DOES NOT work for txt files ONLY csv files.

The file received is a flat text file with no column separator.

Even if you specify the length of the column - this is ignored.
Judy Microsoft Employee on at

Like (0)

Report

Data Exchange Definition

Hi,

You can check the steps to set up the custom Import file through Assisted Setup by selecting Set up a bank statement file import format.

For more details, please check the following blog:

https://yzhums.com/11072/

Best Regards,

Judy