We Can Hide Any Open Application Window in Windows Operating System

Your Ad Here

During the development of my one of the projects I wanted to hide Firefox web browser window. I was using HtmlUnitDriver to automate something but using it we cannot hide any web browser window, i did some research and some across one very good tool called AutoIt , It has all the capability to handle windows. We can perform all kinds of operations using AutoIt.

Let me tell you how we can implement utility which can help us to Hide and again show any application window.

Please follow below steps one by one.

You have to first install AutoIt, it is free.
download from : http://www.autoitscript.com/site/autoit/downloads/

Open the Editor and write below code for Hiding any window.
AutoItSetOption("WinTitleMatchMode", 2) 
WinSetState("Title Of Your Window", "", @SW_HIDE)

Continue >>

Read more...

How to Use "soapUI" Tool to Perform Load Testing

Your Ad Here

SOAP means "Simple Object Access Protocol" which is used to exchange information on the web. We have already seen how we can send and receive Soap requests programmatically using Java, but today I will teach you how to use the SoapUI tool to generate traffic.

soapUI is one of the best tools which can be used to send and receive soap requests and it does not require any kind of programming knowledge. It is a very simple tool and used widely all over the world for API functionality as well as load testing.

Today in this article we will see how we can make use of this soapUI tool to perform load testing or to generate traffic.

Well, starting a load test using SOAP UI tool is fairly easy and would only take couple of minutes to get it going. If you have used SOAP UI tool for functional testing then you can configure the tool quickly to generate traffic.

Steps:

#1. Connect the soapUI tool with the application by creating a project and providing appropriate WSDL url.

There are two ways to generate new project:

Select "File" -> "New soapUI Project (Ctrl-N)" menu or form left Navigator pane right click on "Projects" root item and select "New soapUI project" from the dropdown list.

Continue Reading >>

Read more...

Capturing Desktop Screenshots Using Java Programming

Your Ad Here

I usually spend my time in designing and developing software test automation frameworks. I have used Quick Test Professional (one of the best software test automation tools) and in Quick Test Professional tool we have different options for capturing the screenshots which is really helpful for the testers to analyze final automation results.

Capturing the screenshot at all failed checkpoints can help testers to analyze the result easily and also it can help testers to understand to root cause of the problem immediately.

Currently I am working on another Automation framework called Selenium. I am new to selenium and every day I am learning new things. My experience says, capturing the screenshot at each checkpoint (verification points into the automated testcases) is really very helpful for the person analyzing the test result. I don't know whether selenium has such in-built functionality but using Java programming we can definitely perform this task very easily.

We can capture different size of screenshots using Java programming language. Let's go through the each steps required to capture screenshots using Java programming.

# We have to first determine the size of our screen (monitor) and reference of the screen size we can decide the actual size of screenshot to capture.

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();


Continue Reading >>

Read more...

Excel Operations in Java Using POI-HSSF

Your Ad Here

Recently I have done some work in Java for automation framework development. During the project I have used java APIs for excel operations. Today I am going to give you the short introduction of that API and also we will discuss some of the API which we can use to read Excel data.First of all let's go through the available projects/libraries to perform operations on Excel sheets and later we will go through in details.There are two types of POI projects available, one is POI-HSSF and another is POI-XSSF. The library that I have used in Java is POI-HSSF which is a project implemented in Pure Java for the Excel "97(-2007)" file format (.xls). POI-XSSF project is for Excel 2007+ file format.HSSF and XSSF both the projects provide ways to perform read/write/create/modify Excel operations.
Let's now discuss different methods and operations in details using HSSF usermodel.
How we can create new workbook?
Continue Reading >>

Read more...

Useful Functions of Microsoft Excel Macro

Your Ad Here

Some of the useful functions are available in Excel which can be used for writing Macro in Excel. Here in this article I will be discussing about some of the useful functions.

Microsoft Excel is very powerful software used for reporting as well as for data management. There are so many useful commands available in Excel which can be run using the Excel GUI and same kinds of commands we can also run in macro through VBScript.

In this article we will be discussing about some of the useful functions which we can use in Excel Macro. If you would like to know basics of Macro, you can visit Basics of Microsoft Excel Macro and Some useful Tips.

These are the two functions which we can use when we want to do some setting or want to hide some of the sheets before close or after opening the Excel sheet.

Workbook_BeforeClose()

Workbook_Open()

When we open Excel file and if it has having many sheets available. Now if we want to activate or select any particular sheet immediately after opening the Excel then we can use below functions.

Sheets(1). Select - (Below line of code will select first sheet from the available sheets).

Number 1 indicates the sheet number. If we want to select sheet which is available at second position then you can specify 2 in place of 1 like below.

Sheets(2).Select

When we want to perform any action on Worksheet change then below function will help you.

Private Sub Worksheet_Change(ByVal Target As Range)

Continue Reading >>

Read more...

How can we perform different operations on web application using Selenium RC

Your Ad Here

Selenium is one of the best automation frameworks available in the market free of cost. We can perform all kinds of operations on web application. In this article you will find some of the useful functions which will help you to perform operations on web.

We have already discussed about the basics of Selenium RC and Selenium IDE. Now today we will be discussing about some of the functions which can help us during the test automation using Selenium RC.

In the last Selenium article, we learned almost all Selenium IDE commands. In selenium RC also there are so many such functions available using which we can perform operations on any web application.

One of the very basic and most useful function of Selenium RC - selenium.close();

I hope you got the purpose of this function. Using this function we can close opened web Browser during the automation run. This function does not have any parameters.

Depends on the requirement some time we have to close the Web Browser at the end of each testcase and similar to that there might be a requirement to maximize the web browser before we start executing our automated testcase. To maximize the browser we can use selenium.windowMaximize() function. This function also does not have any parameters.

Continue Reading >>

Read more...

Basics of Microsoft Excel Macro and Some Useful Tips

Your Ad Here

Microsoft Excel is very powerful software for managing/manipulating data and also it is used for reporting purposes. Microsoft Excel has many useful, and easy to use in-built features that anyone can learn it very easily in short time.

You must have heard of one of the very useful Excel Developer features called "Macro". Using the Marco we can automate all manual steps in Excel Sheet and can be run anytime we want by just one button Press.

In this article you will learn some basics of Marco which includes:How to write macro, how to add button in Excel sheet, how we can call Function/Subroutine by pressing a button in Excel sheet, how to add forms in Excel, and some useful Tips.

Writing Macro in Excel:
Excel has special Visual Basic Editor for writing Macro. Shortcut key "Alt + F11" can beused for opening an Editor. In the 'Project Explorer' View (View -> Project Explorer [Ctrl+R]) of Macro Editor you can see one VBAProject and under that VBAProject by default four Excel Objects can be found, one Excel Object for each sheet and one for the entire WorkBook.

Continue Reading >>

Read more...

How to Run Recorded Script of 'Selenium IDE' Using 'Selenium RC'

Your Ad Here

Selenium IDE is one of the easiest tools for automating any web related activities. If you don't know how to use Selenium IDE then please refer "Selenium Automation Tool (Selenium IDE)" article.

In this article you will learn about selenium RC and how you can run Selenium IDE script using Selenium RC.

Let me give you short introduction of Selenium RC first. Selenium Remote Control (Selenium RC) is one of the variant of Selenium Framework. Selenium RC has two components, one is "Selenium Server" and another is "Selenium Client".

Before we start running any automated Testcase developed for Selenium RC, you have to first start Selenium Server and then your automated Testcase. You can have Testcases automated in any of the following programming languages.

Continue Reading >>

Read more...

How to Redirect the Output of SQL Queries to a File

Your Ad Here

Today I was running some SQL Queries and I wanted to redirect all the output of my SQL Queries to one file. Initially I thought it can be done similarly to how we usually do it in UNIX command prompt (simply redirecting output of a command to a file using > or >>) but it didn't work.

Before searching on Internet, I first preferred to ask my senior for the solution and came to know the easiest solution for the problem and it is a very simple method. Let me share with you the solution.

Steps to redirect Output of any SQL query to a File:

Launch the SQL prompt, login with the correct username and password. Now execute the below commands one after another on the SQL prompt.

> spool
> [Run your all SQL Queries/Commands]
> ...

Continue Reading >>

Read more...

Selenium Automation Tool (Selenium IDE)

Your Ad Here

When we talk about Software Testing, Test Automation is one of the areas where most of the software Testers would like to be involved and I am one of them.

I always try to find tools which can make my life easy in terms of Software Testing. I have tried so many software test automation tools but Selenium is the only Tool I like very much. It is very useful, very easy to learn, having all good / necessary / important features which should be available in any Automation Tool.

Selenium is one of the most powerful tools available in the Market created by developers at ThoughtWorks and released publicly as an Open Source project on OpenQA.

As per my information this is the only tool that supports multiple browsers and multiple operating systems. Following are the list of Operating Systems and Browsers.

Continue Reading >>

Read more...