Hi all<div><br></div><div>I have a question about importing non-realtime data into rrdtool. There is an arduino device that logs various parameters and sends the CSV to a server once per day. The data is logged for the whole day obviously (at an interval of approximately every 20-23 seconds): Sample below:</div>
<div><div><br></div><div>2011/12/30 16:12:53,193.5,174.0,159.0,142.8,132.3,123.5,245.3,162.5,12.5,5.0,0.0,115990,40618,0</div><div>2011/12/30 16:13:14,188.8,169.9,155.0,139.0,128.4,119.7,225.7,156.7,12.5,5.0,0.0,111852,39975,0</div>
<div>2011/12/30 16:13:35,189.2,170.2,155.5,139.4,128.8,120.0,222.2,153.9,12.5,5.0,0.0,113136,40170,0</div><div>2011/12/30 16:13:56,189.7,170.2,155.5,139.8,128.9,120.1,224.6,157.4,12.5,5.0,0.0,115207,39350,0</div><div>2011/12/30 16:14:17,191.1,170.9,156.3,140.8,129.8,120.9,226.4,158.2,12.4,5.0,0.0,118940,38754,0</div>
<div>2011/12/30 16:14:39,194.1,174.0,159.3,143.8,132.7,123.8,225.1,159.2,12.5,5.0,0.0,119053,38814,0</div><div>2011/12/30 16:15:00,195.6,175.0,159.9,144.3,133.3,124.5,231.2,164.9,12.4,5.0,0.0,121238,38925,0</div></div><div>
<br></div><div>I am new to RRDtool and would like to create daily, weekly, monthly and yearly graphs for all this data. For example, field 13 in the data above is btu per/hr.</div><div><br></div><div>I am fairly new to rrdtool and played around with it and created a graph using the following commands (i had to change all the date/times to epoch and do an rrdtool update of course):</div>
<div><br></div><div>rrdtool create btuperhr.rrd --start 1325232008 --step 1 DS:btu_per_hr:GAUGE:600:1:U RRA:AVERAGE:0.5:1:100000</div><div><br></div><div>rrdtool graph btuperhr.png --start 1325232008 --title="Boiler BTU Dec 30 2011" --vertical-label="BTU per Hr" -x MINUTE:10:HOUR:1:MINUTE:120:0:%R DEF:btu_per_hr=btuperhr.rrd:btu_per_hr:AVERAGE LINE2:btu_per_hr#FF0000</div>
<div><br></div><div><br></div><div>the graph on the x axis doesnt look right. </div><div><br></div><div>Also does anyone have any better strategies for doing this then I have? I feel like I am missing something critical.</div>
<div><br></div><div>Thanks and Regards,</div><div><br></div><div><br></div>