Dynamics Community Forum Thread Details

How to get datetime in file name while exporting to csv in AX 2009

Hi All,

We have written a job to export to csv, able to export if ww dont include datetime in file name.

But when we include the datetime in file name unable to export.

If we include datetime in file name , "file" in the next line is coming as null.

Please let us know how we can include datetime in the filename while exporting to CSV.

Below is the job:

public static void main(Args _args)
{
Commaio file;
container line;
InventTable inventTable;
LedgerJournalTable ljt;
str filname;
str datefile;
utcDateTime dateTime = DateTimeUtil::getSystemDateTime();
date dateformat;
str TodayDate;
;
dateformat = today();
TodayDate = date2str(dateformat,321,DateDay::Digits2,DateSeparator::Slash,DateMonth::Digits2,DateSeparator::Slash,DateYear::Digits4);
filname = @"C:\\" + TodayDate + "Error.csv"; --> able to get file name with data as "C:\\2021/08/22Error.csv"

#File

file = new Commaio(filname , #io_write); -->coming null if include date in filename

if( !file || file.status() != IO_Status::Ok)
{
throw error("File Cannot be opened");
}
while select ljt
{
line = [ljt.JournalNum];
file.writeExp(line);

}

Regards,

Akbar

Quick Links