Re: [gentoo-user] [OT] rrd to CSV

[Mick]

On Saturday 04 July 2009, Mark Shields wrote:
> On Sat, Jul 4, 2009 at 11:36 AM, Mick <michaelkintzios@×××××.com> wrote:
> > Hi All,
> >
> > I know that rrdtool dump will export the rrd data into XML, but is there
> > something to either directly or via rrdtool create a CSV file for me?
> > Will probably want to run this on a cron job and email/save it.
> > --
> > Regards,
> > Mick
>
> Judging from a few cursory google searches, it won't output to CSV, but you
> can easily convert it.  Try piping the file/output to these commands
> (yanked
>
> from Cacti forums):
> | grep -v NaN | grep '<row>' | tr e ' ' \
> | awk {'print "Q"$2"qcq"$3"qcq"$9"Q"'} \
> | tr Q '"' | tr c ',' | tr q '"'"
>
> Haven't tested it, but looks like it should work.

Thanks Mark, will give it a go and let you know.

-- 
Regards,
Mick