[Asterisk-Users] CallerID

Wed May 25 12:06:27 MST 2005

On 12:20, Wed 25 May 05, Anton Krall wrote:
> Say the Word Michiel... When do We start? 

Can I contact you tomorrow ???
Tonight is too slow for me to stay focussed.

> 
> |-----Original Message-----
> |From: asterisk-users-bounces at lists.digium.com 
> |[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of 
> |Michiel van Baak
> |Sent: Martes, 24 de Mayo de 2005 04:45 p.m.
> |To: asterisk-users at lists.digium.com
> |Subject: Re: [Asterisk-Users] CallerID
> |
> |On 23:44, Tue 24 May 05, Anton Krall wrote:
> |> I like you scenario Michiel!
> |> 
> |> Ok, I have sugarcrm installed on the same box as 
> |asterisk...What do I 
> |> need to do in order to, for example, start my softphone or hardphone 
> |> and when an incoming calls comes in, make a window popup (web window 
> |> that is) and show the contact window for that particular 
> |callerid on sugarcrm..
> |> 
> |> Any ideas? 
> |
> |Anton,
> |
> |We have this setup working in our webbased php app.
> |The process is like this:
> |When a call comes in, we launch a php agi script. This agi 
> |script does a SQL query in our contacts database to see if one 
> |of our customers has a phone number record that matches 
> |${CALLERID}. If so, it will put this customers database id in 
> |a temporary table. In our application we have a php script 
> |that turns this table into a xml file, and that xml file is 
> |read by a little javascript thing in our php webbased app. 
> |
> |As you see it doesn't matter what phone/software you have on 
> |the client, all is done in asterisk dialplan and the webbased 
> |app. I think it should be possible to set the calleridname on 
> |the asterisk channel so the phone will show it too, but we 
> |didn't care about that cause some of the phones are budgetones 
> |(yeah yeah I know, they are getting replaced by GXP-2000's 
> |next week) and those wont show it correctly
> |
> |Have another look at the files in the tgz file on my website. 
> |If you want we can have a look at it together and see how we 
> |can get this to work with sugarCRM.
> |I'm not familiar with sugarCRM but I can have a look at it 
> |with you if you want.
> |If it is possible in sugarCRM to get a customers overview 
> |screen using an url with parameters it should be very easy to 
> |modify our scripts so it works with sugarCRM. If it works with 
> |html post data it will need some work, but a day should be 
> |enuf to fix that I think.
> |
> |Right now we are not generating alerts of calls with a 
> |callerid that does not match one of our customers, but it can 
> |be done so it will just show you the phone nr and not the 
> |customer name. 
> |
> |If you want to contact me off-list that's ok.
> |But I think this is interesting enough for the list so other 
> |ppl and vendors can watch and start working on their projects ;)
> |
> |Sorry for the long story, but this is an issue that, in my 
> |opinion, really makes asterisk a HUGE added value product for 
> |business life.
> |
> |Cheers,
> |
> |> 
> |> |-----Original Message-----
> |> |From: asterisk-users-bounces at lists.digium.com
> |> |[mailto:asterisk-users-bounces at lists.digium.com] On Behalf 
> |Of Michiel 
> |> |van Baak
> |> |Sent: Martes, 24 de Mayo de 2005 02:14 p.m.
> |> |To: asterisk-users at lists.digium.com
> |> |Subject: Re: [Asterisk-Users] CallerID
> |> |
> |> |On 11:18, Tue 24 May 05, Anton Krall wrote:
> |> |> Anyway that works would be nice :) What I would like to do
> |> |Is get the
> |> |> callerid and then pass that parameter in order to open a http url 
> |> |> containing the callerid to pass or open a CRM webpage 
> |like SugarCRM.
> |> |> 
> |> |
> |> |Why is it that you want to do this client side ?
> |> |In my opinion it's better to do this on the server.
> |> |That way you really benefit of a web-based application like 
> |sugarCRM.
> |> |Webbased apps are made so you don't have to carry your own 
> |pc to get 
> |> |into the app. Why not do the same with callerID?
> |> |
> |> |Senario:
> |> |Sitting on a beach on a tropical island, enjoying a nice drink.
> |> |You still want to make money so you use a webbased app with your 
> |> |laptop. Softphone logged in to the * box.
> |> |A server-side handled callerID mechanism would be the way to go if 
> |> |you ask me.
> |> |--
> |> |Michiel van Baak
> |> |http://lunteren.vanbaak.info
> |> |michiel at vanbaak.info
> |> |GnuPG key: 
> |> |http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x7E0B9A2D
> |> |
> |> |"Two of the most famous products of Berkeley are LSD and BSD. 
> |> |I don't think that this is a coincidence."
> |> |
> |> |_______________________________________________
> |> |Asterisk-Users mailing list
> |> |Asterisk-Users at lists.digium.com
> |> |http://lists.digium.com/mailman/listinfo/asterisk-users
> |> |To UNSUBSCRIBE or update options visit:
> |> |   http://lists.digium.com/mailman/listinfo/asterisk-users
> |> |
> |> 
> |> _______________________________________________
> |> Asterisk-Users mailing list
> |> Asterisk-Users at lists.digium.com
> |> http://lists.digium.com/mailman/listinfo/asterisk-users
> |> To UNSUBSCRIBE or update options visit:
> |>    http://lists.digium.com/mailman/listinfo/asterisk-users
> |
> |--
> |Michiel van Baak
> |http://lunteren.vanbaak.info
> |michiel at vanbaak.info
> |GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x7E0B9A2D
> |
> |"Two of the most famous products of Berkeley are LSD and BSD. 
> |I don't think that this is a coincidence."
> |
> |_______________________________________________
> |Asterisk-Users mailing list
> |Asterisk-Users at lists.digium.com
> |http://lists.digium.com/mailman/listinfo/asterisk-users
> |To UNSUBSCRIBE or update options visit:
> |   http://lists.digium.com/mailman/listinfo/asterisk-users
> |
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Michiel van Baak
http://lunteren.vanbaak.info
michiel at vanbaak.info
GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x7E0B9A2D

"Two of the most famous products of Berkeley are LSD and BSD. I don't think that this is a coincidence."