<html><head><base href="x-msg://100/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Feb 4, 2010, at 10:38 PM, Darren C. wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: arial, helvetica, sans-serif; font-size: 12pt; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Tim,<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Many thanks for your response.<span> <span class="Apple-converted-space"> </span></span>I posted this message on the Dev list and all I heard was crickets.<span> I would think a web GUI for a phone would be in demand by the FS community....</span><o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">We are doing something similar to what you described.<span> <span class="Apple-converted-space"> </span></span>We’re developing a rather complex IVR/Switching application and it currently does all its database writes via our Web Service to an MS SQL database.<span> <span class="Apple-converted-space"> </span></span>We have a web site that is updated with call details via the web service’s backend database.<span> <span class="Apple-converted-space"> </span></span>From this web interface a user can see counts of voicemails, see call activity, play voicemails, see calls in progress, record calls, etc.<span> <span class="Apple-converted-space"> </span></span>It’s a specialized application so it doesn’t have every PBX feature but this is what we wanted to do with a high-end SIP Phone to replace our office PBX.<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Currently we have an ESI (Estech) E-Class PBX that uses normal digital phones as well as proprietary VOIP (non-SIP) phones.<span> <span class="Apple-converted-space"> </span></span>I think these really nice SIP phones with huge color touchscreens would be much better than even high-end proprietary digital phones + we’d get all the benefits of FS.<span> <span class="Apple-converted-space"> </span></span>We’ll just need to add all the basic PBX capabilities to the phone’s GUI to see how many voicemails are waiting, how many lines are in use, button for call transfer, etc.<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">As you mentioned:</span><span style="font-size: 10pt; font-family: 'Courier New'; "><span> <span class="Apple-converted-space"> </span></span>“you can do a DB query to find out what voicemail messages a user has, or what calls are active, etc.”<span> <span class="Apple-converted-space"> </span></span></span><span style="font-size: 10pt; font-family: Arial, sans-serif; ">We are keeping track of all this ourselves via our web service’s backend database.<span> <span class="Apple-converted-space"> </span></span>I’m not sure I need to do this for everything but we are.<span> <span class="Apple-converted-space"> </span></span>It’s a multi-tenant system with hundreds of tenants so I’m guessing I might lose some needed relationships by querying FS but I’m going to re-visit this…I will make sure I can’t just query FS like you’re doing for some of these things…we’ve never turned on ODBC or even looked for the documentation as to what FS stores.<span> <span class="Apple-converted-space"> </span></span>We have to run FS in Linux for some Sangoma stuff but we’re Windows people so that is another reason we store via web services to an MS SQL backend.</span></div></div></div></div></span></blockquote><div><br></div>FreeSWITCH can use ODBC to talk directly to your db, and for this sort of setup, its probably a requirement to use a db other than the embedded database. Sangoma wanpipe on windows I am told works or basically works. I would talk to sangoma for more information.</div><div><br></div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: arial, helvetica, sans-serif; font-size: 12pt; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">I was worried I’d get one of these fancy phones and find out it doesn’t support important SIP/FS features rendering the color touchscreen useless.<span> <span class="Apple-converted-space"> </span></span>I’ve never owned one of these SIP phones, just used various softphones.<span> <span class="Apple-converted-space"> </span></span>But thanks to you I’ll get an Aastra 6739i and give it a try.</span></div></div></div></div></span></blockquote><div><br></div>Typically the applications on the phone are not related to sip at all.</div><div><br></div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: arial, helvetica, sans-serif; font-size: 12pt; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; "><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">I have a fulltime programmer working on this system on and off now for over a year but this has been mostly developing the IVR.<span> <span class="Apple-converted-space"> </span></span>We haven't made any attempt at using FS as a PBX. So based on your comments I think I’ll purchase an Aastra 6739i and develop a custom SIP Phone GUI interface with FS.</span></div></div></div></div></span></blockquote><div><br></div>I am not sure the phone gui has much to do with FreeSWITCH at all, other than pulling a little data from the databases (again, ODBC highly recommended)</div><div><span class="Apple-style-span" style="font-family: Arial, sans-serif; font-size: 13px; "> </span></div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: arial, helvetica, sans-serif; font-size: 12pt; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">If you or others would like to collaborate on an Aastra 6739i phone GUI for FS, feel free to contact me.<span> <span class="Apple-converted-space"> </span></span>We can try to make it extensible for other phones as well.<span> <span class="Apple-converted-space"> </span></span>My email is ustcor<remove this junk>poration@yah<remove this too>oo.com.<span> </span><o:p></o:p></span></div></div></div></div></span></blockquote></div><br><div>Can you post for all to see some idea of how these applications work, lanagages used, some samples so we can see if we can get some interest in this?</div><div><br></div><div>Mike</div><div><br></div></body></html>