similar to: Mysql 6 second rounding

Is there anyway to get CDR to show just the answered calls. Not by exporting to a spreadsheet and editing. We have ring groups and queues and CDR shows everything as calls received. Even if it's multiple extensions ringing it shows them as multiple calls received. This seems kind of goofy.

Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l.

Hi, I'm stuck on a silly thing. I need to get the "billsec" CDR value after a call. But I'm finding its always 0. Here's my test code: exten => *244*,1,Dial(Local/test@custom-tests/n,,g) exten => *244*,n,Noop(after dial duration is ${CDR(duration)} billsec is ${CDR(billsec)}) exten => *244*,n,Hangup [custom-tests] exten => test,1,Answer exten =>

Hello, I want to create php rate script and I'm using Deadagi. But I allways get billsec 0 , or nothing. Can you help me to solve this problem... My extension.conf: exten => _123,1,DeadAgi(rate.php) exten => _123,2,hangup And my simple test php script rate.php #!/usr/local/bin/php -q <?php include_once (dirname(__FILE__)."/phpagi.php"); $AGI = new AGI();

How is the billsec field calculated in CDRs? I have a situation where billsec is being reported as 0 despite the call being answered and a conversation occurring. An example record follows: '2007-11-06 21:36:50', '6495566778', '6495566778', '0116495566778', '1100012_1', 'Local/0116495566778 at 1100012_1-887b,2',

Can someone tell me what I am doing wrong? Why doesn't CDR(duration) or CDR(billsec) return the correct values? cdr.conf endbeforehexten=yes extensions.conf [macro-Dial] ; ${ARG1} - Dial String exten => s,1,Dial(${ARG1},,M(post-dial)) exten => h,1,NoOp(Call was hung up - ${CDR(duration)} seconds long, billed for ${CDR(billsec)} seconds) The log shows: -- Executing [h

Hi people, when I try to get the billsec in the dialplan, it is 0... but if after that I check the database, it is right (not 0). I'm trying to get it in the h extension, like: exten => h,1,Noop(End) exten => h,n,Noop(Time is ${CDR(billsec)}) .... Is it updated after the extension h is executed? In that case, how can I get the call duration in the h extension? Thanks, Anahi

Can someone help me, im using latest CVS, asterisk and cdr_mysql, when I make a bridge call (using .call files in outgoing/) I always get 'billsec=12' in the cdr, both mysql and Master file even if the call lasted longer, watching the Master file while making a call I see it updated at 12 seconds even while im still 'in' the DIAL app and the call continues on just fine. Iv looked

Hello, I am wondering if someone has got any ideas that can help solve this problem. I have a dial plan that you call into, and depending on certain conditions it calls out on a number grabbed from a database. Something like this : exten => s,n,Do something exten => s,n,Do something else exten => s,n,Dial(ZAP/g1/${OUTBOUND},${timeout}) I need to log the time the person

I was just going through my call records ( stored in mysql database by cdr_MYSQL module ) and saw a record having duration = 0 and billsec of more than 50 seconds . I did a query on cdr where duration < billsec and saw that there were infact some 250 records with duration less than billsecond ( table had around 4,00,000 records) . Did anyone came across this ? I also checked csv files and they

Hi I'm using asterisk 1.8.23.1 but I've seen this same issue in previous versions of 1.8. I have created some work arounds but the behaviour is incorrect. This is the scenario: Call comes in and goes to appropriate dialplan In the dialplan the call is forwarded to another number using a Local channel (and using /n ) e.g. Dial(Local/<my-number>@outbound-context/n,60) The number is

Hi, I've got a dialplan that transfers all outgoing calls to a Local channel before dialling out via SIP. I did this because sometimes i'm dialling two numbers at the same time and need to know which call is answered for billing purposes. However, I've just noticed that billsec is always equal to 0 even though i know the calls were answered. I now have to take the cdrs from my

So... I'm trying to access CDR(duration) and CDR(billsec) inside h... I keep getting 0. Can I access the CDR function inside a hangup extensions? Asterisk 1.4.13 Thanks, Doug. ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

Hi All, I have been running a environment with asterisk 1.4.20.1 for some time now with no issue but have recently added some extra functionality (enabled call recording via MixMonitor) and ran into some deadlock issues which seem to be well documented with earlier 1.4.x releases so have decided to take the plunge and upgrade. I decided to start testing with 1.6.2 but have run into a couple

hi, all asterisk 1.4.24 , zaptel 1.4.10.1 , E1 Manager API Action : Action: Originate Channel: ZAP/G1/8888888 Callerid: 12345678 Context: callout Exten: s Priority: 1 extensions.conf [callout] exten => s,1,Answer() exten => s,n,Wait(10) exten => s,n,Hangup() when the phone 8888888 pick up , it will come to callout context, after hangup, one cdr generate, but the

Hi, My costumers are logged in on my Asterisk PBX through XLite Softphone (SIP). My server is connected to PSTN. Problem is when SIP phone calls ordinary phone via dahdi I get DAHDI/1-1 ANSWERED SIP/number-number and billsec field from cdr is start counting. Is it normal behavior ? Can I change that ? So channel gets in ANSWERED state and billsec starts as soon as line starts to ring even if no

Hi, I have few questions on the specification. * Just to understand : - What is the interest of super blocks ? Is it to save place when recording coded block flags (7.3) ? - What is the advantage of using the coded order ? it is more often easier with raster order (especially to find neighbor in 7.8.1 for exemple). Is it to simplify the correspondence between block, macro block

Hello, I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built from source. Everything is working nicely except one small issue. The CDR records are stored in the CSV file correctly and complete. The MySQL storage is working as it should and is automatically updating all the fields except the CLID field. I have

Hello! i'm trying to set up transfer without using the respective asterisk-function but with the built-in phone functions. my goal is to have the first callleg billed to the caller and the second callleg to the callee, who is responsible for the forward(and i can't bill a unknown caller anyways) so far it's working without problems, but my cdr's are messed. with the help of the

Hello Asterisk-Users, For some reason my CDR records for disposition and billsec are not working correctly. I always receive a 0 for billsec and the disposition is always at "NO ANSWER', even when I grab the calls. I experience this with Asterisk 1.6.0.1 and Asterisk 1.4.22. Here is information on how I do the call: -----------------------------------------------------------------