[asterisk-users] Cdr problem

[Hooman Peiro]

thanks for your responses, I checked again and I found that I asked a wrong
question! I was supposed to ask about answer time. The answer time is not
getting save in the database.

On Tue, Mar 10, 2009 at 11:41 AM, Anthony Francis <anthonyf at rockynet.com>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 :(.
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090310/8f98c4b2/attachment.htm