Test Automation Ecstasy

Lot of members are facing some errors whenever trying to connect and read/write values from excel or other databases. Here is some code snippet which will easy the task for you... To Get Data: Function GetData(strFilePath, strSQL)  Dim objConn, objRecord, strConnectionString  Set objConn = CreateObject("ADODB.Connection")  Set objRecord = CreateObject("ADODB.RecordSet")  strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFilePath & ";Excel 12.0;HDR=YES;READONLY=1;IMEX=1;"  objConn.Open strConnectionString  objRecord.Open strSQL, objConn  msgbox objRecord(0).Value  objConn.Close End Function Points to take care: 1. Always use readonly=1 to force read-only mode while reading. 2.Use IMEX value based on your requirement. IMEX=1 - It will convert all data types to text and return. IMEX=2 - It will return the data as it is. To Write Data: Function UpdateData(strFilePath, strSQL)  Dim objConn...

Today I am going to write a simple topic on excel and it seems very simple but lot of automation testers in need of this topic. Say I want to have multiple data on a single cell(using ALT+ENTER). This will solve the purpose as well as maintenance easy.  Ok, How to get that data from excel and separate the data which was enterted using ALT+ENTER. Just get the cell data and replace the string for vbLF with "" (Empty String) and you can pass your data. Normally new line indicates vbCRLF (Chr(13) + Chr(10)) but in excel new line char is Char(10) i.e. only vbLF not vbCR or vbCRLF. Hope this will help you guys !!!

Lot of guys will face app hanging problem while script execution in QTP. You can always use QTP provided SystemMonitor API to know memory usage by application an you can decide your control mechanisms. SystemMonitor.GetValue("YourApp.exe","Memory Usage (in MB)") In the same way, you can get processor usage, Os details, etc.. If this will give you exact thing, always you can use WMI to get every system information you need.

In QTP, we can use lot of ways to identify an object. Most of the QTP Test Developers are always using streamlined and static approaches and if object is not identifiable using those approaches, just leaving then as not identifiable. We can try using below ways of handling objects for our purpose before saying NO !!! 1. Store the objects in OR If you are comfortable on using OR and suitable for your project with your designed framework, you can go ahead with OR. a. Add the object in OR, then see what are the properties will make QTP to identify this object uniquely.  b. Remove unwanted properties c. Add unique and required properties d. Assign regular expressions for the required properties which have dynamic values in full or part.Make use of Reg Exp Evaluator to set the RegExp correctly. e. Assign a human understandable, easily classifiable logical name for the object based on type of object, application module or screen, etc. 2. Use Descriptive Programming Here...

Always I am seeing  many of my friends asking for help if any error occurs while running script in QTP without googling for help. How much troubleshooting you guys are doing will directly reflect your knowledge on the tool. I agree, no one knows each and every error occurs in the software. But we can improve our knowledge by googling and doing workarounds... Whenever the question "How much level you know QTP?" arrows me, always I am comfortable with the answer "below 10%". But after answered, my mind will have an inner thought like, What are the things I have to learn to fulfill the answer I have told because I never used lot of features in QTP. Here I am listing out some of the errors, situations and what might be the original issue things etc. I hope this will give you some ideas to improve your debug ability and to solve your errors. Kindly correct me If I am wrong in any point. Type mismatch: - Mostly doing operations with different data types without doi...

Here I am listing out some common QTP topics those are concentrated on most QTP interviews. Hope this will help lot of QTP beginners. 1. Why we go for automation? 2. What is Action? What are the types? 3. What is function? What is Sub? Diff between these two? 4. What is OR? Types of OR? 5. Which kind of OR is best? 6. What is TO? What is RO? 7. How QTP identifies object in UI and does the operations? 8. What are types of properties for a object? Mandatory, Assistive, Ordinal Identifiers. 9. What is smart Identification? 10.What is Synchronization? What are the synchronization methods available? 11.How you generated your results? 12.How you will email the results automatically after execution? 13.What is framework? Have you worked/designed a framework? 14.VBScript - String functions, Array, FileSystemObject, DictionaryObject 15.Connecting Excel and fetching data? 16.Connecting database and fetching data? 17.What kind of applications you have automated? 18.What kind o...

Lot of testers have interest to know about, 1. What is agile model? 2. What is the advantage of it over other models? Agile - Simply we can say "On demand, more monitored and controlled testing" Agile model have benefits like, 1. Easy adoption of requirement changes at any stage. 2. Piece of working product will be arrived very early in life cycle. 3. More monitoring on team so every team members will be in same path and goal. SCRUM is one of a process of agile methodology. SCRUM involves below terms, 1. Sprint 2. Scrum master 3. User Stories 4. Work Items 5. Sprint Back Logs 6. Sprint retrospective item, etc. Sprint - Sprint is nothing but the scrum period. i.e. The no of days for between each release like 30 days, 15 days. This is mainly based on customer requirement. If your every sprint consists 30 days, then every 30 days there will be a release. Sometimes release will not be there based on customer request. Scrum Master - The person responsible to...