Axapta V/s Me

Yet another blog for Dynamics 365 for Finance and Operations. This blog primarily targets the technical readers. I will be sharing my experience with Dynamics AX using code snippets, errors, and solutions, Tips, and tricks.

How export data to csv file in Ax 2009

How export data to csv file in Ax 2009

Hi friends ,

   Today we will learn how to exporting our  data from Ax 2009 to csv file format. The programming is done through X++ code. Change the code as per your requirements. Now we will have a simple example of writing the invent table to the csv file

public static void main(Args _args)
    Commaio file;
    container line;
    InventTable inventTable;

    file = new Commaio(#filename , #io_write); or  file = new Commaio(#filename , 'W');
    if( !file || file.status() != IO_Status::Ok)
        throw error("File Cannot be opened");
    while select inventTable
        line = [inventTable.ItemId,inventTable.ItemName];

You can save the document in any format such as doc,txt,xls only.


No comments:

Post a Comment


Note: Only a member of this blog may post a comment.