The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

receiving serial data/email alerts?


  • Subject: receiving serial data/email alerts?
  • From: "Paul Gale" <groups@xxxxxxxxxxxxxxxx>
  • Date: Thu, 14 Jul 2005 13:05:32 +0100

------_=_NextPart_001_01C5886C.555FECB7
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I=92ve got an aquarium computer that outputs it=92s values via RS232. The
o=
utput data looks like:

E12:34    Th, 14.07.
E1 (Te-) 26.3  =B0C
E2 (Lv ) Water

These values continuously loop and update.

I also have a program that logs this data into an access db and can
automat=
ically output to CSV and Excel file. This program will also email alarms
if=
values are exceeded (the email content is configurable). It also allows ch=
arting and upload to FTP and an online database controlled by the program
w=
riter. This program is quite good and provides some functionality that I
wo=
uldn=92t really like to have to replicate (e.g. charting).

I need some help working out how to get this data into the xAP realm and
th=
en perform actions such as:

1)	Email me if the temperature exceeds a max and min value
2)	SMS me if the temperature exceeds a max and min value
3)	Speak via xAPTTS a warning/alarm if the temperature exceeds a max and
mi=
n value
4)	Do something else via HomeVision if the temperature exceeds a max and
mi=
n value
5)	Do the same if the pH exceeds a max and min value

I guess I want to work with the access, excel or CSV file as the source?

Any ideas what I need to do and a good approach? I don=92t want to have to
=
write any code as I=92m not a programmer (unless anyone can help?).

Thinking about it from a different approach =96 it would be nice if there
w=
as a xAP application that could listen to serial data and perform actions
b=
ased on this data (a bit like the HomeVision functionality). I didn=92t
wan=
t to use HV as I don=92t have a spare HV serial port although I guess I
cou=
ld use ACE to forward the serial data to HV.

Thanks,

Paul.




------_=_NextPart_001_01C5886C.555FECB7
Content-Type: text/html; charset=Windows-1252
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html;
charset=3DWindows-1=
252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server
version 6.5.7226.0">
<TITLE>receiving serial data/email alerts?</TITLE>
</HEAD>
<BODY>


<!-- Converted from text/rtf format -->

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">I</FONT>=
</SPAN><SPAN LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=
=3D"Arial">=92</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=3D"en-gb=
"><FONT SIZE=3D2 FACE=3D"Arial">ve got an aquarium
computer that outputs it=
</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=
=3D2 FACE=3D"Arial">=92</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=
=3D"en-gb"><FONT SIZE=3D2 FACE=3D"Arial">s
values via RS232. The output dat=
a looks like:</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">E12:34&n=
bsp;&nbsp;&nbsp; Th, 14.07.</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">E1 (Te-)=
26.3&nbsp; =B0C</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">E2 (Lv )=
Water</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"></SPAN=
></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">These va=
lues continuously loop and update.</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">I also h=
ave a program that logs this data into</FONT></SPAN><SPAN
LANG=3D"en-gb"></=
SPAN><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial"> an access db and c=
an automatically output to CSV and Excel file. This program will also
email=
alarms if values are exceeded</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SP=
AN LANG=3D"en-gb"> <FONT SIZE=3D2
FACE=3D"Arial">(</FONT></SPAN><SPAN LANG=
=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">the</F=
ONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"> <FONT SIZE=3D2=
FACE=3D"Arial">email</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=
=3D"en-gb"> <FONT SIZE=3D2
FACE=3D"Arial">content is configurable). It also=
allows charting and upload to FTP and an online database controlled by the=
program writer</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=3D"en-g=
b"><FONT SIZE=3D2 FACE=3D"Arial">. This program is
quite good and provides =
some functionality that I wouldn</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><=
SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">=92</FONT></SPAN><SPAN LA=
NG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=3D"Arial">t
re=
ally like to have to replicate (e.g.
charting).</FONT></SPAN><SPAN LANG=3D"=
en-gb"></SPAN><SPAN
LANG=3D"en-gb"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">I need s=
ome help working out how to get this data</FONT></SPAN><SPAN
LANG=3D"en-gb"=
></SPAN><SPAN LANG=3D"en-gb"> <FONT SIZE=3D2
FACE=3D"Arial">into the xAP re=
alm and then perform actions such as:</FONT></SPAN></P>

<P><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">1)&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"> =
<FONT SIZE=3D2 FACE=3D"Arial">Email me if the temperature
exceeds a max and=
min value</FONT></SPAN>

<BR><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">2)&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb">=
<FONT SIZE=3D2 FACE=3D"Arial">SMS me if the
temperature</FONT></SPAN><SPAN=
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"> <FONT SIZE=3D2
FACE=3D"Arial">=
exceeds a max and min value</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN =
LANG=3D"en-gb"></SPAN>

<BR><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">3)&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;</FONT> <FONT SIZE=3D2
FACE=3D"Arial">Speak via xAPTTS a warnin=
g/alarm</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT=
SIZE=3D2 FACE=3D"Arial"> if the
temperature</FONT></SPAN><SPAN LANG=3D"en-=
gb"></SPAN><SPAN LANG=3D"en-gb"> <FONT
SIZE=3D2 FACE=3D"Arial">exceeds a ma=
x and min value</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=3D"en-g=
b"></SPAN>

<BR><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">4)&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;</FONT> <FONT SIZE=3D2
FACE=3D"Arial">Do something else via Hom=
eVision</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"> <FON=
T SIZE=3D2 FACE=3D"Arial">if the
temperature</FONT></SPAN><SPAN LANG=3D"en-=
gb"></SPAN><SPAN LANG=3D"en-gb"> <FONT
SIZE=3D2 FACE=3D"Arial">exceeds a ma=
x and min value</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN LANG=3D"en-g=
b"></SPAN>

<BR><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">5)&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;</FONT> <FONT SIZE=3D2
FACE=3D"Arial">Do the same if the pH exc=
eeds</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"> <FONT S=
IZE=3D2 FACE=3D"Arial">a max and min
value</FONT></SPAN><SPAN LANG=3D"en-gb=
"></SPAN><SPAN LANG=3D"en-gb"></SPAN>
</P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">I guess =
I want to work with the access, excel or CSV file as the
source?</FONT></SP=
AN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">Any idea=
s what I need to do and a good approach? I
don</FONT></SPAN><SPAN LANG=3D"e=
n-gb"></SPAN><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">=92</FONT><=
/SPAN><SPAN LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=
=3D"Arial">t want to have to write any code as
I</FONT></SPAN><SPAN LANG=3D=
"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">=92</FONT=
></SPAN><SPAN LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FAC=
E=3D"Arial">m not a programmer (unless anyone can
help?).</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">Thinking=
about it from a different approach</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPA=
N><SPAN LANG=3D"en-gb"> <FONT SIZE=3D2
FACE=3D"Arial">=96</FONT></SPAN><SPA=
N LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=3D"Arial">=
it would be nice if there was a xAP application that could listen to seria=
l data and perform actions based on this data (a bit like the HomeVision
fu=
nctionality)</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb">=
<FONT SIZE=3D2 FACE=3D"Arial">. I
didn</FONT></SPAN><SPAN LANG=3D"en-gb"></=
SPAN><SPAN LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">=92</FONT></SPAN><S=
PAN LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=3D"Arial=
">t want to use HV as I don</FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN =
LANG=3D"en-gb"><FONT SIZE=3D2
FACE=3D"Arial">=92</FONT></SPAN><SPAN LANG=3D=
"en-gb"></SPAN><SPAN
LANG=3D"en-gb"><FONT SIZE=3D2 FACE=3D"Arial">t
have a =
spare HV serial port although I guess I could use ACE to forward the
serial=
data to HV.</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-gb"><FONT
SIZE=3D2 FACE=3D"Arial">Thanks,<=
/FONT></SPAN><SPAN
LANG=3D"en-gb"></SPAN><SPAN
LANG=3D"en-gb"></SPAN></P>

<P ALIGN=3DLEFT><SPAN
LANG=3D"en-gb"></SPAN><A
NAME=3D""><SPAN LANG=3D"en-g=
b"><FONT SIZE=3D2
FACE=3D"Arial">Paul.</FONT></SPAN></A></P>
<BR>

<P ALIGN=3DLEFT><SPAN
LANG=3D"en-gb"></SPAN></P>



<?---- LSpots keywords ?>
<?---- HM ADS ?>
=20=20

<!-- **begin egp html banner** -->


<br>
<div style=3D"text-align:center; color:#909090;
width:500px;">
<hr style=3D"border-bottom:1px; width:500px;
text-align:left;">
<tt>YAHOO! GROUPS LINKS</tt>
</div>
<br>
<ul>
<tt><li type=3Dsquare>&nbsp;Visit your group "<a
href=3D"http://groups.ya=
hoo.com/group/xap_automation">xap_automation</a>" on the
web.<br>&nbsp;</tt=
>
<tt><li type=3Dsquare>&nbsp;To unsubscribe from this group,
send an email=
to:<br>&nbsp;<a href=3D"mailto:xap_automation-unsubscribe@xxxxxxx?=
subject=3DUnsubscribe">xap_automation-unsubscribe@xxxxxxx</a><br>&n=
bsp;</tt>
<tt><li type=3Dsquare>&nbsp;Your use of Yahoo! Groups is
subject to the <=
a href=3D"http://docs.yahoo.com/info/terms/";>Yahoo!
Terms of Service</a>.</=
tt>
</ul>
<br>
<div style=3D"text-align:center; color:#909090;
width:500px;">
<hr style=3D"border-bottom:1px; width:500px;
text-align:left;">
</div>
</br>

<!-- **end egp html banner** -->


</BODY>
</HTML>
------_=_NextPart_001_01C5886C.555FECB7--



xAP_Automation Main Index | xAP_Automation Thread Index | xAP_Automation Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.