Planet Jaspersoft

Filter by tags:

April 10, 2020

If we wan to run the cucumber project from command line/prompt using executable jar , we should create main method and inside it have to pass string values of cucumber options.

Adding main method for BasePage.java class and appropriate jar assembly plugin in pom.xml with the fully qualified class name say com.sadakar.selenium.common.BasePage
(in which main method is written), generates the MANIFEST.FM file that can be viewed if  extracts the jar

The options for command line differs from what we give in CucumberRunner.java (cucumber runner class with )

These options for command line are presented with -g, -p, -m and etc.
-g for glue code
-p for pretty
-m for monochrome
and to read the .feature files give "classpath:features".


The below piece of code explains how the cucumber options should be passed to main method.
Basepage.java
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;

public class BasePage {

public static WebDriver driver;

public static void main(String args[]) throws Throwable{
try {
cucumber.api.cli.Main.main(
new String[]{
"classpath:features",
"-t","@scenario_AccountPage",
"-g", "com.sadakar.cucumber.stepdefinitions/",
"-g","com.sadakar.cucumber.common",
"-p","pretty",
"-p","json:target/cucumber-reports/Cucumber.json",
"-p", "html:target/cucumber-reports",
"-m"
}
);
}
catch(Exception e) {
System.out.println("Main method exception");
}
}
}

CucumberRunner.java
In standalone cucumber runner class options are represented with tags, glue, plugin and etc.
package com.sadakar.cucumber.runner;

import org.junit.runner.RunWith;
import cucumber.api.CucumberOptions;
import cucumber.api.junit.Cucumber;


@RunWith(Cucumber.class)
@CucumberOptions
(
features="classpath:features",
tags="@scenario_AddAccountPage",
glue={"com.sadakar.cucumber.stepdefinitions/","com.sadakar.cucumber.common"},
plugin = { "pretty", "json:target/cucumber-reports/Cucumber.json",
"junit:target/cucumber-reports/Cucumber.xml",
"html:target/cucumber-reports"},
monochrome = true
)

public class CucumberRunner {



}


MANIFEST.FM

Manifest-Version: 1.0
Built-By: Sadakar
Class-Path: cucumber-java-1.2.5.jar cucumber-core-1.2.5.jar cucumber-h
 tml-0.2.3.jar cucumber-jvm-deps-1.0.5.jar gherkin-2.12.2.jar cucumber
 -junit-1.2.5.jar junit-4.12.jar hamcrest-core-1.3.jar selenium-java-3
 .141.59.jar selenium-api-3.141.59.jar selenium-chrome-driver-3.141.59
 .jar selenium-edge-driver-3.141.59.jar selenium-firefox-driver-3.141.
 59.jar selenium-ie-driver-3.141.59.jar selenium-opera-driver-3.141.59
 .jar selenium-remote-driver-3.141.59.jar selenium-safari-driver-3.141
 .59.jar selenium-support-3.141.59.jar byte-buddy-1.8.15.jar commons-e
 xec-1.3.jar guava-25.0-jre.jar jsr305-1.3.9.jar checker-compat-qual-2
 .0.0.jar error_prone_annotations-2.1.3.jar j2objc-annotations-1.1.jar
  animal-sniffer-annotations-1.14.jar okhttp-3.11.0.jar okio-1.14.0.ja
 r log4j-1.2.17.jar poi-4.1.0.jar commons-codec-1.12.jar commons-colle
 ctions4-4.3.jar commons-math3-3.6.1.jar poi-ooxml-4.1.0.jar poi-ooxml
 -schemas-4.1.0.jar commons-compress-1.18.jar curvesapi-1.06.jar xmlbe
 ans-3.1.0.jar poi-scratchpad-4.1.0.jar
Created-By: Apache Maven 3.6.3
Build-Jdk: 1.8.0_181
Main-Class: com.inovalon.selenium.common.BasePage


maven-assembly-plugin in pox.xml


<plugin>
<!-- NOTE: We don't need a groupId specification because the group is
org.apache.maven.plugins ...which is assumed by default.
-->
<artifactId>maven-assembly-plugin</artifactId>
<version>3.1.1</version>
<configuration>
<archive>
<manifest>
<addClasspath>true</addClasspath>
<mainClass>com.sadakar.selenium.common.BasePage</mainClass>
</manifest>
</archive>
<descriptorRefs>
<descriptorRef>jar-with-dependencies</descriptorRef>
</descriptorRefs>
</configuration>
<executions>
<execution>
<id>make-assembly</id>
<phase>package</phase>
<goals>
<goal>single</goal>
</goals>
</execution>
</executions>
</plugin>


Eclipse command to generate the jar from Maven build: 
clean compile assembly:single install

Hope this helps someone in the community.

Cheers.!
Sadakar Pochampalli 

April 10, 2020

Programming is not always easy


ExcelUtils.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
package com.sadakar.excel.utilities;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.sadakar.resource.utilities.Log;

public class ExcelUtils {

public static XSSFSheet ExcelWSheet;

public static XSSFWorkbook ExcelWBook;

public static XSSFCell Cell;

public static String currentDir = System.getProperty("user.dir");

// public static final String currentDir = System.getProperty("user.dir");

// This method is to set the File path and to open the Excel file, Pass
// Excel Sheet name as Arguments to this method

public static InputStream getResource(String filename) {
InputStream inputStream = ExcelUtils.class.getResourceAsStream(filename);
if (null == inputStream) {
//fail("Resource not found: `" + filename + "`");
Log.error("Resource not found: `" + filename + "`");
}
return inputStream;
}

public static void setExcelFile(String fileName, String SheetName)
throws Exception {

InputStream ExcelFile = null;

try {
String testEnv = System.getProperty("testEnv");
if (testEnv != null && testEnv.equalsIgnoreCase("local")) {

//This piece of code search for the excel file where the jar is generated or deployed
fileName = "./" + fileName;
ExcelFile = new FileInputStream(fileName);


//This code ships the excel file into the jar
//ExcelFile = getResource("/data/SMAPI_UI_Automation.xlsx");

} else {
fileName = "/data/" + fileName;
ExcelFile = getResource(fileName);
}

ExcelWBook = new XSSFWorkbook(ExcelFile);
ExcelWSheet = ExcelWBook.getSheet(SheetName);

} catch (FileNotFoundException e) {
System.out.println("Excel Reading have problems : " + e);
Log.error("Excel Reading have problems : " + e);
}
}

// This method is to read the test data from the Excel cell, in this we are
// passing parameters as Row num and Col num
public static String getCellData(int RowNum, int ColNum) throws Exception {
try {

Cell = ExcelWSheet.getRow(RowNum).getCell(ColNum);
DataFormatter formatter = new DataFormatter();
String CellData = formatter.formatCellValue(Cell);
return CellData;

} catch (Exception e) {
return "";
}
}

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package com.sadakar.cucumber.stepdefinitions;
import org.openqa.selenium.By;
import org.openqa.selenium.WebElement;
import com.sadakar.excel.utilities.ExcelUtils;
import com.sadakar.resource.utilities.Log;
import com.sadakar.selenium.common.BasePage;
import cucumber.api.java.en.Then;
import org.junit.Assert;
import java.util.concurrent.TimeUnit;

public class AddAccount extends BasePage{

ExcelUtils eu = new ExcelUtils();

public void readAccountsData() throws Exception{

try {
Log.debug("Reading Accounts Excel data file");
ExcelUtils.setExcelFile("Accounts_Test_Data_Automation.xlsx", "Accounts");
}
catch(Exception e) {
System.out.println("\n Unable to read excel file or Sheet:\n"+e);
Log.error("\n Unable to read excel file or Sheet:\n"+e);
throw e;
}

try {

Log.debug("---------Accounts Test Data------------");
System.out.println("---------Accounts Test Data-------");

readAccountsData();

Log.debug("AccountID* ="+ExcelUtils.getCellData(1,1));
Log.debug("AccountName* ="+ExcelUtils.getCellData(2,1));

System.out.println(ExcelUtils.getCellData(1,1)+"\n");
System.out.println(ExcelUtils.getCellData(2,1)+"\n");

Log.debug("-----------------------------------------");
System.out.println("---------------------------------");

}catch(Exception e) {
Log.error("Unable to display Accounts test data"+e);
System.out.println("Unable to display Accounts test data"+e);
}
}
}

April 10, 2020

Hi,
In this post




1
2
3
4
5
6
7
8
public static InputStream getResource(String filename) {
InputStream inputStream = ExcelUtils.class.getResourceAsStream(filename);
if (null == inputStream) {
//fail("Resource not found: `" + filename + "`");
Log.error("Resource not found: `" + filename + "`");
}
return inputStream;
}

April 10, 2020

April 2, 2020

This is an extended tutorial of my post back in 2015, today, I needed to implement the same and struggled to get the old example working, so, thought of documenting it again with server export available for the community. 

https://jasper-bi-suite.blogspot.com/2015/01/tip-intercharts-drill-down-technique-in.html
Tip : Intra charts/components linking technique in Jasper reports : HTML5 charts inter linking with in report in Jasper Studio 6.x

Problem Statement : 
How to drill down with in the report ? How to get dynamic data displayed in a table component when performed click action on particular slices from Pie Chart ?

Pie : Number of cars by Occupation
Table : Details of customer by occupation





Solution :  
1) Create a parameter say : $P{paramOccupation} for main report and give default value
         In this example default value is given as "Manual"
2) Create a data set and create the same parameter and filter the query with this parameter.
3) Design Pie graph and table component.
4) For the Pie graph category create Bucket Property
        paramOccupation = $F{paramOccupation}
4) For the pie graph Hyperlink give _report = path of the same report from J.Server.
    and add parameter as shown in below image.
  i.e.,
(NOTE : Assuming the report is published already to the server)

_report="/Praveen/Drill_with_in_reports"                  
  paramOccupation=Level1.paramOccupation   (This is the Bucket property created for category)


5) Make sure the table component "Dateset" is added with Parameter
       i.e., In table component properties --> Parameters -->
         Add paramOccupation=${paramOccupation}

6) Re publish the report to Jasper Server and hide the paramOccupation parameter
         
Download the server zip file for live example :  Click Me
Import this zip to your jasper server and run "Drill with in report" report from "Praveen" folder


JRXML: 
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Drill with in reports" pageWidth="1000" pageHeight="842" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4b0b908c-5907-4119-9d85-00671c2494af">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.reportUnit" value="/Praveen/Drill_with_in_reports"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="ireport.jasperserver.report.resource" value="/Praveen/Drill_with_in_reports_files/main_jrxml"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="Dataset1-table" uuid="24749c25-55a5-49c2-be2d-f5dc1ec06acb">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="paramOccupation" class="java.lang.String"/>
<queryString>
<![CDATA[select * from customer where occupation= $P{paramOccupation} limit 10]]>
</queryString>
<field name="customer_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="account_num" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="account_num"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="lname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="lname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="mi" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="mi"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address3" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address3"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address4" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address4"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="city" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="city"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="state_province" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="state_province"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="postal_code" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="postal_code"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="country" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="country"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="customer_region_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_region_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="birthdate" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="birthdate"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="marital_status" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="marital_status"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="yearly_income" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="yearly_income"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="gender" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="gender"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="total_children" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="total_children"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_children_at_home" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_children_at_home"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="education" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="education"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="date_accnt_opened" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="date_accnt_opened"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="member_card" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="member_card"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="houseowner" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="houseowner"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_cars_owned" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_cars_owned"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fullname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fullname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
</subDataset>
<parameter name="paramOccupation" class="java.lang.String">
<defaultValueExpression><![CDATA["Manual"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select occupation, sum(num_cars_owned) cars  from customer
group by occupation
 order by occupation]]>
</queryString>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="cars" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="cars"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="420" splitType="Stretch">
<componentElement>
<reportElement x="0" y="80" width="400" height="340" uuid="07f8444d-5b85-4950-aefc-4e4b3f62c16c"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{occupation}]]></bucketExpression>
<labelExpression><![CDATA[]]></labelExpression>
<bucketProperty name="paramOccupation"><![CDATA[$F{occupation}]]></bucketProperty>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns"/>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["Cars"]]></labelExpression>
<valueExpression><![CDATA[$F{cars}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1">
<hc:contributor name="SeriesItemHyperlink">
<hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Self"/>
<hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/>
<hc:contributorProperty name="_report" valueType="Expression">
<hc:valueExpression><![CDATA["/Praveen/Drill_with_in_reports"]]></hc:valueExpression>
</hc:contributorProperty>
<hc:contributorProperty name="paramOccupation" valueType="Bucket" value="Level1.paramOccupation"/>
</hc:contributor>
</hc:series>
</hc:chart>
</componentElement>
<componentElement>
<reportElement x="420" y="60" width="540" height="60" uuid="100a6fe4-7159-4de7-a8af-ec3abb357d30">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
</reportElement>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="Dataset1-table" uuid="10d6d999-3da9-4530-b062-fe2fc3cd4330">
<datasetParameter name="paramOccupation">
<datasetParameterExpression><![CDATA[$P{paramOccupation}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="110" uuid="6eabdd56-6307-4a16-b24d-0bd7f9d8af20">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="110" height="30" uuid="8a77e308-071d-4305-b50d-0a4c2469db0c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[account_num]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="110" height="30" uuid="894b8b9c-47e8-4943-9ce9-1d5d9da3895d"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{account_num}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="130" uuid="bd701c03-37dd-4ac7-9d88-bbd6ad9e6ef3">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="130" height="30" uuid="e0a9941b-2b4e-473c-98bf-c1dc4039b841"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[occupation]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="130" height="30" uuid="8d464964-5455-4479-9ff3-30badb9dbc13"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="140" uuid="ec42ddc4-b560-400f-ae5c-2661a02e2607">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="140" height="30" uuid="81af8ec1-0046-4c1e-87dd-fdc7693678b9"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[country]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="140" height="30" uuid="bb5ab017-42ca-49cd-847a-94c55853cc52"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="160" uuid="313a65a4-3caa-494e-a6fb-502eb5030755">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="160" height="30" uuid="ceb0dd75-ca3f-4351-a343-93e4d33515f0"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[total_children]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="160" height="30" uuid="ef9155f3-1e33-405f-9b7f-861d02b5fd95"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{total_children}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
<textField>
<reportElement x="30" y="20" width="130" height="30" uuid="859c4814-f726-45ab-b928-07af80779061"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{paramOccupation}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>

April 2, 2020

March 31, 2020

In this post, you will see java snippet inputs for  calling chromedriver.exe file eclipse project relative path.

1) Create folder "drivers" for the project.

2) Upload the chromedriver.exe file as shown in below image. (chromedriver_80 another folder created under drivers folder)

3) Right click on the "chromedriver.exe" and make note of the path
     for example : /Jaspersoft Automation/drivers/chromedriver_80/chromedriver.exe

4) Define a key-value pair for the driver path in configuration.properties file
     chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe

5) While setting System property for driver, give the relative path 
System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);

Run the project using Junit and observe that the driver instantiated from the relative path provided.

Detailed code snippets follows....



configuration.properties 

# Give this relative path of the driver uploaded for "drivers" folder in eclipse project.
chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe

Code snippet in CommonFunctions.java file i.e., instantiating the chrome driver

public void initDriver() {

String chromeDriverPath=PropertyManager.getInstance().getChormeDriverPath();

String path = System.getProperty("user.dir");
System.out.println(path); 

System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);

}

getChromeDriverPath() is the method defined in PropertyManager.java

public class PropertyManager {

     private static PropertyManager instance;
    private static final Object lock = new Object();
    //private static String propertyFilePath=System.getProperty("user.dir") + "\\configuration.properties"; 
    private static String app_mangt_url;
    private static String auth_uname_pwd_autoit_path;
    private static String chrome_driver_path;
    private static String browser_type;
    private static String ie_driver_path;
    private static String auth_uname_pwd_autoit_path_ie;
 
    //Create a Singleton instance. We need only one instance of Property Manager.
    public static PropertyManager getInstance () {
        if (instance == null) {
            synchronized (lock) {
                instance = new PropertyManager();
                instance.loadData();
            }
        }
        return instance;
    }

    //Get all configuration data and assign to related fields.
    private void loadData() {
        //Declare a properties object
        Properties prop = new Properties();

        //Read configuration.properties file
        try {
            //prop.load(new FileInputStream(propertyFilePath));
                               prop.load(this.getClass().getClassLoader().getResourceAsStream("configuration.properties"));
        } catch (IOException e) {
            System.out.println("Configuration properties file cannot be found");
        }

        //Get properties from configuration.properties
        app_mangt_url = prop.getProperty("app_mangt_url");
        auth_uname_pwd_autoit_path=prop.getProperty("auth_uname_pwd_autoit_path");
        chrome_driver_path=prop.getProperty("chrome_driver_path");
        browser_type=prop.getProperty("browser_type");
        ie_driver_path=prop.getProperty("ie_driver_path");
     
        auth_uname_pwd_autoit_path_ie=prop.getProperty("auth_uname_pwd_autoit_path_ie");

    }

    public String getAppMangtURL () {
      return app_mangt_url;
    }
    public String getAuthUnamePwdAutoIT () {
        return auth_uname_pwd_autoit_path;
      }
    public String getChormeDriverPath () {
        return chrome_driver_path;
      }
    public String getbrowserType () {
        return browser_type;
      }
    public String getIEDriverPath () {
        return ie_driver_path;
      }
    public String getAuthUnamePwdAutoITIE () {
        return auth_uname_pwd_autoit_path_ie;
      }

}

Hope this helps you.

Cheers.!

March 31, 2020

March 30, 2020

Hi,

In this post, I'd like to share my experience on automating jaspersoft login page using valid (not invalid) credentials using cucumber frame work.

The core of this post is how to generate jar file to run the cucumber project/features from command prompt. You can watch the below  video tutorial for the whole project flow, coding inputs, etc. and I hope this will be helpful for someone in the community.

Watch this ~15 min video tutorial for the cucumber execution flow and for some coding inputs




Below are the steps for core part that is how to generate jar and run cucumber project from jar file.

1) In the pom.xml ensure to provide plugin details for jar and mainClass.
    This is used to generate the manifest file where the project execution starts when execute the jar from command prompt.

2) Write a main method and pass the cucumber options as String to the Main class.

3) Run the project as Maven build by providing : clean package shade:shade 

4) Note down the path of the generated jar

5) Open command prompt and navigate to the path run this command
          java -jar <GeneratedJarFile>


pom.xml plugin snippet for jar:
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jar-plugin</artifactId>
<version>3.2.0</version>
<configuration>
      <archive>
          <manifest>
             <addClasspath>true</addClasspath>
                <mainClass>com.sadakar.selenium.common.BasePage</mainClass>
          </manifest>
      </archive>
                </configuration>

</plugin>

calling main method with cucumber options as input
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
public  static WebDriver driver;
public static void main(String args[]) throws Throwable{
try {
cucumber.api.cli.Main.main(
new String[]{
"classpath:features",
"-t","@ValidLogin",
"-g", "com.sadakar.cucumber.stepdefinitions/", 
"-g","com.sadakar.cucumber.common",
"-p","pretty", 
"-p","json:target/cucumber-reports/Cucumber.json",
"-p", "html:target/cucumber-reports",

}
             ); 
}
catch(Exception e) {
System.out.println("Main method exception");
}

}

}

Build the jar file : clean package shade:shade


Navigate to the target folder where jar is generated and running it.
C:\Users\sadakar\eclipse-workspace\Jaspersoft Automation\target>java -jar Jaspersoft_Automation-0.0.1-SNAPSHOT.jar

Click on the image to get the best view of the content:


Sample output:

March 30, 2020

March 28, 2020

Software : 
----------------
1) J. Studio 7.2 pro
2) Jasperreports server 7.5 Enterprise


Requirement :
-----------------
Drill down to customer detailed report from customer total number of cars by occupation
i.e., Pie graph to tabular data.

Watch 10 min video tutorial: 


Click on image to get best view of content: 

SQL query :
--------------
Parent report :
-----------------
select occupation, sum(num_cars_owned) cars  from customer
group by occupation
order by occupation

Child report:
-----------------
select * from customer where occupation= $P{paramOccupation}

Steps :
-----------
1. Design Parent report with Pie graph.
2. Design Child report with tabular data having "paramOccupation" parameter.
3. Publish Parent report and unit test the output.
4. Publish Child report and unit test the output with various input values for the parameter.

Hyperlinking/Drill down to the Child report from Parent report
----------------------------------------------------------------
1. Edit the Pie vizz. of Parent report.

2. For Categories Levels, create "Bucket Properties" i.e., paramOccupation=$F{occupation}

3. For Measures, click on "Edit Hyperlink" -> check "Use Hyperlink"

4. Click on _report[SeriesItemHyperlink] -> Use Constant value i.e.,_report=/Praveen/Child

5. Clcik on Add to link the parameter
 
   PropertyName=paramOccupation
   UseBucketValue=Level1.paramOccupation

Click on image to get best view of content:  


Post linking steps:
----------------------
1. Re-publish the Parent report.
2. In the server, edit the child report --> navigate to "Controls and Resources"
3. Change : Display Mode= In Page and un-check "Always prompt"

NOTE:
---------
1. In the Child report JRXML, for the parameter, check the "Is For Prompting" property.




March 28, 2020

Hi All, Find detailed post about steps to be taken to create a connection to your google drive using Talend. 1. Obtain access token to your google drive account. a. Go to Google API Console b. Create a new project,...

March 28, 2020

March 24, 2020

Hi,

In this post, you will see tips on how to authenticate a website that is based on windows authentication. 
Reader is assumed to have some prior fundamental knowledge on the java-selenium-cucumber framework/setup. 

NOTE: 
This post is not written to give step-by-step procedure instead written to give direct inputs on specific areas. 

Sample cucumber feature file and scenario: 

@feature_login
Feature: Launch internet browser and login with valid credentials
  This is a windows based authentication for sadakar.selenium.com site using internet browser.

  @senario_loginsadakar.selenium.com
  Scenario: Login to sadakar.selenium.com with internet explorer windows based authentication
    When I open internet explorer browser
    Then I login with username and password and navigate to sadakar.selenium.com


Problem statement : 
When you try to open sadakar.selenium.com and if the website is configured for windows based authentication as shown in below image - how do you navigate to the site using java-selenium code ? 

Click on the image to get best view of the content: 
Solution : 
1) Install latest Auto IT tool ( download : https://www.autoitscript.com/site/autoit/downloads/ )
2) Then : 
        a) Open the website with its security pop-up for windows based authentication 
        b) Open the AutoIt tool on top of the the website's windows security pop-up. 
3) Hold on "Finder Tool" on AutoIT and drag that on to the security pop-up window. 
4) Note down "Title" and "Class" in the AutoIt tool. 

Click on the image to get best view of the content: 


5) Now, in Notepad++ file write below code and save it as "autoit_ie.au3"

$sUsername = "SADA001\administrator"
$sPassword = "SADAPassWord@001"
$sTitle = WinGetTitle("Windows Security")
Sleep(1000)
    If $sTitle = "Windows Security" or WinWaitActive("[CLASS:Credential Dialog Xaml Host]") or WinWaitActive("Windows Security") or WinWaitActive("iexplore.exe") or WinWaitActive("Connecting to sadakar.selenium.com")Then
        Send($sUsername)
        Send("{TAB}")
        Send($sPassword,1)
        Send("{TAB}")
        Send("{ENTER}")
    EndIf

6) Right click on the saved file and compile it (just compile) and you would see "autoit_ie.exe" generated in the folder where you saved your au3 file. 

NOTE : 
if you try open this .exe, you would see some encrypted data that will not be readable. 

7) How to call the generated autoit_ie.exe file in java-selenium. 

  public void getCredentialsFromAutoITExe() {
try {
Log.debug("Reading Username and Password from IE AutoIT exe file");
                                 System.out.println("Reading Username and Password from IE AutoIT exe file");
Runtime.getRuntime().exec("D:\\autoit_ie.exe");
Log.debug("Read Username and Password from AutoIT exe file");
}
 
}catch(Exception e) {
Assert.fail("failed to Read Username and Password from AutoIT exe file");
System.out.println("failed to read credentials from AutoIT exe file"+" "+e);
}
}

 public void getAppManagementURL() {

Log.debug("Authenticating to sadakar.selenium.com URL");
 driver.get("http://sadakar.selenium.com/");
                  Log.debug("Authenticated to Application URL and opened the site                             
                       http://sadakar.selenium.com/");
}

7) When you run your project (in my case its a maven-java-selenium-junit-cucumber) the pop-up should read the username and password from the auto_it.exe file and fill the corresponding values as shown in below image.

NOTE : 
Runtime.getRuntime().exec("auto it exe file path") should be called before driver.get("URL")


Thank you, for stopping by and I hope it helps someone in the community. 

March 24, 2020

March 13, 2020

Hi ,

This is an introductory article on automating the Jaspersoft reports server user activities. In this tutorial, you would learn how to effectively implement cucumber framework with java selenium for Jaspersoft server.

NOTE : 
1) Assuming, the reader should already have basic knowledge on all the software's or technologies mentioned below.

Software's used: 
1) Eclipse - Version: 2.3.0.v20191210-0610, Build id: I20191210-0610
2) Java 1.8
3) Maven build tool (default comes with Eclipse)
4) Cucumber 1.2.5
5) Cucumber Junit 1.2.5
6) Junit 4.12
7) Log4j 1.2.17
8) Google Chrome Browser : Version 80.0.3987.132 (Official Build) (64-bit)
9) Jaspersoft 7.5 Community Server

Automation flow architecture: 

Click on the image to view in non-scroll mode or to view the whole flow:




Note that you may have to download and point to correct chromedriver.exe driver. This demonstration is used chrome driver 80 versioned driver.

To get a copy of this demo, drop me a message at
LinkedIn


Video tutorial : Execution flow of the project
TBD

Steps: 
1) Creating a new Maven project

       File -> New -> Project -> Maven -> Maven Project
         (Jaspersoft Automation is the project  name)

2) Add log4j library to the project build path.
     
3) Ensure installed JRE points to locally installed jdk as shown in below image. 
    i.e., C:\Program Files\Java\jdk1.8.0_181


4)  The final project folder structure is as follows.

5) pom.xml

This will download and install the required libraries for the project. 

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>SMAPI_UI_POC</groupId>
  <artifactId>SMAPI_UI_POC</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>SMAPI_UI_POC</name>
  <description>SMAPI_UI_POC</description>
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  <dependencies>

  <!--  cucumber-java -->
<!-- https://mvnrepository.com/artifact/info.cukes/cucumber-java -->
<dependency>
    <groupId>info.cukes</groupId>
    <artifactId>cucumber-java</artifactId>
    <version>1.2.5</version>
</dependency>

  <!--  cucumber-junit -->
<!-- https://mvnrepository.com/artifact/info.cukes/cucumber-junit -->

<dependency>
    <groupId>info.cukes</groupId>
    <artifactId>cucumber-junit</artifactId>
    <version>1.2.5</version>
</dependency>
<!--
<dependency>
        <groupId>io.cucumber</groupId>
        <artifactId>cucumber-junit</artifactId>
        <version>3.0.2</version>
        <scope>test</scope>
    </dependency>
-->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java -->
<dependency>
    <groupId>org.seleniumhq.selenium</groupId>
    <artifactId>selenium-java</artifactId>
    <version>3.141.59</version>
</dependency>
  </dependencies>

  <build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.21.0</version>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>

6) configuration.properties

Read values from properties file 

chrome_driver_path=D:\\chromedriver_80\\chromedriver.exe
jaspersoft_server_url=http://localhost:8080/jasperserver
user_id=jasperadmin
password=jasperadmin

7) 001_LoginJaspersoftServer.feature 

Cucumber feature file with valid and invalid login scenarios using Scenario Outline concept.
This code of language is called as Gherkin 

#Author: sadakar.pochampalli
# https://docs.katalon.com/katalon-studio/docs/cucumber-features-file.html#maintain-features-file
# https://riptutorial.com/cucumber/example/28790/scenario-outline
#https://www.tutorialspoint.com/cucumber/cucumber_scenario_outline.htm
@Login
Feature: Login feature

  As a admin user, I want to login to Jaspersoft Server so that
  I can run the reports, dashboards, create ad-hoc reports and etc.

  @ValidLogin
  Scenario Outline: Login with valid credentials
    Given Chrome browser and Jaspersoft login page
    When I enter User Id as "<UserId>" and Password as "<Password>"
    And I click on Login button
    Then I should be able to login successfully

    Examples:
      | UserId      | Password    |
      | jasperadmin | jasperadmin |
      | joeuser     | joeuser     |

  @InvalidLogin
  Scenario Outline: Login with Invalid credentials
    Given Chrome browser and Jaspersoft login page
    When I enter User Id as "<UserId>" and Password as "<Password>"
    And I click on Login button
    Then I should NOT be able to login successfully

    Examples:
      | UserId  | Password    |
      | baduser | jasperadmin |
      | joeuser | badpassword |
      | baduser | badpassword |

8) log4j.properties

DEBUG, ERROR, INFO logs displayed in file at : D:\\jasper_selenium\\jasper_selenium.logs

# Root logger option
log4j.rootLogger=DEBUG,stdout,dest1,ERROR,INFO

# Direct log messages to a log file
log4j.appender.dest1=org.apache.log4j.RollingFileAppender
log4j.appender.dest1.File=D:\\jasper_selenium\\jasper_selenium.logs
log4j.appender.dest1.MaxFileSize=10MB
log4j.appender.dest1.MaxBackupIndex=10
log4j.appender.dest1.layout=org.apache.log4j.PatternLayout
log4j.appender.dest1.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
log4j.appender.dest1.Append=false

# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

#ERROR
log4j.appender.ERROR=org.apache.log4j.RollingFileAppender
log4j.appender.ERROR.layout=org.apache.log4j.PatternLayout
log4j.appender.ERROR.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
#log4j.appender.ERROR.File=D:\\smapiui_logs\\smapi_ui.logs

#INFO
log4j.appender.INFO=org.apache.log4j.RollingFileAppender
log4j.appender.INFO.layout=org.apache.log4j.PatternLayout
log4j.appender.INFO.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
#log4j.appender.INFO.File=D:\\smapiui_logs\\smapi_ui.logs

9) Hooks.java - This class displays each scenario name with it's status. 

package com.sadakar.cucumber.common;
import com.sadakar.resource.utilities.Log;
import cucumber.api.Scenario;
import cucumber.api.java.After;
import cucumber.api.java.Before;

public class Hooks {
@Before(order=0)
public void before(Scenario scenario) {
    System.out.println("------------------------------");
    Log.info("------------------------------");
    Log.info("Scenario: '" + scenario.getName() );
    Log.info("******************************");
    System.out.println("Starting - " + scenario.getName());
    System.out.println("------------------------------");
}
@After(order=0)
public void after(Scenario scenario) {
    System.out.println("------------------------------");
    Log.info("Scenario: '" + scenario.getName() + "' has status " + scenario.getStatus());
    Log.info("******************************");
    Log.info("------------------------------");
    System.out.println(scenario.getName() + " Status - " + scenario.getStatus());
    System.out.println("------------------------------");
}
}

10) CucumberRunner.java

In this class, give path for the features, glue code, which scenarios to test/run and cucumber plugins such as reports in various formats

package com.sadakar.cucumber.runner;
import org.junit.runner.RunWith;
import cucumber.api.CucumberOptions;
import cucumber.api.junit.Cucumber;

@RunWith(Cucumber.class)
@CucumberOptions
(
features="classpath:features",
tags="@ValidLogin,@InvalidLogin",
glue={"com.sadakar.cucumber.stepdefinitions/","com.sadakar.cucumber.common"},
plugin = { "pretty", "json:target/cucumber-reports/Cucumber.json",
"junit:target/cucumber-reports/Cucumber.xml",
"html:target/cucumber-reports"},
monochrome = true
)
public class CucumberRunner {

}

11) LoginToJaspersoft.java

In this class define the step definitions for the scenarios. This code is called glue code. Wherever required, add the wait, sleep statements based on the logon speed of your jaspersoft server. 

package com.sadakar.cucumber.stepdefinitions;

import com.sadakar.resource.utilities.Log;
import com.sadakar.selenium.common.BasePage;
import com.sadakar.selenium.common.CommonFunctions;
import cucumber.api.java.en.And;
import cucumber.api.java.en.Given;
import cucumber.api.java.en.Then;
import cucumber.api.java.en.When;
import java.util.concurrent.TimeUnit;
import org.junit.Assert;
import org.openqa.selenium.By;
import org.openqa.selenium.Keys;

public class LoginToJaspersoft extends BasePage{
CommonFunctions cf = new CommonFunctions();
@Given("^Chrome browser and Jaspersoft login page$")
public void chrome_browser_and_Jaspersoft_login_page() throws Throwable {
try {    
cf.initDriver();
cf.maximizeDriver();
driver.manage().timeouts().implicitlyWait(15, TimeUnit.SECONDS);
cf.getJapsersoftURL();
driver.manage().timeouts().implicitlyWait(60, TimeUnit.SECONDS);
}
catch(Exception e) {
Log.error("failed to open the Japsersoft URL or Login page"+e);
Assert.fail("failed to open the Japsersoft URL or Login page"+e);
}
}

@When("^I enter User Id as \"([^\"]*)\" and Password as \"([^\"]*)\"$")
public void i_enter_User_Id_as_and_Password_as(String arg1, String arg2) throws Throwable {
  Log.debug("Enter User Id");
  driver.findElement(By.xpath("//*[@id='j_username']")).sendKeys(arg1+Keys.TAB);
  Log.debug("Enter tab");
  Log.debug("Enter Password");
      driver.findElement(By.xpath("//*[@id='j_password_pseudo']")).sendKeys(arg2+Keys.TAB);
      Log.debug("Enter tab");
}
@And("^I click on Login button$")
public void i_click_on_Login_button() throws Throwable {
Log.debug("Click Login button");
      driver.findElement(By.xpath("//*[@id='submitButton']")).click();  
      Thread.sleep(5000);
}

@Then("^I should be able to login successfully$")
public void i_should_be_able_to_login_successfully() throws Throwable {
if(driver.getCurrentUrl().equalsIgnoreCase(
      "http://localhost:8080/jasperserver/flow.html?_flowId=searchFlow")){
         Log.debug("Login Successfull");
      } else { 
         Log.debug("Login NOT Success full");
         Assert.fail("Login NOT Success full");
      } 
driver.close(); 
driver.quit();
}
@Then("^I should NOT be able to login successfully$")
public void i_should_NOT_be_able_to_login_successfully() throws Throwable {
if(driver.getCurrentUrl().equalsIgnoreCase(
      "http://localhost:8080/jasperserver/login.html?error=1")){
         Log.debug("Invalid Login Successfull");
      } else { 
         Log.debug("Invalid Login NOT Success full");
         Assert.fail("Invalid Login NOT Success full");
      } 
driver.close(); 
driver.quit();
}
}

12) Log.java

package com.sadakar.resource.utilities;
import org.apache.log4j.Logger;
public class Log {

public static Logger log= Logger.getLogger(Log.class.getSimpleName());
//Logger log2 = Logger.getLogger("devpinoyLogger");

/**
* To print Log for the start test case
* @param startTestCaseMessage
*/
public static void startTestCase(String startTestScenario ) {
log.info("********************* " + "S_T_A_R_T" + " *********************");
log.info("********************* " + startTestScenario + " *********************");
}

/**
* This is to print Log for the ending of the test case
* @param endTestCaseMessage
*/
public static void endTestCase(String endTestScenario) {
log.info("********************* " + "-E---N---D-" + " *********************");
log.info("********************* " + endTestScenario + " *********************");
}

public static void info(String infoMessage) {
log.info(infoMessage);
}

public static void warn(String warnMessage) {
log.warn(warnMessage);
}

public static void error(String errorMessage) {
log.error(errorMessage);
}

public static void fatal(String fatalMessage) {
log.fatal(fatalMessage);
}

public static void debug(String debugMessage) {
log.debug(debugMessage);
}

}

13) PropertyManager.java

package com.sadakar.resource.utilities;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;
public class PropertyManager {
private static PropertyManager instance;
    private static final Object lock = new Object();
    private static String propertyFilePath=System.getProperty("user.dir") + "\\configuration.properties";    
    private static String jaspersoft_server_url;
    private static String chrome_driver_path;
    private static String user_id;
    private static String password;
    
    //Create a Singleton instance. We need only one instance of Property Manager.
    public static PropertyManager getInstance () {
        if (instance == null) {
            synchronized (lock) {
                instance = new PropertyManager();
                instance.loadData();
            }
        }
        return instance;
    }
    //Get all configuration data and assign to related fields.
    private void loadData() {
        //Declare a properties object
        Properties prop = new Properties();
        //Read configuration.properties file
        try {
            prop.load(new FileInputStream(propertyFilePath));
            //prop.load(this.getClass().getClassLoader().getResourceAsStream("configuration.properties"));
        } catch (IOException e) {
            System.out.println("Configuration properties file cannot be found");
        }
        //Get properties from configuration.properties
        jaspersoft_server_url = prop.getProperty("jaspersoft_server_url");
        chrome_driver_path=prop.getProperty("chrome_driver_path");
        user_id=prop.getProperty("user_id");
        password=prop.getProperty("password");

    }
    public String getAppMangtURL () {
      return jaspersoft_server_url;
    }
    public String getChormeDriverPath () {
        return chrome_driver_path;
      }
    
    public String getUserId () {
        return user_id;
      }
      public String getPassword () {
          return password;
        }
}

14) Basepage.java

package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;

public class BasePage {
public  static WebDriver driver;
public static void main(String args[]){
}

}

15) CommonFunctions.java

package com.sadakar.selenium.common;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import com.sadakar.resource.utilities.Log;
import com.sadakar.resource.utilities.PropertyManager;

import org.openqa.selenium.PageLoadStrategy;
public class CommonFunctions extends BasePage{
String chromeDriverPath=PropertyManager.getInstance().getChormeDriverPath();
String appMangtURL = PropertyManager.getInstance().getAppMangtURL();

public void initDriver() {
Log.debug("finding chrome driver path");
System.setProperty("webdriver.chrome.driver",chromeDriverPath);
Log.debug("Chrome driver path found");
Log.debug("Initiate Chrome driver");
ChromeOptions options = new ChromeOptions();
        //options.addArguments("--headless");
        options.addArguments("--disable-gpu");
        options.setPageLoadStrategy(PageLoadStrategy.NONE);
        options.addArguments("--allow-insecure-localhost");
        options.addArguments("--allow-running-insecure-content");
        options.addArguments("--ignore-certificate-errors");
        options.addArguments("--no-sandbox");
        options.addArguments("--window-size=1280,1000");
        options.setCapability("acceptSslCerts", true);
        options.setCapability("acceptInsecureCerts", true);
        
driver = new ChromeDriver(options);
Log.debug("Chrome driver is being initiated");
}
public void maximizeDriver() {
Log.debug("Maximize Chrome Browser");
driver.manage().window().maximize();
Log.debug("Chrome Browser maximized");
}
public void getJapsersoftURL() {
Log.debug("Authenticating to Jaspersoft Reports Server");
//System.out.println("App magt URL="+appMangtURL);
//driver.get("http://management.myabilitynetwork.lab/");
        driver.get(appMangtURL);
        Log.debug("Enter User ID and Password");
}
public void closeDriver() {
Log.debug("Closing driver: Closing browser");
driver.close();
Log.debug("Driver is closed: Closed browser");
}
public void quitDriver() {
Log.debug("Closing driver session");
driver.quit();
Log.debug("Driver session is closed");
}

}

16) Cucumber reports




17) jasper_selenium.logs

2020-03-13 19:22:57 INFO  Log:30 - ------------------------------
2020-03-13 19:22:57 INFO  Log:30 - Scenario: 'Login with valid credentials
2020-03-13 19:22:57 INFO  Log:30 - ******************************
2020-03-13 19:22:57 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:22:57 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:22:57 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:07 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:07 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:07 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:07 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:07 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:07 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:08 DEBUG Log:46 - Enter tab
2020-03-13 19:23:08 DEBUG Log:46 - Enter Password
2020-03-13 19:23:08 DEBUG Log:46 - Enter tab
2020-03-13 19:23:08 DEBUG Log:46 - Click Login button
2020-03-13 19:23:14 DEBUG Log:46 - Login Successfull
2020-03-13 19:23:15 INFO  Log:30 - Scenario: 'Login with valid credentials' has status passed
2020-03-13 19:23:15 INFO  Log:30 - ******************************
2020-03-13 19:23:15 INFO  Log:30 - ------------------------------
2020-03-13 19:23:15 INFO  Log:30 - ------------------------------
2020-03-13 19:23:15 INFO  Log:30 - Scenario: 'Login with valid credentials
2020-03-13 19:23:15 INFO  Log:30 - ******************************
2020-03-13 19:23:15 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:15 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:15 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:24 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:24 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:24 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:24 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:24 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:24 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:25 DEBUG Log:46 - Enter tab
2020-03-13 19:23:25 DEBUG Log:46 - Enter Password
2020-03-13 19:23:25 DEBUG Log:46 - Enter tab
2020-03-13 19:23:25 DEBUG Log:46 - Click Login button
2020-03-13 19:23:30 DEBUG Log:46 - Login Successfull
2020-03-13 19:23:31 INFO  Log:30 - Scenario: 'Login with valid credentials' has status passed
2020-03-13 19:23:31 INFO  Log:30 - ******************************
2020-03-13 19:23:31 INFO  Log:30 - ------------------------------
2020-03-13 19:23:31 INFO  Log:30 - ------------------------------
2020-03-13 19:23:31 INFO  Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:23:31 INFO  Log:30 - ******************************
2020-03-13 19:23:31 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:31 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:31 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:40 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:40 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:41 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:41 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:41 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:41 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:42 DEBUG Log:46 - Enter tab
2020-03-13 19:23:42 DEBUG Log:46 - Enter Password
2020-03-13 19:23:42 DEBUG Log:46 - Enter tab
2020-03-13 19:23:42 DEBUG Log:46 - Click Login button
2020-03-13 19:23:47 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:23:48 INFO  Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:23:48 INFO  Log:30 - ******************************
2020-03-13 19:23:48 INFO  Log:30 - ------------------------------
2020-03-13 19:23:48 INFO  Log:30 - ------------------------------
2020-03-13 19:23:48 INFO  Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:23:48 INFO  Log:30 - ******************************
2020-03-13 19:23:48 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:48 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:48 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:57 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:57 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:57 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:57 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:57 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:57 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:58 DEBUG Log:46 - Enter tab
2020-03-13 19:23:58 DEBUG Log:46 - Enter Password
2020-03-13 19:23:58 DEBUG Log:46 - Enter tab
2020-03-13 19:23:58 DEBUG Log:46 - Click Login button
2020-03-13 19:24:03 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:24:04 INFO  Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:24:04 INFO  Log:30 - ******************************
2020-03-13 19:24:04 INFO  Log:30 - ------------------------------
2020-03-13 19:24:04 INFO  Log:30 - ------------------------------
2020-03-13 19:24:04 INFO  Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:24:04 INFO  Log:30 - ******************************
2020-03-13 19:24:04 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:24:04 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:24:04 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:24:14 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:24:14 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:24:14 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:24:14 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:24:14 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:24:14 DEBUG Log:46 - Enter User Id
2020-03-13 19:24:15 DEBUG Log:46 - Enter tab
2020-03-13 19:24:15 DEBUG Log:46 - Enter Password
2020-03-13 19:24:15 DEBUG Log:46 - Enter tab
2020-03-13 19:24:15 DEBUG Log:46 - Click Login button
2020-03-13 19:24:20 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:24:21 INFO  Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:24:21 INFO  Log:30 - ******************************
2020-03-13 19:24:21 INFO  Log:30 - ------------------------------

March 13, 2020

Pages