Monday, December 6, 2010

AppSys on Bloggers

AppSys on Bloggers

When to stop Testing

Ø      When time decided for testing is elapsed / time limit is completed
Ø      When budget allocated for testing gets exhausted
Ø      When specific kindof testing has been completed / when the AUT/SUT passes the standard (companyspecific) number of tests.
Ø      When defect arrival rate (DAR) falls below the specified limit.

First Floor, 624, Tonk Road, Tonk Phatak,
Near Krishna Mall, Jaipur Rajasthan, India

Sunday, December 5, 2010

Working with Excel objects in QTP

We  create framework for automating the application. For this we need the independent structure for reporting and data. Excel plays a very important role in this approach.

QTP has its own test result displaying mechanism in the predefined format. Once the test is run, the result sheet is generated which gives you the insight of the script – stating the point of failures, warnings and passes.

We create customized checkpoint in the script and it is possible to customize the result file also depending upon the checkpoint created will be passed or failed.

In most of the cases we want to create summarized or detailed report of the entire test in excels. The reason to create customized report is that one is able to keep the file in central location and to create the report in our own format.

In this article we are going to learn the interaction of Excel with VBScript.

The whole mechanism goes in the following steps:
1. Understanding the hierarchy of Excel Application.
2. Creating the Excel Object
3. Opening an existing workbook or creating the new one
4. Setting the objects for various sheets in workbook.
5. Writing and fetching the data values in the cells.
6. Saving and closing the workbook
7. Closing the application and releasing the memory

We will go through each of the above stated steps with a suitable example to understand the approach properly.

Understanding the hierarchy of Excel Application

We will not go into the details of the complete hierarchy of the Excel application but to the extend what is required.

Excel Application

Creating the Excel Object

The first step towards the process of reporting via excel is to create object of Excel. Reporting in Excel can either be done in backend, without making the application visible or u can make it appear to user once the process of writing or fetching the data is going. In either way creating of the Excel Application object is required.
It goes as:
Dim xl
Set xl = CreateObject(“Excel.Application”)

Opening an existing workbook or creating the new one

Once the excel object has been created, it means that excel application has been invoked but is not visible. So either one can perform the operations like that or make the application visible and then perform the operations.

To make the application visible:
xl.visible = true

To open a new Workbook:

To open an existing Workbook:
xl.workbooks.Open(“File Name with complete path”)

Setting and accessing the objects of sheets in workbook.

Once the workbook has been opened, either existing or new one, we need to write some data in various cells in various sheets of that workbook.
By default there are 3 sheets in a workbook and various operations can be performed on. So one need create the object to reference these sheets as it becomes easy to access them and you don’t have to mention the complete hierarchy over and over again.

Say one has to create a reference for sheet with index i, which starts from 1
Set sht1 = xl.activeworkbook.sheets(i)

One can add or delete n number of sheets from the activeworkbook
To add a sheet in workbook –

To delete a particular sheet where i represent the index which starts from 1 –

To change the name of the sheets –
xl.activeworkbook.sheeets(i).name = “Name of your choice”

To count the total number of sheets in the workbook
Cnt = xl.activeworkbook.sheets.count

Writing and fetching the data values in the cells

To write the data in Excel sheet, one should know the cell address in which the data has to be written. Same thing goes for accessing the data from the cells

To write the data in sheet2 cell address as D8, we write the following command. Cell address here is represented by row number followed by column number –
xl.activeworkbook.sheets(2).cells(8,4) = “hello”
To fetch the data from sheet3 cell address A7 –
Val = xl.activeworkbook.sheets(3).cells(7,1)

If one has already created the object of the particular sheet, you don’t have to write the complete hierarchy but simply –
Object.cells(row,col) = value

Saving and closing the workbook

Once the work completed you can save the newly created workbook to a specified location or save the changes made to already existing opened workbook.

To save as in case of new workbook
xl.activeworkbook.saveas “path_with_file_name.xls”

To save in case of existing workbook

To close the workbook

Closing the application and releasing the memory

To close the application

To release the memory of all the objects
Set xl = nothing

1st Floor, 624 Tonk Road (Above Apex Automobiles), Tonk Phatak
Near Krishna Mall, Jaipur, Rajasthan, India
+91-9785022310, 0141-3143687

Saturday, December 4, 2010

What is Software Testing:

Software Testing: 1) Set of activities performed / conducted with the intent to identify errors
within the software
                                                  Dr. Proff. Watts S. Humphrey

Objectives of Software Testing:
A.     Identification of errors
B.     To ensure the correctness of the software prior to its release
C.     To ensure the optimal quality of the software prior to its release
D.     To increase customer satisfaction & build up confidence
E.      To increase market reputation
F.      To ensure the conservation of financial investment that have been made in the development of the software
G.     To ensure the fulfillment of the identified Business Objective of the product

                                       i.      Simplification of the procedural complexities
                                     ii.      Reduction in the operational time of a business process
                                    iii.      Lesser probability of commencement of errors
                                   iv.      Ubiquitous & runtime availability of the information
                                     v.      Facilitation to the aspects of decision making
                                   vi.      Relative lesser (early) Return On Investment (ROI)

ROI: Period that identifies the profitable aspects of software / products

1st Floor, 624 Tonk Road (Above Apex Automobiles), Tonk Phatak
Near Krishna Mall, Jaipur, Rajasthan, India
+91-9785022310, 0141-3143687

AppSys Jaipur, IT Services, Software Services, QA Testing Services, Third Party Testing, Web Services, Software/Web Development, Website Designing, Company, Jaipur, Rajasthan, India

Now a days most of us (in IT industry) know/have heard about Automated testing tools.

Rational Functional Tester (RFT), as the name says, is an automated functional testing tool from Rational. This tool tests your application automatically without human intervention.

IBM Rational Functional Tester is an object-oriented automated testing tool that lets you test a variety of applications. You can quickly generate scripts by recording tests against an application, and you can test any object in the application, including the object’s properties and data. Rational Functional Tester offers you a choice of scripting language and development environment — Java in the Eclipse framework or Microsoft Visual Basic .NET in the Microsoft Visual Studio .NET Development Environment. That means that regardless of the language or platform your development staff has chosen, you should be able to integrate with them and leverage some of their expertise as you develop your automated tests.

Rational Functional Tester offers these powerful capabilities
• Play back scripts against an updated application
• Update recognition properties for an object
• Merge multiple test object maps
• Display associated scripts
• Use pattern-based object recognition
• Integrate with UCM

1st Floor, 624 Tonk Road (Above Apex Automobiles), Tonk Phatak
Near Krishna Mall, Jaipur, Rajasthan, India
+91-9785022310, 0141-3143687

Sunday, October 24, 2010

IT Services, Software Development, Web Development Company Jaipur

AppSys is a premier Custom Software Development, Web Application Development, Website/Portal Development, Web Designing, Logo Designing, Banner Designing, Web Services QA & Testing Services company located at Tonk Road, Tonk Phatak, Jaipur, Rajasthan, India. Our corporate culture reflects our understanding that successful business relationships are built on long term mutual gain, not short-term expediency.

Our Services:
• Custom Software Development
Web Application Development
Website/portal Development
Website/Logo/Banner Designing
QA & Testing Services
Third Party Testing
Domain Registration & Web Hosting
• SEO/Website Ranking
• Outsourcing
• Data Processing Services
• Bulk SMS

1st Floor, 624 Tonk Road (Above Apex Automobiles), Tonk Phatak
Near Krishna Mall, Jaipur, Rajasthan, India
+91-9785022310, 0141-3143687