[asterisk-users] Cdr problem

[Tilghman Lesher]

On Tuesday 10 March 2009 03:11:57 Anthony Francis wrote:
> Tilghman Lesher wrote:
> > On Monday 09 March 2009 01:28:49 pm Anthony Francis wrote:
> >> Tilghman Lesher wrote:
> >>> On Friday 06 March 2009 11:24:46 pm Hooman Peiro wrote:
> >>>> hi,
> >>>> I'm working with asterisk on a project and I found a problem with
> >>>> cdr_odbc. As we know, after answering each call a cdr event is raised
> >>>> which is saved in cdr_csv and cdr_odbc. but here my point is on
> >>>> cdr_odbc. some information, including start_time and end_time is given
> >>>> by cdr event but the problem is that these two information(start_time
> >>>> and end_time) is not getting save in cdr_odbc. I checked the source
> >>>> code and I found that by default it's not doing so. I need to query
> >>>> these two information, start time and end time, from cdr_odbc and I
> >>>> need your help.
> >>>> thanks
> >>>
> >>> You are partially incorrect.  The start time is indeed stored in the
> >>> CDR, although the column name is 'calldate'.  As for the end time, it
> >>> can be derived by adding 'duration' (which is in whole seconds) to the
> >>> 'calldate' column.
> >>>
> >>> Another solution that allows for retrieving both columns with their
> >>> native names (or completely different names, whatever you map it to) is
> >>> to use cdr_adaptive_odbc in 1.6.0 and higher.
> >>
> >> I have often thought, wouldn't it be better if the cdr config files
> >> allowed you to specify column names i.e.
> >> calldate => callstart_datetime
> >>
> >> Or whatever, the basic format being asteriskfieldname => db columnname.
> >>
> >> Just an idea..
> >
> > Which is how cdr_adaptive_odbc already works.  ;-)
>
> Yeah I haven't moved to 1.6 yet :(.

You could always use the backport.
http://svncommunity.digium.com/view/tilghman/branches/1.4/

-- 
Tilghman