Sunday 9 March 2014

ATU Reporter Part 5

Excel Reports Dependencies:


The ATU Reporter requires the following libraries to be available in the build path for generating Excel reports.

The two main libraries used:

Apache POI : For Generating Excel

After downloading Add the following five jars in the build Path
From the POI folder use the following jars

1 >> poi-version.jar
2 >> poi-ooxml-version.jar
3 >> poi-ooxml-schemas-version.jar


From the POI "ooxml-lib folder" use the following

4 >> dom4j-version.jar
5 >> xmlbeans-version.jar


JFreeChart: For Generating BarChart, this chart is written to Excel

Two jars are required
1 >> jfreechart-version.jar

JFreeChart JCommon:

2 >> jcommon-version.jar


All the above jars are required for generating Excel Reports.

57 comments:

  1. AT-

    Need to release 4.0 version ? or reports can export using V3.5 ?

    ReplyDelete
  2. Hi ATU,

    i tried updating by project for Excel report by using 4.0 buy i get error,
    [TestNG] Running:
    C:\Users\sk030336\AppData\Local\Temp\testng-eclipse-297044164\testng-customsuite.xml

    java.lang.IllegalStateException: java.lang.NullPointerException
    at atu.testng.reports.listeners.ATUReportsListener.onStart(Unknown Source)
    at org.testng.SuiteRunner.invokeListeners(SuiteRunner.java:197)
    at org.testng.SuiteRunner.run(SuiteRunner.java:238)
    at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
    at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
    at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
    at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
    at org.testng.TestNG.run(TestNG.java:1057)
    at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)
    at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)
    at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)
    Caused by: java.lang.NullPointerException
    at atu.testng.reports.utils.Directory.init(Unknown Source)
    at atu.testng.reports.utils.Directory.verifyRequiredFiles(Unknown Source)
    ... 11 more


    Can you provide more Description about new version usage and how it will look.

    Regards
    Sujan

    ReplyDelete
    Replies
    1. Sujan,
      You have to define new property for excel reports. Pleasr refer to Part 4 Post.

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Hi AT,
    I have included all the required jar into the classpath. when I execute the script it runs successfully without any error. ATU reports are creating but I could not see the excel report. could you please help me
    If it is generated where it will be generated (dir) and name of the report

    ReplyDelete
    Replies
    1. In the properties file, set the excel reports value to true to generate excel reports. These reports will be stored in the Run folder(say Run_5).

      #AT

      Delete
    2. Thank you. Excel report got generated in Run folder.

      Delete
    3. I too have the same problem , i changed the reports value true still am not seeing the Excel report, Please advice

      Delete
    4. Make sure you are using the latest version if ATU Reporter. Add the required libraries, set the excel reports value to true in properties file.

      #AT

      Delete
    5. Hi AT,

      I am Using Maven, Can you please post all the required dependencies?

      Thanks in advance

      Delete
    6. i also have a same prblm. am changed the report value true. but excel will not generate. am using version 5.1.

      Delete
  6. Hi,

    I have completed all the above mentioned steps for excel report but in my case excel report is generating with 0 KB size. Can you please help on this?

    Ric

    ReplyDelete
  7. is it possible to add the Pass/fail status in step screen...

    ReplyDelete
    Replies
    1. This feature will definitely be available from next version 5.0 onwards. For a list of features refer to part 3 post.

      #AT

      Delete
    2. Hello,

      i'm waiting with impatience for the next release,you have an idea for the date ??

      Delete
    3. Hi,

      i cannot set a specific date of release but I could say that 60% of the new features have been implemented.

      #AT

      Delete
  8. Hello AT,

    I got the same issue than RITESH,the excel file is generated witt 0 Ko,
    can you please provide a sloution ?!

    Reagrds

    ReplyDelete
    Replies
    1. Hi Chinig,

      Please mail us @ our blog email. we would like to take a closer look on the issue.

      #AT

      Delete
  9. Could you please share the group id and artifact id for maven dependencies

    for the ATU reports

    ReplyDelete
  10. Hi All,

    Please provide example code, how to use it?

    I have added jars to class path and kept the given property file in the project location. But did see any reports even Run folder also.

    Could anyone pls help me..

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Hi AT,

    i m getting the below Exception when i m setting (atu.reports.recordExecution=suite) .

    java.lang.IllegalStateException: java.lang.NullPointerException
    at atu.testng.reports.listeners.ATUReportsListener.onExecutionFinish(Unknown Source)
    at org.testng.TestNG.runExecutionListeners(TestNG.java:1095)
    at org.testng.TestNG.run(TestNG.java:1071)
    at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)
    at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)
    at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)
    Caused by: java.lang.NullPointerException

    ReplyDelete
  13. Hi,
    I am facing one issue in ATU reports as follows:-
    If I put ATU report in @BeforeTest and @AfterTest in Main TestNG Class...and check the report, the Browser Version is not showing.
    But in @Test...it showing in reports.
    I am using ATU version 5.0

    ReplyDelete
  14. Hello,

    I have got the below 2 errors while I was running my testatu.xml file.
    java.io.FileNotFoundException: C:\Selenium\JavaPrograms\WebDriver\ATU Reports\Results\Run_14\pieChart.js (The system cannot find the path specified)
    java.io.FileNotFoundException: C:\Selenium\JavaPrograms\WebDriver\ATU Reports\Results\Run_15\pieChart.js (The system cannot find the path specified)
    I am using ATU 5.1.1.

    ReplyDelete
  15. Hi At

    I am getting following error after my test method is getting pass

    [ATU Custom Reporter Step Failed Exception] at atu.testng.reports.listeners.ATUReportsListener.onTestSuccess(Unknown Source) at org.testng.internal.Invoker.runTestListeners(Invoker.java:1781) at org.testng.internal.Invoker.runTestListeners(Invoker.java:1761) at org.testng.internal.Invoker.invokeMethod(Invoker.java:710) at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:834) at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1142) at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:124) at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:108) at org.testng.TestRunner.privateRun(TestRunner.java:771) at org.testng.TestRunner.run(TestRunner.java:621) at org.testng.SuiteRunner.runTest(SuiteRunner.java:357) at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:352) at org.testng.SuiteRunner.privateRun(SuiteRunner.java:310) at org.testng.SuiteRunner.run(SuiteRunner.java:259) at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) at org.testng.TestNG.runSuitesSequentially(TestNG.java:1176) at org.testng.TestNG.runSuitesLocally(TestNG.java:1101) at org.testng.TestNG.run(TestNG.java:1009) at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111) at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204) at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)

    ReplyDelete
    Replies
    1. Hi.. i am getting the same issue. Did you get a fix for it . Kindly help .Thanks.

      Delete
  16. Hi AT,

    Do you have Maven dependency for ATU Reports?

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. How can i fetch remote browsers' details in Summary and Execution Platform details in my Report?

    Ex. When I run my tests in saucelabs, it takes my local machine's information in Execution Platform Details and in Summary, it shows Browser = "Unknown".

    I want to fetch details of the saucelab's machine where my test was run on. Ex. If it runs on Windows 8 and Chrome Browser then it should display in my report not my local machine's information.

    Note : Currently we are using 5.1.1 version of ATU report.

    ReplyDelete
  20. HI UNABLE TO GENERATE EXCEL REPORTS IN ATU 5.5 VERSION JARS
    can please help me

    ReplyDelete
    Replies
    1. Hi,

      I faced same issue but able to generate excel report using ATU 5.1 version

      Delete
  21. How to get screenshot when we come across any failure in AUT report ?

    ReplyDelete
  22. I have done all the things mentioned above but still getting some error as below,
    java.lang.NoSuchMethodError: org.jfree.chart.plot.PiePlot.setSectionPaint

    ReplyDelete
  23. Hello AT,

    this is really an awaesome report generator and thank you for sharing this tool for free. 😁
    I have a question, please.

    What should be done/configured to get ONLY ONE report generated when you have more than 1 test class , e.g.

    Public mytestclass1

    @Test
    Runtest1()

    @Test
    Runtest2()

    ...

    public mytestclass2

    @Test
    runtest1()

    @Test
    runTest2()
    ....

    then execute the two test classes defined in testng.XML

    ...




    ...


    ...


    Thank you very much and lots of greeting from Germany 😀

    Loren

    ReplyDelete
  24. This comment has been removed by the author.

    ReplyDelete
  25. Hello again,

    I found a solution for my issue described above :-)
    Thank you anayway ...
    By the way just another question, please ...

    Is this feature implemented yet ?
    atu.reports.setMaxRuns = 1

    I use version 5.1.1

    Thank you

    Loren

    ReplyDelete
  26. Hi,

    is it possible to have a current report backup to share instead of taking whole iterations to share

    Thanks,

    ReplyDelete
    Replies
    1. Any please update me on above my comment it's very needful for me,

      Thanks,

      Delete
    2. This comment has been removed by the author.

      Delete
  27. Yes , its possible. try to pass the reports dir value dynamically in properties file.(ie: atu.reports.dir=C:\Users\kalyan\workspace\testProject\ATU Reports. )

    once you set above property file , on each execution you will get new report folder with time stamp .

    I hope i ll help you..

    ReplyDelete
    Replies
    1. Hi Ciddagoni,
      Thanks for the solution will try this way.

      Thanks,

      Delete
    2. Hi Ciddagoni,
      Could you please help me how to use timestamp in the atu.properties file?

      Thanks,

      Delete
  28. what don't you just put the pom.xml here for dependencies? it's easier

    ReplyDelete
  29. static {
    System.setProperty("atu.reporter.config", ".\\atu.properties");
    }

    I have set the property inside a static block as shown above. The property file is not detected in my project and the properties are not applied in my project. No logo, no header text, no directory is created. It creates a default directory as "ATU reports" inside project folder. Pls help soon to detect the property file as i am stuck in my project. The author details are reflected, but the properites are not reflected in project. Pls give me a solution soon.

    Thanks
    HS

    ReplyDelete
  30. Hi , I got the Excel report generated but i am unable to open the xlsx file ("excel cannot open the file because the extension is not valid") and the file size is 0 . Kindly help me with the same

    ReplyDelete
  31. Hi AT,

    i m getting the below Exception.[TestNG] Time taken by org.worldbankgroup.iportal.ExecutionReports.TestNGCustomReportListener@4c203ea1: 103 ms
    java.io.FileNotFoundException: C:\Users\smanigam\IportalAutomation\IportalAutomation\ATU Reports\Results\Run_21\pieChart.js (The system cannot find the path specified)

    Please help me to resolve this issue.

    Thanks&Regards,
    SivaKrishna.M

    ReplyDelete
  32. Is there Maven Dependency available for ATU report? I tried searching completely but i could not find. Please let me know how to add dependency to POM as our project need to run globally via jenkins.

    ReplyDelete
  33. Is there any Native Method to take the Screenshot of Mobile Page

    ReplyDelete