Answer / kr

In QTP9.0 it supports XML input data.here also same as in
QTP8.2 we can import .xml files into user defined
Environment Variable section.

Answer / sandipgami84

Hi Chandana,

u can retrive data from database(XML fromet)..

u can use SQL..
LIKE e.g. Select * FROM TableName For XML Type, AUTO

Sandip
Cell No: 09986645937

Answer / nidhi jain

Chandan, below is solution

Const XMLDataFile = <your file path>

Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.Async = False
xmlDoc.Load(XMLDataFile)

Set nodes = xmlDoc.SelectNodes(<provide you node hierarchy>)
MsgBox "Total books: " & nodes.Length

Set nodes = xmlDoc.SelectNodes("<node hierarchy>/text()")

' get their values
For i = 0 To (nodes.Length - 1)
Title = nodes(i).NodeValue
MsgBox "Title #" & (i + 1) & ": " & Title
Next


I hope this will be helpful.

Answer / fayaz

We can load environment variables from an xml file.

File --> Settings and click the "Environment" tab

You can see a check box "Load environment variables "

check it and give the path of the xml file.

when u run QTP , the variables in XML file will be
available.
And you can retrieve those values using Environment.value
("variable_name") from any actions.


Hope this will answer your question

Answer / reddy

shilpa u can not understanding what is the requirement of
chandana.
what she asking is how to retrieve xml file data using
script in qtp

ex: u have data in datatable that all the will be retrive
in xml format using script

Answer / shilpa reddy

chandana,we cannot apply xml data directly to script,first
we should import data into runtime datatable using import
sheet/import methods.using datatable methods we can apply
this values in our required location in the script.I
provided script for this in further answers,check it out
once.

How to export data present in Datatable to an ".xls" file?

1 Answers   Crea,

What are the problems / difficulties faced when you used Smart Identification ?

2 Answers   Keane India Ltd,

synchronization, wait,wait Property?

1 Answers  

Could some one help me the difference between GetTOProperty and SetTOProperty and when we will use these properties. and what is meant by SetToProperties..

5 Answers   Clinical Soft,

What are the different attributes used with regular expression?

0 Answers  

What are the key elements available in test result window?

0 Answers  

How to change the priorities of the recovery scenario properties?

0 Answers  

What type of VB script u had done in expert view?

1 Answers   HCL,

Is there any option in QTP to add Java add-in after instaling the QTP?

3 Answers   IBM,

Which property do you use to retrieve or assign data into a cell in a Data Table object?

1 Answers  

How will u find that how many List boxes( and check boxes) are present in one particular window

8 Answers  

How to use transactions in qtp?

0 Answers