The method we use for web popups on incoming calls in the astGUIclient client app that we are working on for release next week is to use AJAX(Javascript + XMLHTTPRequest) It works in Firefox and IE5+ and doesn't require any META refreshes. We've been using this internally for the last month and it works great. MATT--- -----Original Message----- From: Anton Krall [mailto:akrall-lists@intruder.com.mx] Sent: Wednesday, May 25, 2005 10:41 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] CRM integration (was RE: CallerID) As one of the members said. The idea behind this is not to have to install any app on the computer but base everything on web apps. Im still trying to find out how to mix everything together but it's a mixture of Asterisk Manager usage and some PHP coding for example. You can probably just open a web page, and it will show you the callerid of whos calling you, provided you first told the web page your extension number or technology, like SIP/myextension so it can check the manager and see when a Dial is executed and extract the callerid. After that, it can probable just open a new browser automatically and insert the callerid or whatever into a URL for your CRM. It doesn't seem to be complicated but for example, the things that bother me are refreshes, I don't want to use meta refreshes for this monitoring webpage every X seconds, rather, use something more realtime... Any ideas? |-----Original Message----- |From: asterisk-users-bounces@lists.digium.com |[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of |Iassen Hristov |Sent: Mi?rcoles, 25 de Mayo de 2005 09:15 a.m. |To: asterisk-users@lists.digium.com |Subject: [Asterisk-Users] CRM integration (was RE: CallerID) | |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@intruder.com.mx> |> Subject: RE: [Asterisk-Users] CallerID |> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" |> <asterisk-users@lists.digium.com> |> Message-ID: <20050525030734.496055B40F4@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@lists.digium.com |>| [mailto:asterisk-users-bounces@lists.digium.com] 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: asterisk-users-bounces@lists.digium.com |>|> | [mailto:asterisk-users-bounces@lists.digium.com] 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. |>|> | -- | | | |_______________________________________________ |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
2005-May-25 09:09 UTC
[Asterisk-Users] CRM integration (was RE: CallerID)
On 11:12, Wed 25 May 05, mattf wrote:> The method we use for web popups on incoming calls in the astGUIclient > client app that we are working on for release next week is to use > AJAX(Javascript + XMLHTTPRequest) It works in Firefox and IE5+ and doesn't > require any META refreshes. We've been using this internally for the last > month and it works great. > > MATT--- >The example scripts I posted in the first thread use xhttprequest as well. I did not use AJAX but coded it myself. Works like a charm here too without the annoying "click" sounds IE gives you in the default install. I'm going to work things out and provide some cleaner scripts together with Anton (See first thread about this). Will keep you all updated on the progress.> > -----Original Message----- > From: Anton Krall [mailto:akrall-lists@intruder.com.mx] > Sent: Wednesday, May 25, 2005 10:41 AM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: RE: [Asterisk-Users] CRM integration (was RE: CallerID) > > > As one of the members said. The idea behind this is not to have to install > any app on the computer but base everything on web apps. Im still trying to > find out how to mix everything together but it's a mixture of Asterisk > Manager usage and some PHP coding for example. > > You can probably just open a web page, and it will show you the callerid of > whos calling you, provided you first told the web page your extension number > or technology, like SIP/myextension so it can check the manager and see when > a Dial is executed and extract the callerid. > > After that, it can probable just open a new browser automatically and insert > the callerid or whatever into a URL for your CRM. > > It doesn't seem to be complicated but for example, the things that bother me > are refreshes, I don't want to use meta refreshes for this monitoring > webpage every X seconds, rather, use something more realtime... Any ideas?
Looking forward to seeing it Matt. Please let us know when the new release is available for download. |-----Original Message----- |From: asterisk-users-bounces@lists.digium.com |[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of mattf |Sent: Mi?rcoles, 25 de Mayo de 2005 10:12 a.m. |To: 'Asterisk Users Mailing List - Non-Commercial Discussion' |Subject: RE: [Asterisk-Users] CRM integration (was RE: CallerID) | |The method we use for web popups on incoming calls in the |astGUIclient client app that we are working on for release |next week is to use AJAX(Javascript + XMLHTTPRequest) It works |in Firefox and IE5+ and doesn't require any META refreshes. |We've been using this internally for the last month and it works great. | |MATT--- | | |-----Original Message----- |From: Anton Krall [mailto:akrall-lists@intruder.com.mx] |Sent: Wednesday, May 25, 2005 10:41 AM |To: 'Asterisk Users Mailing List - Non-Commercial Discussion' |Subject: RE: [Asterisk-Users] CRM integration (was RE: CallerID) | | |As one of the members said. The idea behind this is not to |have to install any app on the computer but base everything on |web apps. Im still trying to find out how to mix everything |together but it's a mixture of Asterisk Manager usage and some |PHP coding for example. | |You can probably just open a web page, and it will show you |the callerid of whos calling you, provided you first told the |web page your extension number or technology, like |SIP/myextension so it can check the manager and see when a |Dial is executed and extract the callerid. | |After that, it can probable just open a new browser |automatically and insert the callerid or whatever into a URL |for your CRM. | |It doesn't seem to be complicated but for example, the things |that bother me are refreshes, I don't want to use meta |refreshes for this monitoring webpage every X seconds, rather, |use something more realtime... Any ideas? | ||-----Original Message----- ||From: asterisk-users-bounces@lists.digium.com ||[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Iassen ||Hristov ||Sent: Mi?rcoles, 25 de Mayo de 2005 09:15 a.m. ||To: asterisk-users@lists.digium.com ||Subject: [Asterisk-Users] CRM integration (was RE: CallerID) || ||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@intruder.com.mx> ||> Subject: RE: [Asterisk-Users] CallerID ||> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" ||> <asterisk-users@lists.digium.com> ||> Message-ID: <20050525030734.496055B40F4@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@lists.digium.com ||>| [mailto:asterisk-users-bounces@lists.digium.com] 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: asterisk-users-bounces@lists.digium.com ||>|> | [mailto:asterisk-users-bounces@lists.digium.com] 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. ||>|> | -- || || || ||_______________________________________________ ||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 |_______________________________________________ |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 |