Say the Word Michiel... When do We start? |-----Original Message----- |From: [EMAIL PROTECTED] |[mailto:[EMAIL PROTECTED] On Behalf Of |Michiel van Baak |Sent: Martes, 24 de Mayo de 2005 04:45 p.m. |To: asterisk-users@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: [EMAIL PROTECTED] |> |[mailto:[EMAIL PROTECTED] On Behalf |Of Michiel |> |van Baak |> |Sent: Martes, 24 de Mayo de 2005 02:14 p.m. |> |To: asterisk-users@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 |> |[EMAIL PROTECTED] |> |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@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@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 |[EMAIL PROTECTED] |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@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@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
