562
Hi All,
I tried blow link for export the data from ax to .CSV file with out batch process its working good .
https://mycsharpdeveloper.wordpress.com/2016/04/28/how-to-export-data-to-csv-using-x/
while i try to add the batch process its not working showing some error.Please give some idea to reslove
Thanks
Tony
class RunBaseDemo extends RunBaseBatch
{
}
client server static ClassDescription description()
{
return "Mark on-hold";
}
public void run()
{
CommaIo io;
str TodayDate;
str strfilename;
str fileName;
TransDate _transDate;
_transDate = systemDateGet();
strfilename = "QL Item Update.csv";
fileName = @"C:\Sample\";
startTime = str2time("12:00:01 am"); //GMT, NOT user time zone - this is how stored in the table
endTime = str2time("11:59:59 pm");
rangeStart = DateTimeUtil::newDateTime(_transDate,startTime);
rangeEnd = DateTimeUtil::newDateTime(_transDate,endTime);
io = new CommaIo(strFmt("%1//%2", filename, strfilename), 'W');
io.outFieldDelimiter(",");
io.outRecordDelimiter('\r\n');
io.write('Item Number','Sell UPC','Description','Size','Color');
while select inventTable where inventTable.createdDateTime >= rangeStart &&
inventTable.createdDateTime <= rangeEnd
{
io.write(inventTable.ItemId,retailInventTable.getDefaultBarcode(),ecoResProductTranslation.Name,inventTable.StandardInventSizeId));
}
info(strFmt("File %1 created in specified folder.", fileName + strfilename));
}
static void main(Args _args)
{
RunBaseDemo objClass = new RunBaseDemo();
//prompt for runbase framework dialog
if (objClass.prompt())
{
//run the process
objClass.run();
}
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
