[Webtest] How to write to Excel file with CanooWebTest?
Dierk Koenig
webtest@lists.canoo.com
Mon, 10 Jul 2006 22:53:43 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01C6A473.B1D15C40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
WebTest writes all result information to WebTestResult.xml.
You can use all kinds of tools to extract data from there and store it into
Excel, e.g. XSLT or a little Groovy script.
For a more elaborate scenario, you could also register your own
BuildListener (written in Java or Groovy) to
hang into the execution of WebTest steps as they are executed. That's what
the IDEs do that show the
progress of WebTest in action.
cheers
Mittie
-----Original Message-----
From: webtest-admin@lists.canoo.com
[mailto:webtest-admin@lists.canoo.com]On Behalf Of Darwin.XP
Sent: Montag, 10. Juli 2006 22:35
To: webtest@lists.canoo.com
Subject: Re: [Webtest] How to write to Excel file with CanooWebTest?
Hi,
Thanks for showing interest.
I am trying to pickup selected values from the test site and write them to
an Excel file.
With CanooWebTest I am testing functionality of the site and would like to
store some text data on intermediate and resulting pages in an Excel file
for later reference.
Like if I my search on the test site is resulting in a list 10 names I
would like to write these to the Excel file for each execution.
Thanks,
Razz
----- Original Message -----
From: Dierk Koenig
To: webtest@lists.canoo.com
Sent: Monday, July 10, 2006 12:47 PM
Subject: RE: [Webtest] How to write to Excel file with CanooWebTest?
Can you elaborate on what you are aiming to do?
cheers
Mittie
-----Original Message-----
From: webtest-admin@lists.canoo.com
[mailto:webtest-admin@lists.canoo.com]On Behalf Of Darwin.XP
Sent: Montag, 10. Juli 2006 20:12
To: webtest@lists.canoo.com
Subject: [Webtest] How to write to Excel file with CanooWebTest?
Hi,
Is there any way to write to an Excel file using CanooWebTest / ANT?
It would be great if someone can provide any pointers on this.
Thanks.
Razz
------=_NextPart_000_001C_01C6A473.B1D15C40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>WebTest writes all result information to=20
WebTestResult.xml.</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
can use all kinds of tools to extract data from there and store it into =
Excel,=20
e.g. XSLT or a little Groovy script.</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>For a=20
more elaborate scenario, you could also register your own BuildListener =
(written=20
in Java or Groovy) to</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>hang=20
into the execution of WebTest steps as they are executed. That's what =
the IDEs=20
do that show the</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>progress of WebTest in action.</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=3D775354920-10072006><FONT face=3DArial color=3D#0000ff =
size=3D2>Mittie</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
webtest-admin@lists.canoo.com =
[mailto:webtest-admin@lists.canoo.com]<B>On=20
Behalf Of </B>Darwin.XP<BR><B>Sent:</B> Montag, 10. Juli 2006=20
22:35<BR><B>To:</B> webtest@lists.canoo.com<BR><B>Subject:</B> Re: =
[Webtest]=20
How to write to Excel file with CanooWebTest?<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for showing =
interest.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to pickup selected values =
from the=20
test site and write them to an Excel file.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>With CanooWebTest I am testing =
functionality of=20
the site and would like to store some text data on intermediate and =
resulting=20
pages in an Excel file for later reference.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Like if I my search on the =
test site is=20
resulting in a list 10 names I would like to write these to the Excel =
file for=20
each execution.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Razz</FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Ddierk.koenig@canoo.com =
href=3D"mailto:dierk.koenig@canoo.com">Dierk=20
Koenig</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dwebtest@lists.canoo.com=20
href=3D"mailto:webtest@lists.canoo.com">webtest@lists.canoo.com</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, July 10, 2006 =
12:47=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [Webtest] How to =
write to=20
Excel file with CanooWebTest?</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=3D498204619-10072006><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Can you elaborate on what you are aiming to =
do?</FONT></SPAN></DIV>
<DIV><SPAN class=3D498204619-10072006><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D498204619-10072006><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=3D498204619-10072006><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Mittie</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff =
2px solid; MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> <A=20
=
href=3D"mailto:webtest-admin@lists.canoo.com">webtest-admin@lists.canoo.c=
om</A>=20
[mailto:webtest-admin@lists.canoo.com]<B>On Behalf Of=20
</B>Darwin.XP<BR><B>Sent:</B> Montag, 10. Juli 2006 =
20:12<BR><B>To:</B> <A=20
=
href=3D"mailto:webtest@lists.canoo.com">webtest@lists.canoo.com</A><BR><B=
>Subject:</B>=20
[Webtest] How to write to Excel file with=20
CanooWebTest?<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is there any way to write to an =
Excel file=20
using CanooWebTest / ANT?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>It would be great if someone can =
provide any=20
pointers on this.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks.<BR>Razz =20
</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_001C_01C6A473.B1D15C40--