About me

About me:-

this is me,  vinod rajput. I have done my graduation, Bachelor of  Technology  from Chandigarh (Punjab) INDIA, in “Electronics & Communication” stream. Afterwords, i ‘ve started my carrier journey with Java/ J2EE.  Currently, I’m working as Test Automation Engineer. I never thought about testing. You know, life makes everything possible, when i started my career in Software Automation  Testing, i found it’s very Interesting. I’ve worked in Discovery (SA) as Senior Test Analyst and QTP Automation Engineer.  I’ve worked with various clients like DD, Artwork (US), Discovery (SA).

I ‘ve done work in Automation Testing using QTP, Badboy, WET, Jmeter, Ranorex, Testlink, RFT, LoadRunner, Mantis, QC etc. Tools. I found these really interesting.  I shall be very thankful to many persons who help me to achieve all this but special thanks to Mr. Ashok Borate who is very supportive as i heard about him.

About bad Time span-> Recession,

You saw up -downs in the the Business . Now that ‘ Time passing is Passing ‘,  means there is big downward slop in IT industry due to bad market condition. So these are very crucial time for IT Engineer to survive in the IT industry. There is plight of IT, coz firing goes every time in  IT ..

Beginning of Recession: 2008…

Leave this up & down comes in every Business. So that was the Big down ….

How to add drop down list in excel sheet

If you are struggling to add dropdown list in excel sheet, for example: rows have following values a, b, c and d. And you want a drop down list on top of these rows to display all these mentioned values then here is solution for you.

1. Open MS excel.

2. Click on the Data tab (present on top of the excel) and click on Data validation tab.

 

 

 

 

 

 

 

 

 

 

3. Under setting tab (default tab in data validation window), and select List item from Allow drop down field.

 

 

 

 

 

 

Note: Make sure you have selected the cell in excel where you want to add the drop down list field.

 

4. Click on the image (present on right side) of the Source field), new pop up will open & again click on that similar image and select the range that you want to see in the drop down list. (Check in screenshot).

Note: That range will populate in Data validation (step 2) pop window and click Ok to save it. 

 

 

 

 

 

 

 

5. You can see the drop down with items (range that you added), in an excel sheet. If you want to display same drop down on other cell, just copy cell where you just created list and paste to the new cell.

How to configure Gmail account with Microsoft Outlook

Do you wanna use “MS Outlook” with Gmail ID. Yes, you can do it, Its very easy to configure Gmail account with MS Outlook. If we are used to with MS Outlook and do wanna use Outlook with Other ID’s e.g. with Gmail Id, then just follow below mentioned link and proceed step by step.

Here is the Link,

                            https://mail.google.com/support/bin/answer.py?answer=77689

Cheers.

After Installing AXE excel add-in (COM Add-in), Excel spread sheet does not display Axe Add-in

Problem: After Installing AXE excel add-in (COM Add-in), Excel spread sheet does not display Axe Add-in.

Solution: Follow the steps mentioned below in sequence,

1. Install AXE (Any COM) Add-in.

2. Check that installed add-in displayed in Add-ins list or not. (Navigation: File> Options> Add-ins> You will see view and manage add-ins window on the right hand right (View will display the list of Active, Inactive and Document related Add-in)

Procedure to install/Uninstall COM add-in

Add a COM add-in

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
3. In the Add-Ins available box, select the check box next to the add-in that you want to install, and then click OK.

Tip    If the add-in that you want to use is not listed in the Add-Ins available box, click Add, and then locate the add-in.

Remove a COM add-in

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
3. In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.

Note    This removes the add-in from memory but keeps its name in the list of available add-ins. It does not delete the add-in from your computer.

4. To remove a COM add-in from the list of available add-ins and to delete the add-in from your computer, click its name in the Add-ins available box, and then click Remove.

3. After adding COM (Axe) excel add-in, again open excel sheet and check “Does it display added COM (AXE) excel add-in. if not then follow below mentioned procedure.

Check and Update the Registry (RegEdit)

Navigate: Start> Run (enter regedit) and click. Regedit window will open. Expand the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE> Software> Microsoft> Office>Excel>

After clicking on the excel , you will the following entries on the right side window.

The following table lists the entries under this registry key.

Entry	Type	Value
Description	REG_SZ	Required. A brief description of the add-in.This description is displayed when the user selects the add-in in the Add-Ins pane of the Options dialog box in the Microsoft Office application.
FriendlyName	REG_SZ	Required. A descriptive name of the add-in that is displayed in the COM Add-Ins dialog box in the Microsoft Office application. The default value is the add-in ID.
LoadBehavior	REG_DWORD	Required. A value that specifies when the application attempts to load the add-in and the current state of the add-in (loaded or unloaded).By default, this entry is set to 3, which specifies that the add-in is loaded at startup. For more information, see LoadBehavior Values.
Manifest	REG_SZ	Required. The full path of the deployment manifest for the add-in. The path can be a location on the local computer, a network share (UNC), or a Web server (HTTP).If you use Windows Installer to deploy the solution, append the string |vstolocal (that is, the pipe character | followed by vstolocal) to the end of this path. This ensures that your solution is loaded from the installation folder, rather than the ClickOnce cache. For more information, see Publishing an Office Solution by Using Windows Installer. Note When you build an add-in on the development computer, Visual Studio automatically appends the |vstolocal string to this registry entry.
Warmup	REG_DWORD	Optional. A value that indicates that the .NET Framework and Visual Studio Tools for Office runtime load before an add-in loads and reduce the perceived time to load an add-in. Set the Warmup entry to 1 and use this in conjunction with LoadBehavior entry to reduce the load time for Outlook 2010 add-ins that are deployed by using Windows Installer (.msi). This registry key cannot be set by using ClickOnce.

Update the Load Behaviour value to 3 (default). The application tries to load the add-in when the application starts. This is the default value when you build or publish an add-in in Visual Studio.

If the application successfully loads the add-in, the LoadBehavior value remains 3. If an error occurs when loading the add-in, the LoadBehavior value changes to 2, and remains at 2 after the application closes.

If still it will not work with Office 2010, then Switch to office 2007. It s working fine with Office 2007.

Interaction of IBM Rational Functional Tester (RFT) with Siebel Application

You are using Rational Functional Tester to interact with Siebel Application. You notice that the objects HTML, links, forms etc are either recognized as generic Window controls, or as HTML.

Does not allow

This could be happening if the Siebel Server is not enabled for automation testing.

Solution

Siebel provides a test framework Siebel Test Automation Framework (STA) which is a small program that, once enabled in the service side, will allow Rational Functional Tester to interface with the HI components.

Server Configuration (Steps to perform automation on Siebel app)

1. Open the .CFG file for the Siebel application on the Siebel server.
2. In SWE, Set both values “EnableAutomation & AllowAnonUsers” to TRUE, EnableAutomation = TRUE, AllowAnonUsers = TRUE

3. Restart the Siebel server.Next step is to enable Test Automation Framework in Siebel 8.0: Perform following action step by steps:

1. Log into Siebel as an administrator:

Site Map -> Administrator – Server Configuration -> Servers -> (Pick Server)

2. Select (Object Manger) -> Parameters
3. Change EnableAutomation & AllowAnonUsers to True.
4. You will also need to enter a license code for the changes to take effect.
1. Log into Siebel as an administrator: Site Map -> Administration – Application -> License Keys -> New
2. Enter (License, OK, 99999, Never)
3. Click on Save
4. Note: You can find the license codes at http://licensecodes.oracle.com/siebel.html
5. Restart you server for the changes to take effect.

4. Once you are done, record the scripts but you will need to tell Siebel that you would like to use the test Automation Framework during a particular session. You can do so by adding SWECmd=AutoOn as a parameter in the URL.

For example:

http://youSiebelServer/service_enu/start.swe?SWECmd=AutoOn

The first time you do this, when logging into the Siebel application, the browser (IE) will ask your permission to install a plug-in, which you will need to authorize. Once you have logged in successfully, you may start the Task Manager and check if the Siebel Automation Framework is running. You should see a process called SiebelAx_Test_Automcation_abc.exe in your system’s process list.

Now Rational Functional Tester should be able to record and play back the test scripts against your Siebel application, recognizing all Siebel objects as such.

How to install CLM component Rational Quality Manager (RQM)

Install Complete Life cycle Management (CLM) components from JAZZ website (https://jazz.net/) and save on your system.

 

Click on the Launch pad icon to install Rational Quality Manager (RQM).

 
 
 
 
 
 
 
 

After clicking on the Launchpad icon, user will see the following windows in sequential way.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Installing Jazz Team server and applications: Just follow the simple way of installing any software app, I mean next – next – next – install etc. But make sure following screens will come in sequence as mentioned below.

 
 

 

After successful installation, you can check the log file.

How to select/capture an object in RFT

How to select/capture an object in RFT

You use the Select an Object dialog box to select the object in your application you want to add to the test object map and a script.

When you select an object, Functional Tester lists its recognition properties in the grid at the bottom of the Select an Object page.

If you select the wrong object, or decide to add a different one, use any of the methods to select a different object. Once you click the Finish button, the object that is listed in the grid is the one that you will be adding.

The following three selection methods are available:

1. Object Finder Tool
2. Object Browser
3. Delay Method

Object Finder Tool: This is the most common and direct method of selecting an object:

How to use it

• Select the Object Finder tool icon and drag it over the object in your application that you want to select. Functional Tester outlines the object with a highlight border.
• Release the mouse button. The object is selected and Functional Tester lists its recognition properties in the grid at the bottom of the Select an Object page

Object Browser: Use the Object Browser method to browse for the object you want to add to the test object map. The browser displays a hierarchical tree of objects in your application. The top level shows any applications you have running. Under each top level, Functional Tester displays the object hierarchy within that application.

How to use it

1. Browse the object tree to find the object you want to add to the test object map.
2. Click the object to select it.

Functional Tester lists the object’s recognition properties in the grid at the bottom of the Select an Object page.

Delay Method: Use the Delay method to select pop-up objects, such as menus. This method uses the Object Finder tool, but enables you to set a delay, which gives you time to get to an object that requires clicking on other objects first.

How to use it

1. In the Seconds before selection field, enter the number of seconds you want to delay before Functional Tester attempts to find the object (the default is 10 seconds).
2. Click the Object Finder tool icon .
3. Go to the application and find the object you want to select. Anything you do during the delay period is not recorded, which enables you to dig for objects if necessary.

When the timer runs out, Functional Tester selects the object under the cursor, outlines the object with a highlight border, and displays its Recognition properties in the grid at the bottom of the Select an Object page.

Note: In order for delayed location of the objects to play back correctly, the object must be exposed by actions in the script. If the object is not exposed, an Object Not Found exception is thrown during playback.

Automation & It’s advantages

Automation : it is a Microsoft technology that make it possible to access software object into one application from another application. For that, we are using the scripting language VBScript, VC++. It is also used to check the functionality of an application.

Test Automation: is the use of software to control the execution of tests, the comparison of actual outcomes to predicted outcomes, the setting up of test preconditions, and other test control and test reporting functions

Advantages of Automation Testing: F3RPC

F: fast. R: Reliable, R: Reusable, R: Repeatable, P: Programmable, C: Comprehensive.

Principles 0f Testing Automation:

• Reusable: using more than 1
• Consistent: orderly, logically
• Repeatable: more than one time
• Versatile: various
• Efficient: effective
• Compliant: willing to comply.

• IPR Retention and Capturing

• Durable

• Broad and Integrated

Once testing requirements have been defined in detail, a Plan for testing must be decided. Automation of testing should be considered as part of this Plan. After taking the following steps you may verify whether to automate all, some or none of the tests to be executed in a testing project

QTP Training Day1

This slideshow requires JavaScript.

QTP Training Day1 is all about,

- What is Automation??

- Benefits of Automated Testing

- QTP Introduction

- Testing with QuickTest

- System Requirements

- Basic steps of QTP

- Advantages of QTP

- Understanding License Types

- Understanding the Add-in Manager Options

- Understanding the Testing Process

- System requirements for QTP 8.2 etc

Presentations of Hybrid Test Automation

This slideshow requires JavaScript.

Database testing

Database testing
Points:
- Test data integrity
- Test data type
- Test data size
- Test Event driven functionality
- Input item verification
- Test Stored procedure functionality

Data integrity:
While performing actions on DB, respective changes should be reflected in DB.
- ensure that the available tables are as per design.
- ensure records are getting populated properly in all related tables when inputs are given in the application.
- ensure records are getting deleted in the related tables when the information is deleted in the application (front end).
- verify for modifications of the records.

*Actions: addition, deletion, updation, insertion

Data Types:
Test the types of entity that are used in database. Entity type should be same as that administrator defined. It is performed on front end as well as from back end also.

e.g. Phone: String – administrator, but developer use it as number.

Data Size:
Test the size of entity that is used in database. Entity type should be same as that administrator defined. It is performed on front end by tester as well as from back end during unit testing by developer also.

e.g. email: max 30 character & min 5 character

Test Event driven functionality:
Event driven actions needs to be tested based on two factors
Events that trigger this action: With developer, QA has to test the event.
Action that performed by above event: testing the SP or functions.

Input item verification:
Process to verify the input items that are added into database. Also verify the fields with junk values, so the SQL injection should not be performed.

Test Stored procedure functionality
Check the functionality of SP.