[Asterisk-Users] CallerID

[Michiel van Baak]

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."