C# and AX Development: Reading CSV files in AX (Axapta)

[Blog bot]

Источник: 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