Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrive XML file data in QTP ? using Script(Chandana)
- 6 Answers
- 33889 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Hi, I am supposed to automate mainframe application through qtp. I do not know how to start abt it. Can you plz help me in first initializing the process or do you anybody have a guide book or a link which guides me through the process of automating the mainframe applications and things involved in it.
Does the Existing reusable action can be modified at the time of calling the action?? Please help me..
Can anybody post some real time scenario in qtp? please its very urgent.
what is the diff between manual test plan document and automation test plan doc.can u explain indetail.
how to open Excel sheet & write in it & save it?
what is meant by iterative model?What is its working principle?What are its advantages and what are its drawbacks?
whare exactly we have to use functions and sub routain
What is Maximum synchronization time out in QTP(By Default is 20sec). Anybody can answer it. Thanks in advance.
How we can merge the object repositories?say if we have two or three object repositories then how e can merge them? is there any option in Qtp to merge the object repositories
How does QTP identifies the object in the application?
What is the difference in between function and sub as well as give some code of both
Hi,iam new to automation and i have 1 year experience in manual testing.I have a little bit idea about QTP9.0 .But i have no idea about script writing using VB.Please help to learn script writing.
WinRunner 
