Tuesday 29 December 2015

Export data from AX to txt file using X++

static void exportData(Args _args)
{
    CustTable custTable;
    BinData binData;
    TextBuffer textBuffer;
    ;
 
    textBuffer = new TextBuffer();
    textBuffer.setText('');

    while select custTable
    {
        textBuffer.appendText(strFmt('%1;%2;%3\r\n',custTable.AccountNum,custTable.name(),custTable.CustGroup));
    }

    textBuffer.getText();

    binData = new BinData();
    binData.setStrData(textBuffer.getText());
    binData.saveFile(strFmt("%1%2",ExportFilePath,"/"+curext()+date2str(systemDateGet(),123,2,0,2,0,4)+".txt"));
    info("File is exported successfully.");
}

No comments:

Post a Comment