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.
Posted by at

57 comments:

  1. Ravi Nelluri10 March 2014 at 06:15

    AT-

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

    ReplyDelete
  2. Unknown11 March 2014 at 22:24

    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. Automation Tester11 March 2014 at 23:18

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

      Delete
  3. Bilal18 March 2014 at 18:50

    This comment has been removed by the author.

    ReplyDelete
  4. Bilal18 March 2014 at 18:52

    This comment has been removed by the author.

    ReplyDelete
  5. Anonymous7 April 2014 at 08:27

    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. Automation Tester7 April 2014 at 09:24

      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. Anonymous9 April 2014 at 08:32

      Thank you. Excel report got generated in Run folder.

      Delete
    3. Automation Tester9 April 2014 at 19:58

      Fantastic!!

      #AT

      Delete
    4. Anonymous14 April 2014 at 08:15

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

      Delete
    5. Automation Tester14 April 2014 at 09:22

      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
    6. Anonymous10 February 2015 at 22:05

      Hi AT,

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

      Thanks in advance

      Delete
    7. Unknown10 August 2015 at 00:43

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

      Delete
  6. Unknown21 April 2014 at 03:51

    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. Anonymous30 April 2014 at 12:48

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

    ReplyDelete
    Replies
    1. Automation Tester30 April 2014 at 18:43

      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. Anonymous3 May 2014 at 03:22

      Hello,

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

      Delete
    3. Automation Tester6 May 2014 at 01:57

      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. Unknown4 May 2014 at 07:24

    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. Automation Tester6 May 2014 at 01:58

      Hi Chinig,

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

      #AT

      Delete
  9. Unknown4 September 2014 at 09:12

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

    for the ATU reports

    ReplyDelete
  10. Syam..13 September 2014 at 03:38

    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. Unknown25 September 2014 at 05:07

    This comment has been removed by the author.

    ReplyDelete
  12. Unknown25 September 2014 at 05:09

    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. Anonymous7 April 2015 at 00: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. Unknown18 May 2015 at 04:11

    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. Unknown4 July 2015 at 06:10

    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. Inkit12 January 2016 at 14:35

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

      Delete
  16. Anonymous27 July 2015 at 02:59

    Hi AT,

    Do you have Maven dependency for ATU Reports?

    ReplyDelete
  17. Unknown4 August 2015 at 03:35

    This comment has been removed by the author.

    ReplyDelete
  18. Unknown4 August 2015 at 03:36

    This comment has been removed by the author.

    ReplyDelete
  19. Anonymous10 August 2015 at 03:23

    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. Unknown1 September 2015 at 00:03

    ✔ PLC Training in chennai
    ✔ PLC Training Institute in chennai
    ✔ PLC Training Center in chennai
    ✔ PLC Training Course in chennai
    ✔ PLC Course in chennai
    ✔ PLC SCADA Training in chennai
    ✔ PLC Training Centre in chennai
    ✔ PLC SCADA Training Institute in chennai
    ✔ Best PLC Training in chennai
    ✔ Best PLC Training Institute in chennai
    ✔ DCS Training in chennai
    ✔ Automation Training in chennai
    ✔ Automation Training Institute in chennai
    ✔ Industrial Automation Training in chennai
    ✔ Process Automation Training in chennai
    ✔ Robotics Training in chennai
    ✔ Inplant Training in chennai

    ReplyDelete
  21. Anonymous23 October 2015 at 07:09

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

    ReplyDelete
    Replies
    1. Unknown11 February 2016 at 00:44

      Hi,

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

      Delete
  22. Anonymous24 November 2015 at 07:46

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

    ReplyDelete
  23. maharajanm4 January 2016 at 07:56

    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
  24. Unknown3 February 2016 at 12:44

    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
  25. Unknown4 February 2016 at 01:00

    This comment has been removed by the author.

    ReplyDelete
  26. Unknown4 February 2016 at 04:55

    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
  27. Unknown11 February 2016 at 00:43

    Hi,

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

    Thanks,

    ReplyDelete
    Replies
    1. Unknown14 February 2016 at 23:01

      Any please update me on above my comment it's very needful for me,

      Thanks,

      Delete
    2. Unknown15 February 2016 at 19:34

      This comment has been removed by the author.

      Delete
  28. Unknown15 February 2016 at 19:39

    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. Unknown15 February 2016 at 20:55

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

      Thanks,

      Delete
    2. Unknown15 February 2016 at 21:14

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

      Thanks,

      Delete
  29. Unknown1 March 2016 at 18:48

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

    ReplyDelete
  30. Anonymous1 December 2016 at 03:59

    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
  31. Prem Kumar K N2 February 2017 at 03:00

    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
  32. Unknown22 February 2017 at 04:30

    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
  33. Ranjith23 February 2017 at 02:21

    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
  34. Anonymous10 July 2017 at 00:02

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

    ReplyDelete

Subscribe to: Post Comments (Atom)