Data Log DB and Graphamatic Again

[The Camper]

hello all I have the db driver working and have managed to get the graphamatic xml right to get it to work, bellow is a screen shot of the output png from the xml also bellow. I am wondering if there is a better way to make the y axis float as it is scaling but due to minuete changes in the data doesn't realy have the desired affect.



and the XML:

<?xml version="1.0" encoding='UTF-8' standalone="no"?>
<!DOCTYPE GraphSpec SYSTEM "file://C:\Graphamatic_GraphSpec.dtd" >

<GraphSpec name="TempGraphs">

<Graph name="2 Day Hot Water Temps"
filetype="PNG"
filename="C:\Program Files\CQC\CQCData\HTMLRoot\2dayhotwater"
height="350"
width ="750"
forecolor="000010" backcolor1="EEEEEE" backcolor2="CCCCCC"
xaxisname="Date"
yaxisname="Degrees" >

<Range xaxis="date" yaxis="float" >
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day], -1,
GETDATE()) AND
( Descriptor = &apos;Hot Water&apos; or
Descriptor = &apos;Hot Water&apos; )
ORDER BY TimeStamp
</Query>
</Range>

<DataSeries name="Hot Water" type="line" color="FF0000" xaxis="date" yaxis="int" ymin="0" ymax="100" label="Hot Water">
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day],-1,
GETDATE()) AND Descriptor = &apos;Hot Water&apos;
ORDER BY TimeStamp
</Query>
</DataSeries>



</Graph>
<Graph name="2 Day Ground Floor Temp"
filetype="PNG"
filename="C:\Program Files\CQC\CQCData\HTMLRoot\Ground Floor"
height="350"
width ="750"
forecolor="000010" backcolor1="EEEEEE" backcolor2="CCCCCC"
xaxisname="Date"
yaxisname="Degrees" >

<Range xaxis="date" yaxis="float" >
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day], -1,
GETDATE()) AND
( Descriptor = &apos;Ground Floor&apos; or
Descriptor = &apos;Ground Floor&apos; )
ORDER BY TimeStamp
</Query>
</Range>

<DataSeries name="Hot Water" type="line" color="FF0000" xaxis="date" yaxis="int" ymin="0" ymax="100" label="Ground Floor">
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day],-1,
GETDATE()) AND Descriptor = &apos;Ground Floor&apos;
ORDER BY TimeStamp
</Query>
</DataSeries>
</Graph>
<Graph name="2 Day 1st Floor"
filetype="PNG"
filename="C:\Program Files\CQC\CQCData\HTMLRoot\2day1stfloor"
height="350"
width ="750"
forecolor="000010" backcolor1="EEEEEE" backcolor2="CCCCCC"
xaxisname="Date"
yaxisname="Degrees" >

<Range xaxis="date" yaxis="float" >
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day], -1,
GETDATE()) AND
( Descriptor = &apos;1st Floor&apos; or
Descriptor = &apos;1stFloor&apos; )
ORDER BY TimeStamp
</Query>
</Range>

<DataSeries name="Hot Water" type="line" color="FF0000" xaxis="date" yaxis="int" ymin="0" ymax="100" label="1st Floor">
<Query dsn="CQCHeatingDB" user="sa" pw="">Select TimeStamp, Value
From DataLogValues Where TimeStamp &gt;= DATEADD([day],-1,
GETDATE()) AND Descriptor = &apos;1st Floor&apos;
ORDER BY TimeStamp
</Query>
</DataSeries>



</Graph>



</GraphSpec>


Also is there a better way of doing this now as I have to set up a task schedule to run the graphamatic program every hour to get upto date results,

and the question on the DB Driver can the sql DB ever get to big and if so how would I incorporate a script into the DB to run to Flush the DB of old enteries Say once a month..


Cheers


Camper OUThock:

[AnthonyZ]

So, what is the "desired effect"? Are you wanting to see larger swings (scaled at like 10ths of degrees)? If so, I can't help but wonder why. The graph you have there shows a ridiculously stable temp. If that's your water heater and your temps are in Celsius , you can sleep well at night knowing that your gear is working very efficiently.

[Dean Roddey]

BTW, I'm adding graphing support now, for the next beta drop. It's live only, no historical data for now, so it starts over when you cycle the master server, but for some folks it might get rid of the need for using this graphing stuff maybe.