Parsing XML in Oscript

Francisco_Alcala-Soler_(iaea_001user3_-_(deleted))

Hi All,I am trying to read an XML file and obtain some values from it. I am not sure how to go about it.The file would contain something like: YYY and I would like to grab the value "YYY" to further process it in my Oscript script.I am testing commands like: String xmlFile = "C:\myFile.xml" DOMParser xmlParser = DOMParser.New() Assoc result = xmlParser.Parse( xmlFile ) DOMDocument xmlDocument = xmlParser.GetDocument() DOMNodeList xmlList = xmlDocument.GetElementsByTagName( "elementC" ) DOMNode xmlNode = xmlList.Item(0)So far, so good. It looks like I have traversed the DOM object all the way to the correct node. However, an expression like does not return the value "YYY" which I would like to get. I have tried to Cast() the node and other things, but I don't know my way around yet.Any help would be greatly appreciated. Curro

Find more posts tagged with

Comments

eLink User

Message from Jeremy Johnson <<A HREF="mailto:johnson_jeremy@bah.com">johnson_jeremy@bah.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">Message

I ran too ran intro problems parsing XML, as there are no real examples in the documentation. Try putting your value "YYY" in a CDATA section so it looks like:

Livelink treats the CDATA section as another node.

Attached is the code I use, there are other ways to parse w/o needing a CDATA section, but CDATA makes things safer. I haven't had a need for attributes so the sample code doesn't do handle it, but shouldn't be too hard to get that.

- Jeremy

-----Original Message-----
From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: Tuesday, April 08, 2003 9:08 AM
To: eLink Recipient
Subject: Parsing XML in Oscript

Parsing XML in Oscript Posted by IAEA_001User3 (Alcala-Soler, Francisco J) on 04/08/2003 09:07 AM

Hi All,

I am trying to read an XML file and obtain some values from it. I am not sure how to go about it.

The file would contain something like:

<elementA>
<elementB/>
<elementC attrC1="****">YYY</elementC>
</elementA>

and I would like to grab the value "YYY" to further process it in my Oscript script.

I am testing commands like:

String xmlFile = "C:\myFile.xml"
DOMParser xmlParser = DOMParser.New()
Assoc result = xmlParser.Parse( xmlFile )
DOMDocument xmlDocument = xmlParser.GetDocument()
DOMNodeList xmlList = xmlDocument.GetElementsByTagName( "elementC" )
DOMNode xmlNode = xmlList.Item(0)

So far, so good. It looks like I have traversed the DOM object all the way to the correct node. However, an expression like <xmlNode.GetNodeValue> does not return the value "YYY" which I would like to get. I have tried to Cast() the node and other things, but I don't know my way around yet.

Any help would be greatly appreciated.

Curro

eLink User

Message from via eLinkHi Jeremy,Thanks for the code snippet. It's helped me figure it out.> I ran too ran intro problems parsing XML, as there> are no real examples in the documentation.? Try> putting your value "YYY" in a CDATA section so it> looks like:>??? <![CDATA[YYY]]</elementC>>?> Livelink treats the CDATA section as another node.I can't afford to modify the XML input, so I can't make use of CDATA.However, in the normal case: ?? YYYthe DOMNode called 'elementC' has a child node of type DOMText, which can becast and on which I can apply the GetData() method, because it inherits itfrom DOMCharacterData interface.Cool, this code does it for me now: // ... some more code here to get to the node's parent ... // ... and park the child nodes in a DOMNodeList ... for item = 0 to (xmlList.GetLength() - 1) xmlNode = xmlList.Item(item) if (xmlNode.GetNodeName() == 'elementC') DOMNode xmlChildNode = xmlNode.GetFirstChild() DOMText xmlText = xmlTextNode.Cast() String xmlValue = tt.GetData() end endThe string xmlValue is the one I was looking for.Thanks a lot! CurroThis email message is intended only for the use of the named recipient.Information contained in this email message and its attachments may beprivileged, confidential and protected from disclosure. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication to others. Also please notify the sender by replying to thismessage and then delete it from your system.