<div dir="ltr">Hi All&#39;<div><br></div><div>can i set multiple sql template in cdr_csv_conf.xml???  </div><div><br></div><div>like this:</div><div><br></div><div>&lt;configuration name=&quot;cdr_csv.conf&quot; description=&quot;CDR CSV Format&quot;&gt;</div><div>  &lt;settings&gt;</div><div>    &lt;!-- &#39;cdr-csv&#39; will always be appended to log-base --&gt;</div><div>    &lt;!--&lt;param name=&quot;log-base&quot; value=&quot;/var/log&quot;/&gt;--&gt;</div><div>    &lt;!--&lt;param name=&quot;default-template&quot; value=&quot;example&quot;/&gt;--&gt;</div><div>    &lt;param name = &quot;default-template&quot; value = &quot;sql&quot; /&gt;</div><div>    &lt;!-- This is like the info app but after the call is hung up --&gt;</div><div>    &lt;!--&lt;param name=&quot;debug&quot; value=&quot;true&quot;/&gt;--&gt;</div><div>    &lt;param name=&quot;rotate-on-hup&quot; value=&quot;true&quot;/&gt;</div><div>    &lt;!-- may be a b or ab --&gt;</div><div>    &lt;param name=&quot;legs&quot; value=&quot;a&quot;/&gt;</div><div>        &lt;!-- Only log in Master.csv --&gt;</div><div>        &lt;!-- &lt;param name=&quot;master-file-only&quot; value=&quot;true&quot;/&gt; --&gt;</div><div>  &lt;/settings&gt;</div><div>  &lt;templates&gt;</div><div>  &lt;template name=&quot;sql&quot;&gt;INSERT INTO cdr VALUES (&quot;${caller_id_name}&quot;,&quot;${caller_id_number}&quot;,&quot;${destination_number}&quot;,&quot;${context}&quot;,&quot;${start_stamp}&quot;,&quot;${answer_stamp}&quot;,&quot;${end_stamp}&quot;,&quot;${duration}&quot;,&quot;${billsec}&quot;,&quot;${hangup_cause}&quot;,&quot;${uuid}&quot;,&quot;${bleg_uuid}&quot;, &quot;${accountcode}&quot;);&lt;/template&gt;</div><div><br></div><div>   &lt;template name=&quot;sql&quot;&gt;INSERT INTO csv VALUES (&#39;${client_id}&#39;, &#39;${user_id}&#39;,&#39;${destination_number}&#39;,&#39;${caller_id_number}&#39;, &#39;${start_stamp}&#39;,&#39;${end_stamp}&#39;,&#39;${answer_stamp}&#39;,&#39;${duration}&#39;,&#39;${ivr_duration}&#39;,&#39;${transfer_duration}&#39;, &#39;${first_dtmf}&#39;, &#39;${vmrecuri}&#39;, &#39;${callrecording_file}&#39;, &#39;${action}&#39;, &#39;${agent}&#39;, &#39;${project_id}&#39;, &#39;${level}&#39;, &#39;${ruleid}&#39;, &#39;${sticky_flag}&#39;, &#39;NORMAL&#39;&lt;/template&gt;</div><div>  &lt;/configuration&gt;  </div><div> <br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Warm regards<div>Chandra Adhikari</div><div>+91 8377939169</div></div></div></div>
</div></div>