Exporting AX Data to .CSV File using Class and Dialog with parameters

(0) Share

Report

Posted on by ALAhmed

916

Hi ,

I have to export data from AX to .csv file to a specific folder using dialog that have two parameter fromDate and toDate. So when i click on the OK of dialog , the data should be exported to cvs file in specific folder.

what steps can i follow to do that requirement

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

HI Alex,

You would be able to use the Data Import Export Framework. Depending on the data you need to export you could also use the dat/def definition group based option to export filtered data.

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report

They are not want use the DMF or ssrs report , they want just use a dialog with parameters and when we click on the ok button , the CSV file saved on the specific folder that have path of folder calculated. i think i have to use a batch dialog ?

Was this reply helpful? Yes No
Suggested answer

RiccardoFiaschi 65 on at

Like (0)

Report

Hi,

There are a number of ways, as André has described. You could also just use the CommaTextIO class to do this:

https://msdn.microsoft.com/en-us/library/aa624902(v=ax.50).aspx

See the Tutorial_* classes in AX for an example how to use a dialog.

Regards,

Riccardo

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report

Is there a turoial class for sysoperation /RunBaseBatch?

What do you think for using sysoperation /RunBaseBatch?

Was this reply helpful? Yes No
Verified answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

CommaIo file= new CommaIo(FilePath+"filename.csv","w");

container buffer;

DictTable dt = new DictTable(tableNum(YOURTABLE));

int fieldcount;

for (fieldcount =1 ;fieldcount <= dt.fieldCnt();fieldcount++)

{

buffer += [dt.fieldName(dt.fieldCnt2Id(fieldcount))];

}

file.writeExp(buffer);

while select YOURTABLE

{

buffer = ConNull();

for (fieldcount =1 ;fieldcount <= dt.fieldCnt();fieldcount++)

{

buffer +=[YOURTABLE.(dt.fieldCnt2Id(fieldcount))];

}

file.writeExp(buffer);

}

file.finalize();

Was this reply helpful? Yes No