Hosting at a low cost|9|3

Menu

Articles
 Main Directory
 New Articles
 Popular Articles
 Top Articles
 Articles FAQ

Search: 

Newest Articles

 XML to DBF Importing
(Hits: 72)


read more...

 Lorem Ipsum
(Hits: 193)

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Cras tempus orci a magna malesuada pharetr...
read more...

 Lorem Ipsum 2
(Hits: 203)

Morbi tempor sagittis nibh. Maecenas nulla. Vestibulum ante ipsum primis in faucibus orci luctus et ...
read more...

Print XML to DBF Importing


XML to DBF Importing
Date Added: 10/10/2009
Posted by:
 administrator
 administratortransworldportal.com

Viewed: 72 times

XMLDOM Code to do the importing.

 

<% 'Two ways to load your XML

'From String
'    xmlString = "foo bar, some xml here"
'    Set oXML = Server.CreateObject("Microsoft.XMLDOM")
'    oXML.async = False
'    oXML.LoadXml(server.mappath(xmlPath))

'From filesystem
    xmlPath = "test.xml"
    Set oXML = Server.CreateObject("Microsoft.XMLDOM")
    oXML.async = False
    oXML.Load(server.mappath(xmlPath))

'The rest is the same regardless of load method

If oXML.parseError.errorCode <> 0 Then
    response.write "Error: could not load XML" & vbCrlf &_
                    "Reason: " &  oXML.parseError.reason & oXML.parseError.Errorcode & vbCrlf &_
                    "Line: " &  oXML.parseError.line & vbCrlf &_
                    "Line Pos: " & oXML.parseError.linepos
    response.end
End If

'Get the root node
set root = oXML.getElementsByTagName("torrents")

if root.length = 0 then
    response.write "root XML element not found"
    response.end
end if

'Loop through torrents
Set torrents = root.item(0).getElementsByTagName("torrent")

for each torrent in torrents
 tHash = torrent.getAttribute("hash")
 tFileName = torrent.getAttribute("filename")
 tName = torrent.getAttribute("name")
 tAdded = torrent.getAttribute("added")
 'You get the idea

 response.write "<strong>Torrent</strong> - " & tName & "  " & tHash & "  " & tFileName & "   " & tAdded & "<br />"

 'Loop the peers
 Set peers = torrent.getElementsByTagName("peer")

 for each peer in peers
        pId = peer.getAttribute("id")
        pIp = peer.getAttribute("ip")
        'Same idea...

        response.write " ; ; ;Peer - " & pId & "  " & pIp & "<br />"
    next
next

%>

 

 XML Code to be imported

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <torrents>
- <torrent hash="069e950a251c40f205d2313599d721177a47d1c2" filename="Disney Greatest Love Songs.torrent" name="Disney Greatest Love Songs" added="2009-08-21 14:48:12" size="101100897" files="33" completed="80" tag="Music" uploadname="Disney Greatest Love Songs" uploader="Paul">
- <peers>
  <peer id="2d415a343230342d3937386238356e3749566d7a" ip="85.241.236.50" uploaded="32464120" downloaded="101417663" left="0" connected="5409" />
  <peer id="2d415a343230342d4341634f7671574361556f64" ip="81.99.1.249" uploaded="15553622" downloaded="101123387" left="0" connected="5409" />
  <peer id="2d415a343230342d554b6556486f685a36687a58" ip="173.25.79.14" uploaded="18011741" downloaded="78953963" left="0" connected="5409" />
  <peer id="2d415a343230342d615a3956716d716c33315570" ip="203.116.201.109" uploaded="2919379" downloaded="7883723" left="93367649" connected="5110" />
  <peer id="2d415a343230342d7972584441384c554942565a" ip="80.148.27.90" uploaded="165086358" downloaded="101244659" left="0" connected="5409" />
  <peer id="2d4243303130392d7cf36cdbabcfddb7c99d33ac" ip="60.50.92.60" uploaded="6253921" downloaded="29912417" left="71303168" connected="5409" />
  <peer id="2d46473031383012a42ec2af97ba7b4888b1d463" ip="190.55.234.81" uploaded="26680002" downloaded="101100897" left="0" connected="5409" />
  <peer id="2d4c54304430302d5775475259745f5956646763" ip="82.55.247.27" uploaded="20252957" downloaded="46343450" left="55443456" connected="4945" />
  <peer id="2d4c57303030322d2a655e1759a21aa7aec18377" ip="98.89.3.217" uploaded="16555325" downloaded="37891107" left="63239116" connected="5409" />
  <peer id="2d4c57303030322d65a513ba950901059d193077" ip="192.168.1.64" uploaded="0" downloaded="0" left="101100897" connected="720" />
  <peer id="2d554d303931422d273cd4b581edf86a846d517f" ip="213.225.127.188" uploaded="41730048" downloaded="101100897" left="0" connected="5409" />
  <peer id="2d5554313737302df39f43c5da5727c831c47e3d" ip="79.64.43.199" uploaded="149467616" downloaded="101187584" left="0" connected="5409" />
  <peer id="2d5554313737302df39ff5ee457b684f81461d28" ip="86.97.84.131" uploaded="9256960" downloaded="35258368" left="65781760" connected="4397" />


CommentAdd Comment/Rating


Other Articles by this Author

Back
Set us as your default homepage Bookmark us Privacy   © 2010 Transworld Interactive Portal All Rights Reserved. Design by: T.Kirby TransworldInteractive.net Go To Top Of Page

Page load time - 0.223