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

[Michiel van Baak]

On 18:48, Wed 25 May 05, Anton Krall wrote:
> Michiel.
> 
> To help better understand what xmlhttp does with asterisk, could you modify
> your tgx file and strip everything related to db and make a sort of hello
> world script? In fact, something small like connecting to the manager (of
> course, we each have to put our config there) and maybe issue a sip show
> peers and show how this can be done and update in realtime via web?
> 
> What do you think? This will elp grasp the concept of xmlhttp and connecting
> to the manager.
> 

Anton,

My script is not connecting to the manager interface.
The php script is run as agi script as first when a call
comes in. The php script will know the callerID of the
calling party, that is something the AGI interface provides
to the script.
Then the AGI script connects to my CRM database to do a
lookup on the phone number. If it finds a match it will put
the companyName and the records ID in a temporary table in
the same database. Of course instead of storing it in a
database it can also write a little xml file. I think I will
do that in the next release of our CRM app (Where this code
is taken from).
I altered the agi script to simplify it a little and I added
comments to explain what is being done.
I will also do this to the php script that generates the
callerID notification in my CRM app.
I will upload the new agi to my server as soon as this mail
is sent. Just for the record:
http://michiel.vanbaak.info/Files/

Have fun,

>  
> 
> |-----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: Mi?rcoles, 25 de Mayo de 2005 02:04 p.m.
> |To: asterisk-users at lists.digium.com
> |Subject: Re: [Asterisk-Users] CRM integration (was RE: CallerID)
> |
> |On 10:17, Wed 25 May 05, Rusty Shackleford wrote:
> |> > -----Original Message-----
> |> > From: asterisk-users-bounces at lists.digium.com
> |> > [mailto:asterisk-users-bounces at lists.digium.com] On Behalf 
> |Of Anton 
> |> > Krall
> |> > Sent: Wednesday, May 25, 2005 7:41 AM
> |> > To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> |> > Subject: RE: [Asterisk-Users] CRM integration (was RE: CallerID)
> |> > 
> |> > 
> |> > 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?
> |> 
> |> And that's the real trick. Web browsers, unless they are 
> |instructed to 
> |> do otherwise, don't DO anything once they've completed 
> |loading a page.
> |> So without instructing them to refresh, they aren't going to 
> |be aware 
> |> of a server-side change, such as an incoming call. For that, you're 
> |> going
> |
> |This is not true. If it was for pure HTML only, yes, you are 
> |correct. But with javascript you can start a timer and execute 
> |a javascript function every once in a while.
> |If this javascript loads an XML document off the server, 
> |you're there ;)
> |
> |
> |> to have to have some way of sending a message TO the client machine, 
> |> have it received by that machine, and have that client machine take 
> |> the desired action (pop up an incoming call dialog, load a contact 
> |> record, etc.).
> |> 
> |
> |Have a look at the tgz file I posted earlier
> |
> |> --
> |> No virus found in this outgoing message.
> |> Checked by AVG Anti-Virus.
> |> Version: 7.0.322 / Virus Database: 266.11.14 - Release Date: 
> |> 05/20/2005
> |>  
> |> 
> |> _______________________________________________
> |> 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."