Click here to Skip to main content
14,641,193 members
Home » Discussions » Visual Basic
   

Visual Basic

 
AnswerRe: Yahoo Finance API Throwing 504 Status? Pin
Afzaal Ahmad Zeeshan19-May-17 23:56
mvaAfzaal Ahmad Zeeshan19-May-17 23:56 
QuestionOutlook signature code suddenly causing "remote procedure call failed" message Pin
Member 1320910118-May-17 7:18
MemberMember 1320910118-May-17 7:18 
AnswerRe: Outlook signature code suddenly causing "remote procedure call failed" message Pin
Richard MacCutchan18-May-17 21:43
mveRichard MacCutchan18-May-17 21:43 
GeneralRe: Outlook signature code suddenly causing "remote procedure call failed" message Pin
Member 134178014-Dec-19 3:07
MemberMember 134178014-Dec-19 3:07 
GeneralRe: Outlook signature code suddenly causing "remote procedure call failed" message Pin
Richard MacCutchan4-Dec-19 3:28
mveRichard MacCutchan4-Dec-19 3:28 
GeneralRe: Outlook signature code suddenly causing "remote procedure call failed" message Pin
Member 134178014-Dec-19 3:32
MemberMember 134178014-Dec-19 3:32 
GeneralRe: Outlook signature code suddenly causing "remote procedure call failed" message Pin
Richard MacCutchan4-Dec-19 3:45
mveRichard MacCutchan4-Dec-19 3:45 
QuestionRetrieving value from an XML file Pin
Ben Senior17-May-17 8:32
MemberBen Senior17-May-17 8:32 
I'm new to working with XML in VB.NET and would like a little help after tearing my hair out for a couple of days.

I have an XML file with the following structure:

-<conceptGrp>
  -<descripGrp>
    <descrip type="subjectField">6411, 6821</descrip>
   </descripGrp>
  -<languageGrp>
    <language lang="DE" type="German"/>
   -<termGrp>
      <term>Scheren</term>
     -<descripGrp>
        <descrip type="termType">fullForm</descrip>
      </descripGrp>
     -<descripGrp>
        <descrip type="reliabilityCode">3</descrip>
      </descripGrp>
    </termGrp>
   </languageGrp>
  -<languageGrp>
    <language lang="EN" type="English"/>
   -<termGrp>
      <term>scissors</term>
     -<descripGrp>
        <descrip type="termType">fullForm</descrip>
      </descripGrp>
     -<descripGrp>
        <descrip type="reliabilityCode">3</descrip>
      </descripGrp>
    </termGrp>
   </languageGrp>
</conceptGrp>


First I need to cycle through all the elements in the file (>550000) and for each element extract the text
"6411, 6821" from
<descrip type="subjectField">6411, 6821</descrip>

and
"3" from
<descrip type="reliabilityCode">3</descrip>


The <descrpGrp> appears just once for each element.
The <languageGrp> appears at least twice but up to 20 times.
The <termGrp> appears mostly once but up to 10 times for each <languageGrp>.
The <descrpGrp> appears twice for each <termGrp>.
The <descrip type="reliabilityCode" ...> appears just once for each term.

Using the extracted strings I look them up and need to replace them with text in the element.

This is my code so far for getting the <descrip type="reliabilityCode">3</descrip>:

' loop thro each element in XML doc and replace the reliabiltiy codes
        For Each conceptGrp In xDoc.Elements("conceptGrp")
            For Each languageGrp In conceptGrp.Elements("languageGrp")
                For Each termGrp In languageGrp.Elements("termGrp")
                    Dim code = termGrp.Element("reliabilityCode")
                    For Each descripGP In termGrp.Elements("descripGrp")
                        For Each descrip In descripGP.Elements("descrip")
                            Dim reliability As String = xDoc.selectSingleNode("/Categories/category[@descrip='reliability code']").InnerText

                        Next descrip
                    Next descripGP
                Next termGrp
            Next languageGrp
        Next conceptGrp


When I look in the locals window I can see "descrip" and for the first node the property "next node" with the value I want but I just can't grab it.

How can I easily get the value and then replace it in the element with my looked up text?

Thanks
Ben

modified 17-May-17 20:17pm.

GeneralRe: Retrieving value from an XML file Pin
PIEBALDconsult17-May-17 14:11
professionalPIEBALDconsult17-May-17 14:11 
GeneralRe: Retrieving value from an XML file Pin
Ben Senior17-May-17 22:33
MemberBen Senior17-May-17 22:33 
GeneralRe: Retrieving value from an XML file Pin
Richard MacCutchan17-May-17 23:08
mveRichard MacCutchan17-May-17 23:08 
GeneralRe: Retrieving value from an XML file Pin
Ben Senior19-May-17 7:40
MemberBen Senior19-May-17 7:40 
GeneralRe: Retrieving value from an XML file Pin
Richard MacCutchan19-May-17 21:13
mveRichard MacCutchan19-May-17 21:13 
AnswerRe: Retrieving value from an XML file Pin
David Mujica19-May-17 7:02
MemberDavid Mujica19-May-17 7:02 
GeneralRe: Retrieving value from an XML file Pin
Ben Senior19-May-17 7:26
MemberBen Senior19-May-17 7:26 
GeneralRe: Retrieving value from an XML file Pin
David Mujica19-May-17 8:28
MemberDavid Mujica19-May-17 8:28 
AnswerRe: Retrieving value from an XML file Pin
Ben Senior20-May-17 4:28
MemberBen Senior20-May-17 4:28 
AnswerRe: Retrieving value from an XML file Pin
Meshack Musundi23-May-17 5:58
professionalMeshack Musundi23-May-17 5:58 
GeneralRe: Retrieving value from an XML file Pin
Ben Senior23-May-17 7:33
MemberBen Senior23-May-17 7:33 
QuestionCatching Control, Shift Key and Alt Key Presses and Releases Pin
Jalapeno Bob16-May-17 11:19
professionalJalapeno Bob16-May-17 11:19 
AnswerRe: Catching Control, Shift Key and Alt Key Presses and Releases Pin
Alex k (oShortyo)16-May-17 23:16
MemberAlex k (oShortyo)16-May-17 23:16 
AnswerRe: Catching Control, Shift Key and Alt Key Presses and Releases Pin
Richard Deeming17-May-17 1:19
mveRichard Deeming17-May-17 1:19 
GeneralRe: Catching Control, Shift Key and Alt Key Presses and Releases Pin
Jalapeno Bob17-May-17 7:03
professionalJalapeno Bob17-May-17 7:03 
QuestionGET PC POSITION IN VISUAL BASIC Pin
Otekpo Emmanuel9-May-17 13:28
MemberOtekpo Emmanuel9-May-17 13:28 
AnswerRe: GET PC POSITION IN VISUAL BASIC Pin
Chris Quinn9-May-17 21:28
MemberChris Quinn9-May-17 21:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.