From the Microsoft Dynamics 365 Finance & Operations Blogs: Zip file; DimensionAttributeValue; Segregation of duties; Journals

This week, on the Dynamics 365 Finance and Operation blog roundup:

• Creating a Zip file from multiple memorystreams in Dynamics 365 Finance and Operations
• Find and merge a DimensionAttributeValue
• Segregation of duties (SOD) in D365FO
• Voucher templates vs periodic journals in D365FO

Creating a Zip file from multiple memorystreams in Dynamics 365 Finance and Operations

On his Dynamics 365 for Finance and Operations blog, Alex Meyer stated that recently he had a requirement to take a number of pieces of data from Dynamics 365 Finance and Operations, create a CSV file out of each data piece, and then wrap these files in a Zip file so it was easy for an end user to download them.

The requirement was that all the data should be held in memory and never written to disk. In his blog post, Meyer explained the process he used to do that.

To show how I did this I will be using the test scenario of taking all customer and vendors from a D365FO environment, writing them each to a CSV, and then committing both to a zip file for an end user to download.

Although Meyer used CSV files in his test scenario, you could also use his solution for other file types, e.g., XLSX, JSON, XML, etc., as long as you can get them into a Stream object or an object that implements the Stream object.

Additionally, Meyer noted that the solution indicated that the data you put into a Zip file doesn't have to be stored as a physical file so it can be exported. Rather, it can be be kept ...