RE: Charting software for web use?

["Paul Gale" <groups@xxxxxxxxxxxxxxxx>]

Mmmm - not sure.

I'd really like to run this on the HA server (W2K3). I already run several
xAP apps and HomeVision s/w on there. I guess a VB app that runs constantly
would be good. It would connect to the serial port and put the values into
the mySQL dB at regular intervals (prob greater intervals than the data
arrives as changes are quite slow). Not sure whether to setup a new mySQL
dB on the W2k3 server or use an existing one on my Asterisk Linux PC that I
just installed???

I'd also like the VB app to generate alarms depending on values. Ideally
xAP messages would be great (but I'm no programmer and haven't a clue how
to do this!).

I've only dabbled with VB before, so would be a VERY steep leaning curve -
not sure if I would have the time to learn it :(

Paul.



> -----Original Message-----
> From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf Of
> Paul Smith
> Sent: 13 May 2005 11:53
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] Charting software for web use?
>
> Hi Paul,
>
> 	What program language would you use.
>
> This is a very simple bit of vb code that I did to connect to mysql,
> serial port in vb is also very easy too, just note that there is no
> error checking in this.
>
>
> Dim MyConn As ADODB.Connection
> Dim MyRecSet As ADODB.Recordset
> Set MyRecSet = New ADODB.Recordset
> Set MyConn = New ADODB.Connection
>
> MyConn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"
_
>             & "SERVER=192.168.250.1;" _
>             & "DATABASE=meter-readings;" _
>             & "UID=*********;" _
>             & "PWD=*********;"
>
> MyConn.Open
>
>
> total = 0
>
>
> Do Until MyRecSet.EOF
>
> total = total + MyRecSet("Reading")
>
> MyRecSet.MoveNext
> Loop
>
> MsgBox (total)
>
> MyRecSet.Close
>
>
> MyConn.Close
>
>
>
> Very easy and to link to mysql on a server.
>
>
> Regards,
>
> Paul
>
>
> -----Original Message-----
> From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
> Of Paul Gale
> Sent: 13 May 2005 11:27
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] Charting software for web use?
>
> Just had a look at this software - very impressive.
>
> Only trouble is, I now need to work out how to get the data into a dB
> such as mySQL - not done too much in mySQL though :(
>
> Paul.
>
>
>
> > -----Original Message-----
> > From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
> Of
> > Paul Smith
> > Sent: 13 May 2005 10:54
> > To: ukha_d@xxxxxxx
> > Subject: RE: [ukha_d] Charting software for web use?
> >
> > Hi Paul,
> >
> > 	I created a simple vb app which counted the number of pluses on
> > the CD line on a com port. It then every minute dumps the count
into a
> > my sql database.
> >
> > Then using php and mysql, and this tool
> > http://www.maani.us/charts/index.php
> >   I generate bar charts to show the various totals, for hour,
day,
> month
> > and year. This works well and free if you are happy for the click
on
> the
> > chart to take you there website.
> >
> > If you however have the need to drill down into the data then you
have
> > to pay for it. But it's cheap.
> >
> > As an aside how are you measuring the PH and getting this into a
pc.
> >
> >
> > Regards,
> >
> > Paul
> >
> >
> > -----Original Message-----
> > From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
> > Of Paul Gale
> > Sent: 13 May 2005 09:51
> > To: ukha_d@xxxxxxx
> > Subject: [ukha_d] Charting software for web use?
> >
> > I'm just about to link up my aquarium computer to my HA server.
The
> plan
> > is to log the values of temp, pH etc that are sent every few
seconds.
> > Not sure yet how I will do this although there is already some
> software
> > that will write the values to an Excel doc. I'd probably be best
> writing
> > to a dB?
> >
> > Anyway, anyone know of a piece of software that will EASILY take
these
> > values on a pre-determined period and create a graph (user
defined)
> for
> > viewing on an Intranet web page? Ideally, this software would be
free!
> > :-)
> >
> > Thanks,
> >
> > Paul.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>