Thanks guys. I understand the ODBC and channel variables using Asterisk. However, I am really looking for an ability for a webserver to subscribe to channel status in asterisk and be informed when a call comes in and show the callerID in real-time.
>From the AMI, there is Newcallerid Event which would be suitable for this purpose. I have been reading the voip-info pages and have set up AJAM and can get results from doing http requests to the asterisk server, however, this is in the form of an action, such as login, rather than subscribing to an event. I have been looking here for information http://www.voip-info.org/wiki/view/asterisk+manager+events Does anyone know if subscriptions is possible with AJAM? Thanks Robert On Tue, Apr 29, 2008 at 6:14 AM, Gleim, Jason <[EMAIL PROTECTED]> wrote: > Robert, > > You can access CDR information within the dialplan using the CDR > variable. I'm doing something very similar with a DISA feature for our > employees. We use ODBC to validate them against an existing MSSQL server > (check their employee ID & pin number) then when all is well, I write > some information about the call (including the uniqueid field) out to a > 'tracking' table I setup. Then I can join the tracking table and the cdr > table on the uniqueid column and associate employees with calls. > > In my dialplan, I use the following snippet for setting the values in > the tracking table: (The DBNIS= line is where I do the insert) > > exten => valid_login,1,NoOp() > exten => valid_login,n,Set(CALLDATE=${STRFTIME(${EPOCH},GMT+5,%x %X)}) > exten => valid_login,n,Set(CLID=${CALLERID(num)}) > exten => valid_login,n,Set(UNID=${CDR(uniqueid)}) > exten => valid_login,n,Set(DBINS = > ${ODBC_DISA(${CALLDATE},${CLID},${ID_ENTERED},${UNID})}) > exten => > valid_login,n,Playback(/var/lib/asterisk/sounds/custom/disa_greet3) > exten => valid_login,n,DISA("no-password",from-disa,"XXXXXXX" > <614xxxxxxxx>) > exten => valid_login,n(end),Hangup > > HTH! > Jason > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Robert > McNaught > Sent: Monday, April 28, 2008 6:31 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: [asterisk-users] func_odbc creating records or best practice > > Hi, > > I am trying to write a custom application which will integrate with an > existing MSSQL crm system. > > We need to get ahold of the CDR(uniqueid) field in during call-time - > I see from doing a DumpChan(), the CDR unique ID is available as soon > as the call is created. CDRs usind odbc are only written once the > call is completed. Does anyone know if it is possible to use > func_odbc to create a temporary record then delete it so that this > information is available to MSSQL. I was not sure if func_odbc was > limited to just using UPDATE/SELECT queries. > > Would there be a better way to do this using the AMI or AGI? It just > seems a little strange to use a database for storing temporary data > such as this? > > Thanks in Advance > > Robert McNaught > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users