Friday, September 24, 2010

QTP 11.00 Advanced Features

QTP 11.00 Advanced Features

QuickTest 11.00 now offers the following new features.

Manage Your Test Data

Quality Center (HP ALM) test configuration functionality enables you to determine at runtime which data sets to use for your tests.

ALM test configurations enable you to:

  • Unbind your data from your tests
  • Share common data sources across different tests
  • Filter your data to fit your testing needs
  • Increase requirements traceability

You store the data for your tests in the Quality Center Test Resources module in the form of data table resource files.

You can then define multiple test configurations for a test in the Test Plan module. When working with data-driven QuickTest tests in HP ALM, each configuration is a QuickTest test that is set to run with a selected data resource file and optional data filter settings.

One or more specific configurations of the test can be included in a Test Set to cover different parts of a requirement or to cover multiple requirements.

By using Quality Center test configurations, you can create more generic tests and reuse them by associating a different set of data with each. You can also reuse your data by associating the same data table file with multiple tests.

Test Your GUI and UI-Less Application Functionality in One Test

The new QuickTest-Service Test integration enables you to test across the GUI and non-GUI layers of your application.

You can use QuickTest steps to start testing the GUI elements in your application, then call a Service Test test to validate service communications (standard Web Services, non-SOAP Web Services, such as REST, etc.), and then step back into your QuickTest GUI testing, all in a single test run.

The results of the QuickTest and Service Test steps are displayed in a unified report in the new Run Results Viewer.

New Run Results Viewer

The new Run Results Viewer provides an Executive Summary page with summary data, pie charts and statistics for both the current and previous runs, a quick link to the previous run results, and more.

The Run Results Viewer displays the results of your run session in a set of panes that you can show, hide, move, dock, and otherwise customize to your needs.

You can install the Run Results Viewer as a standalone installation. This enables you to share the results of your tests with business analysts and developers who do not work with QuickTest.

Help QuickTest Identify Your Objects as a Manual Tester Would – VISUALLY

You can now use visual relation identifiers to identify application objects based on other objects that are always near them.

This enables you to create a more reliable identification definition for test objects that are otherwise difficult to differentiate, and to ensure that the identification remains reliable even if the user interface design changes.

The Visual Relation Identifier Dialog Box provides the interface and tools to help you create and verify your visual relation identifier definitions.

Collaborate with Developers to Pinpoint Defects Using Log Tracking

In today's more agile development environment, it is more important than ever for QA engineers and developers to work together throughout the development and release process.

QuickTest's new Log Tracking functionality helps you work with developers to pinpoint the root causes of unexpected behavior in your application.

When you enable log tracking, QuickTest receives the Java or .NET log framework messages from your application and embeds them in the run results.

You can click a log message in the results to jump to the relevant step in the run results tree, or you can click a step in the run results tree and view the log message that was generated at the time that the selected step ran. You can also specify that a log message of a particular level (or higher) will fail your test.

After you view the results, you can print or export the log tracking details to a file to show to a developer, or you can provide the developer with the standalone Run Results Viewer installation so that the developer can view and analyze the results directly on his or her own desktop.

Out-of-the-Box Support for Web 2.0 Toolkit Applications

QuickTest 11.00 provides Web Add-in Extensibility-based add-ins for ASP .NET Ajax, GWT, Yahoo UI, and Dojo Web 2.0 toolkits.

You can use these add-ins just as you would any other add-in. You can also use Web Add-in Extensibility or Extensibility Accelerator to customize the provided support to match your needs.

You install these add-ins by running the Web 2.0 Toolkit Support Setup from the Add-in Extensibility and Web 2.0 Toolkits option in the QuickTest Professional setup window.

The operations supported for each Web 2.0 test object class are a combination of custom operations developed for that test object class and operations directly inherited from the corresponding (base) Web Add-in test object class.

New Web Testing Capabilities

Many new testing capabilities are now available for working with Web-Based objects.

  • Firefox Testing. You can now record steps on Mozilla Firefox and use the .Object property to access the Firefox DOM.

  • XPath, CSS, Identifiers. You can add the XPath or CSS identifier properties to instruct QuickTest to identify a Web object in your application based on its XPath location or CSS definition.

  • Event Identifiers. You can also now use the attribute/* notation in the test object description to identify a Web-based object based on an event associated with that object. For example, you can add attribute/onClick as a property in a WebButton test object description to identify a button that is associated with the onClick event.
  • Embed or Run JavaScripts in Your Web Pages. You can use the new EmbedScript/EmbedScriptFromFile and RunScript/RunScriptFromFile functions to embed JavaScripts in all loaded browser pages and frames or to run JavaScripts in specific pages. Use these scripts to perform operations on, or retrieve data from, the browser pages in your application.

Automatically Parameterize Steps

You can instruct QuickTest to automatically parameterize the steps in your test's actions at the end of a recording session.

This enables you to create actions that can be used for a variety of different purposes or scenarios by referencing different sets of data.

You activate this option by selecting the Automatically parameterize steps option in the General tab of the Options dialog box. You can set the option to use Global Data Table Parameters or Test Parameters.

When you stop a recording session while this option is selected, QuickTest replaces the constant values in the test object operation arguments of your steps with either Data Table parameters or action parameters, based on your selection in the Options dialog box.

QuickTest performs this automatic parameterization for all relevant steps in any action in your test, in which you recorded one or more steps during that recording session.

If you work with HP ALM, and you select the Global Data Table Parameters option, you can map the generated parameters to the column names of a data resource and then use different configurations in your test sets.

If you work with SAP eCATT and you select the Test Parameters option, you can then supply the values for the test parameters from eCATT.

New Silverlight Add-in

You can use the new Silverlight Add-in to test objects in Silverlight 2 and Silverlight 3 applications.

After you install the Silverlight Add-in, it is displayed in the Add-in Manager as a child add-in under the WPF Add-in.

Extend WPF and Silverlight Support

The WPF and Silverlight Add-in Extensibility SDK enables you to develop support for testing third-party and custom WPF and Silverlight controls that are not supported out-of-the-box by the relevant QuickTest add-ins.

You install the WPF and Silverlight Add-in Extensibility SDK from the Add-in Extensibility and Web 2.0 Toolkits option in the QuickTest Professional setup window.

Use Extensibility Accelerator for Web Add-in Extensibility Development

The new Extensibility Accelerator for Functional Testing is a Visual Studio-like IDE that facilitates the design, development, and deployment of Web Add-in Extensibility support.

It provides a user interface and special tools that help you define new test object classes, map those test object classes to the controls in your application, and teach QuickTest how to identify the controls, perform operations on the controls and retrieve their properties.

You install the Extensibility Accelerator from the Add-in Extensibility and Web 2.0 Toolkits option in the QuickTest Professional setup window.

It's Easier Than Ever to Insert Regular Expressions

The Smart Regular Expression list provides syntax hints that make it easier than ever to insert regular expressions into your test steps. It also enables you to access the Regular Expression Evaluator, which lets you test regular expressions to make sure they suit your needs.

Load Function Libraries at Run Time

The new LoadFunctionLibrary statement lets you load a function library when a step runs instead of at the beginning of a run session. This means, for example, that you can define conditional steps that use functions from various function libraries, but load only the required function libraries during a run session.

Avoid Downtime Due to License Server Failures

With redundant license servers you create failover, so that if your main license server fails, your remaining servers maintain availability of your licenses without causing any downtime or loss of licenses for users.

The redundant license server feature is especially useful for enterprise customers

who have a large network installation and want to maintain license server backup.

Improved Documentation Structure Helps You Find the Information You Need

When you open the QuickTest Professional Help, you can now access the entire Documentation Library from one central point, the Home page. It provides links to all available guides in each available format, including PDF files.

The HP QuickTest Professional User Guide and the HP QuickTest Professional for Business Process Testing User Guide are now organized into topic types: Concepts, Tasks, and References. Use each topic type to access specific information about a feature or product area.

For example, you can use the Tasks topic type to learn the overall workflow of a feature to help you accomplish your goals, or you can use the Reference topic type to look up a specific user interface element, such as a window, dialog box, or page.

Hope You Like this Post. Please Comment.

Sunday, September 19, 2010

Agile Testing Strategies

If you're having trouble viewing this email, Click here
 
Organized by
Edista Testing Institute
  QAI Global
 
  A Two Day Workshop On
  Agile Test Strategies and Management
        Bangalore: Sep 30 - Oct 01, 2010
Register Now
Workshop Instructor: A Narsimhan
Mr. Narasimhan is a Certified Scrum Master (CSM) and PMP® having more than 2 decades of experience in the IT industry. Narasimhan has conducted several training programs on Agile and SCRUM Master Training, Project Management for PMP®, Risk Management, Professional Ethics, Professional communication skills etc.

During his extensive career in IT, Mr. Narasimhan has been in various roles including Head of India Development center for a services company, Development Manager for an enterprise healthcare product, etc, and established and headed the PMO in a large multinational, headed the SEPG and steered process improvements successfully and also an Assessment Team Member for CMMI® L3 certification (with Agile Scrum). He has also presented papers on Scrum Methodologies in various national conferences.
 
   Workshop Objectives
This course provides two days of experience in managing and controlling Agile Software Testing projects, looking at the underlying philosophy and motivation for this trend in software testing /development and examining the core practices. The course does not teach any specific tool or technique but provides an introduction to the Agile Methods that will enable the participants to make informed decisions regarding practices that will be effective for their own organizations.
   Audience Profile
Participants are expected to have some understanding of basic business practice, and to have been exposed to aspects of the Software Development Lifecycle and Software Testing.
Participants should have some experience in guiding or leading teams and/or projects.
  Click here for details
 
 Workshop Methodology
The course is a mix of hands on case driven, instructor-led, and self paced learning, designed to enable participants learn, experiment and implement the concepts. The class will have exercises and discussions on real life situations.
 Workshop Coverage
Agile concepts
Introduction to Scrum
Estimation in Agile Scrum
Agile testing strategies/planning
Release Testing and automation
Metrics and Release management
Agile Engineering/Best practices
Test team dynamics
Exercise: Release planning and Estimation
Transitioning to Scrum
Exercise – 60 minute Sprint
Feedback/Conclusion
 
 Avail Special Discounts
5% Discount for Early Bird Registrations (15 Days in advance to the program date) 5% Discount on Task force of 4 to 7 10% Discount on task Force of 8 and above 10% discount applicable to CSTE / CSQA Qualified Professionals, PMI / CSI and NASSCOM Members
Note: Only one discount option is applicable at any time
 
 Contact Details    
Harsha Bhat
Phone: +91-80-40981424/5/6
Mobile
: +91-9845098916
Fax: +91 080 2550 6431
harsha.b@edistatesting.com
Course Fee:
Single Nomination: Rs. 15,000 + 10.3% ST
Task Force of Four: Rs. 54,000 + 10.3% ST
Test republic

QAI Global Institute  
Corporate eLearning Solutions
Online IT Training solutions from QAI Global Institute, Hosted on EdistaLearning. Clients include HCL, Wipro, HP, Satyam & many more.
Register for Course Details and Free Demo!
This mail is sent to you by QAI Global Institute
1010-12, Ansal Towers, 38 Nehru Place, New Delhi - 110019

Since India has no anti-spamming law, we follow the US Bill, which states that mail cannot be considered spam if it contains contact information, which this mail does. If you want to be removed from the mailing list please return mail with UNSUBSCRIBE as the subject
Click here to Unsubscribe
Sent to hemanthbolem@gmail.com. Unsubscribe | Update Profile | Forward to a Friend

Wednesday, July 14, 2010

OZ Agile Days 2010 - Program

Dear Ladies and Gentleman,

 

in November the OZ Agile Days 2010 take place in Sydney, Australia.

 

Today it is my pleasure to send the conference program through to you.

 

Over three thought-provoking days, explore new developments and key concepts as local and internationally recognized authorities share their unique experience in Agile – including North American experts Janet Gregory and Linda Rising, UK expert Stuart Reid and many more.

 

For further information please have a look at http://www.ozagile.com/

 

If you have any queries do not hesitate to contact me.

 

Best regards

 

Anna Granobs

 
Anna Granobs
Event Management & Media
 
Díaz & Hilterscheid Unternehmensberatung GmbH
Kurfürstendamm 179
10707 Berlin
 
Telefon: +49 (0)30 74 76 28 - 0
Telefax: +49 (0)30 74 76 28 - 99
 
José M. Díaz Delgado - Geschäftsführer
Julia Hilterscheid - Geschäftsführerin
Marc Ahlbach - Geschäftsführer
 
Ust-IdNr. DE195661616
Amtsgericht Berlin Charlottenburg HRB 67896
 
 
Email: Anna.Granobs@diazhilterscheid.de
 
--------------------------------------------------------------------------------
Diese Nachricht kann vertrauliche Informationen enthalten.
Weitere Information finden Sie unter www.diazhilterscheid.de/privacy.htm
 
This message may contain confidential information.
--------------------------------------------------------------------------------

Monday, June 21, 2010

Perl Introduction

PERL

Scripting Languages Vs Programming Languages

Scripting Language Programming Language
1) It is an Interpreter based Language 1) It is a compiler based Language.
2) Interpreter converts high level instructions into machine language line by line 2) Compiler converts the whole program in single short into machine language.
3) It doesn’t create executable file. 3) It Creates .exe file.
4) No need to compile the program Need to compile the program
5) It takes less code 4) It takes numerous lines of code
6) It greatly reduces development time 5) It increases development time
7) It reduces maintenance of cost 7) It Increases maintenance of cost
PERL-Practical Extraction and Reporting Language

# Perl was originally developed by Larry Wall, a linguist working as a systems administrator for NASA, in 1987, as a general-purpose Unix scripting language to make report processing easier.
# Perl is a high-level, general-purpose, interpreted, dynamic Scripting language.

The home of perl is UNIX
Perl Inherited features from UNIX utilities (awk, sed, grep, Smalltalk, Lisp, C, C++, Pascal and UNIX shell.
Perl written in C language.
Perl is free software.
Perl is open source code.
Perl is highly portable Language (supports 76+ Operating systems, Scripts developed in one operating system allows to run on other operating system with/without modifications.)
Perl supports oops concepts known as object oriented perl.
Perl supports database connectivity.
Perl has given CPAN (Comprehensive Perl Archive Network) modules.website is www.cpan.org
Perl was originally developed for to do manipulations in the text files later it is used in wide range of the following areas
System Administration
Database Administration
Network Programming
Web Development
Software Testing
Hardware Testing
Telecom
Vlsi
Baoinformatics and so on
It is built-in with UNIX and Its flavers like Linux, Solaris etc…
Perl is a case sensitive Language.
Each and every statement should end with (;) semicolon.
Perl is an interpreter based Language.
Extension of perl program is .pl or .plx
Perl supports two types of comments.
Single line comment (#)
Multi line comment
Pod (perl old document)

——

——

Cut

Perl program compilation Process:

Writing a program to display welcome message

#! C:perlbinperl

print “welcome to Perl n”;

print “This is my first program”;

Save with “first.pl”

Running perl Program in Windows

C:perl first.pl

#! It is shebang statement, used for to invoke perl interpreter path.

Running perl Program in UNIX/Linux

$ which perl # it displays location of perl

usr/bin/perl

perl –v # version of perl

$ man perl # help document

$ vi first.pl

#! usr/bin/perl

print “welcome to Perl n”;

print “This is my first program”;

$ perl first.pl

or

$ chmod 755 first.pl

$./first.pl

Chapter-2 (Variables)
Variables

It is a Data name or memory location name.
It is used for to store data value.
Value can change during execution of the program
It is a temporary storage location.
Perl allows implicit variable declaration.
Every variable occupies memory at runtime.
Variables are classified into 3 types

Scalar Variables
Array Variables or List Variables
Hash Variables or Associate Array Variables
1) Scalar Variables

It holds one value.
The value may be Integer or Float or String.
The Variable should begin with $ symbol.
a=10; – wrong

$a=10; – right

2) Array Variables

It is a group of scalar values
It should begin with @ symbol.
3) Hash Array Variables

It is a group of key pair values.
It should begin with % symbol.
1) Scalar Variables

$a=10; # Integer

$b=1.5; # Float

$c=”Gcreddy” #String

$d=”perl is a scripting language” # String

$e=”100” # String

$f=’Perl’ # String

Strings are classified into 3 types

1) Double quoted strings (“ “) or qq with delimiter of any one || or [] or {} or <>

2) Single quoted strings (‘ ‘) or q with delimiter of any one || or [] or {} or <>

3) Back tick / quoted strings (` `) or qx with delimiter of any one || or [] or {} or <>

a) $str=”perl”;

$x= “I like $str”;

print $x;

Output: I like Perl

b) $x= ‘I like $str’;

print $x

Output: I like $str

c) $x= “I like perl n $str”

print $x;

output: I like

Perl

d) $x= ‘I like n $str’;

print $x;

output: I like $x;

e) $str= “I said “Don’t write to disk””; # wrong

$str= “I said |“Don’t write to disk|””; # right

$str= ‘I said “Don’t write to disk”’; # wrong

$str= ‘I said “Don|’t write to disk”’; # right

$str= qq| I said “Don|’t write to disk”|; # right

$str= q|I said “Don’t write to disk”|; # right

f) $x= “Unix/Linux”; # right

$x= qq|Unix/Linux|; # wrong

$x= qq|Unix/Linux|; # right

$x= qq{Unix/Linux}; # wrong

note: qq for variable substitute

q for as it is

qx for OS command

# $x= `dir`;

`md xyz`;

$x= qx|dir|;

print $x;

perl –c pl.pl # compilation ok

Writing output:

Perl p1.pl>a1 # over write

Perl p1.pl>>a2 # add

Perl p1.pl> D:a3 # path

Standard Input / Output Handlers

print () – it used for to write data to the screen

print(“Hello”);

or

print “Hello”;

or

print STDOUT “Hello”;

I/O handlers

1) STDIN

2) STDOUT

3) STDERR

STDIN – It used for to accept input from user

Ex: write a program accepting name and display?

Print “What is your name”;

$name=; or <> # Diamond operator

print “Hello $name, Good morning”;

chmod ($name); # It is a pre-defined function, it deletes the given string lost line character if it is new line.

Ex2: write a program accept 2 integer values and find sum?

Print “Enter a number 1: “;

Chomp ($a= );

Print “Enter a number 2: “;

Chomp ($b= );

$c= $a + $b

print “n $a + $b= $c”;

Chapter-3 (Operators)
1) Arithmetic Operators:

+, -, *, /, %, ** (right to left)

a) $a=10;

$b=20;

print $a + $b;

output: 30

b) $a=10;

$b=25abc;

print $a + $b;

output: 35

a) $a=10;

$b=”abc20;

print $a + $b;

output: 10

d) $a=10;

$b=20abc34;

print $a + $b;

output: 30

e) $a=”perl”;

$b=”gcreddy”;

print $a + $b;

output: 0

f) $a=10;

$b=”25abc”;

print $a + $b;

output: 35

print $a .$b;

output: 1025abc

g) $a=2;

$b=3;

print $a ** $b;

output: 8

h) $a=2;

$b=3;

$c=2;

print $a ** $b ** $c;

output: 512

i) $a=2;

$b=3;

$c=2;

print ($a ** $b) ** $c;

output: 64

2) Relational Operators:

i) Numeric Comparison Operators

<, >, <=, >=, ==, !=, <=>

ii) String Comparison Operators

lt, gt, le, ge, eq, ne, cmp

a) $a=100;

$b=20;

$a>$b;

output: true

$a gt $b;

output: false (ansii nos)

b) $x= “tecno”;

$y= “harika”;

$x gt $y;

output: true

$x > $y;

output: false (0,0)

c) $a=100;

$b=20;

$c= $a<=>$b

if a>b output is 1

ay output is 1

x $b ? print “$a is big” : print “$b is big”;

10) Incremental Operator (++)

$a=10;

$a=$a+1; or $a+=1; or $a++;

11) Detrimental Operators (–)

$a=$a-1; or $a-=1 or $a–;

——————-****—————-****——————

Chapter-4 (Control flow statements)
a) Conditional Statements:

1) Simple if condition

if (condition)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

2) Simple unless

unless (condition)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

3) If….else

if (condition)

{

Statements

——–

——–

——–

}

else

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

4) unless….else

unless (condition)

{

Statements

——–

——–

——–

}

else

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

5) if….elseif…else

if (condition)

{

Statements

——–

——–

——–

}

else if (condition)

{

Statements

——–

——–

——–

}

else if (condition)

{

Statements

——–

——–

——–

}

else

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

6) Single line if statement

statement if (condition);

Statements

——–

——–

7) Single line unless statement

statement unless (condition);

Statements

——–

——–

b) Loop Statements:

1) While Loop

while (condition)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

2) until Loop

until (condition)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

3) Do while Loop

do

{

Statements

——–

——–

——–

}

while (condition)

{

Statements

——–

——–

——–

}

4) Do until Loop

do

{

Statements

——–

——–

——–

}

until (condition)

{

Statements

——–

——–

——–

}

5) For Loop

for (initiation; condition; increment/decrement)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

6) Foreach Loop

foreach variable (list of variables)

{

Statements

——–

——–

——–

}

Statements

——–

——–

——–

7) Last keyword:

It is used for to terminate the loop; it is same as break in ‘C’ Language.

While (condition)

{

Statements

——–

——–

last;

——–

——–

}

Statements

——–

——–

——–

Next keyword:

It is a keyword, used for to place control at beginning of the loop. It is same as continue in ‘C’ language.

While (condition)

{

Statements

——–

——–

next;

——–

——–

}

Statements

——–

——–

——–

Examples:
1) Write a program accepting a number and check given number is 3 digit number or not?

Print “Enter a number: “;

Chomp ($n= );

If ($n >=100 && $a <=999) { print “$n is a 3 digit number”; } else { print $n is not a 3 digit number”; 2) Write a program accepting user name and password and check for given user name & password are valid or not? Print “n Enter user name”; Chomp ($uname= );

Print “n Enter password”;

Chomp ($pwd= );

If ($uname eq “tecno” && $pwd eq “soft”

{

print “n welcome to tecnosoft”;

}

else

{

print “n invalid user name or password”;

}

3) Write a program to print numbers 1 to 10?

$num=1;

while ($num ,=10)

{

print “$num n”;

$num++

}

(or)

for ($num=1; $num <= 10; $num++)

{

print “$num n”;

}

(or)

foreach $num(1..10)

{

print “$num n”;

}

(or)

foreach (1..10)

{

print “$_ n”;

}

(or)

foreach (1..10)

{

print ;

}

Note: $_ is Perl special and default variable. If we don’t declare any variable for reading data then Perl will store the value in default variable.

Database Scripts-Part Two

Database Scripts-II

1) Insert Data into a database table using Database Command Object

Dim objCon,objCom
Set objCon=Createobject("ADODB.connection")

objCon.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\gcreddy.mdb;"

Set objCom=Createobject("ADODB.Command")
objCom.ActiveConnection=objCon

objCom.CommandText="insert into Emp values('G C Reddy',88233,30000)"
objCom.Execute

objCon.Close
Set objCom=Nothing
Set objCon=Nothing

2) Insert multiple sets of Data (using Excel sheet) into a database table using Database Command Object

Dim objCon,objCom,strEmpName,intEmpNo,intEmpSal,intRowcount,i
Set objCon=Createobject("ADODB.connection")

objCon.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\gcreddy.mdb;"

Set objCom=Createobject("ADODB.Command")
objCom.ActiveConnection=objCon

Datatable.AddSheet("input")
Datatable.ImportSheet "C:\gcreddy.xls",1,"input"
intRowcount=Datatable.GetSheet("input").GetRowCount
Msgbox intRowcount
For i=1 to intRowcount step 1
DataTable.SetCurrentRow(i)
strEmpName= DataTable.Value(1,"input")
intEmpNo= DataTable.Value(2,"input")
intEmpSal= DataTable.Value(3,"input")
objCom.CommandText="insert into Emp values( '"&strEmpName&" ',"&intEmpNo&","&intEmpSal&")"
objCom.Execute

Next

objCon.Close
Set objCom=Nothing
Set objCon=Nothing

Database Scripts-Part Two

Database Scripts-II

1) Insert Data into a database table using Database Command Object

Dim objCon,objCom
Set objCon=Createobject("ADODB.connection")

objCon.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\gcreddy.mdb;"

Set objCom=Createobject("ADODB.Command")
objCom.ActiveConnection=objCon

objCom.CommandText="insert into Emp values('G C Reddy',88233,30000)"
objCom.Execute

objCon.Close
Set objCom=Nothing
Set objCon=Nothing

2) Insert multiple sets of Data (using Excel sheet) into a database table using Database Command Object

Dim objCon,objCom,strEmpName,intEmpNo,intEmpSal,intRowcount,i
Set objCon=Createobject("ADODB.connection")

objCon.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\gcreddy.mdb;"

Set objCom=Createobject("ADODB.Command")
objCom.ActiveConnection=objCon

Datatable.AddSheet("input")
Datatable.ImportSheet "C:\gcreddy.xls",1,"input"
intRowcount=Datatable.GetSheet("input").GetRowCount
Msgbox intRowcount
For i=1 to intRowcount step 1
DataTable.SetCurrentRow(i)
strEmpName= DataTable.Value(1,"input")
intEmpNo= DataTable.Value(2,"input")
intEmpSal= DataTable.Value(3,"input")
objCom.CommandText="insert into Emp values( '"&strEmpName&" ',"&intEmpNo&","&intEmpSal&")"
objCom.Execute

Next

objCon.Close
Set objCom=Nothing
Set objCon=Nothing

Database Scripts-Part One

Database Scripts-I

1) Get Test Data From a Database and use in Data Driven Testing (through Scripting)

1) Dim con,rs
2) Set con=createobject("Adodb.connection")
3) Set rs=createobject("Adodb.recordset")
4) con.provider=("microsoft.jet.oledb.4.0")
5) con.open "C:\Documents and Settings\Administrator\My Documents\Gcreddy.mdb"
6) rs.open "Select * From Login",con
7) While rs.eof <>True
8) SystemUtil.Run "C:\Program Files\Mercury Interactive\QuickTest Professional\samples\flight\app\flight4a.exe"
9) Dialog("Login").Activate
10) Dialog("Login").WinEdit("Agent Name:").Set rs.fields ("Agent")
11) Dialog("Login").WinEdit("Password:").Set rs.fields ("Password")
12) Dialog("Login").WinButton("OK").Click
13) Window("Flight Reservation").Close
14) rs.movenext
15) Wend

2) Exporting Data from a Database to an Excel Sheet

1) Dim con,rs
2) Set con=createobject("adodb.connection")
3) Set rs=createobject("adodb.recordset")
4) con.provider="microsoft.jet.oledb.4.0"
5) con.open"C:\Documents and Settings\admin\My Documents\Gcreddy.mdb"
6) rs.open"select*from Login",con
7) Set ex=createobject("Excel.Application")
8) Set a=ex.workbooks.open("C:\Documents and Settings\admin\My Documents\Gcreddy.xls")
9) Set b=a.worksheets("sheet1")
10) i=1
11) Do While Not rs.EOF
12) b.cells (i,1).value=rs.fields("agent")
13) b.cells(i,2).value=rs.fields("password")
14) rs.movenext
15) i=i+1
16) Loop
17) a.save
18) a.close

3) Exporting Data from a Database to a Text file
Dim objCon,objRs,ObjFso,myFile,myData,rc,r
Set objCon=createobject("Adodb.connection")
Set objRs=createobject("Adodb.Recordset")
set objFso=createobject("Scripting.Filesystemobject")
Set myFile=objFso.OpenTextFile("C:\Documents and Settings\gcr\My Documents\gcreddy.txt",8)
objcon.provider=("Microsoft.jet.oledb.4.0")
objcon.open"C:\Documents and Settings\gcr\My Documents\gcreddy.mdb"
objrs.open "select * from login",objCon
r=1
Do until objRs.EOF
a=objRs.Fields ("Agent")
b=objRs.Fields ("Pwd")
myFile.Writeline a &","& b
r=r+1
objRs.MoveNext
Loop
myFile.Close
objCon.Close

4) Connecting to a SQL Sever database

Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open _
"Provider=SQLOLEDB;Data Source=atl-sql-01;" & _
"Trusted_Connection=Yes;Initial Catalog=Northwind;" & _
"User ID=fabrikam\kenmyer;Password=34DE6t4G!;"

objRecordSet.Open "SELECT * FROM Customers", _
objConnection, adOpenStatic, adLockOptimistic

objRecordSet.MoveFirst

Wscript.Echo objRecordSet.RecordCount

5) Open a Database Using a DSN

Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open _
"Northwind;fabrikam\kenmyer;34ghfn&!j"

objRecordSet.Open "SELECT * FROM Customers", _
objConnection, adOpenStatic, adLockOptimistic

objRecordSet.MoveFirst

Wscript.Echo objRecordSet.RecordCount


6) Open Two Recordsets


Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")
Set objRecordSet2 = CreateObject("ADODB.Recordset")

objConnection.Open _
"Provider= Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=inventory.mdb"

objRecordSet.Open "SELECT * FROM GeneralProperties Where ComputerName = 'Computer1'", _
objConnection, adOpenStatic, adLockOptimistic

objRecordSet.MoveFirst


objRecordSet2.Open "SELECT * FROM Storage Where ComputerName = 'Computer1'", _
objConnection, adOpenStatic, adLockOptimistic

objRecordSet2.MoveFirst

Do Until objRecordset.EOF
Wscript.Echo objRecordset.Fields.Item("ComputerName")
Wscript.Echo objRecordset.Fields.Item("OSName")
objRecordSet.MoveNext
Loop

Do Until objRecordset2.EOF
Wscript.Echo objRecordset2.Fields.Item("DriveName"), _
objRecordset2.Fields.Item("DriveDescription")
objRecordSet2.MoveNext
Loop

objRecordSet.Close
objRecordSet2.Close
objConnection.Close


7) Searching a Database Using String Criteria

Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open _
"Provider = Microsoft.Jet.OLEDB.4.0; " & _
"Data Source = eventlogs.mdb"

objRecordSet.Open "SELECT * FROM EventTable " & _
"WHERE Type = 'Error'", objConnection, adOpenStatic, _
adLockOptimistic

objRecordSet.MoveFirst

Wscript.Echo "Number of records: " & objRecordset.RecordCount

objRecordSet.Close
objConnection.Close

Friday, May 14, 2010

Urgent Requirement : Software- Testing Engineer

We are Tharka HR solutions(A Division of Tharka Infotech Pvt Ltd) one of the leading recruitment and HR services consulting company from Hyderabad. We are retained by MNC.

Following is the Requirement
Position: software- Testing Eng
Location : Hyderabad / Bangalore / Chennai / Delhi / Mumbai / Pune
Years of Experience : 2 â€" 6 years
Education Qualification: BE / B.Tech / MCA
NOTE: Please mention the Location ( your Job Preffered Place)
Skill Requirement:
Primary / Must Have Skills:
Testing - Functional, QTP Automation, Performance â€" Load Runner, ETL,
Database, Strong in SQL

Good communication skills (Spoken/written)

For careers post your resumes at -  naveen@tharka.com

CTC as per industry standard and is no bar for the right candidate.

Please send the following details if the above job opening interests you.
1. Updated profile in word format
2. Current Annual Salary + Benefits:
3. Expected Annual Salary + Benefits:
4. Notice period :
5. Two Reference names with contact numbers :
Please forward to your friends and colleagues who are looking for change!!!!
Note: If you have already received the mail for the same OR If the requirement is not matching to your profile, please accept our Apologies and ignore this mail.

Contact Person:
Naveen Kumar
Tharka HR solutions
Mobile : 09886145613

"Testing Openings" @ Software Company Chennai,Walkin our Hyderabad Office

Hi Friend, "Have a great day"
======================================================

Pls walkin Immediately to our Hyderabad office.
======================================================

Refering to your Resume we have immediate openings for
"Testing" in Software company @ Chennai.,If you are Interested
to work with this software pioneer.PLEASE WALKIN


Job Location : Chennai
Skills : "Manual Testing, QTP"
Exp:- : 2+ yrs of Exp

==============================================

Walkin Timing :

Saturday ( 15.05.10) 4.00 PM to 7 PM

Sunday ( 16.05.10) 9.00 AM to 1 PM

===============================================
Contact:
Vasu
Shree Consultancy,
Arun Aditya Residency,
No.6-3-841/a/2
4 Floor, Old Post Office Road(Big Bazaar Road)
Near Durga Temple
opp Road to: Iyangar Bakery
Ameerpet,
Hyderabad-38
Ph.No:: 9293773439

QTP Info

Dear Professionals,

Now websites enhanced with more content, visit and upgrade your skills:


I) QTP Step by Step Guide





Test Pane




Test Object Model



Keyword Driven Methodology



Enhancing Tests







Adding Comments

Inserting Flow Control Statements


Running/Executing Tests

Analyzing Test Results & Reporting

Reporting Defects


Functions


Virtual Object Configuration 


Batching Testing




Automation Object Model


Dynamic Handling of Object Repositories



                                                          II)QTP Scripting








Power point Scripts

Word Scripts



QTP Framework


Test Automation Framework

Types of Framework

Folder Structure

Record & Playback or Linear Framework

Modular Driven framework

Data Driven Framework

Keyword Driven framework

Hybrid driven Framework

Driver Script Creation

Initialization Script



                                        V) QTP Interview Questions


                                                      QTP Certification
This section provides HP QTP Certification guidelines and model Questions, It useful for QTP test professionals for preparing Certification exam.



                                             QTP Training Programs



This section provides QTP Related articles and other information like, challenges in Test Automation using QTP, Migrating Test scripts from old version to New version, QTP trends, enhancements, New release information, Browser compatibility issues etc..


Software Testing Reference
    
Sample BRS Document
Sample SRS Document
Software Test Metrics 
SQL for Testers 
SQL Queries Examples 
SQL and PL / SQL Interview Questions-I
SQL and PL / SQL Interview Questions-II
SQL and PL / SQL Interview Questions-III
Test case writing
Testing Interview questions
Software Test Documents
Configuration Management
Software Testing Guide
Unit Testing
Selenium tool
Test Management
Manual Testing Questions & Answers Part-II
Manual Testing Questions and Answers Part-I
Software Test Methods
Requirement Management Tools
Requirements Management
 
Rational Robot
 
An Introduction to Quality Center
 
An Introduction to LoadRunner  
Performance Testing  
Usability Testing
CMM Levels Vs ISO Standards
Agile methodology
Test Design Techniques  
ISTQB Certification Model questions
Test plan
Performance Test Plan
Use Case template  
web dictionary
Static Testing
Web testing guidelines 
Database tutorial
Certification Model questions
Software Quality Standards
ISTQB Certification Guidelines
Database Testing
Quality Assurance