Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
when we try to open the csv file with note pad after it was exported from AX through the closedXML library, the file opens in different format with different characters inside as per below pic , so we have to manually save the file as csv comma delimted then it open with correct format, how can we solve this issue that after the export it opens in right format ?
This is not a CSV file. It's an Excel file, which isn't a huge surprise, since you used a library for working with Excel files.
So either your fine with getting an Excel file, or you'll have to change your implementation.
Thank you Martin.
i have a question please :
we are trying to generate a csv file when the WF is completed. the file is generated successfully but when we try to open it with note pad the value appear with "" is there any way to remove the "" .
Instead of removing, I would focus on not writing the quotation marks in the file in the first place.
How to do that in your case depends quite a lot on your implementation. Perhaps you can share your code, then we can suggest how to change it?
Thank you Nikolaos for your response : below is the code and the output
Try commaIo.WriteExp method instead of the write method.
Thank you Nikolaos, replaced the write with writeexp but with same output.
Sorry, actually you need to use TextIO instead of CommaIO if you don't want to have the quotation marks. In normal CSV string values are surrounded by quotation marks, to avoid issues where the string field contains the delimiter character (such as comma).
Are you sure it's not ok to have the quotation marks there? I would assume that the application who reads this file knows how to handle it.
Thanks a lot Nikolaos, the team has used the TextIO, and is exporting it to CSV.
Business Applications communities