similar to: cdr viewer for csv

I have created an asterisk.org blog entry: http://www.asterisk.org/node/48358 to describe what I will shortly be committing to trunk to correct the weaknesses of CDRs, that asterisk users and developers have been complaining about for quite some time. Highlights: Restructuring the code and philosophy of CDRs. Plans to eliminate the ForkCDR() application Plans to create

My cdrs are missing accountcodes for incoming calls from other asterisk servers.. I've seen a few people mentioning this on the list and the solution seems to be setting up a dialplan for incoming calls from a particular sip peer.. in my opinion this does not scale well at all and I am looking for a solution to correct this problem. example sip peer: [asterisk_gw] type=friend

Hi, I`ve recently upgraded a server from 1.8 to Asterisk 13. While everything is under control, I have one issue with the way CDRs are kept for queues. And I don`t mean ?I don`t like it?. I mean it crashes the server. I realize there are multiple CDRs per queue call ? one per ring/per phone, basically. The issue is that whenever the number of CDRs ?to be recorded? for a call exceeds 5000,

I've taken the liberty of starting a new thread to discuss the design of the Asterisk CDR mechanism. The discussion has been kindly initiated by murf putting together a proposal: http://svn.digium.com/svn/asterisk/team/murf/RFCs. After reading the proposal I still don't think it's the right way to go. To my mind adding more channel variables increases the complexity in a situation

I don't know...now I have a _X. in my CDR. -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Saturday, March 12, 2005 8:05 PM To: Asterisk Developers Mailing List <asterisk-dev@lists.digium.com> Subject: Re: [Asterisk-Dev] SetVarCDR You must have some fux0red config 'cause using _X. works fine here. I haven't had an 's' in my CDRs for

Hello Asterisk Community, Is there a way to check in asterisk cdrs and extension forwarded? I mean, i'm calling to a ISDN number, wich goes to extension 8222, but this extension is forwarded to another one, the problem is that in CDRs i am able to see the the first step of the call, but never see the forwarded extension, how can i do that? Thanks!

Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office. the problem is the management of the CDRs. i can see the master.csv file, but it is not very friendly for the secretary of this office to manage the calls. is there a way to have a nice way to see the CDRs?Since the machine is very small on

Hi all, I'm looking for a reporting solution for Asterisk CDRs. I have a small Asterisk server that will eventually have 4 - 6 trunks. the system is up and the CDRs are being written to a MySQL DB. I tried installing Areski, but had no success .. I assume it's no longer supported... the last update was in March 2005 according to this page..

I can?t see cdrs for calls completed with astcc app, this is the log in asterisk console: DBD::mysql::db do failed: Unknown column 'callstart' in 'field list' at /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 31. -- AGI Script astcc.agi completed, returning 0 cdrs table exist but I am not sure why is empty and why was not created properly, any idea? --

Greetings list, Whilst running through a routine check of some CDRs, I've noticed that the originating channel's accountcode isn't preserved on creating a local channel. For example, if we start with: exten => 123,1,Set(CDR(accountcode)=foo) exten => 123,n,Queue(bar,nrtw,,,) And the queue 'bar' is defined as follows: [bar] member => Local/456 at outbound member

Hi! I just found out that Asterisk (1.4) does not write CDRs if the incoming call was not forwarded but handled internally without answering the call. E.g.: [from_pstn] exten => 997,1,Answer() exten => 997,2,Playback(tt-weasels) exten => 997,3,Hangup() exten => 999,1,Playback(tt-weasels|noanswer) exten => 999,4,Hangup() For incoming calls to 997 a CDR will be written, but not

Hello, When I bridge an incoming and outgoing call (attempting to simulate call-forwarding) I'm only getting one CDR -- that of the outgoing call. A (PSTN) calls B (residing on Asterisk) and the Asterisk calls C (cell phone on PSTN) and bridges the call. The only CDR created is from B to C. I have even tried using Answer() and ForkCDR() to get two CDRs, but to no avail. I am starting to

We have a billing system that depends on the CDRs. We had a guest that made a one minute call to a local cellphone, this call went out Zap channel through our channel bank. The CDR recorded a 200 minute call, but I checked with the Telco's records and it had terminated after one minute. What can cause this and what can I do to prevent it? -- Chris Mason NetConcepts (264) 497-5670 Fax:

I've taken the liberty of starting a new thread to discuss the design of the Asterisk CDR mechanism. The discussion has been kindly initiated by murf putting together a proposal: http://svn.digium.com/svn/asterisk/team/murf/RFCs. After reading the proposal I still don't think it's the right way to go. To my mind adding more channel variables increases the complexity in a situation

When I compare my total minutes on the bill from VoIP Innovations, to the number from our CDRs, I'm finding a smalish (3-4%) discrepancy in the count of minutes. I'm wondering why it's there. Are there different methods of counting the billable start or end point of a phone call? If it matters, I'm counting more termination minutes than they are and they're counting more

Hi everyone, I am facing lots for problem with CDRs in 1.6 and above versions,its shows wrong records when I do transfer(caller side and calee side),callforward,call parking.Is the present CDRs in 1.6 is enough for Complete billing.?What I need to do to make it proper.Please help me on this. Thanks Nikhil

Hello, I'm working on an Asterisk configuration for a call center, and they bill based on the time spent talking to an agent, but not for any time spent waiting in a queue. The CDR information contains the entire duration of the call as billable seconds, including time spent waiting in the queue. I would like the billable seconds to only include the time spent actually talking to an agent.

Hello list, I have been working lately on a small CDR parsing utility, and would like to do some performance testing on it. I am looking for some - possibly large - real-life Asterisk CDR datasets to run some performance monitoring. Anybody's got some CDRs that can be shared? Thanks in advance, l. -- Loway Research - Home of QueueMetrics http://queuemetrics.com

Hello! Most are probably bored seeing another letter about this, but I've put in a fair amount work on a spec for rewriting the CDR system in Asterisk, and I have some questions: First, please look at what I've written so far: svn co http://svn.digium.com/svn/asterisk/team/murf/RFCs and look at the file "CDRfix2.rfc.txt" in the RFCs dir. The spec SIGNIFICANTLY alters the way

Hi, Is there a way to enable the usage of UNIQUEID CDR field using a MySQL database backend for storing CDRs without having to recompile asterisk-addons as stated here http://www.voip-info.org/wiki-Asterisk+cdr+mysql ? After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend) How would it be the syntax in cdr.conf? I tried this without success in