search for: userfield

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 extract for what is insi...

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 => s,n,Set(RECORDFILE=/var/spool/asterisk/autorecord/${STR...

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

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 created in mysql has a blan...

...stion 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 exten => h,1,NoOp(${CDR(userfield)}) exten => h,n,Set(CDR(userfield)=changed) exten => h,n,NoOp(${CDR(userfield)}) In the same context I execute: exten => 10,1,Set(CDR(userfield)=empty) exten => 10,n,Dial(SIP/10) The "h" extension outputs two lines with userfield set to "empty". I would expect the...

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 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 [in] exten => s,1,Set(CDR(userfield)=23XXXXX6) same=> n,Goto(in2) [in2] exten => s,1,GotoIfTime(08:00-17:00|mon-...

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 attachment was scr...

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 a...

...al 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 piece of information along with the call record There is a userfield in the SQL database, which is a VARCHAR(255) and would be plenty for what we need. Is there a way to set the userfield of the CDR database from within such a callfile? -- AJS

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...

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 executed. But when the call finishes, a cdr is written into the DB with an empty 'userfield'. I'm sure, I'm missing something bu...

...tunately, it is not modifiable from the "h" extension, because the cdr_object is already in the finalized table. Is there a way how to modify the CDR without hacking the code? How bad idea is it to comment the (it_cdr->fn_table == &finalized_state_fn_table) tests in ast_cdr_setuserfield and ast_cdr_setvar and thus allow the "h" extension write to a finalized CDR? Is there any chance the feature was left out by an accident and if so, is there a plan to add it again? My extensions.conf: exten => h,1,NoOp(${CDR(userfield)}) exten => h,n,Set(CDR(userfield)=changed...

...UMBER > > 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 piece of information along with the call record There is a > > userfield in the SQL database, which is a VARCHAR(255) and would be > > plenty for what we need. Is there a way to set the userfield of the CDR > > database from within such a callfile? > > Yes, adding a Set field in your call file (see > http://www.voip-info.org/wiki/view/Asterisk+auto...

...g 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 perfect. Cheers 2015-08-10 15:05 GMT+02:00 Matthew Jordan <mjordan at digium.com>: > > On Tue, Aug 4, 2015 at 9:16 AM, Filip Jenicek <fjenicek at kerio.com> wrote: > >> With endbeforehexten=no I actually get two CDR entries. One for the call >> and a s...

...end of each call. I am using asterisk version 1.4.26. For CDR purposes, I am using cdr_custom, and the content of my cdr_custom.conf is the following: [mappings] Master.csv => ${CDR(dstchannel)},${CDR(clid)},${CDR(cid-num)},${CDR(dst)},${CDR(start)},${CDR(billsec)},${CDR(disposition)},${CDR(userfield)} In my dialplan, right before my Hangup() call, I have put the following (am using AEL, but I guess this is irrelevant) Set(JITTER=${CUT(RTPAUDIOQOS,\;,4)}); Set(CDR(userfield)=${CUT(JITTER,\=,2)}); I make an outgoing call with asterisk debugging mode on. When I hangup the call, I see the f...

-----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(use...

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

I'm tearing (what's left of) my hair out on this one :-( <shortform> How can I set the CDR(userfield) in the calling thread from the dialplan (actually a macro called from a feature) in the called thread? <long version> I use mixmonitor to record calls driven by entries in the asterisk database for selected phones. As part of this dialplan, I set the CDR(userfield) to the mixmonitor filen...

Paul, Thanks - it worked! For the record, this is exactly what I did: cd/usr/src/asterisk/cdr grep -in "userfield" cdr_csv.c (to find the line that had "#define CSV_LOGUSERFIELD 1" commented out) Opened cdr_csv.c and removed the /* and */ comment marks Saved & exited After shutting down * I went to /usr/src/asterisk and did the usual: Make clean Make Make install I also added this line in t...