Thursday, August 4, 2011

Writing Data to CSV file from Dyanamics AX

Here is a code to write date from Microsoft Dyanics Ax to comma separated file(.csv).

static void AX2CSV(Args _args)
    CommaTextIO file;
    container line;
    InventTable invenTable;
    file = new CommaTextIO(#filename, #io_write);
    if (!file || file.status() != IO_Status::Ok)
        throw error("File cannot be opened.");
    file.outFieldDelimiter(';'); // for semicolon seperator and default field delimitter is ,(comma)
    while select invenTable
        line = [invenTable.ItemId,invenTable.ItemName,invenTable.ItemGroupId];
Good Luck.. :)

No comments:

Post a Comment