Источник:
http://olondono.blogspot.com/2007/12...a-asciiio.html
==============
Reading CSV files in AX (Axapta)
AsciiIo x = new AsciiIo("C:\MyFilename.csv","R");
Container y;
CustTable ct;
CustAccount accountNum;
;
x.inRecordDelimiter('\r\n');
x.inFieldDelimiter(','); // Or other values like ; or \t
while (x.status() == IO_Status::Ok)
{
y = x.read();
if (conlen(y) == 3) // You can validate content here
{
accountNum = ConPeek(y, 1); // Index is one based (1-based) no zero based (0-based)
ttsbegin;
select forupdate ct
index hint AccountIdx
where ct.AccountNum == accountNum;
if (ct)
{
// Read and update fields
...
ct.update();
}
else
{
// Fill fields and insert record
...
ct.insert();
}
ttscommit;
}
}
Источник:
http://olondono.blogspot.com/2007/12...a-asciiio.html