Tuesday 28 June 2016

Export data to .CSV file from AX 2012 using X++

static void exportDataToCSVfile(Args _args)
{
    CommaIo commaIO;
    container line;
    CustTable custTable;
    FileIoPermission perm;

    #define.ExampleFile(@"c:\test\filename.csv")
    #File
    ;

    perm = new FileIoPermission(#ExampleFile, #io_write);
    perm.assert();

    commaIO = new CommaIo(#ExampleFile, #io_write);

    if (!commaIO || commaIO.status() != IO_Status::Ok)
        throw error("File cannot be opened.");

    while select custTable
    {
        line = [custTable.AccountNum, custTable.name()];
        commaIO.writeExp(line);
    }
}

No comments:

Post a Comment