<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2232.0">
<TITLE>RE: [rrd-users] exporting data</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>John,</FONT>
<BR><FONT SIZE=2>If you use rrdtool fetch ... ,</FONT>
<BR><FONT SIZE=2>Excel will import using "Fixed Width". </FONT>
<BR><FONT SIZE=2>Then, Remove the ":" s using Find Replace.</FONT>
<BR><FONT SIZE=2>Last, Use this VBA function to convert the dates:</FONT>
</P>
<P><FONT SIZE=2>-----------------</FONT>
<BR><FONT SIZE=2>Function UnixDate(iDate) As Date</FONT>
</P>
<P><FONT SIZE=2> UnixDate = Format(DateAdd("s", iDate, "1/1/1970"), "mm/dd/yy hh:mm")</FONT>
</P>
<P><FONT SIZE=2>End Function</FONT>
<BR><FONT SIZE=2>-----------------</FONT>
</P>
<P><FONT SIZE=2>David</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: John Payne [<A HREF="mailto:john@sackheads.org">mailto:john@sackheads.org</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, October 12, 1999 3:48 PM</FONT>
<BR><FONT SIZE=2>To: rrd-users@list.ee.ethz.ch</FONT>
<BR><FONT SIZE=2>Subject: [rrd-users] exporting data</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>I know that rrdtool supports dumping the data out into XML, but</FONT>
<BR><FONT SIZE=2>is there any way to get this into other formats for importing into</FONT>
<BR><FONT SIZE=2>spreadsheets? Are there any XML to spreadsheet converters/import filters?</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>John Payne <A HREF="http://www.sackheads.org/jpayne/" TARGET="_blank">http://www.sackheads.org/jpayne/</A> john@sackheads.org</FONT>
<BR><FONT SIZE=2> Sarcasm by request Fax: +44 870 0547954</FONT>
<BR><FONT SIZE=2>My mail provider doesn't welcome UBE - <A HREF="http://www.sackheads.org/uce/" TARGET="_blank">http://www.sackheads.org/uce/</A></FONT>
<BR><FONT SIZE=2>Euro-folk register in the spam-fight - <A HREF="http://www.euro.cauce.org/" TARGET="_blank">http://www.euro.cauce.org/</A></FONT>
</P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>* To unsubscribe from the rrd-users mailing list, send a message with the</FONT>
<BR><FONT SIZE=2> subject: unsubscribe to rrd-users-request@list.ee.ethz.ch</FONT>
</P>
</BODY>
</HTML>