vb.net xml parsing?

-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0\|702\|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Socoder -> Basic Basement -> vb.net xml parsing?
Sat, 24 Apr 2010, 03:53
spinal	I have had a look on the net, but i can't seem to get any examples i find to work properly Basically, I want to grab the imURL, imageNumber and romCRC extension=".nds" values from the following xml file and drop them into a listview box. (there would be a few thousand entries for 'game' <?xml version="1.0" encoding="UTF-8" standalone="no"?> <dat xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="datas.xsd"> <configuration> <datName>ADVANsCEne Nintendo DS Collection</datName> <datVersion>1506</datVersion> <system>Nintendo DS</system> <screenshotsWidth>256</screenshotsWidth> <screenshotsHeight>384</screenshotsHeight> <infos> <title visible="false" inNamingOption="true" default="false"/> <location visible="true" inNamingOption="true" default="true"/> <publisher visible="true" inNamingOption="true" default="true"/> <sourceRom visible="true" inNamingOption="true" default="true"/> <saveType visible="true" inNamingOption="true" default="true"/> <romSize visible="true" inNamingOption="true" default="true"/> <releaseNumber visible="true" inNamingOption="true" default="false"/> <languageNumber visible="true" inNamingOption="true" default="false"/> <comment visible="true" inNamingOption="true" default="false"/> <romCRC visible="true" inNamingOption="true" default="true"/> <im1CRC visible="true" inNamingOption="false" default="false"/> <im2CRC visible="true" inNamingOption="false" default="false"/> <languages visible="true" inNamingOption="true" default="true"/> </infos> <canOpen> <extension>.nds</extension> <extension>.neo</extension> <extension>.ids</extension> <extension>.dsi</extension> </canOpen> <newDat> <datVersionURL>https://www.advanscene.com/offline/version/ADVANsCEne_NDS.txt</datVersionURL> <datURL fileName="ADVANsCEne_NDS.zip">https://www.advanscene.com/offline/datas/ADVANsCEne_NDS.zip</datURL> <imURL>https://www.retrocovers.com/offline/imgs/ADVANsCEne_NDS/</imURL> </newDat> <search> <to value="location" default="true" auto="true"/> <to value="romSize" default="true" auto="false"> <find operation="=" value="8388608">64Mbits</find> <find operation="=" value="16777216">128Mbits</find> <find operation="=" value="33554432">256Mbits</find> <find operation="=" value="67108864">512Mbits</find> <find operation="=" value="134217728">1024Mbits</find> <find operation="=" value="268435456">2048Mbits</find> </to> <to value="languages" default="true" auto="true"/> <to value="saveType" default="true" auto="false"> <find operation="inNoCase" value="EEPROM - 4 kbit">Eeprom - 4 kbit</find> <find operation="inNoCase" value="EEPROM - 64 kbit">Eeprom - 64 kbit</find> <find operation="inNoCase" value="EEPROM - 512 kbit">Eeprom - 512 kbit</find> <find operation="inNoCase" value="FLASH - 2 mbit">Flash - 2 mbit</find> <find operation="inNoCase" value="FLASH - 4 mbit">Flash - 4 mbit</find> <find operation="inNoCase" value="FLASH - 8 mbit">Flash - 8 mbit</find> <find operation="inNoCase" value="FLASH - 64 mbit">Flash - 64 mbit</find> <find operation="inNoCase" value="NONE">None</find> <find operation="inNoCase" value="TBC">TBC</find> </to> <to value="publisher" default="true" auto="true"/> <to value="sourceRom" default="true" auto="true"/> </search> <romTitle>%e %n %o%m</romTitle> </configuration> <games> <game> <imageNumber>1</imageNumber> <releaseNumber>1</releaseNumber> <title>Metroid Prime Hunters - First Hunt (Demo)</title> <saveType>None</saveType> <romSize>16777216</romSize> <publisher>Nintendo</publisher> <location>1</location> <sourceRom>Darkfader</sourceRom> <language>2</language> <files> <romCRC extension=".nds">C2FB5233</romCRC> </files> <im1CRC>789F71C4</im1CRC> <im2CRC>633C8693</im2CRC> <comment>xxxx</comment> <duplicateID>30</duplicateID> </game> <game> <imageNumber>2</imageNumber> <releaseNumber>2</releaseNumber> <title>Electroplankton</title> <saveType>None</saveType> <romSize>16777216</romSize> <publisher>Nintendo</publisher> <location>7</location> <sourceRom>Trashman</sourceRom> <language>256</language> <files> <romCRC extension=".nds">94767CD4</romCRC> </files> <im1CRC>4CF966EA</im1CRC> <im2CRC>82AA0065</im2CRC> <comment>0001</comment> <duplicateID>72</duplicateID> </game> </games> <gui> <images width="478" height="386"> <image x="0" y="0" width="214" height="384"/> <image x="220" y="0" width="256" height="384"/> </images> </gui> </dat> --v Does anyone have an example to hand for doing this? -=-=- Check out my excellent homepage!
Sat, 24 Apr 2010, 04:15
Jayenkai	repeat in$=readline(filein) if instr(in$,"<game>") then This.Game=New Game if instr(in$,"<imageNumber>") then This.imagenumber=int(GetParam$(in$,"imageNumber")) etc,etc.. until eof(filein) function GetParam$(in$,bit$) a=instr(in$,"<"+bit$+")+len("<"+bit$+">") b=instr(in$,"</"+bit$+>") if a>0 and b>0 then return mid$(in$,a,(b-a)-1) end function --v Might need a bit of tweaking to get the string length right! I usually bugger that up, first time around Basically, just treat it as a plain text file. XML's nothing special, and shouldn't be treated as if it is.. It's just formatted "Better" ... Although my version of "Better" would be... [game] imageNumber = X ReleaseNumber = Y etc = Z [game] imageNumber = A ReleaseNumber = B etc = C --v because A, it's more readable, and B, it's using half the damn space, because everything's not bloody well repeated. -=-=- ''Load, Next List!''
Sat, 24 Apr 2010, 04:55
JL235	I would not advise Jay's method, it doesn't verify the XML is well-formed (and do something appropriate if it's not). Instead you could take a look at using the XMLDocument class, and I expect there is a lot more you can use too in system.xml.
Sat, 24 Apr 2010, 04:59
Jayenkai	It's a preformatted Database -> XML output thing, it's always formatted like that and is simple enough that there are no real errors. There might be occasional "other data" bits, or even "missing data" bits, but otherwise it'll be the same through and through. See Advanscene for further details.. -=-=- ''Load, Next List!''
Sat, 24 Apr 2010, 06:11
spinal	I have always had a hatred for xml, mostly because there is way too much bloat. It seems to me that 95% of the time an .ini file will do the job much smaller, quicker and easier. However, this file is downloaded from some place and I have no say in the format. -=-=- Check out my excellent homepage!
Sat, 24 Apr 2010, 06:28
JL235	Jayenkai It's a preformatted Database -> XML output thing, it's always formatted like that and is simple enough that there are no real errors. Doesn't guarantee it'll always be formatted correctly. Second, if there is a class that does this already in the .NET framework then why build your own hackish bit of simple string concatonation? Just use the libraries, they are there and ready to use!