Cannot read the XML file if there is schema

[LWU]

Here is the XML file:
<?xml version="1.0" encoding="UTF-8" ?>
- <CTMS xmlns="ctms-20.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="ctms-20.xsd
http://www.clinphone.com/schema/CTMS-20.xsd" transferType="Incremental"
transferId="-1" previousTransferId="-1"
creationDateTime="2006-10-13T01:01:01" metaDataVersion="1.0">
- <StudyData studyId="HGS1006C1056">
- <SubjectManagement countryId="USA" siteId="US123" patId="991001"
messageType="Screening Details">
- <CTMS_Terms>
<DateOfBirth>16-DEC-2006</DateOfBirth>
<DateOfScreening>2006-10-12T01:01:01</DateOfScreening>
<Gender>M</Gender>
</CTMS_Terms>
</SubjectManagement>
</StudyData>
- <AuditRecord>
<UserRef>CLP</UserRef>
<LocationRef>GRB</LocationRef>
<DateTimeStamp>2006-10-13T01:01:01</DateTimeStamp>
<ReasonForChange>Automated Update</ReasonForChange>
<SourceId>0</SourceId>
</AuditRecord>
</CTMS>

---End of XML File

And My question is I would like to parse the studyId, and countryId,
sitId, patId and messageType, and DateOfBirth and DateOfScreening.
My code is the following:
m_xmld = New XmlDocument()
m_xmld.Load(xmlFile)
Dim ncsi As New XmlNamespaceManager(m_xmld.NameTable)
ncsi.AddNamespace("foo", "ctms-20.xsd")
ncsi.AddNamespace("xsi",
"http://www.w3.org/2001/XMLSchema-instance")

m_nodelist1 = m_xmld.SelectNodes("/CTMS/StudyData", ncsi)
For Each m_node1 In m_nodelist1
studyIdAttribute =
m_node1.Attributes.GetNamedItem("studyId").Value
Next
m_nodelist2 =
m_xmld.SelectNodes("/CTMS/StudyData/SubjectManagement")
For Each m_node2 In m_nodelist2
countryIdAttribute =
m_node2.Attributes.GetNamedItem("countryId").Value
siteIdAttribute =
m_node2.Attributes.GetNamedItem("siteId").Value
patIdAttribute =
m_node2.Attributes.GetNamedItem("patId").Value
mtAttribute =
m_node2.Attributes.GetNamedItem("messageType").Val ue
Next
m_nodelist3 =
m_xmld.SelectNodes("/CTMS/StudyData/SubjectManagement/CTMS_Terms")
For Each m_node3 In m_nodelist3
DOB = m_node3.ChildNodes.Item(0).InnerText
SEX = m_node3.ChildNodes.Item(1).InnerText
Next
m_nodelist4 = m_xmld.SelectNodes("/CTMS/AuditRecord")
For Each m_node4 In m_nodelist4
UserRef = m_node4.ChildNodes.Item(0).InnerText
LocationRef = m_node4.ChildNodes.Item(1).InnerText
DateTimeStamp = m_node4.ChildNodes.Item(2).InnerText
ReasonForChange = m_node4.ChildNodes.Item(3).InnerText
SourceId = m_node4.ChildNodes.Item(4).InnerText
Next
---End of Code
I alwasy get back the empty string for all nodes and all elements.
Any help....

[Martin Honnen]

LWU wrote:

Here is the XML file:
<?xml version="1.0" encoding="UTF-8" ?>
- <CTMS xmlns="ctms-20.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="ctms-20.xsd
http://www.clinphone.com/schema/CTMS-20.xsd" transferType="Incremental"
transferId="-1" previousTransferId="-1"
creationDateTime="2006-10-13T01:01:01" metaDataVersion="1.0">
- <StudyData studyId="HGS1006C1056">
- <SubjectManagement countryId="USA" siteId="US123" patId="991001"
messageType="Screening Details">
- <CTMS_Terms>
<DateOfBirth>16-DEC-2006</DateOfBirth>
<DateOfScreening>2006-10-12T01:01:01</DateOfScreening>
<Gender>M</Gender>
</CTMS_Terms>
</SubjectManagement>
</StudyData>
- <AuditRecord>
<UserRef>CLP</UserRef>
<LocationRef>GRB</LocationRef>
<DateTimeStamp>2006-10-13T01:01:01</DateTimeStamp>
<ReasonForChange>Automated Update</ReasonForChange>
<SourceId>0</SourceId>
</AuditRecord>
</CTMS>

---End of XML File

And My question is I would like to parse the studyId, and countryId,
sitId, patId and messageType, and DateOfBirth and DateOfScreening.
My code is the following:
m_xmld = New XmlDocument()
m_xmld.Load(xmlFile)
Dim ncsi As New XmlNamespaceManager(m_xmld.NameTable)
ncsi.AddNamespace("foo", "ctms-20.xsd")
ncsi.AddNamespace("xsi",
"http://www.w3.org/2001/XMLSchema-instance")

m_nodelist1 = m_xmld.SelectNodes("/CTMS/StudyData", ncsi)

m_nodelist1 =
m_xmld.SelectNodes("/foo:CTMS/foo:StudyData", ncsi);

For Each m_node1 In m_nodelist1
studyIdAttribute =
m_node1.Attributes.GetNamedItem("studyId").Value
Next
m_nodelist2 =
m_xmld.SelectNodes("/CTMS/StudyData/SubjectManagement")

m_xmld.SelectNodes("/foo:CTMS/foo:StudyData/foo:SubjectManagement")

Use that prefix in XPath expressions.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[John Saunders]

"LWU" <wu*******@gmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

Here is the XML file:
<?xml version="1.0" encoding="UTF-8" ?>
- <CTMS xmlns="ctms-20.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="ctms-20.xsd
http://www.clinphone.com/schema/CTMS-20.xsd" transferType="Incremental"
transferId="-1" previousTransferId="-1"
creationDateTime="2006-10-13T01:01:01" metaDataVersion="1.0">
- <StudyData studyId="HGS1006C1056">

....

</StudyData>

....

</CTMS>

---End of XML File

And My question is I would like to parse the studyId, and countryId,
sitId, patId and messageType, and DateOfBirth and DateOfScreening.
My code is the following:
m_xmld = New XmlDocument()
m_xmld.Load(xmlFile)
Dim ncsi As New XmlNamespaceManager(m_xmld.NameTable)
ncsi.AddNamespace("foo", "ctms-20.xsd")
ncsi.AddNamespace("xsi",
"http://www.w3.org/2001/XMLSchema-instance")

m_nodelist1 = m_xmld.SelectNodes("/CTMS/StudyData", ncsi)

If you specify "foo" for the namespace prefix in the AddNamespace, then you
have to use foo:. Try /foo:CTMS/foo:StudyData.

John

[LWU]

This is WORKING...
You guys awesome..
John Saunders wrote:

"LWU" <wu*******@gmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

Here is the XML file:
<?xml version="1.0" encoding="UTF-8" ?>
- <CTMS xmlns="ctms-20.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="ctms-20.xsd
http://www.clinphone.com/schema/CTMS-20.xsd" transferType="Incremental"
transferId="-1" previousTransferId="-1"
creationDateTime="2006-10-13T01:01:01" metaDataVersion="1.0">
- <StudyData studyId="HGS1006C1056">

...

</StudyData>

...

</CTMS>

---End of XML File

And My question is I would like to parse the studyId, and countryId,
sitId, patId and messageType, and DateOfBirth and DateOfScreening.
My code is the following:
m_xmld = New XmlDocument()
m_xmld.Load(xmlFile)
Dim ncsi As New XmlNamespaceManager(m_xmld.NameTable)
ncsi.AddNamespace("foo", "ctms-20.xsd")
ncsi.AddNamespace("xsi",
"http://www.w3.org/2001/XMLSchema-instance")

m_nodelist1 = m_xmld.SelectNodes("/CTMS/StudyData", ncsi)

If you specify "foo" for the namespace prefix in the AddNamespace, then you
have to use foo:. Try /foo:CTMS/foo:StudyData.

John