Steve Hanselman
2005-Dec-16 11:29 UTC
[Asterisk-Users] CID lookup from an Exchange Public folder
Has anybody done this? 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?) Steve The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendata.co.uk -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051216/3f42ca19/attachment.htm
Colin Anderson
2005-Dec-16 11:48 UTC
[Asterisk-Users] CID lookup from an Exchange Public folder
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. 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. If you want, email me offlist and I will send you my ODBCSockets script. -----Original Message----- From: Steve Hanselman [mailto:SteveH@brendata.co.uk] Sent: Friday, December 16, 2005 11:29 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [Asterisk-Users] CID lookup from an Exchange Public folder Has anybody done this? 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?) Steve The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendataco.uk -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051216/f27e3ee9/attachment.htm
Steve Hanselman
2005-Dec-17 03:18 UTC
[Asterisk-Users] CID lookup from an Exchange Public folder
We have a public folder full of contacts, but I understood that you could only access this if the contacts were contacts in AD? I was planning on doing a match on telephone number, mobile number and fax. And then pulling a shortened version of the name as the caller ID, Steve -----Original Message----- From: Jason SJOBECK [mailto:jason@sjobeck.com] On Behalf Of support@sjobeck.com Sent: 16 December 2005 21:48 To: asterisk-users@lists.digium.com Cc: Steve Hanselman Subject: Re: [Asterisk-Users] CID lookup from an Exchange Public folder Steve, You can get to anything in Exchange via LDAP. What is and or is not working? Where are you entering the callerID info you want pulled? Please see attachment for where you might want to enter this. Please share if you get this. Cheers. Jason ------------------------- Message: 1 Date: Fri, 16 Dec 2005 18:29:12 -0000 From: "Steve Hanselman" <SteveH@brendata.co.uk> Subject: [Asterisk-Users] CID lookup from an Exchange Public folder To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Message-ID: <11720FFB22BED511A66800E07D923B379571B9@prodntsc2.brendata> Content-Type: text/plain; charset="us-ascii" Has anybody done this? 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?) Steve The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendata.co.uk
Colin Anderson
2005-Dec-17 11:28 UTC
[Asterisk-Users] CID lookup from an Exchange Public folder
Exchange contacts != AD entries. Contacts in Exchange are basically email messages with metadata. Now, if all of your contacts WERE in AD, you could do a script to query AD through LDAP (that's what AD is - LDAP with MS extensions) and you would solve latency problems when Asterisk would query AD instead of clunky MAPI. Here's a cool script to export contacts in a public folder to AD: http://www.msexchange.org/articles/Migrating-Contacts-Distribution-Lists-Out look-Active-Directory.html The problem with this is maintenance, since now you have 2 contact databases. Making sure they are sync'd wouldn't be an automatic process and invariably would mean that an admin would have to fire up ADSI Edit every once in a while. This is mitigated by how often you change contacts. In an org where contacts change rarely, or never this isn't a problem. Where I work, contacts nmber in the THOUSANDS and change EVERY DAY. The administrative overhead of maintaining those guys in AD is brutal, and that's why at my work I have basically banned using public folders as a contact manager and insisted that we use SQL server with a web front-end, this makes things simple for the maintainer, extensible and fast, and SQL server plugs into everything. hth -----Original Message----- From: Steve Hanselman [mailto:SteveH@brendata.co.uk] Sent: Saturday, December 17, 2005 3:18 AM To: support@sjobeck.com; asterisk-users@lists.digium.com Subject: RE: [Asterisk-Users] CID lookup from an Exchange Public folder We have a public folder full of contacts, but I understood that you could only access this if the contacts were contacts in AD? I was planning on doing a match on telephone number, mobile number and fax. And then pulling a shortened version of the name as the caller ID, Steve -----Original Message----- From: Jason SJOBECK [mailto:jason@sjobeck.com] On Behalf Of support@sjobeck.com Sent: 16 December 2005 21:48 To: asterisk-users@lists.digium.com Cc: Steve Hanselman Subject: Re: [Asterisk-Users] CID lookup from an Exchange Public folder Steve, You can get to anything in Exchange via LDAP. What is and or is not working? Where are you entering the callerID info you want pulled? Please see attachment for where you might want to enter this. Please share if you get this. Cheers. Jason ------------------------- Message: 1 Date: Fri, 16 Dec 2005 18:29:12 -0000 From: "Steve Hanselman" <SteveH@brendata.co.uk> Subject: [Asterisk-Users] CID lookup from an Exchange Public folder To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Message-ID: <11720FFB22BED511A66800E07D923B379571B9@prodntsc2.brendata> Content-Type: text/plain; charset="us-ascii" Has anybody done this? 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?) Steve The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendata.co.uk _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Steve Hanselman
2005-Dec-19 05:48 UTC
[Asterisk-Users] CID lookup from an Exchange Public folder
My point exactly. I'll take a look at that script though, if I could automate that each night then it might be fine, tag the imports, clear out those then re-import again. Thanks Steve -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Colin Anderson Sent: 17 December 2005 18:29 To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] CID lookup from an Exchange Public folder Exchange contacts != AD entries. Contacts in Exchange are basically email messages with metadata. Now, if all of your contacts WERE in AD, you could do a script to query AD through LDAP (that's what AD is - LDAP with MS extensions) and you would solve latency problems when Asterisk would query AD instead of clunky MAPI. Here's a cool script to export contacts in a public folder to AD: http://www.msexchange.org/articles/Migrating-Contacts-Distribution-Lists -Out look-Active-Directory.html The problem with this is maintenance, since now you have 2 contact databases. Making sure they are sync'd wouldn't be an automatic process and invariably would mean that an admin would have to fire up ADSI Edit every once in a while. This is mitigated by how often you change contacts. In an org where contacts change rarely, or never this isn't a problem. Where I work, contacts nmber in the THOUSANDS and change EVERY DAY. The administrative overhead of maintaining those guys in AD is brutal, and that's why at my work I have basically banned using public folders as a contact manager and insisted that we use SQL server with a web front-end, this makes things simple for the maintainer, extensible and fast, and SQL server plugs into everything. hth -----Original Message----- From: Steve Hanselman [mailto:SteveH@brendata.co.uk] Sent: Saturday, December 17, 2005 3:18 AM To: support@sjobeck.com; asterisk-users@lists.digium.com Subject: RE: [Asterisk-Users] CID lookup from an Exchange Public folder We have a public folder full of contacts, but I understood that you could only access this if the contacts were contacts in AD? I was planning on doing a match on telephone number, mobile number and fax. And then pulling a shortened version of the name as the caller ID, Steve -----Original Message----- From: Jason SJOBECK [mailto:jason@sjobeck.com] On Behalf Of support@sjobeck.com Sent: 16 December 2005 21:48 To: asterisk-users@lists.digium.com Cc: Steve Hanselman Subject: Re: [Asterisk-Users] CID lookup from an Exchange Public folder Steve, You can get to anything in Exchange via LDAP. What is and or is not working? Where are you entering the callerID info you want pulled? Please see attachment for where you might want to enter this. Please share if you get this. Cheers. Jason ------------------------- Message: 1 Date: Fri, 16 Dec 2005 18:29:12 -0000 From: "Steve Hanselman" <SteveH@brendata.co.uk> Subject: [Asterisk-Users] CID lookup from an Exchange Public folder To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Message-ID: <11720FFB22BED511A66800E07D923B379571B9@prodntsc2.brendata> Content-Type: text/plain; charset="us-ascii" Has anybody done this? 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?) Steve The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendata.co.uk _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Brendata immediately on: +44 (0)1268 466100, or email 'technical@brendata.co.uk' Brendata (UK) Ltd Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK Registered Office as above. Registered in England No. 2764339 See our current vacancies at www.brendata.co.uk