Показать сообщение отдельно
Старый 16.08.2011, 12:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,644 / 848 (80) +++++++
Регистрация: 28.10.2006
daxdilip: CommaTextIO Class How to Export data to .csv file via X++
Источник: http://daxdilip.blogspot.com/2011/08...t-data-to.html
==============

I'm sure many of you out there might have already used this API within AX.

I had a requirement to spit out a .csv file from AX, Looping through Iventory Pricing and On-Hand Data.
And this code snippet from MSDN was handy for the purpose

http://msdn.microsoft.com/en-us/libr...(v=ax.50).aspx

Below sample shows example of how to output the data from CustTable.

#File
CommaTextIo commaTextIo;
FileIOPermission permission;
CustTable custTable;
str fileName = @"C:\test.csv";
;
permission = new FileIOPermission(fileName,#io_write);
permission.assert();
commaTextIo = new CommaTextIo(fileName,#io_write);
while select custTable
{
commaTextIo.write(custTable.AccountNum,custTable.Name);
}
CodeAccessPermission::revertAssert();






Источник: http://daxdilip.blogspot.com/2011/08...t-data-to.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.