How to retrive XML file data in QTP ? using Script(Chandana)

Answers were Sorted based on User's Feedback



How to retrive XML file data in QTP ? using Script(Chandana)..

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.

Is This Answer Correct ?    11 Yes 0 No

How to retrive XML file data in QTP ? using Script(Chandana)..

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

Is This Answer Correct ?    6 Yes 0 No

How to retrive XML file data in QTP ? using Script(Chandana)..

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.

Is This Answer Correct ?    9 Yes 5 No

How to retrive XML file data in QTP ? using Script(Chandana)..

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

Is This Answer Correct ?    7 Yes 4 No

How to retrive XML file data in QTP ? using Script(Chandana)..

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

Is This Answer Correct ?    3 Yes 1 No

How to retrive XML file data in QTP ? using Script(Chandana)..

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.

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More QTP Interview Questions

how can i call an external action,which is not added external action of an action?

2 Answers   Ordain Solutions,


How do u write a regular expression for date (dd/mm/yyyy) field?

10 Answers  


How many ways we can parameterize data in QTP ?

9 Answers  


What are the advantages of Object Repository?

0 Answers  


Tell me about your project? please help me how to tell about insurance project

0 Answers   Cap Gemini,






Hi any body pls help me for QTP 11.0 software free demo version. i have to practice. Kindly send the link.or where i have to download.

0 Answers  


Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloumns like Description, Code, date(DD/MM/YY), hours etc) and export these feilds to a Website and then click on Submit Automatically on that web page. This it should do for all the Rows in that excel file. Any help is much appriciated Thanks Shalini

2 Answers   TCS,


What are the different types of recording modes in qtp? Which will be used when?

0 Answers  


What are the types of object repository in qtp?

0 Answers  


there are having 10 checkboxes..how can i check only first 5 check boxes by using descriptive programing..

10 Answers   HealthAsyst,


Plz write the code, function will take the parameter as month number, i.e., numerical value, but it returns the last day of the month in string (weekday). example: input: function parameter: 3(march) output: thursday

1 Answers  


What is the difference between driver-script and AOM-script?

2 Answers   IBM, Value Labs,


Categories