From mboxrd@z Thu Jan  1 00:00:00 1970
Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org)
	by finch.gentoo.org with esmtp (Exim 4.60)
	(envelope-from <gentoo-user+bounces-97609-garchives=archives.gentoo.org@lists.gentoo.org>)
	id 1MNAnB-0005vE-Gu
	for garchives@archives.gentoo.org; Sat, 04 Jul 2009 19:20:57 +0000
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
	by pigeon.gentoo.org (Postfix) with SMTP id CCCD2E0566;
	Sat,  4 Jul 2009 19:20:55 +0000 (UTC)
Received: from mail-ew0-f211.google.com (mail-ew0-f211.google.com [209.85.219.211])
	by pigeon.gentoo.org (Postfix) with ESMTP id 8ABA5E0566
	for <gentoo-user@lists.gentoo.org>; Sat,  4 Jul 2009 19:20:55 +0000 (UTC)
Received: by ewy7 with SMTP id 7so3229327ewy.34
        for <gentoo-user@lists.gentoo.org>; Sat, 04 Jul 2009 12:20:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:from:reply-to:to:subject:date
         :user-agent:references:in-reply-to:mime-version:content-type
         :content-transfer-encoding:message-id;
        bh=HSxadgBpyUu2FCZGEN8Io1ePC/nhGGqxJ7b1bexqmV8=;
        b=BRLD5qDyZp0fC2ijy1ra4MOW6Xr75PnYa2quiKFkd3vwZe7cZTwVZGTxN/EKEPn6DH
         rfDTbTP+RKQ9X8X/jzto/aRlwMZwdHaVpXi+dDCq/roXawRday2sO+Gig6G6MQ79J3yq
         MqKFWDS2zYZ0qaOTDaccHPZ7n9gP/Kb7MyCWg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=from:reply-to:to:subject:date:user-agent:references:in-reply-to
         :mime-version:content-type:content-transfer-encoding:message-id;
        b=Eo3PetmAF1xWoKqo+E/lZXohQE1VjJNvb++oCimjGgNWmnJm5ocyolVgena91xMb5U
         YTMQZfgEfkMqqJIjfXGjuCmwZTuf0pImlNqykGqR9im5nFQ2yBQzbddADSeyYl3ecn1C
         X9EucGPX+8+lhO4yozwSUsFhyVlD29WONSxaA=
Received: by 10.210.59.14 with SMTP id h14mr1000419eba.52.1246735255047;
        Sat, 04 Jul 2009 12:20:55 -0700 (PDT)
Received: from lappy.study (230.3.169.217.in-addr.arpa [217.169.3.230])
        by mx.google.com with ESMTPS id 7sm6537886eyg.47.2009.07.04.12.20.54
        (version=TLSv1/SSLv3 cipher=RC4-MD5);
        Sat, 04 Jul 2009 12:20:54 -0700 (PDT)
From: Mick <michaelkintzios@gmail.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] [OT] rrd to CSV
Date: Sat, 4 Jul 2009 20:20:42 +0100
User-Agent: KMail/1.9.10
References: <200907041636.51868.michaelkintzios@gmail.com> <642958cc0907040923n5592c393t73b2df7196e1ec8d@mail.gmail.com>
In-Reply-To: <642958cc0907040923n5592c393t73b2df7196e1ec8d@mail.gmail.com>
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart1888244.FuMJfschsp";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200907042020.53052.michaelkintzios@gmail.com>
X-Archives-Salt: 46d533aa-a1e3-4155-a003-e0c045924dbe
X-Archives-Hash: 1309b2e4d88c4e87681ca2a0d2810b47

--nextPart1888244.FuMJfschsp
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Saturday 04 July 2009, Mark Shields wrote:
> On Sat, Jul 4, 2009 at 11:36 AM, Mick <michaelkintzios@gmail.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?=20
> > 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 y=
ou
> 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.

=2D-=20
Regards,
Mick

--nextPart1888244.FuMJfschsp
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.11 (GNU/Linux)

iEYEABECAAYFAkpPq5QACgkQVTDTR3kpaLaSfwCguQCop4NTXGgJOXYuELwyPvqz
uMAAoPWVR9bIuPXjPq8JFClM2dnwmJZl
=S9xh
-----END PGP SIGNATURE-----

--nextPart1888244.FuMJfschsp--