How to setup the slow mode in Selenium RC using Java

How to setup the slow mode in Selenium RC using Java ?

I came across this issue several times when automating test scripts using Selenium RC & Java. In many instances you need to use the slow mode (especially when dealing with the dynamic components) in-order to run your script smoothly.

Following method can be used to set the selenium slow mode by pausing each and every step by limiting in to a specific time period (in milliseconds)

 //define a public string with the time limit you need to pause every step in milliseconds  
 public String timeout="6000";  
 //Add the initial steps to start selenium  
  RemoteControlConfiguration rc = new RemoteControlConfiguration();  
  seleniumserver = new SeleniumServer(rc);  
  selenium = new DefaultSelenium("localhost", 4444, browser, "http://");  
  seleniumserver.start();  
  selenium.start();  
 //Once the server is started then set the default timeout period ( in-order to emulate the slow mode )  
 selenium.setSpeed(timeout);  

How to Import Data from Web to an Excel Sheet

In order to import data from web and maintain an excel sheet you can simply use the feature of "Web Query" in the Data Tab in MS Excel.

Steps
1. Create a New Excel File
2. Go to Data > Web Query
3. Enter the URL of the Web Site you need to import data from
4. Then it will indicate the possible fields that you can extract data from using Yellow Arrows
5. Select the fields you want
6. Click on Import
7. Select the Sheet or cell range you need to populate the data
8. Ok

When ever you need to update your data, click on Refresh All which will Sync with the Web Site.

Reference: http://www.mrexcel.com/tip103.shtml

How To Automate Testing using Selenium

What is Selenium ?


"Selenium is a portable software testing framework for web applications. Selenium provides a record/playback tool for authoring tests without learning a test scripting language (Selenium IDE). It also provides a test domain-specific language (Selenese) to write tests in a number of popular programming languages, including C#, Java, Groovy, Perl, PHP, Python and Ruby. The tests can then be run against most modern web browsers. Selenium deploys on Windows, Linux, and Macintosh platforms"  [ Reference: http://en.wikipedia.org/wiki/Selenium_(software) ]

Further you may refer the main web site of Selenium for more details.  [ http://seleniumhq.org/ ]


Selenium IDE

• As a starting point, it would be nice to first setup Selenium IDE in your Firefox browser ( you can find the xpi from following url :  http://release.seleniumhq.org/selenium-ide/1.9.0/selenium-ide-1.9.0.xpi )
• Using Selenium IDE you can simply records the steps that you do in the web site and then you can play back them easily. 
• You may refer this article as a starting guide:  http://seleniumhq.org/docs/02_selenium_ide.html
• Further you can add assertions to your scripts and verify the values and enhance you scripts.
• But still if you wish to automate complex work flows in web sites using values from files, xml etc, it is recommended to move to Selenium RC using Java or any language you prefer to write test cases. But still Selenium IDE can used to record the basic flow and then Export to Java (or any supporting language) and then modify them and add more functionality using Java (or the supporting language)

Selenium RC

• The Selenium Server is needed in order to run either Selenium RC style scripts or Remote Selenium Webdriver ones
• You can download the Selenium RC server from following location. http://selenium.googlecode.com/files/selenium-server-standalone-2.25.0.jar

How to Start Test Automation using Java & Selenium RC

• Make sure you have downloaded the Selenium Server jar file from above link
• Record the script using Selenium IDE and export it to Java ( JUNIT )
• Add the java file to your project
• Add the Selenium Server jar file to your project as well 
• Start the selenium server using the command line 
• Go to the path of the jar file and type  java -jar <selenium server jar name>
• Run the test case from your Java IDE (eg: inteliJ Idea, Eclipse )
• You may refer this article for more details http://seleniumhq.org/docs/05_selenium_rc.html

In order to automate a data driven test case using files you may use different techniques to read files from java and then set the values to the relevant places. 

Example: How to read values from Excel files and use in Selenium Test Cases

• This can be simply done by using the jxl library which is available in the internet. [ http://sourceforge.net/projects/jxl/ ]
• You may refer how to read and write from excel file using jxl from following article http://www.andykhan.com/jexcelapi/tutorial.html
• Following is a sample Selenium script which uses jxl for reading values http://itsmyselenium.blogspot.com/2012/04/simple-datadriven-example.html

Selenium Tips

Please refer following links for more tips 

• http://www.jroller.com/selenium/entry/selenium_overview_tutorial
• http://jroller.com/selenium/

Selenium Test Automation for GWT Websites

Hi,

GWT is one of the latest technologies used to develop nice web sites and applications. When it comes to test automation for GWT based web sites / systems we need to know what we can do and what we cannot do. Therefore I thought of sharing this post with what I could found recently and I will keep updating this post with my latest findings. Visitors are welcome to share their experience related to Selenium with GWT under this post.


Following are couple of good articles I came across and looks interesting.

• http://www.javacodegeeks.com/2011/10/testing-gwt-apps-with-selenium-or.html
• http://drglennn.blogspot.com/2010/01/selenium-testing-gwt-upgrading-to-gwt.html

When dealing with different types of elements we may need to use xpath to access some elements in GWT. In that case it is good to have an idea about xpaths and how we can find the xpath and how we can use them  with Selenium.

Following links provide some useful information related to xpath and how we can use in Selenium.

• http://www.w3schools.com/xpath/xpath_syntax.asp
• http://www.theautomatedtester.co.uk/tutorials/selenium/selenium_xpath.htm
• https://addons.mozilla.org/en-US/firefox/addon/firepath/     ( If you have firebug installed please use the plugin fire path to generate the xpath of any element you want )
• If you need to give more prefrence to resolve elements using xpath please change the order or resolving elements via selenium IDE. Load Selenium IDE > options > go to Build Locators, change the order as you wish by drag and drop

Further I came across following plugins which would be very useful when recording scripts via Selenium IDE

Selenium useful Plugins:

• Selenium Expert
• Highlight Elements
• Implicit Wait

How to Generate an Index of Excel Sheets Dynamically

This post is about "How to Generate an Index of Excel Sheets Dynamically" which is very helpful when you are dealing with Large excel files with lots of sheets/tabs.

Step 1. Create a New Sheet called "Index"
Step 2. Right click on the sheet and go to View Code ( It will open VB Editor )
Step 3. Copy the following VB Script there

 Private Sub Worksheet_Activate()
 Dim wSheet As Worksheet
 Dim l As Long
 l = 1
   With Me
     .Columns(1).ClearContents
     .Cells(1, 1) = "INDEX"
     .Cells(1, 1).Name = "Index"
   End With
   For Each wSheet In Worksheets
     If wSheet.Name <> Me.Name Then
       l = l + 1
         With wSheet
           .Range("A1").Name = "Start_" & wSheet.Index
           .Hyperlinks.Add Anchor:=.Range("C1"), Address:="", _
           SubAddress:="Index", TextToDisplay:="Back to Index"
         End With
         Me.Hyperlinks.Add Anchor:=Me.Cells(l, 1), Address:="", _
         SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name
     End If
   Next wSheet
 End Sub

Step 4. Now save and close the VB Editor
Step 5. Go to a different sheet and come back to Index Sheet
Step 6. Now you can see that the Index has been generated along with the list of sheets with links
Step 7. when you go to a sheet you can see another link to go back to index sheet as well.

How to Format Code Blocks in your Blog

I thought it would be interesting to know how we can publish code blocks with proper formatting which is convenient for the reader to read or copy.

I found couple of interesting articles which can be used to do this task. I thought of sharing this links rather than explaining the same thing by my self.

• http://codeformatter.blogspot.com/
• http://timbroder.com/2007/07/howto-post-code.html
• http://pleasemakeanote.blogspot.com/2008/06/posting-source-code-in-blogger.html

Test Automation - integrating to Jenkins

Test Automation - integrating to Jenkins/Hudson


Currently test driven development is the latest trend in the software industry due to the Agile Process. Hence it is really important to utilize test automation tools in the QA process to automate possible test cases. This allows to save time and utilize the resources very well. In this post I would like to discus about how we can integrate test automation scripts to Jenkins (Continuous Integration Tool / Build Tool) and generate test results.

There are lot of approaches to do this task and it depends on the tools that is used by your company for test Automation.

Here are few suggestions I can given and you may further refer following links to integrate you test scripts to Jenkins/Hudson

Marathon vs Jenkins

• If your using Marathon as the test automation tool then you can create a simple build.xml with the test scripts. Test Scripts can be groups in to several ant targets. 
• You can create a Jenkins job and setup the build.xml and invoke the relevant ant target.
• Further you need to mention the marathon home path in the build xml and the project paths of the test automation projects.
• Further you can setup "Publish JUnit test result report" with the JUnit report generation path of your test automation project
• Then you may execute these Jenkins jobs as you wish
• This will execute your test scripts using Marathon, and generate JUnit test reports and it will display under test results of the Jenkins Job.

TestLink vs Jenkins

Further you can integrate Testlink with Jenkins and you may refer following article for more details.

OpenSource Tools