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]

Re: xAP & SQL



--------------050006070501070408010807
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I just tried loading the console verion of the email sending app from
Stuart's link, adding the <start><end> block to the tosend file
and
tried a call. Well the good news was it worked so in theory all the
issues  will be a config or network one. A few things to check:
in SendEMail.exe.config fill in the <add key="SMTPServer"
value="IP or
address of smtp" />
make sure that when the block was added to the ToSend file the
<start>
and <end> are on lines all by themselves.
Assuming all this is running on a single pc then just like xpl, xAP
needs a hub to be running
http://www.xapframework.net/modules.php?name=Content&pa=showpage&pid=8
The hub should be started before all other applications for it to work
correctly, the windows service version is good for this.

One thing I didn't mention was that Switcboard reads the event files
when the event is fired. So you can edit these files and changes will be
live, you don't need to restart Switchboard.

If all that fails then give Viewer a go
http://www.xapframework.net/modules.php?name=Content&pa=showpage&pid=9
It will show you all messages being received so under Switchboard you
should see your mail message. You should see messages from all your
apps, if after a couple of minutes one doesn't show then that app will
need a checkup.

hth
James

Neil Frost wrote:

> Is there a way to troubleshoot this?
>
>
>
> I've installed and started the sendmail service added the message
> below to the ToSend.txt file, restarted xAP Switchboard.
>
>
>
> Receive an incoming call, complete the call and no email...
>
>
>
> Any ideas?
>
>
------------------------------------------------------------------------
>
> *From:* xap_automation@xxxxxxx
> [mailto:xap_automation@xxxxxxx] *On
Behalf Of *James
> *Sent:* 12 July 2005 22:19
> *To:* xap_automation@xxxxxxx
> *Subject:* Re: [xap_automation] xAP & SQL
>
>
>
> Neil,
>
>  As Kevin described, Switchboard can't on it's own send emails, sms or
> IMs as these tasks are best handled by separate apps. What Switchboard
> does have is a flexible event system with the events triggering when
> various things happen:
> On an Incoming call (ToSend)
> When an incoming call is picked up (ToSend_Pickup)
> The end of an Incoming call (ToSend_IncEnd)
> When a local phone is picked up and/or a digit is pressed
> (ToSend_OutDigit)
> The end of an Outgoing call (ToSend_OutEnd)
> When an IM contact changes state (ToSendIM)
>
> Each of these events is actually a text file inside the Switchboard
> directory, the names of the files being what's between the ( ) above.
> Each file contains as many xAP messages as you like and each xAP
> message can contain elements from the phone call. If you have a look
> at the Tosend.txt file, in its default state it sends 3 messages on an
> incoming call, one for a slimp3, one for a generic display and finally
> one for text to speech. Each message is between a <start> and an
<end>
> and insertable  elements are contained within *s. There is a list of
> all possible *s in the ToSend file. Now Switchboard support a few
> builtin schemas but to send an email you will need to use a raw
> message. Below is an example block to add to a ToSend file:
>
> <start>
> Type=raw:Mail.Outgoing
> Target=>
> <raw>
> Message
> {
> To=james@xxxxxxx <mailto:To=james@xxxxxxx>
> From=telephone@xxxxxxx <mailto:From=telephone@xxxxxxx>
> Subject=*Direction* Call from *NameCompanyNumber*
> }
> Body.Text
> {
> Text.1=*Direction* Call from *NameCompanyNumber*
> Text.2=on *LineDescription* from *LocationSTD*
> }
> </raw>
> <end>
>
> Now assuming your xAP mail gateway is set up that's all that is needed
> to send an email. Using the same kind of idea you could use xAPSMS to
> send an SMS, or even send a message to a Netiom-xAP to flash a light!
>
> Hope all this is of help and if you have any questions just ask.
>
> James
>
>
> Neil Frost wrote:
>
> thanks, I'll look at this tonight.
>
>
>
>
------------------------------------------------------------------------
>
> *From:* xap_automation@xxxxxxx
> <mailto:xap_automation@xxxxxxx>
on behalf of Stuart Booth
> *Sent:* Tue 12/07/2005 13:35
> *To:* xap_automation@xxxxxxx
> <mailto:xap_automation@xxxxxxx>
> *Subject:* Re: [xap_automation] xAP & SQL
>
> On Tue, 12 Jul 2005 13:25:28 +0100, Kevin Hawkins
> <lists@xxxxxxx> <mailto:lists@xxxxxxx> wrote:
>
>>NB  I would have to check that we actually have such a xAP
application
>>to send an email via a xAP schema - I had originally thought
Stuarts,
>>xAP Mail Monitor did but in just skimming the docs maybe it doesn't
,
>>and I thought James and Patrick each had one too although maybe
that was
>>SMS.....- does anyone have such an application ???
>
> An old application that does this, but definitely needs an update (the
> schema links on this page are out of date I now notice):
>
> <http://www.xapframework.net/modules.php?name=Downloads&d_op=viewdownload&cid=43
> <http://www.xapframework.net/modules.php?name=Downloads&d_op=viewdownload&cid=43>>
>
> And the xAP schema to do so:
>
> <http://www.xapautomation.org/modules.php?name=Sections&op=viewarticle&artid=8
> <http://www.xapautomation.org/modules.php?name=Sections&op=viewarticle&artid=8>>
>
> HTH,
>
> S
> --
> Stuart Booth <stuart@xxxxxxx> <mailto:stuart@xxxxxxx>
> xAPFramework.net - a xAP software development framework for .net
>
> http://www.xapautomation.org/     
 http://www.xapframework.net/
>
>
>
> Yahoo! Groups Links
>
>
> <mailto:xap_automation-unsubscribe@xxxxxxx>
>
>
>
>
>
>
>
------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
>     *  Visit your group "xap_automation
>       <http://groups.yahoo.com/group/xap_automation>"
on the web.
>
>     *  To unsubscribe from this group, send an email to:
>        xap_automation-unsubscribe@xxxxxxx
>       <mailto:xap_automation-unsubscribe@xxxxxxx?subject=Unsubscribe>
>
>     *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>       Service <http://docs.yahoo.com/info/terms/>.
>
>
>
------------------------------------------------------------------------
>


--------------050006070501070408010807
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01
Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">


I just tried loading the console verion of the email sending app from
Stuart's link, adding the &lt;start&gt;&lt;end&gt; block to
the tosend
file and tried a call. Well the good news was it worked so in theory
all the issues&nbsp; will be a config or network one. A few things to
check:<br>
in SendEMail.exe.config fill in the &lt;add key="SMTPServer"
value="IP
or address of smtp" /&gt;<br>
make sure that when the block was added to the ToSend file the
&lt;start&gt; and &lt;end&gt; are on lines all by
themselves.<br>
Assuming all this is running on a single pc then just like xpl, xAP
needs a hub to be running<br>
<a class="moz-txt-link-freetext" href="http://www.xapframework.net/modules.php?name=Content&pa=showpage&pid=8";>http://www.xapframework.net/modules.php?name=Content&amp;pa=showpage&amp;pid=8</a><br>
The hub should be started before all other applications for it to work
correctly, the windows service version is good for this.<br>
<br>
One thing I didn't mention was that Switcboard reads the event files
when the event is fired. So you can edit these files and changes will
be live, you don't need to restart Switchboard.<br>
<br>
If all that fails then give Viewer a go<br>
<a class="moz-txt-link-freetext" href="http://www.xapframework.net/modules.php?name=Content&pa=showpage&pid=9";>http://www.xapframework.net/modules.php?name=Content&amp;pa=showpage&amp;pid=9</a><br>
It will show you all messages being received so under Switchboard you
should see your mail message. You should see messages from all your
apps, if after a couple of minutes one doesn't show then that app will
need a checkup.<br>
<br>
hth<br>
James<br>
<br>
Neil Frost wrote:
<blockquote
cite="mid287B62DA4E419A4390EE493CCCF5E55A4C6E@xxxxxxx"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
">
<meta name="Generator" content="Microsoft Word 11
(filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Re: [xap_automation] xAP &amp; SQL</title>
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName">
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
tt
{font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1177379536;
mso-list-template-ids:788946408;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level1 lfo2
{mso-level-start-at:0;
mso-level-numbering:continue;
mso-level-text:\F0A7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</o:SmartTagType>
<div class="Section1">
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Is
there a
way to troubleshoot
this?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;">I&#8217;ve
installed and started the sendmail
service added the message below to the ToSend.txt file, restarted xAP
Switchboard.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;">Receive an
incoming call, complete the
call and no
email&#8230;<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Any
ideas?<o:p></o:p></span></font></p>
<div>
<div class="MsoNormal" style="text-align: center;"
align="center"><font
color="black" face="Times New Roman"
size="3"><span
style="font-size: 12pt; color: windowtext;"
lang="EN-US">
<hr tabindex="-1" align="center" size="2"
width="100%"></span></font></div>
<p class="MsoNormal"><b><font
color="black" face="Tahoma"
size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;
font-weight: bold;"
lang="EN-US">From:</span></font></b><font
color="black" face="Tahoma"
size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;"
lang="EN-US"> <a class="moz-txt-link-abbreviated"
href="mailto:xap_automation@xxxxxxx";>xap_automation@xxxxxxx</a>
[<a class="moz-txt-link-freetext" href="mailto:xap_automation@xxxxxxx";>mailto:xap_automation@xxxxxxx</a>]
<b><span
style="font-weight: bold;">On
Behalf Of </span></b>James<br>
<b><span style="font-weight:
bold;">Sent:</span></b> 12 July 2005
22:19<br>
<b><span style="font-weight:
bold;">To:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:xap_automation@xxxxxxx";>xap_automation@xxxxxxx</a><br>
<b><span style="font-weight:
bold;">Subject:</span></b> Re:
[xap_automation] xAP
&amp; SQL</span></font><font
color="black"><span
style="color: windowtext;"
lang="EN-US"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="black"
face="Times New Roman"
size="3"><span style="font-size:
12pt;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font color="black"
face="Times New Roman"
size="3"><span style="font-size:
12pt;">Neil,<br>
<br>
&nbsp;As Kevin described, Switchboard can't on it's own send emails,
sms or
IMs
as these tasks are best handled by separate apps. What Switchboard does
have is
a flexible event system with the events triggering when various things
happen:<br>
On an Incoming call (ToSend)<br>
When an incoming call is picked up (ToSend_Pickup)<br>
The end of an Incoming call (ToSend_IncEnd)<br>
When a local phone is picked up and/or a digit is pressed
(ToSend_OutDigit)<br>
The end of an Outgoing call (ToSend_OutEnd)<br>
When an IM contact changes state (ToSendIM)<br>
<br>
Each of these events is actually a text file inside the Switchboard
directory,
the names of the files being what's between the ( ) above. Each file
contains
as many xAP messages as you like and each xAP message can contain
elements from
the phone call. If you have a look at the Tosend.txt file, in its
default state
it sends 3 messages on an incoming call, one for a slimp3, one for a
generic
display and finally one for text to speech. Each message is between a
&lt;start&gt; and an &lt;end&gt; and insertable&nbsp;
elements are contained
within *s. There is a list of all possible *s in the ToSend file. Now
Switchboard support a few builtin schemas but to send an email you will
need to
use a raw message. Below is an example block to add to a ToSend
file:<br>
<br>
&lt;start&gt;<br>
Type=raw:Mail.Outgoing<br>
Target=&gt;<br>
&lt;raw&gt;<br>
Message<br>
{<br>
<a href="mailto:To=james@xxxxxxx";>To=james@xxxxxxx</a><br>
<a href="mailto:From=telephone@xxxxxxx";>From=telephone@xxxxxxx</a><br>
Subject=*Direction* Call from *NameCompanyNumber*<br>
}<br>
Body.Text<br>
{<br>
Text.1=*Direction* Call from *NameCompanyNumber*<br>
Text.2=on *LineDescription* from *LocationSTD*<br>
}<br>
&lt;/raw&gt;<br>
&lt;end&gt;<br>
<br>
Now assuming your xAP mail gateway is set up that's all that is needed
to send
an email. Using the same kind of idea you could use xAPSMS to send an
SMS, or
even send a message to a Netiom-xAP to flash a light!<br>
<br>
Hope all this is of help and if you have any questions just ask.<br>
<br>
James<br>
<br>
<br>
<st1:PersonName w:st="on">Neil Frost</st1:PersonName>
wrote: <o:p></o:p></span></font></p>
<div id="idOWAReplyText71329">
<div>
<p class="MsoNormal"><font color="black"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">thanks, I'll look
at this
tonight.</span></font><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><font color="black"
face="Times New Roman"
size="3"><span style="font-size:
12pt;"><o:p>&nbsp;</o:p></span></font></p>
<div class="MsoNormal" style="text-align: center;"
align="center"><font
color="black" face="Times New Roman"
size="3"><span
style="font-size: 12pt;">
<hr tabindex="-1" align="center" size="2"
width="100%"></span></font></div>
<p class="MsoNormal" style="margin-bottom:
12pt;"><b><font
color="black" face="Tahoma"
size="2"><span
style="font-size: 10pt; font-family: Tahoma; font-weight:
bold;">From:</span></font></b><font
face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma;"> <a
href="mailto:xap_automation@xxxxxxx";>xap_automation@xxxxxxx</a>
on behalf of Stuart Booth<br>
<b><span style="font-weight:
bold;">Sent:</span></b> Tue 12/07/2005
13:35<br>
<b><span style="font-weight:
bold;">To:</span></b> <a
href="mailto:xap_automation@xxxxxxx";>xap_automation@xxxxxxx</a><br>
<b><span style="font-weight:
bold;">Subject:</span></b> Re:
[xap_automation] xAP
&amp; SQL</span></font><o:p></o:p></p>
</div>
<div>
<p style="margin-bottom: 12pt;"><font
color="black"
face="Times New Roman" size="2"><span
style="font-size: 10pt;">On Tue,
12 Jul 2005 13:25:28 +0100, Kevin Hawkins<br>
<a href="mailto:lists@xxxxxxx";>&lt;lists@xxxxxxx&gt;</a>
wrote:<br>
<br>
&gt;NB&nbsp; I would have to check that we actually have such a xAP
application<br>
&gt;to send an email via a xAP schema - I had originally thought
Stuarts,<br>
&gt;xAP Mail Monitor did but in just skimming the docs maybe it doesn't
,<br>
&gt;and I thought James and Patrick each had one too although maybe
that was<br>
&gt;SMS.....- does anyone have such an application
???&nbsp;&nbsp;&nbsp;<br>
<br>
An old application that does this, but definitely needs an update
(the<br>
schema links on this page are out of date I now notice):<br>
<br>
&lt;<a
href="http://www.xapframework.net/modules.php?name=Downloads&amp;d_op=viewdownload&amp;cid=43";>http://www.xapframework.net/modules.php?name=Downloads&amp;d_op=viewdownload&amp;cid=43</a>&gt;<br>
<br>
And the xAP schema to do so:<br>
<br>
&lt;<a
href="http://www.xapautomation.org/modules.php?name=Sections&amp;op=viewarticle&amp;artid=8";>http://www.xapautomation.org/modules.php?name=Sections&amp;op=viewarticle&amp;artid=8</a>&gt;<br>
<br>
HTH,<br>
<br>
S<br>
--<br>
Stuart Booth <a href="mailto:stuart@xxxxxxx";>&lt;stuart@xxxxxxx&gt;</a><br>
xAPFramework.net - a xAP software development framework for .net<br>
<br>
<a href="http://www.xapautomation.org/";>http://www.xapautomation.org/</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="http://www.xapframework.net/";>http://www.xapframework.net/</a><br>
<br>
<br>
<br>

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.