Google Sheet- app scripting for giving formula with dynamic row value

 Hey folks,

If you want to give formula like =Mod((G9-E9),1)*24) in google app script than give it in below way.

var row=e.range.getRow();

e.source.getActiveSheet().getRange(row,9).setFormula("=Mod((G" + (row)+ "-F" + (row) + "),1)*24" );

Cheers.

TJ

Steps to implement Allure Reporting in Selenium java

 Hey Guys,

Steps to implement Allure reporting in selenium java framework.

Allure is an open-source framework designed to create interactive and comprehensive test report.

Each time when we run automation tests, we will have test results to view details about no. of tests passed, failed and failure details etc. And few reports also include test failure screenshots.

Allure report works

When we run our tests, every popular test framework generates junit-style xml report which will be used by Allure to generate HTML report. Allure reports has provided adapters for Java, PHP, Ruby, Python, Scala and C# test frameworks.

Steps to Generate Allure Reports

Install and configuration

• Install Allure report command line application
• do this manually by downloading the latest version as a zip archive from bintray.
• Unpack the archive to allure-command line directory
• Navigate to bin directory
• Add allure to system PATH.

Implementation in code

•            Create Maven project
•             Add allure maven dependencies in pom.xml file and also add  AspectJ Weaver dependency along with allure.
•             Create two test file in src/test/java folder and append the allure features in it for writing reports
•             Create Testng.xml file
•             We can add environment details in allure report by adding following
•   Environment.properties
•   Environment.xml
•              We can categories the failed cases/defects using categories.json file
• append the features of allure report to code like @step, @feature etc

 Run the code and generate the allure report

•  Go to command prompt and in project directory and run the command
• Mvn clean test
• Or run the code through eclipse/intelij
• Go to command prompt and generate the allure report in temporary folder using command
• Allure serve <path of allure report>  (Generate report in temporary folder)
• Allure generate <path of allure report> (Generate report in c:/user directory with allure folder)
• Allure open <path of allure report>
• Allure generate <path of allure report> --clean (will overwrite the existing report)

You can find more information on Allure documentation.

 Cheers.

TJ

Command to check version of softwares

 Hey Guys,

Recently i needed to check the versions of installed most of the time, so i thought to list down commands on finger tips.

• Java
• java -version
• nodeJS
• node -v
• npm -v
• newman
• newman -version
• install command : npm install -g newman
• Allure reports
• allure --version
• maven
• mvn -version
• Jenkin
• install command: java -jar Jenkins.war

Regards,

TJ

Smart way of Testing

Hey Folks,

Time to come up with some smart tools, which make your life easier.

1. To find the xpath from xml file : 

xpather.com 

2. To find the WSDL APIs: 

Install Google Chrome extension - wsdler

3. To test mobile app on emulator:

Install Google Chrome extension - Android online emulator

4. To do browser and excel automation without investing much time on commercial or freeware tool

Install Google Chrome extension - iMacros

Cheers,

TJ