<div dir="ltr">Ah, right. Have a look at this documentation:<div><br></div><div style>You may need to add some mapping</div><div style><br></div><div style>Julian</div><div><div class="" title="cdr_custom" style="color:rgb(0,0,0);font-family:serif;font-size:medium">
<div class=""><h4 class="" style="font-family:sans-serif;font-size:16px">cdr_custom</h4></div><p><a id="Monitoring_id249774" style="color:blue;text-decoration:underline"></a><a id="I_indexterm24_d1e51585" class="" style="color:blue;text-decoration:underline"></a><a id="I_indexterm24_d1e51592" class="" style="color:blue;text-decoration:underline"></a><a id="I_indexterm24_d1e51599" class="" style="color:blue;text-decoration:underline"></a>This CDR backend allows for custom formatting of CDR records in a log file. This module is most commonly used for customized CSV output. The configuration file used for this module is <code class="" style="font-family:serif;font-style:italic">/etc/asterisk/cdr_custom.conf</code>. A single section called <code class="">[mappings]</code> should exist in this file. The <code class="">[mappings]</code> section contains mappings between a filename and the custom template for a CDR. The template is specified using Asterisk dialplan functions.</p>
<p><a id="Monitoring_id249791" style="color:blue;text-decoration:underline"></a>The following example shows a sample configuration for <code class="">cdr_custom</code> that enables a single CDR log file, <code class="" style="font-family:serif;font-style:italic">Master.csv</code>. This file will be created as <code class="" style="font-family:serif;font-style:italic">/var/log/asterisk/cdr-custom/Master.csv</code>. The template that has been defined uses both the <code class="">CDR()</code> and <code class="">CSV_QUOTE()</code> dialplan functions<a id="I_indexterm24_d1e51630" class="" style="color:blue;text-decoration:underline"></a><a id="I_indexterm24_d1e51633" class="" style="color:blue;text-decoration:underline"></a>. The <code class="">CDR()</code> function retrieves values from the CDR being logged. The <code class="">CSV_QUOTE()</code> function ensures that the values are properly escaped for the CSV file <span class="">format</span>:</p>
<a id="Monitoring_id249831" style="color:blue;text-decoration:underline"></a><pre class="" style="font-size:12px;margin-right:0.25in;margin-left:0.25in;padding:0.5em;background-color:rgb(240,240,240);border-color:black;border-style:dotted solid solid dotted;border-width:1px 2px 2px 1px">
[mappings]
Master.csv => ${CSV_QUOTE(${CDR(clid)})},${CSV_QUOTE(${CDR(src)})},
${CSV_QUOTE(${CDR(dst)})},${CSV_QUOTE(${CDR(dcontext)})},
${CSV_QUOTE(${CDR(channel)})},${CSV_QUOTE(${CDR(dstchannel)})},
${CSV_QUOTE(${CDR(lastapp)})},${CSV_QUOTE(${CDR(lastdata)})},
${CSV_QUOTE(${CDR(start)})},${CSV_QUOTE(${CDR(answer)})},
${CSV_QUOTE(${CDR(end)})},${CSV_QUOTE(${CDR(duration)})},
${CSV_QUOTE(${CDR(billsec)})},${CSV_QUOTE(${CDR(disposition)})},
${CSV_QUOTE(${CDR(amaflags)})},${CSV_QUOTE(${CDR(accountcode)})},
${CSV_QUOTE(${CDR(uniqueid)})},${CSV_QUOTE(${CDR(userfield)})}</pre><div class="" title="Note" style="border:1px solid black;margin:0.125in 0.5in;padding:0px 55px;font-size:14px;background-image:url(http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/images/note.png);background-color:rgb(252,246,220);background-repeat:no-repeat no-repeat">
<p><a id="Monitoring_id249823" style="color:blue;text-decoration:underline"></a>In the actual configuration file, the value in the <code class="" style="font-family:serif;font-style:italic">Master.csv</code> mapping should be on a single line.</p>
</div></div><div class="" title="cdr_manager" style="color:rgb(0,0,0);font-family:serif;font-size:medium"><div class=""><h4 class="" style="font-family:sans-serif;font-size:16px"><a id="Monitoring_id249846" style="color:blue;text-decoration:underline"></a>cdr_manager</h4>
</div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 29 March 2013 10:02, Olivier <span dir="ltr"><<a href="mailto:oza_4h07@yahoo.fr" target="_blank">oza_4h07@yahoo.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">2013/3/29 Julian Lyndon-Smith <span dir="ltr"><<a href="mailto:asterisk@dotr.com" target="_blank">asterisk@dotr.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">check out the endbeforehexten option in cdr.conf<div><br></div><div>this needs to set to "yes"</div><div><br></div><div>Julian</div></div></blockquote><div><br><br></div><div>Unfortunately, this doesn't help.<br>
</div><div><br></div><div>Let's drop the hangup handler at the moment, and focus on the "saving to file" part.<br></div><div>Then my issue is I can't update CDR value is hangup exten.<br></div><div><br>
</div>
<div>Here is a dialplan that illustrate this:<br><br>[from-foobar]<br>exten => _X.,1,Verbose(0,Entering context ${CONTEXT} from channel ${CHANNEL(channeltype)} ${CHANNEL} with EXTEN and CID set to ${EXTEN} and ${CALLERID(num)})<br>
same => n, Set(CDR(userfield)=foo)<br> same => n, Dial(SIP/foobar/${EXTEN})<br> same => n, Set(CDR(userfield)=bar)<br> same => n, Hangup()<br><br>exten => h,1,Verbose(0,Entering context ${CONTEXT} from ${CHANNEL(channeltype)} channel ${CHANNEL} with EXTEN and CID set to ${EXTEN} and ${CALLERID(num)})<br>
same => n, ExecIf($["x${CHANNEL(channeltype)}"="xLocal"]?Set(CDR(userfield)=baz1:baz2)<br><br></div><div>My goal is to get either baz1 or baz2 value in /var/log/asterisk/cdr-csv/Master.csv.<br><br>
</div><div>Typing channel originate Local/7005@from-foobar application Playback tt-monkeys, I can see that the line with ExecIf is run but CDR still contains foo value (the one set before Dial).<br></div><div>The strange thing is :<br>
1. a CDR is written at the moment extension 7005 answers,<br></div><div>2. no other CDR is added when 7005 hangs up (so can't tell how long extension 7005 listened to monkeys fellows).<br></div><div>(Setting endbeforehexten to either yes or no has no effect on this behaviour.<br>
<br><br></div><div>My question are:<br></div><div>1. Is it simply possible to update CDR in hangup exten ?<br></div><div>2. How can I have a CDR for the application Playback part (see above) ?<br></div><div>3. Any tip or suggestion ?<br>
<br></div><div>Cheers<br></div></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"><div><br></div>-- <br>Julian Lyndon-Smith<br>
IT Director, Dot R Limited<br><br>"I don’t care if it works on your machine! We are not shipping your machine!”<br><br>The kangaroo dances: <a href="http://www.youtube.com/watch?v=MAWl5iYOaUg" target="_blank">http://www.youtube.com/watch?v=MAWl5iYOaUg</a>
</div>