<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tilghman Lesher wrote:
<blockquote
cite="mid:200903091505.46854.tilghman@mail.jeffandtilghman.com"
type="cite">
<pre wrap="">On Monday 09 March 2009 01:28:49 pm Anthony Francis wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Tilghman Lesher wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Friday 06 March 2009 11:24:46 pm Hooman Peiro wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap="">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..
</pre>
</blockquote>
<pre wrap=""><!---->
Which is how cdr_adaptive_odbc already works. ;-)
</pre>
</blockquote>
Yeah I haven't moved to 1.6 yet :(.<br>
</body>
</html>