Exporting the Data from AX to CSV file

Hi All,

Today I want to share a code for exporting data from AX to CSV file with an example of Invent table.

static void ExportDataToCSV(Args _args)
{
    Query                                 q;
    QueryBuildDataSource     qbds;
    QueryBuildRange             qbr;
    QueryRun                         qr;
    CommaIO                         commaIO;
    FileName                          fileName;
    InventTable                      inventTable;
    ;
   
    fileName       = WINAPI::getTempPath() + "ItemDetails" + ".csv";
    commaIO      = new CommaIO(fileName,'CSVFile');
   
    q                  = new Query();
    qbds             = q.addDataSource(tablenum(InventTable));
    qbr               = qbds.addRange(fieldnum(InventTable,ItemId));
   
    qr                = new QueryRun(q);
   
    commaIO.write("ItemId","Item Name","Item Type","Item GroupId","Dimension GroupId","Model GroupId");
    while( qr.next() )
    {
        inventTable = qr.get(tablenum(InventTable));
       
        commaIO.write(inventTable.ItemId,inventTable.ItemName,enum2str(inventTable.ItemType),inventTable.ItemGroupId,
                      inventTable.DimGroupId,inventTable.ModelGroupId);
    }
   
    WINAPI::shellExecute(fileName);
}

Microsoft Dynamics AX Design Patterns [AX 2012]

The Microsoft Dynamics AX design patterns in the following list enable you to use existing code patterns to resolve common design issues.

Instantiating Application Objects Design Pattern

Searching for Records Design Pattern

static find Method Design Pattern

static exist Method Design Pattern

Parameter System Design Pattern

Multiselection Design Pattern

Searching for Multiple Occurrences Design Pattern

Change Company Design Pattern

Partner Hooks Design Pattern

Pack-Unpack Design Pattern

Use the Type System Design Pattern

Storno Design Pattern

Persistent Data Storage Design Pattern

Data Validation Design Pattern