World Conference Next Generation Testing (WCNGT-2013)

Today i thought of sharing our experience for “World Conference Next Gen Testing ” which 
was held at Bangalore between 11-12th July, 2013. It was our first exposure to any 
conference which was getting organized at an international level, with participation of  
eminent personalities from the testing community.


World Testing Conference

Our team was lucky to crack the initial two rounds of “ITL,Indian Testing League” an
 first of 
its type quiz related to testing. Entering into semi-finals, was enough to convince 
our company to sponsor us for the event.

We reached by afternoon(Due to Flight issues), and thought of attending “Design of Test Automation” by Rahul Verma. It was very informative and practical seminar.After that we attended sessions by speakers like “John ShuttleWorth”,Julian Harty”,”Rex Black”,”Shrini Kulkarni”,”Paul Gerrard” and many more known speakers..There were 4 parallel tracks going on,thus to get the maximum out of each, we were shuffling between conference rooms. 

Regarding the quiz part it was amazing there were 20 questions for semifinalist(16
 Objective + 4 Subjective).We were quite confident to enter the finals but it was not 
our day, and top 5 teams were selected for the finals(3 from CTS itself,i believe it was fair enough, with 27 teams from them).

Finals was held on second day, it was combination of audio, visual + audience rounds, 
even our team was banned from answering the open questions(May be organizers felt 
we had won enough goodie bags).Winning team was given “IPAD Mini”, just to console our self, we were talking that we would have easily won the second position(Provided we 
entered Finals :).


Indian Testing League


To summarize it was great experience in technology front, where testing is heading, 
keynotes about testing, lot of networking, branding for our company and making new 
friends, enjoying weather of Bangalore, moving around MG road, visiting Infy-Mysore and moreover no-office work.

Advance level Frequently Asked Questions in Unified Functional Testing

We tried to cover some of the advanced and useful Frequently asked Questions.Please feel free to add your comments and share your experiences.

Ur1stTestingHelp
Ur1stTestingHelp




1.How we can Reverse given string without using strRev function?

2.Copy text from Notepad and Replace all digits with newline?

3.How we can check the status of opened database connection?

4.Difference between Image & Bitmap checkpoint in a .NET window application

5.How to find unique combination from a given series say “1”,”5″,”3″,”1″,”5″


Hints:-
2.Use Filescripting object to ReadAll data from Notepad, than check each digit(Using Isnumeric function),incase it is digit than replace it with newline

3.Using “State” 
4.Image checkpoint exists only for Web applications.
5.Use Dictionary Object

Part1

Easy way to calculate Return on Investment in Automation

Automation of software testing process always sounds good to Quality Engineer (QE) managers. Intuitively, you see that creating an automated test one time and then running it hundreds or thousands of times will enable you to expand test coverage, find defects earlier, and focus manual test effort where it is really needed.

Return on Investment

 Thought of sharing the basic formula for calculating ROI(Return on Investment):-

 Automation Cost = Price Of Hardware + Price of Software(Tools) + Development Cost + Maintenance Cost + Execution Cost 

Manual Testing Cost = Development Cost + Maintenance Cost + Execution Cost

 ROI = (Manual Testing Cost – Automation Cost)/Automation Cost 

 Now as Regression increases, thus resulting in repeat ion in execution of Test cases, it results in surge in ROI by Automation Tool.

We can say that general Principle for Automation is “More Repetitive tasks are ideal candidate for Automation” producing more ROI

The aim is to have an ROI >>> than 1 


Please share your comment/Feedback 

Working with Database in UFT/QTP?

Scenario: How we can Fetch data from Database using UFT/QTP Automation Framework?

Solution:  Database plays a crucial role in designing a robust framework in UFT.It provides flexibility to user to add or delete data irrespective to script of UFT.

 We used this concept in creating Data/Keyword /Hybrid frameworks.  Basic aim was to allow non-expert users of UFT to run the scripts on selective data. Our manual team
was given full rights for the database thus they can change/modify/update the database
(thus selective in approach of testing, functionality/component/input data) with
comfort and without knowing any technical details of UFT.

Database used in “Microsoft Access”, we can change the connection string parameters in
case we want to work with other databases like SQL Server, Oracle, Excel.

Pseudo-Code:

Step-1:- Manually creating Microsoft Access file and adding values into it

Step-2:-Creating ADO objects for working with any kind of database

Step-3:- Opening the database connection

Step-4:-Sending the SQL command like select /delete/update

Step-5:- Using Recordset object receiving the values from database until End of file(EOF)

Step-6:- Closing the connection opened before and destroying the ADO objects to free the memory occupied by these objects.

Database View:-

Access-Database with Tables(Test)

Code Part-1:-

Below code is the calling script, which calls the DB functions placed separately
in Function library.

'#################Driver Script#########################
'Microsoft Access database path
sDBName ="C:UsersuftHelpDesktopData.mdb"

'Function call to connect to database,Incase Opening the connection fails then exit the test
if (not fnDatabaseConn(sDBName)) then
Reporter.ReportEvent 1,"Connection to database cannot be establised","So exiting the test"
ExitTest
End if

'Function call to fetch data from database and looping till the end of data is reached
Do
'Variable to take the data returned from the database
Dim sFileData
'Function call to fetch data from database , Input parameters is the Table/Column Name of Database
sFileData= fnDatabaseFetch ("Test","UserName")
'IF data is returned from the database than do some operation on the returned data
if( sFileData <> "" ) then
msgbox "Value of Data fetched from Database is " &sFileData
'Function call for Updating the database reflecting that operation on current row is done
fnUpdateDataBase "Test",Trim(sFileData)
else
Exit do
End if
Loop
Msgbox "SuccessFully Completed Running of scripts on Data"
'Function call to close the opened connection
fnCloseDatabase
'#################End of Driver Script#########################

Code Part-2:-
This contains called Functions by above Driver Script

Open database connection in Automation
Opening Database Connection

Update database in UFT
Fetch and Update database

Close Database Connection in UFT
Closing the Database Connection

 Working with Outlook API in UFT

Are Your Ready for HR Interview Round?

Scenario:-Some of the frequent asked questions in HR round.

Ur First Testing Help


Solution:– Thought of sharing some important questions, for which one should be prepared with logical answers to impress the HR team and have a valid offer :), for me this is the most boring part in a interview process.

Please share your comments or feedback


1.Why you want to change the current company?

2.What you want in your future joining organization?

3.What things your are most passionate about?

4.Things which you thought but was never able to accomplish ?

5.What you aim in your future ?


Hints:-
For all answers, try to sound genuine, with your answers having blend of technical flavor and carrier growth oriented.

Exhaustive List of Questions