XPath Teamcenter-XML

Submitted by Robse-ponte on Wed, 08/31/2016 - 05:00
Forums: 
.NET programming

Hello Gurus,

I´ve got a problem with reading a Teamcenter Xml-File via XPath.

I am not able to get the right path for following XML-Data: < > are replaced with ( and )

(TcBusinessData xmlns="http://teamcenter.com/BusinessModel/TcBusinessData" Date="")
(Add)
(TcLOV name="INDO_WL_Bemerkung" lovType="ListOfValuesString" usage="Exhaustive" description="")
(TcLOVValue value="Rilsan" description="" conditionName="isTrue"/)
(TcLOVValue value="Bronce 1" description="" conditionName="isTrue"/)
(/TcLOV)
(/Add)
(/TcBusinessData)

My Function looks like this:

Function ReadXML(XmlFile As String, Pattern As String)

Dim list As New List(Of String)

Dim Xml As New XmlDocument()
Xml.Load(XmlFile)
For Each ReadNode As XmlNode In Xml.SelectNodes_
("//TcLOV[@name=""" & Pattern & """]/TcLOVValue/@value")
list.Add(ReadNode.InnerText)
Next

Return list
End Function

If I remove the part with the namespace URI

xmlns="http://teamcenter.com/BusinessModel/TcBusinessData"

erverything does work. I tried now so many different things like using the entire Path, including the attributes and namespaces etc. Could anyone tell me the right code? Seems I am too stupid...

Thank you and best regards

Robse-ponte - Thu, 09/01/2016 - 09:40

Function ReadXML(Xml_File As String, Pattern As String)

Dim list As New List(Of String)

Dim Xml As New XmlDocument()
Xml.Load(Xml_File)
Dim nsmgr As XmlNamespaceManager = New XmlNamespaceManager(Xml.NameTable)
nsmgr.AddNamespace("x", "http://teamcenter.com/BusinessModel/TcBusinessData")

For Each ReadNode As XmlNode In Xml.SelectNodes("//x:TcLOV[@name=""" & Pattern & """]/x:TcLOVValue/@value", nsmgr)
list.Add(ReadNode.InnerText)
Next
Dim XmlArray() As String = list.ToArray

Return XmlArray

End Function

Best Regards