Small and medium business | Business Central, N...

Data Exchange Definition

(1) Share

Report

Posted on by stephenm171

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:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Sort by

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
stephenm171 27 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Your data exchange definition shows that the file should have a column separator of comma. Have you tried changing that setting?
Suggested answer

Jun Wang 8,222 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

stephenm171 27 on at

Like (1)

Report
Copy link

Link copied!

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.