<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hello Will, thank you for getting back to me. Yes, I have added the fields but how do I populate those fields which are not a part of the default cdrs table? Where do I make the modification in the kamailio config file to update the cdrs table? Again, thanks for the help.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span>Regards,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style:
normal;"><span>Arun</span></div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Will Ferrer <will.ferrer@switchsoft.com><br> <b><span style="font-weight: bold;">To:</span></b> arun Jayaprakash <jayaprakasharun@yahoo.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 26, 2013 5:06 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [SR-Users] adding new column in the CDRS table?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv2207409861"><div><div dir="ltr">Hi Arun<div><br clear="none"></div><div>We have added several columns to our cdr table simple by
connecting to the database through mysql workbench and adding them, and then modifying the mysql routine: kamailio_cdrs to populate in the required data to the new fields. We are however also using siremis which is where these cdr generation routines come from -- <a rel="nofollow" shape="rect" target="_blank" href="http://siremis.asipto.com/">http://siremis.asipto.com/</a></div>
<div><br clear="none"></div><div>Some info on cdr generation for the acc module can be found here:</div><div><a rel="nofollow" shape="rect" target="_blank" href="http://kamailio.org/docs/modules/3.3.x/modules_k/acc.html#idp89024">http://kamailio.org/docs/modules/3.3.x/modules_k/acc.html#idp89024</a><br clear="none">
</div><div><br clear="none"></div><div>I hope that helps.</div><div><br clear="none"></div><div>All the best.</div><div><br clear="none"></div><div>Will Ferrer</div><div><br clear="none"></div><div><br clear="none"></div></div><div class="yiv2207409861gmail_extra"><br clear="none"><br clear="none"><div class="yiv2207409861gmail_quote">On Tue, Nov 26, 2013 at 9:29 AM, arun Jayaprakash <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:jayaprakasharun@yahoo.com" target="_blank" href="mailto:jayaprakasharun@yahoo.com">jayaprakasharun@yahoo.com</a>></span> wrote:<br clear="none">
<blockquote class="yiv2207409861gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="yiv2207409861yqt0912108570" id="yiv2207409861yqt04487"><div><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif;"><div>Hello, can someone let me know how I can add a new field in the cdrs table? I would like to set a flag depending if a call is make to another extension number of if the call is made to a PSTN line. Thank you for the help.</div>
<span class="yiv2207409861HOEnZb"><font color="#888888"></font></span><div><br clear="none"></div><div style="font-style: normal; font-size: 16px; background-color: transparent; font-family: 'times new roman', 'new york', times, serif;">Arun</div></div>
</div></div><br clear="none">_______________________________________________<br clear="none">
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none">
<br clear="none"></blockquote></div><br clear="none"></div></div></div><br><br></div> </div> </div> </div></body></html>