Announcement

Collapse
No announcement yet.

XML Parsing Issue

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • XML Parsing Issue

    Hello All,

    I am having trouble getting this xml file to parse using DataReader. I like using data reader because it loads the information atutomatically and refreshes when i want it to. I have parsed xmls before but for some reason this one is giving me trouble. Is there a way to parse this using Data Reader or if some other way is better.

    Thanks in advance,
    Shotski

    <DATA>
    <RUN_DATE>Tue Jul 24 14:53:38 EDT 2018</RUN_DATE>
    <RUN_EPOCH>1532458418</RUN_EPOCH>
    <RACE ID="161">
    <RACE_INFO>
    <RACE_ID>161</RACE_ID>
    <JURISDICTION_ID>10</JURISDICTION_ID>
    <RACE_NAME1>Manatee County Commissioner</RACE_NAME1>
    <RACE_NAME2>District 7</RACE_NAME2>
    <NUM_SEATS>1</NUM_SEATS>
    <PROMPT_LINES1/>
    <PROMPT_LINES2/>
    <ALLCAND_VOTES>161917</ALLCAND_VOTES>
    <PRECINCTS_TOTAL>70</PRECINCTS_TOTAL>
    <PRECINCTS_REPORTING>70</PRECINCTS_REPORTING>
    <PCT_PRECINCTS_REPORTING>100</PCT_PRECINCTS_REPORTING>
    <UPDATED>2016-11-08 20:39:20</UPDATED>
    </RACE_INFO>
    <CANDIDATE_INFO>
    <CANDIDATE>
    <CANDIDATE_ID>1</CANDIDATE_ID>
    <DISPLAY_ORDER>1</DISPLAY_ORDER>
    <VISIBLE>Y</VISIBLE>
    <FIRST_NAME>Betsy</FIRST_NAME>
    <LAST_NAME>Benac</LAST_NAME>
    <INCUMBENT>Y</INCUMBENT>
    <WINNER>Y</WINNER>
    <PARTY_ID>2</PARTY_ID>
    <PARTY_ABBR>R</PARTY_ABBR>
    <PARTY_NAME1>Republican</PARTY_NAME1>
    <PARTY_NAME2>R</PARTY_NAME2>
    <VOTE_TOTAL>104920</VOTE_TOTAL>
    <VOTE_TOTAL_COMMIFIED>104,920</VOTE_TOTAL_COMMIFIED>
    <PCT_TOTAL>65</PCT_TOTAL>
    <PIC_ID/>
    </CANDIDATE>
    <CANDIDATE>
    <CANDIDATE_ID>2</CANDIDATE_ID>
    <DISPLAY_ORDER>2</DISPLAY_ORDER>
    <VISIBLE>Y</VISIBLE>
    <FIRST_NAME>Jack</FIRST_NAME>
    <LAST_NAME>Richardson</LAST_NAME>
    <INCUMBENT>N</INCUMBENT>
    <WINNER/>
    <PARTY_ID/>
    <PARTY_ABBR/>
    <PARTY_NAME1/>
    <PARTY_NAME2/>
    <VOTE_TOTAL>56997</VOTE_TOTAL>
    <VOTE_TOTAL_COMMIFIED>56,997</VOTE_TOTAL_COMMIFIED>
    <PCT_TOTAL>35</PCT_TOTAL>
    <PIC_ID/>
    </CANDIDATE>
    </CANDIDATE_INFO>
    </RACE>
    </DATA>

  • #2
    This is the link to the xml as well

    http://10.55.13.211/cgi-bin/exportEl...race_id=161%20[10.55.13.211]

    Comment

    Working...
    X