Monday, March 16, 2015


Selenium Automation Testing
http://seleniumsimplified.blogspot.com



QTP Nested Webtables

QTP Nested Webtables


You need to add the correct webtable to the OR. Go to OR click Add Object and then Click on one of the cells and you will see a object hierarchy of the below type

Browser
+--Page
+----WebTable
+--------WebTable
+----------WebTable
+------------WebElement

Now add the Last WebTable to the OR and then try the operations that you are trying to do 


Dim iRow  'find total number of rows in nested table
Dim iCol    'find total number of cols in nested table


For i=0 to iRow
  For j=0 to iCol

    if (Browser().Page().WebTable().ChildItemCount(i, j, "Image") > 0) Then
      iRequiredRow = i
      iRequiredColumn = j
      Exit For
    Next
Next


Saturday, May 18, 2013

This blog contains free useful information on the below topics:


Disclaimer: I am not responsible for any damage or loss or profit on using this blog posts.

Web UI Automation with Windows PowerShell

Web UI Automation with HP QTP

Web UI Automation with OATS

Web UI Automation with Selenium

Desktop UI Automation

Windows Applications Automation with QTP

QTP windows application automation

Follow this blog to get updated on RESOLVING SOLVING WORKAROUNDS FOR tricky issues using automation.

How to know EPF INDIA BALANCE


Know your EPF india balance sms

Provident Fund balance sms
Provident Fund online balance checking
Provident Fund PF balance amount online

Click the below link

http://epfoservices.in/epfo/member_balance/member_balance_office_select.php

You need to refer your current payslip.
Select the appropriate state of india as per your payslip

Example : If your payslip has KN/12345/678901

then you need to select KARNATAKA in the list box and click the office name as Bangalore.

In the new window, type 12345 in the 3rd text box and leave 4th text box blank,
Type 678901 in the 5th text box

Type the name that appears exactly on your payslip.

Type the mobile number you want to receive the EPF balance sms and click submit button after selecting
I Agree checkbox.

You will receive sms within 2-3 minutes.

Employee PF Account Number* BG BNG 12345      678901



Saturday, April 13, 2013

Making group chat in Pidgin to blink flash

Making group chat in pidgin to blink when somebody types in the group chat
Getting noticed if someone types in group chat of pidgin
Flash Notification of pidgin group chat
Notification methods for message in group chat window
Flash blink new chat window in pidgin


  1. Activate the pidgin buddy list window
  2. Click Tools > Plugins
  3. select "Messenger Notification"
  4. click Configure plugin button
  5. Wait for the pop up window to open
  6. click checkbox for Chat windows
  7. also click checkbox for IM windows if you want notification for individual chat IM
  8. click checkbox for flash window under Notification Methods sections 
  9. click close.


Now whoever types a new message in group chat, you will be notified in the system bar, just the way by default how you would get notified when you receive new messages in independent chat windows with single persons.

Creating Group chat in Pidgin

Creating Group chat in Pidgin
Create Group chat in Pidgin
Create Permanent Group chat in Pidgin



  1. Activate Pidgin buddy list window.
  2. click Buddies menu 
  3. Enter Room: teamgroupchat
  4. Click Join button
Server name is shown by default for your network.
Type password if you want your group chat to be password protected.

Activating Pidgin messenger using vbscript

Activating Pidgin messenger everytime upon idle
Activating Pidgin messenger forever
Activating Pidgin messenger whenever system goes for idle state
Activating Pidgin messenger using vbscript


Save the below code as vbs file, say, pidgin.vbs


Dim WshShell, oExec
Set WshShell = CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("C:\Program Files\Pidgin\pidgin.exe")
' Change the pidgin installed location in your computer and according to your operating system
Do While oExec.Status = 0
WScript.Sleep 100
Loop
'WScript.Echo oExec.Status

Open Task Scheduler in Windows XP and select the above pidgin.vbs file to run for everytime or when your system goes idle or choose to run this vbs file for every 5 mins, so that your pidgin status can never be idle even if you go off for a coffee break :) ;) in your office.


Monday, July 18, 2011

SOFTWARE DEVELOPMENT PROCESS


Software development process
Activities and steps
Requirements · Specification
Architecture · Design
Implementation · Testing
Deployment · Maintenance
Methodologies
Agile · Cleanroom · Iterative
RAD · RUP · Spiral
Waterfall · XP · Lean
Scrum · V-Model · TDD
Supporting disciplines
Configuration management
Documentation
Quality assurance (SQA)
Project management
User experience design
Tools
Compiler · Debugger · Profiler
GUI designer · IDE

HP QTP Certification

Please view on the follow HP link, for HP QTP Certification
  • HP0-M16 Exam Preparation Guide
ftp://ftp.hp.com/pub/hpcp/epgs/HP0-M16_EPG.pdf
--

List of Cloud computing Providers


Cloud computing Providers, Updated July 2011

Types of cloud computing

Cloud Computing Types: 

  1. Public Cloud, Public cloud or external cloud describes cloud computing in the traditional mainstream sense, whereby resources are dynamically provisioned on a fine-grained, self-service basis over the Internet, via web applications/web services, from an off-site third-party provider who shares resources and bills on a fine-grained utility computing basis.
  2. Hybrid Cloud, 
    hybrid cloud environment consisting of multiple internal and/or external providers "will be typical for most enterprises".
  3. Private Cloud,
    Private cloud and internal cloud are neologisms that some vendors have recently used to describe offerings that emulate cloud computing on private networks. 

What happens when you save QTP

What happens when you save QTP
Which one gets saved, when you click Save in QTP.

Answer.
When you click Save in QTP, it saves the local object repository by default.

Unless you do the following, QTP save does not save changes in Shared object repository.


If you want to save changes in Shared repository, open it using Object repository manager and then
edit the objects and click Save.
--

Difference between Global datasheet and Local Datasheet

Difference between Global datasheet and Local Datasheet


You can directly fill the rows in your global datatable and parameterise the values without handling any for loops.

For example, if there are 10 rows filled in, QTP by default runs for 10 times and stops after executing 10th row.
msgbox Datatable("columnname")
Note: if sheet is not mentioned, it takes data from first sheet with index of 1. which is the global sheet by default.

But if you fill your data in Local datasheet, you need to specifically write logic to handle from which row
QTP need to pick up the data and from which row it should stop.

msgbox Datatable("columnname","Action1")

QTP Error pure virtual function call

Whenever you close QTP or try to save QTP with resources, you may occassionally see the
Runtime error "VC++ Runtime error" 

What has gone wrong?
You either forgot to free up the objects in memory(RAM)

How to do it ?
Set yourobjectname= Nothing

Never forget to release objects from memory. It directly impacts your system performance.
--

If same object is present in Local Object repository and Shared Object Repository of QTP, QTP will use which object

If same object is present in Local Object repository and Shared Object Repository of QTP,
QTP will use which object ?

Answer. QTP will lookup objects from local object repository first. If it does not find object specified in the script, it will lookup into the associated shared object repository(ies).

Difference between Public and Global variables in QTP

What is the difference in Public and Global variables ?

  • All variables declared in a QTP Action are Public by default.

"Variables declared in  Action1, for example can be accessed in all functions declared inside Action1."    Scope: Within the Action where the variable is declared.

  • All variables declared in .vbs file are called global and are public by default.

 "Why these are called Global variables because, Once you declare a variable in .vbs file,this .vbs file is going to be executed first and then the QTP test action script. So variables declared in .vbs files can be accessible from all Actions at ease."Scope: Globally available to all actions.
--

Friday, November 5, 2010

Excel Compare two columns of infinite ROWS

Excel Compare two columns

Suppose there is data of 50-100 rows or more in two columns, A and B
you want to compare whether they are equal or not

---------------------------------------------------------------
column A        || column B           || column C
----------------------------------------------------------------
100                      101                    =IF(A1=B1,0,1)
---------------------------------------------------------------


you can type in column c1, this formula
=IF(A1=B1,0,1)
press enter

Result is 0 if content of A1 CELL and B1 CELL values are same
Result is 1 if content of A1 CELL and B1 CELL values are NOT same

Now, you copy C1 cell and paste in the remaining 49or 99 rows down
so that you would see the result for all 49 or 99 rows in the excel worksheet having data.

Excel Date month year formula

Excel cell formula : Date month year

We Use data stored in Excel and evaluate the data in Excel
with that of our Application under test (AUT) while automation.

Sometimes it is easier to store values or formulae in excel rather than we computing in our code.

Suppose today's date is 05 november 2010
you can type the following formula in Excel

05                =TEXT(TODAY(),"dd")
11                  =TEXT(TODAY(),"mm")
Friday            =TEXT(TODAY(),"dddd")
November     =TEXT(TODAY(),"mmmm")
10              =TEXT(TODAY(),"yy")
2010      =TEXT(TODAY(),"yyyy")
06                =TEXT(TODAY()+1,"dd")  ' add one to today's date --> 05+1 = 06

So in a single cell if you would like to see today's date,month and year :
05 November,  2010
you type in as follows
=TEXT(TODAY(),"dd")&" "&TEXT(TODAY(),"mmmm")&",  "&TEXT(TODAY(),"yyyy")

&" " --> you are appending a space in between the strings returned

On Error Resume Next - usage and demerits

On Error Resume Next - usage and demerits

USAGE


You can add this "On Error Resume Next" to hide any code execution errors to pop-up on your screen
if you know you would get an error in the code block.
You must use "On Error goto 0" to activate error-handling mechanism , after the code of block if finished executing, so that if there any consequent errors in the remaining block of code, you will come to know there are errors.

DEMERITS
It so happened to me , that i used "On Error Resume Next" before

if Data1(i)<>Data2(i) then


so that, my code execution would not stop and happily my code got executed.
But i was unaware that on adding "On Error Resume Next" would really cause me problems.
If there was data or invalid data, you cant compare them, naturally it would throw u error
sayimg "Subscript out of range" or "cant compare with /null"
you should write an exception mechanism to control  the flow of execution to get uninterrupted.

Workaround:
Check if your code can handle the error , and if you continously get "Null" values,
and if you are using any resultset or dbconnections, use RS.MoveFirst after Rs.Next loop if any.