similar to: CEL custom variable in outbound channel

Hi, I write the CDR of my Asterisk 1.2.17 server in MySQL database using cdr_addon_mysql.so. Now I'm trying to write some custom values to userfield column by the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in MySQL cdr table!! Why? I'm I skeeping something or what? Taking a look at the URL:

Hello, I am using Queue application with multiple agents in each queue. I want to set the CDR(userfield) for each cdr based on the agent answering the call. Is it possible to do this? Thanks

Hello, I'm using Asterisk with Realtime extensions and ODBC CDR. And I'm have some trouble with the CDR userfield that is not changed when using the SET command in the realtime dialplan. In my dialplan (extensions.conf, the file) I'm setting the userfield like this : exten => s,n,Set(CDR(userfield)="X") Later, my dialplan switches to the realtime part and this is an

Hi, I'm trying to migrate from Asterisk 1.8 to Asterisk 13 and can't figure this one out. I'm pretty sure the question has been already asked, but I failed to find a solution. Can you modify CDR values in an h-extension? My cdr.conf contains: [general] enable=yes unanswered=yes endbeforehexten=yes initiatedseconds=no batch=no The diaplan contains a simple "h" extension

cdr_mysql doesn't set the userfield when it's set inside a macro called from a feature (1.4.25, addons 1.4.8). I have a feature code: autorecord => *1,self,Macro,apprecord The apprecord macro looks like: [macro-apprecord] exten => s,1,Playback(beep) exten =>

Hi all, I've been trying to add a custom mysql field to my CDR's, but I must be doing something wrong. I am using asterisk 1.4 and asterisk 1.6, in extensions.conf I add: exten => h,1,Set(CDR(q931)=${HANGUPCAUSE}) This extension is executed, I can see it in the asterisk console. I have added a new column in my MySQL database called q931. However, the new field does not show up in

With endbeforehexten=no I actually get two CDR entries. One for the call and a second one for the "h" extension. "","13","10","sip-locals","""13"" <13>","SIP/13-00000006","SIP/10-00000007","Dial","SIP/10","2015-08-04 06:28:44","2015-08-04

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I am trying to set the CDR(userfield) to a certain vaule using the application map of features.conf but I am not able to do it. When I receive a call I would like to tag it with a client code (3 digit numeric) so I can referenci it later from the CDR. I have edited features.conf with something like: code => #111,self,SET(CDR(userfield(111)) or

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it

I'm trying to use the MySQL CDR records. According to dialplan show, the line in the dialplan is: 11. Set(CDR(userfield)=${billing_code}) [pbx_ael] It looks like the value is being set when I watch the console during the call: -- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's

Hi, Reading this old thread, may I ask if keeping hangup handlers from updating CDR values still enforced in Asterisk 15 ? If positive, would it be very complex to add in Asterisk, a configuration option allowing a system administrator to list in cdr.conf, the CDR fields allowed to be updated in hangup handlers ? I'm planning to store some RTCP stats. Saving them in CDR(userfield) would be

I want to set some custom data in the field of userfield in table CDR as following. exten => s,19,Set(CDR(userfield)=1234) exten => s,20,Dial(SIP/1234) However, the userfield doesn't get update after making the call. After that, I relocate the command as following. exten => s,19,Dial(SIP/1234) exten => s,20,Set(CDR(userfield)=1234) The userfield doens't get update at all. I

Hi list, I need some help to improve my cdr, now in my company are asking me how to know which of my phone numbers are most used when receiving calls from the PSTN and incoming the IVR was thinking about using userfield field, and I'm trying to do, I have at the moment 4 channel DAHDI ; DAHDI CHANNEL 3=23XXXXX6 context=in callerid=asreceived group=1 signalling=fxs_ks channel => 3

Hi, I'm logging cdr via odbc to mysql. It seems that there is an intermittent problem where the CDR(userfield) isn't written to the database. The rows all seem to be there, but that specific field is missing. The same dialplan. Nothings changed. Probably 1 in 10 is missing the userfield. Any ideas how I can debug this? Many thanks Dan -------------- next part -------------- An HTML

I have A@H 2.1, running * 1.2.1. I am trying to put information into the userfield with SetCDRUserField and AppendCDRUserField. However, the field is never populated in the cdr - I've checked the csv files and the MySQL asteriskcdrdb table. The field is defined in the MySQL table, but is always empty. The csv files that get created don't have a userfield at all, that is, there

Hi, I would like to see the DNID in my MySQL CDR logs. I have read one big thread in the Asterisk Developer List, but I could not figure out how to implement it ? Is there a simple step-by-step. Thx in advance. Vai

I would like to send the CDR records from all our machines around the world to a single database. But I need the hostname included with each record for monitoring purposes. Is there a better way than using the userfield and adding SetCDRUserfield for every call to set the userfield to the name of the host? Thanks...

Our current Asterisk 1.6.2.9 setup includes a CGI auto-dial application (written by someone else before me) which sets up calls by creating files of the general form Channel: SIP/$INSIDE_NUMBER Context: $CONTEXT Extension: $OUTSIDE_NUMBER Priority: 1 CallerId: $INSIDE_NUMBER in /var/spool/asterisk/outgoing/ . It works very well. However, it would be nice to be able to attach an additional

Hello everyone, I can not get the name of the recoding file of agents calls. I set agents.conf as following: ; Enable recording calls addressed to agents. It's turned off by default. recordagentcalls=yes ; ; The format to be used to record the calls (wav, gsm, wav49) ; By default its "wav". ;recordformat=gsm ; ; Insert into CDR userfield a name of the the created recording ; By

Hi everybody, i've been googling for quite some time now but can't find an answer to my problem... I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten => 1234,n,Set(CDR(userfield)=blah) exten => 1234,n,Answer() exten => 1234,n,Queue(.....) exten => 1234,n,Hangup() When I'm doing a call I can see that the statement is