<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C60236.AF9D02B0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.emailstyle17
{mso-style-name:emailstyle17;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>OWA sucks
big time you’ll never get it to run right. If you use CDO in an ASP script, you
can programmatically access basically every structure in Exchange. If you call
a shell script via AGI with wget in it, that would call the ASP script which
would filter items in the Exchange store via CDO, then return the item you want
using SET VARIABLE syntax to Asterisk. Problem is there is massive overhead in
CDO (it’s basically a MAPI client) so the latency would be so bad that it would
never work in near real time and scaling would be a problem from the get-go. <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>I do a
caller ID lookup from our SQL server using ODBCSockets direct to Asterisk and
it is under a second, with no scaling problems. This approach would work fine
for you, as long as you had a vbscript that you could run say once a day that
would do the CDO, get the contact items, wipe all of the records from the SQL
server table, and repopulate the table. This solves your latency problem. If
you don’t have SQL you can get the free SQL 2005 download from Microsoft. <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>If you
want, email me offlist and I will send you my ODBCSockets script. <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle18><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Steve Hanselman
[mailto:SteveH@brendata.co.uk]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, December 16, 2005
11:29 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Asterisk Users Mailing List -
Non-Commercial Discussion<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Asterisk-Users] CID
lookup from an Exchange Public folder</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'>Has anybody done this?</span></font><font
color=black><span lang=EN-GB style='color:black;mso-color-alt:windowtext;
mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'> </span></font><font color=black><span
lang=EN-GB style='color:black;mso-color-alt:windowtext;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'>I looked at LDAP but you can’t get to them
that way, I’m considering either a timed export, or some other way (can you
access them via IMAP? Or by wget on the owa web structure?)</span></font><font
color=black><span lang=EN-GB style='color:black;mso-color-alt:windowtext;
mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'> </span></font><font color=black><span
lang=EN-GB style='color:black;mso-color-alt:windowtext;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'>Steve</span></font><font color=black><span
lang=EN-GB style='color:black;mso-color-alt:windowtext;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-GB'> </span></font><font color=black><span
lang=EN-GB style='color:black;mso-color-alt:windowtext;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
</div>
</body>
</html>
<HTML><BODY><P><FONT color=#000000 face="Arial" size=2>The information contained in this email is intended for the personal and confidential use<BR>of the addressee only. It may also be privileged information. If you are not the intended<BR>recipient then you are hereby notified that you have received this document in error and<BR>that any review, distribution or copying of this document is strictly prohibited. If you have <BR>received this communication in error, please notify Brendata immediately on: <BR><BR>+44 (0)1268 466100, or email 'technical@brendata.co.uk' <BR><BR>Brendata (UK) Ltd<BR>Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK<BR>Registered Office as above. Registered in England No. 2764339<BR><BR>See our current vacancies at www.brendataco.uk</FONT></BODY>