Export BP to excel

(0) Share

Report

Posted on by venkates

240

Hi All,

I have a scenario where I need to export the best practice list to excel or a html file in AX 2009. I tried using sysCompilerOutput::exportLog but it is exporting all(warnings,errors and BP's).

Is there any other way to achieve this.

Thanks.

All responses (2)

Answers (0)

venkates 240 on at

Like (0)

Report

RE: Export BP to excel

Hi Crispin,

I am using the below code.

projectNode.AOTcompile();

sysCompileroutput = infolog.compilerOutput();

tmpCompilerOutput = sysCompileroutput.compilerOutput();

but I am not getting any buffer in tmpCompilerOutput. If I get buffer I will use it to store the BP deviations in a separate table. What could have been wrong here as I could not find the issue that cause buffer to be 0.
Crispin John Augustine 37,081 on at

Like (0)

Report

RE: Export BP to excel

1. Try to make use of a small job to run a best practice check.

2. Results are stored in templorary table TmpCompilerOutput

3. Filter only TmpCompilerOutput.SysCompilerOutputTab == SysCompilerOutputTab::BestPractices

and export them in your desired format.

(Note: you have to use the SysCompilerOutput class to access data from TmpCompilerOutput)