You have to use adaptive cdr for this functionality. In 1.8 the conf file for adaptive cdr is cdr_adaptive_odbc.conf. The sample conf file should tell you everything.<br><br>If you are using some other cdr engine then you will have to jump into the code of asterisk to make it log the item you want, which includes creating an extra variable in the cdr data struction, creating a function to set/get its value from dialplan, and then changing the sql command to include the extra variable for insertion into DB.<br>
<br><div class="gmail_quote">On Thu, Mar 24, 2011 at 1:55 PM, Jonas Kellens <span dir="ltr"><<a href="mailto:jonas.kellens@telenet.be">jonas.kellens@telenet.be</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
is there anyone who can point me to correct information ?<br>
<br>
Following </font><font face="Helvetica, Arial, sans-serif"><a href="http://pbxinaflash.com/forum/showthread.php?t=9042" target="_blank">http://pbxinaflash.com/forum/showthread.php?t=9042</a>
and <a href="http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql" target="_blank">http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql</a> >
Extending CDR does not result in a working environment for me.<br>
<br>
Any feedback appreciated.<br>
<br>
<br>
<br>
Kind regards,<br>
Jonas.</font><br>
<font face="Helvetica, Arial, sans-serif"><br>
<br>
</font><br>
-------- Original Message --------
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th align="right" nowrap valign="baseline">Subject: </th>
<td>[asterisk-users] Asterisk 1.6.2.10 & CDR custom added
field</td>
</tr>
<tr>
<th align="right" nowrap valign="baseline">Date: </th>
<td>Tue, 22 Mar 2011 14:05:23 +0100</td>
</tr>
<tr>
<th align="right" nowrap valign="baseline">From: </th>
<td>Jonas Kellens <a href="mailto:jonas.kellens@telenet.be" target="_blank"><jonas.kellens@telenet.be></a></td>
</tr>
<tr>
<th align="right" nowrap valign="baseline">Reply-To: </th>
<td>Asterisk Users Mailing List - Non-Commercial Discussion
<a href="mailto:asterisk-users@lists.digium.com" target="_blank"><asterisk-users@lists.digium.com></a></td>
</tr>
<tr>
<th align="right" nowrap valign="baseline">To: </th>
<td>Asterisk Users Mailing List - Non-Commercial Discussion
<a href="mailto:asterisk-users@lists.digium.com" target="_blank"><asterisk-users@lists.digium.com></a></td>
</tr>
</tbody>
</table><div><div></div><div class="h5">
<br>
<br>
<font face="Helvetica, Arial, sans-serif">Hello list,<br>
<br>
I have added an extra field "mycolumn" to the cdr table in my MySQL-DB.<br>
<br>
I simply try to add a value to this column by doing the following in
the dialplan :<br>
<br>
exten => 600,n,Set(CDR(mycolumn)="myvalue")<br>
<br>
<br>
But this value is not written to the column 'mycolumn' together with
the other CDR-data.<br>
<br>
Why is this ?! Do I need further configuration ? (Not according to
<a href="http://pbxinaflash.com/forum/showthread.php?t=9042" target="_blank">http://pbxinaflash.com/forum/showthread.php?t=9042</a>)<br>
<br>
<br>
Kind regards,<br>
Jonas.<br>
</font>
<br>
</div></div></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><font color="#888888"><div>
Best Ragards</div><div>Rizwan Qureshi</div><div>VoIP/Asterisk Engineer</div><div>Axvoice Inc.<br><br></div>
<div>V: +92 (0) 3333 6767 26</div><div>E: <a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a></div><div>W: <a href="http://www.axvoice.com/" target="_blank">www.axvoice.com</a></div></font><br>