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

Data Exchange Definition - csv output - speech marks

(0) Share

Report

Posted on by Heather Roggeveen

9,146

I am working to create a payment export file (simple csv format) using Data Exchange Definitions. I have used details from this post:

https://community.dynamics.com/business/f/dynamics-365-business-central-forum/314580/how-to-export-data-to-csv-files/912977#912977

But the problem I have is the speech marks in the resulting file. Because the file is to be imported into the bank, we don't open it using Excel - because Excel is rather smart and does things like drop leading zeros. I have tested the output file - and without intervention, the bank rejects the file. If I open the file in notepad and remove the speech marks, it imports into the bank perfectly. Anyone know how to set it up so no speech marks?

Cheers

Heather

All responses (2)

Answers (0)

Suggested answer

MartinNL 480 on at

Like (0)

Report

RE: Data Exchange Definition - csv output - speech marks

Hi Heather,

As mentioned by aotto this can be resolved by changing the Field Deliminator property on the XML Port that you are using as for variable text it is set to use the "" as separators. This is simple to do if you are using NAV and have access to the developer environment or via AL if using Business Central.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-fielddelimiter-property

Hope this helps.

Martin
Community Member on at

Like (0)

Report

RE: Data Exchange Definition - csv output - speech marks

You should set FieldDelimiter = '<None>'; in the xmlport