D365FO: Read CSV file from Azure File Share

Purpose: The purpose of this post is to demonstrate how we can read a CSV file from Azure File Share in X++. Application: Dynamics 365 Finance and Operations Prerequisites: Azure file storage account must be configured in Azure PortalFile shares must be configured under this Azure file storage accountAccess permissions must be configured for this...

Write TSV file in X++

Purpose: The purpose of this blog post is to demonstrate how can we write a tsv (tab delimited) file in X++ The code actually exports system database log to a TSV fileUses standard SysDatabaseLogReport queryAdds a range for Warehouse tableUses formatted datetime string for filename Product: Dynamics AX 2012 Code: Class declaration. class MAKSysDatabaseLogService {...

Read CSV file in X++

Purpose: The purpose of this blog post is to demonstrate how to read a csv file in X++ Product: Dynamics AX 2012 Code: static void MAKReadFile(Args _args) { #File IO io; CustAccount custAccount; Email email; FilenameOpen filename = @"C:\Temp\CustomerContactInfo.csv"; Container record; ; io = new CommaTextIo(filename, #IO_Read); if (!io || io.status() != IO_Status::Ok) { throw...