[Asterisk-Users] CRM integration (was RE: CallerID)

[Iassen Hristov]

I am also very interested in CRM integration. Anything I can do to help?

One thing I don't understand is how is the browser being launched on the
person's PC. Or is it not launched automatically?

Anyone know of a simple app running on the desktop to do this? I looked
into IPSwithcBoard and it appears like it should be able to do the job,
but: 
a) It is pretty heavy - it does a lot of other things that are not
necessary in this scenario
b) it did not work for me. It gives me a bunch of exceptions when
connecting to my Asterisk box.

---
Iassen Hristov

> ------------------------------
> 
> Message: 3
> Date: Tue, 24 May 2005 22:03:48 -0500
> From: "Anton Krall" <akrall-lists at intruder.com.mx>
> Subject: RE: [Asterisk-Users] CallerID
> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
> 	<asterisk-users at lists.digium.com>
> Message-ID: <20050525030734.496055B40F4 at intruder.com.mx>
> Content-Type: text/plain;	charset="us-ascii"
> 
> Hi Michiel.
> 
> Could We do that? Could you help me disect your apis so I can better
> understand what you are doing? I code in php so mustly what We need to do
> is understand what you are doing to your DB, etc.
> 
> Let me know what to do.
> 
> Thx! And I sure think this is going to be a great addon to the list for
> everybody looking to use php and integrate CTI into apps like SugarCRM,
> salesforce.com, etc. 
> 
>| -----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.
>|> | --