[asterisk-users] Set CDR userfield for Queues

Mon Feb 1 07:56:27 CST 2010

Yes, over asterisk 1.4.x  you need put an cron or deamon to load queue
log into database. I suggest check on the list for more details.

Regards,

On Mon, Feb 1, 2010 at 8:51 AM, William Stillwell (Lists)
<william.stillwell-lists at ablebody.net> wrote:
> 1.4.x doesn't natively support logging the queue to to mysql, and can't find
> any way without batching it from the /var/log/asterisk/queue
>
>
>
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Luis Morales
> Sent: Saturday, January 30, 2010 8:38 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] Set CDR userfield for Queues
>
> Thereis an option with log queue stored into database. You can do an
> cross join from cdr and queue log using callid. With this solution you
> can track your call over your asterisk system.
>
> I wrote about this in old post and submit an complete solution.
>
> Regards,
>
> On Sun, Jan 24, 2010 at 1:14 PM, William Stillwell (Lists)
> <william.stillwell-lists at ablebody.net> wrote:
>> Yeah, after hours of trying Friday, I got working by a macro.. I didn't
> like
>> the outcome using a context, the macro cdr records looked cleaner.
>>
>>
>> [macro-queue]
>>
>> exten => s,1,Answer()
>> exten => s,n,Queue(${ARG1}|rn)
>> exten => s,n,Set(MEMBERINTERFACE='NOANSWER')
>> exten => s,n,VoiceMail(${ARG1},u)
>> exten => s,n,Hangup()
>> exten => h,1,Set(CDR(userfield)=${MEMBERINTERFACE})
>>
>>
>> Which is called from:
>>
>> exten => _?????,1,Macro(queue,${EXTEN})
>>
>>
>>
>>
>> -----Original Message-----
>> From: asterisk-users-bounces at lists.digium.com
>> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Deep D
>> Sent: Friday, January 22, 2010 11:28 PM
>> To: Asterisk Users Mailing List - Non-Commercial Discussion
>> Subject: Re: [asterisk-users] Set CDR userfield for Queues
>>
>> I just added a line with 'h'extension.
>>
>> My dialplan is like this
>>
>> [mycontext]
>> exten => s,1,Queue(6000)
>>
>> exten => h,1,Set(CDR(userfield)=${MEMBERINTERFACE})
>>
>> On Sat, Jan 23, 2010 at 12:14 AM, William Stillwell (Lists)
>> <william.stillwell-lists at ablebody.net> wrote:
>>> "setinterfacevar=yes"
>>>
>>> Needs to be under each queue
>>>
>>> What does your dialplan end up looking like?
>>>
>>> I would like to add to mine, and stop running a cron job..
>>>
>>> exten => 5000,1,Answer
>>> exten => 5000,n,Queue(5000|rn)
>>> exten => 5000,n,VoiceMail(5000,u)
>>> exten => 5000,n,Hangup
>>>
>>>
>>> -----Original Message-----
>>> From: asterisk-users-bounces at lists.digium.com
>>> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Deep D
>>> Sent: Friday, January 22, 2010 1:15 PM
>>> To: Asterisk Users Mailing List - Non-Commercial Discussion
>>> Subject: Re: [asterisk-users] Set CDR userfield for Queues
>>>
>>> The 'h' extension worked. Thanks.
>>>
>>> The other option of 'memebermacro' did not work.  On the asterisk
>>> console I could see that the macro is executed and cdr userfield is
>>> set when agent answers the call, but the userfield doesn't show up in
>>> the generated cdr.
>>>
>>> Also I had one more question. Doesn't "setinterfacevar=yes" work when
>>> it is declared in the general section? I had to declare it for each
>>> queues.
>>>
>>>
>>>
>>> On Fri, Jan 22, 2010 at 10:37 PM, Carlos Chavez <cursor at telecomabmex.com>
>>> wrote:
>>>> On Fri, 2010-01-22 at 20:25 +0530, Deep D wrote:
>>>>> I want to do something like this
>>>>> exten = 1234,n,Queue(6000,c)
>>>>> exten = 1234,n,Set(CDR(userfield)=${Agent})   ;; where Agent is the
>>>>> agent who answered the call
>>>>> exten = 1234,n,Hangup
>>>>>
>>>>        Actually because the user will hangup within the Queue
> application
>>> you
>>>> cannot do that.  You will have to use the h extension to make the change
>>>> to the userfield.  Something like this:
>>>>
>>>> h,1,Set(CDR(userfield)=${MEMBERINTERFACE})
>>>>
>>>>        Make sure you have setinterfacevar=yes in your queue.conf so that
>>>> variable is created when the user is connected to the agent.  Another
>>>> possibility is to run a macro by using "membermacro=somemacro" and set
>>>> the userfield within that macro.  I think that option is only available
>>>> on Asterisk 1.6.X and not for older ones though.  You can also run an
>>>> AGI script (you can set it as an option in the Queue commando) that will
>>>> set the userfield as this AGI is run just before the call is bridged to
>>>> the agent but the ${MEMBERINTERFACE} is already set.
>>>>
>>>>
>>>> --
>>>> Telecomunicaciones Abiertas de México S.A. de C.V.
>>>> Carlos Chávez Prats
>>>> Director de Tecnología
>>>> +52-55-91169161 ext 2001
>>>>
>>>> --
>>>> _____________________________________________________________________
>>>> -- 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
>>>
>>
>> --
>> _____________________________________________________________________
>> -- 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
>>
>
>
>
> --
> ----------------------------------------------------------------------------
> -----
> Luis Morales
> Consultor de Tecnologia
> Cel: +(58)412-2352745
> ----------------------------------------------------------------------------
> -----
> "Empieza por hacer lo necesario, luego lo que es posible... y de
> pronto estarás haciendo lo imposible"
>
> Leonardo Da'Vinci
> ----------------------------------------------------------------------------
> -----
>
> --
> _____________________________________________________________________
> -- 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
>

-- 
---------------------------------------------------------------------------------
Luis Morales
Consultor de Tecnologia
Cel: +(58)412-2352745
---------------------------------------------------------------------------------
"Empieza por hacer lo necesario, luego lo que es posible... y de
pronto estarás haciendo lo imposible"

Leonardo Da'Vinci
---------------------------------------------------------------------------------