conversion of xml to csv file

Microsoft Windows xp professional w/serv...
September 14, 2010 at 03:25:32
Specs: Windows XP, 512
i have a xml file which is actually a optuput of browser history. The script goes as follows:-


<?xml version="1.0" encoding="ISO-8859-1" ?>
<visited_links_list>
<item>
<url>f956.mail.yahoo.com</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 10:11:57 AM</modified_date>
<expiration_date>N/A</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/certaudit/usblog/usb.csv</url>
<title></title>
<hits>6</hits>
<modified_date>9/14/2010 9:17:42 AM</modified_date>
<expiration_date>10/10/2010 9:17:44 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/certaudit/usblog/usb.xml</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 8:31:12 AM</modified_date>
<expiration_date>10/10/2010 8:31:14 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/1.html</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 12:19:21 PM</modified_date>
<expiration_date>10/10/2010 12:12:14 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/33.png</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 3:20:43 PM</modified_date>
<expiration_date>10/10/2010 3:20:44 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/33.png</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 3:20:34 PM</modified_date>
<expiration_date>10/10/2010 3:20:36 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/33.png</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 3:20:43 PM</modified_date>
<expiration_date>10/10/2010 3:20:44 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder></subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/33.png</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 3:20:34 PM</modified_date>
<expiration_date>10/10/2010 3:20:36 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder></subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/CD_ROOT.iso</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 11:22:07 AM</modified_date>
<expiration_date>10/10/2010 11:15:00 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/CookieHistory-2010-09-14-08-51-43.csv</url>
<title></title>
<hits>3</hits>
<modified_date>9/14/2010 2:24:26 PM</modified_date>
<expiration_date>10/10/2010 2:24:28 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/EXPLORERLOGS/ie.html</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 11:29:50 AM</modified_date>
<expiration_date>10/10/2010 11:29:52 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/EXPLORERLOGS/ie.xml</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 1:21:42 PM</modified_date>
<expiration_date>10/10/2010 1:21:44 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/final/firewall/CONF6XP_firewallstat.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 8:22:36 AM</modified_date>
<expiration_date>10/10/2010 8:15:28 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/final/openports/CONF6XP_ports.csv</url>
<title></title>
<hits>3</hits>
<modified_date>9/14/2010 9:23:17 AM</modified_date>
<expiration_date>10/10/2010 9:23:18 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/final/USB/CONF6XP_usb.csv</url>
<title></title>
<hits>8</hits>
<modified_date>9/14/2010 11:39:25 AM</modified_date>
<expiration_date>10/10/2010 11:39:26 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/final/USBDEVIEW/CONF6XP_usb.csv</url>
<title></title>
<hits>6</hits>
<modified_date>9/14/2010 10:13:51 AM</modified_date>
<expiration_date>10/10/2010 10:13:52 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/final/USBDEVIEW/usb.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 9:21:34 AM</modified_date>
<expiration_date>10/10/2010 9:21:36 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/rr.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 12:09:53 PM</modified_date>
<expiration_date>10/10/2010 12:09:54 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/textocsv.pdf</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 11:22:47 AM</modified_date>
<expiration_date>10/10/2010 11:22:48 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/Desktop/WebHistory-2010-09-14-08-51-43.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 2:24:48 PM</modified_date>
<expiration_date>10/10/2010 2:24:50 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/My%20Documents/Downloads/dump/dump/Tools/SamInside/Tools/LRConvert.txt</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 1:08:10 PM</modified_date>
<expiration_date>10/10/2010 1:01:02 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/My%20Documents/Downloads/historian/Export.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 1:33:56 PM</modified_date>
<expiration_date>10/10/2010 1:33:58 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/My%20Documents/Downloads/historian/Readme.rtf</url>
<title></title>
<hits>4</hits>
<modified_date>9/14/2010 1:32:13 PM</modified_date>
<expiration_date>10/10/2010 1:32:14 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/My%20Documents/Downloads/syscombotln/syscombotln/scripts/plugins/regtln.pl</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 3:05:45 PM</modified_date>
<expiration_date>10/10/2010 3:05:46 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Documents%20and%20Settings/Administrator.LAB6/My%20Documents/Downloads/syscombotln/syscombotln/scripts/rip.pl</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 3:05:30 PM</modified_date>
<expiration_date>10/10/2010 3:05:32 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/New%20Text%20Document.txt</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 2:38:53 PM</modified_date>
<expiration_date>10/10/2010 2:38:54 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Program%20Files/MANDIANT/Web%20Historian/text.txt</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 2:43:39 PM</modified_date>
<expiration_date>10/10/2010 2:43:40 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/Program%20Files/MANDIANT/Web%20Historian/Web%20Historian%20User%20Guide.pdf</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 2:25:21 PM</modified_date>
<expiration_date>10/10/2010 2:25:22 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/ra.csv</url>
<title></title>
<hits>4</hits>
<modified_date>9/14/2010 12:17:16 PM</modified_date>
<expiration_date>10/10/2010 12:17:18 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///C:/rr.csv</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 12:17:01 PM</modified_date>
<expiration_date>10/10/2010 12:17:02 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>file:///G:/to%20check/browserhistory.pdf</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 3:08:22 PM</modified_date>
<expiration_date>10/10/2010 3:08:24 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>http://f956.mail.yahoo.com/ws/mail/v1/formrpc?appid=YahooMailClassic&wssid=hBsrlLhd2Gx&m=BatchExecute</url>
<title></title>
<hits>2</hits>
<modified_date>9/14/2010 10:11:57 AM</modified_date>
<expiration_date>10/10/2010 10:11:58 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>http://in.mc956.mail.yahoo.com/mc/welcome?.gx=1&.tm=1284438852&.rand=d4k6o36rq6l72</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 10:11:55 AM</modified_date>
<expiration_date>10/10/2010 10:11:56 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>http://in.search.yahoo.com/search?fr=chr-greentree_ie&ei=utf-8&type=937811&p=www.yahoo+mail</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 10:11:16 AM</modified_date>
<expiration_date>10/10/2010 10:11:18 AM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>http://runonce.msn.com/runonce3.aspx</url>
<title></title>
<hits>4</hits>
<modified_date>9/14/2010 3:15:33 PM</modified_date>
<expiration_date>10/10/2010 3:15:34 PM</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>in.mc956.mail.yahoo.com</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 10:11:55 AM</modified_date>
<expiration_date>N/A</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>in.search.yahoo.com</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 10:11:16 AM</modified_date>
<expiration_date>N/A</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>My Computer</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 3:20:34 PM</modified_date>
<expiration_date>N/A</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
<item>
<url>runonce.msn.com</url>
<title></title>
<hits>1</hits>
<modified_date>9/14/2010 8:32:39 AM</modified_date>
<expiration_date>N/A</expiration_date>
<user_name>Administrator</user_name>
<subfolder>MSHist012010091420100915</subfolder>
</item>
</visited_links_list>

please give some ideas tp change this file into csv format............
thanks in advance


See More: conversion of xml to csv file

Report •

#1
September 15, 2010 at 15:36:47
some ideas tp change this
Probably the easiest method would be to use the COM object Microsoft.XMLDOM, probably though VBScript.

Report •
Related Solutions


Ask Question