Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data Log DB and Graphamatic Again
#1
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.

[Image: 2dayhotwater.png]

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 OUTConfusedhock:
Reply
#2
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.
Recovering (quasi) ex-professional integrator...wait...scratch that. I'm back in the field and should probably have my head examined...
HAI, UPB, Parasound, Global Cache GC100 and IR learner, DatalogDB, Barix Barionet (I need to buy another one of these!), Weather, RFID, Logic Server
Reply
#3
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.
Dean Roddey
Explorans limites defectum
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  GPS Data from Traccar to MQTT simplextech 0 130 02-01-2020, 07:27 PM
Last Post: simplextech
  Charting data with CanvasJS wuench 9 3,848 10-23-2015, 02:43 AM
Last Post: znelbok
  Graphamatic? dlmorgan999 5 1,555 07-19-2015, 06:54 PM
Last Post: dlmorgan999
  Graphamatic help robolo 32 6,854 04-13-2011, 07:51 PM
Last Post: Trioxide
  Graphamatic AnthonyZ 45 7,667 01-13-2011, 04:41 PM
Last Post: Dean Roddey
  Data from Personal Weather Stations George M 6 2,510 04-25-2010, 01:30 PM
Last Post: Sendero
  Newbie Question: How do I get event data for triggered events? Sendero 7 2,314 02-10-2009, 11:26 PM
Last Post: Dean Roddey
  Russound CAV 2-way/meta-data integration netarc 7 2,223 12-02-2006, 02:59 PM
Last Post: Dean Roddey

Forum Jump:


Users browsing this thread: 1 Guest(s)