[Wtr-general] data driven testing using WTR

[Beaton, Malcolm]

I was working on something to do similar a while back (with some help
from MB I think)

 

I got an xls sheet test running against what I wanted but then work got
in the way and I haven't been back to it for a bit

 

I have tried posting what I have but not sure the attachments will come
thru. The XL sheet Has to be in the same folder as the script, It runs
against Virgin Atlantics public site so it should work for anyone (Sorry
it is still full of all the rubbish I put in when I'm working) But hope
it points you in the right direction.

 

If you come up with better cleaner etc post it back I'd love to see it.

 

It basically goes across then down rows and grabs 

 

Type of object from 1 

ID (?? Cant remember  what that is? The ID of the object perhaps?) from
2

Value we set it to from 3

Validate (??Again Cant remember  what that is? The ID of the next
object perhaps?) from 4

And finally what we expect to see from row 5.

 

So it goes B1 - 5 C 1 - 5 Etc 

 

It is set up so B fails C, D and E Pass

 

(have just re read it and its pretty all over the place but I'm sure
you'll get the idea)

 

Malcolm Beaton

M +44 (0) 777 071 3121 

________________________________

From: wtr-general-bounces at rubyforge.org
[mailto:wtr-general-bounces at rubyforge.org] On Behalf Of Anil Kumar Das
Sent: 11 April 2006 21:23
To: Wtr-general at rubyforge.org
Subject: [Wtr-general] data driven testing using WTR

 

I am trying to implement data driven testing using xls sheet & watir.
 

For example:
1. I have an xls sheet(c:/info.xls) with three columns called name,ssn,
telephone/ 10-10 records in each column
2. My screen has three fields and submit button
name 
ssn
telephone

I want to get data from xls sheet, enter in screen & submit records one
by one.
 

Any workaround?? -- how to do this using watir or ruby
 


_____________________________________________________________________
This e-mail has been scanned for viruses by MessageLabs. The information contained in this message is confidential and is intended for the addressee only. If you have received this message in error, please notify Conchango plc as soon as possible. The unauthorised use, disclosure, copying or alteration of this message is prohibited and may be unlawful. The internet cannot guarantee the integrity of this message and therefore Conchango plc will not be liable for the message if modified.  

Reg. Heritage House, Church Road, Egham, Surrey, TW20 9QD T 44 (0) 1784 222 222 F 44 (0) 1784 222 200 E talktous at conchango.com  No. 2598884
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/wtr-general/attachments/20060412/12da4b75/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TempTry.rb
Type: application/octet-stream
Size: 5185 bytes
Desc: TempTry.rb
Url : http://rubyforge.org/pipermail/wtr-general/attachments/20060412/12da4b75/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FieldControlDem.xls
Type: application/vnd.ms-excel
Size: 15872 bytes
Desc: FieldControlDem.xls
Url : http://rubyforge.org/pipermail/wtr-general/attachments/20060412/12da4b75/attachment.xls