Write to a CSV file and save it

-
This is a simple job I wrote in D365O that writes all customers where the DataAreaId is “USRT” to a CSV file and downloads it.
WriteToCSV
When you run the job you will be prompted to save the file.
SaveFile
Your saved file as CSV:
CSVFile

Comments

  1. Shubhrta26 May 2018 at 03:45

    Hi, this is nice snippet. I want to export CSV file every day at mid-night, can you please tell what's the good way to do this.

    ReplyDelete
  2. Shahil Ram12 June 2018 at 03:10

    Hi Shubhrta, apologies for the late reply. You can create a recurring job in ax that runs every midnight.

    ReplyDelete
  3. kishorepvk23 August 2018 at 08:53

    Nice post. Thanks you very much for sharing. Quick question, can we store it a specific folder (if we configure a batch job) instead of giving an option to user to save the file?

    ReplyDelete
    Replies
    1. Shahil Ram28 August 2018 at 17:28

      Since D365FO is web based, it doesn't have access to the file system. However, Microsoft has introduced Recurring Integrations Scheduler which can help you achieve that. I have a look at these links:
      https://github.com/Microsoft/Recurring-Integrations-Scheduler
      https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/data-entities/recurring-integrations

      Delete
    2. Nikolay17 January 2020 at 06:13

      Hi Shahil, But do you have links to examples of solutions to a similar task of saving files using the Recurring Integrations Scheduler in D365?

      Delete
    3. Shahil Ram29 January 2020 at 11:29

      Have a look at this wiki: https://github.com/microsoft/Recurring-Integrations-Scheduler/wiki

      Delete
  4. Byron4 March 2019 at 23:56

    Hi, I tried this sample code and it's working fine.

    Have you tried working on multiple files? Let's say one button that will generate 2 csv files to the client. Thanks!

    ReplyDelete
    Replies
    1. Shahil Ram18 June 2019 at 15:33

      Hi Byron I haven't tried that out. It would be interesting to know how it behaves. Do tell if you have given it a go

      Delete
  5. Hassan Ali1 April 2020 at 09:08

    hi, this is something i was trying to achieve this saves my time, but there is one thing i want to know when i am opening the file with edit option on notepad the file columns are in inverted comma, can you please let me know if there is separate class to get data without inverted comma?

    in note it is like "Hassan" in excel it is fine.

    ReplyDelete
  6. Amber29 January 2021 at 10:42

    I'm attempting to do the same, but it's telling me that System.IO.StreamReader does not exist. Did Microsoft remove this? What would you do now that it's not available? Thanks!

    ReplyDelete
  7. Sk Abdul Kader30 March 2021 at 22:40

    CSV file save in non editable mode.

    I have generated csv file from data Gried view ,now i want to save csv file in readonly format.
    please help.

    ReplyDelete

Post a Comment

Popular posts from this blog

Override a System Defined Refresh button in D365O

-
Image
Essentially this post is going to discuss calling custom code while refreshing a form in D365O, however, you can find more information about other system defined buttons and how you can run extra code or suppress them in this article:  System-Defined buttons Firstly the datahelper() method of the formRun framework class can be used to provide services that allow managing the datasources of the form. How can I add custom code to run when I click refresh? We are going to use eventing (pre-event handler and post-event handler) to do this: 1. Write your method that you want to call when the refresh button is clicked 2. In the Form.int subscribe using the datahelper().Refreshing event 3. On refresh click you'll see your message
Read more

Printing PDF Attachments in MSDyn365FO

-
Image
In this post I’ll detail how you can print PDF document attachments using AXs DocumentContract framework. I have used this forum post as a reference: https://community.dynamics.com/ax/f/33/p/222925/785091#785091 1. Create extension of the DocuView form to introduce a new Print button. 2. Next thing is to create a handler class that will have all our event handlers. a. Firstly, we create a class with the reference to DocumentContract AX framework. In my case, I am also using Reporting framework. b. Let’s subscribe to the OnActivated event of the main DataSource which is DocuRef. This is so we can enable or disable printing by checking if the reference is a document and is of type ‘pdf’ c. Then we can create subscribe to the OnClicked event of the new button Print button. We will write our printing logic here. d. Once you click print, you’ll get the following message and you have managed to successfully print an attachment:
Read more