[asterisk-users] Cdr problem

[Anthony Francis]

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