How to retrive XML file data in QTP ? using Script(Chandana)
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 |
can u expect, major bugs in NET BANKING Project? Modules Transaction Module, Customer Relation Module.
What is the difference between run time object and test object?
I have recorded a test using qtp to download a file in an application. Code: Browser("MFA Work Queue Manager").Page("MFA Work Queue Manager").Link("Rules Maintenance").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebEdit("txtSearch").Set "PmtType" Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Search").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Export").Click Browser("MFA Work Queue Manager").Dialog("File Download").WinButton("Save").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").Sync Dialog("Save As").WinButton("Save").Click Dialog("Save As_2").WinButton("Yes").Click Problem: When running this test it gives an error at line no. 5 as Save button object is not identified by it's parent object. This code I ran 4 times after recording at it was working fine but 5th time onwords, it starts giving me the above problem. I used exist property option, Check Property option but none of this changes work at all. Kindly help...
How to insert screenshot on to the body of outlook? -1 how to use insert-picture tab in new email outlook to insert image in the body. Suggest something.......
How To Export The Screen Shoots Along With The Test Reports In QTP Version 10? Thanks In Advance SenthilKumar
what testing activities u may want to automate in a project?
How can we parameterize our test, values in flat file. Ex:- Values in notepad, with that values i want to parameterize the test.
How can we close all webbrowsers which are opened in out desktop?
How u connect bugzilla with QTP
1 Answers Deloitte, TCS, Wipro,
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
Explain quicktest professional (qtp) testing process?
write script to read and write data from file ?