Hi friends,
Today we have a small requirement of importing data into Ax 2009 from a csv file. We imported a small data to the InventTable.
Note:: The follwing does not followed the best practices please bear that in mind
public static void main(Args _args)
{
Commaio file;
container line;
InventTable inventTable;
#define.filename("E:\\Items.csv")
#File
;
file = new Commaio(#filename , 'R');
file.inFieldDelimiter(',');
if( !file || file.status() != IO_Status::Ok)
{
throw error("File Cannot be opened");
}
line = file.read();
inventTable.ItemId = conpeek(line,1);
inventTable.ItemName = conpeek(line,2);
inventTable.insert();
Today we have a small requirement of importing data into Ax 2009 from a csv file. We imported a small data to the InventTable.
Note:: The follwing does not followed the best practices please bear that in mind
public static void main(Args _args)
{
Commaio file;
container line;
InventTable inventTable;
#define.filename("E:\\Items.csv")
#File
;
file = new Commaio(#filename , 'R');
file.inFieldDelimiter(',');
if( !file || file.status() != IO_Status::Ok)
{
throw error("File Cannot be opened");
}
line = file.read();
inventTable.ItemId = conpeek(line,1);
inventTable.ItemName = conpeek(line,2);
inventTable.insert();
}
Please made changes as per your requirement.
Vivek Chirumamilla
No comments:
Post a Comment