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;
#define.filename('u:\\items.CSV')
#File
;
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];
file.writeExp(line);
}
}
No comments:
Post a Comment