asterisk users - Mar 2009 - Cdr problem

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20090307/fbba23d5/attachment.htm

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.

-- 
Tilghman