<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>In case someone finds this later on with similar issues, I'll tell the rest of the story.</div><div><br></div><div>Setting the skipNormalize field to 1 or true in each data source did stop the normalization. This stopped the problem of fields changing when I didn't want them too. But, it also caused CDRTool to not display everything the same way as a normalized call.</div><div><br></div><div>For example, failed calls (486, 503, etc) displayed as "in progress". I have other processes that add Rating info and Prices, and they weren't displayed anymore. Neither was the KBIn or KBOut of a call tha went through a Mediaproxy relay. Hmm.</div><div><br></div><div>I solved the issue by normalizing the calls in the stored procedures. This really isn't the same "bringing them into a normal format" the normalizing procedure normally does, but rather only setting the flag to 1 once the call was complete. I updated the insert_radacct_record procedure to set Normalized='1', unless SipResponseCode=200, in which case we'll set the field with the update_radacct_record. I modified the update_radacct_record procedure to set Normalized='1' instead of the '0' it already had.</div><div><br></div><div>So, problem solved. Of course maintaining these updates will require re-modifying the procedures each time the a new version of CDRTool requires updating the procedures in MySQL. Definitely worth it, though. CDRTool is still a fantastic utility when used only as a display front-end for the database.</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> Jeff Pyle <<a href="mailto:jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a>><br><span style="font-weight:bold">Reply-To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Date: </span> Tue, 8 Mar 2011 12:28:27 -0500<br><span style="font-weight:bold">To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Subject: </span> Re: [OpenSIPS-Users] CDRTool - disable or minimize normalization<br></div><div><br></div><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Yep, that did it. Excellent.</div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> Adrian Georgescu <<a href="mailto:ag@ag-projects.com">ag@ag-projects.com</a>><br><span style="font-weight:bold">Reply-To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Date: </span> Tue, 8 Mar 2011 03:40:57 -0500<br><span style="font-weight:bold">To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Subject: </span> Re: [OpenSIPS-Users] CDRTool - disable or minimize normalization<br></div><div><br></div><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Actually I found it, there is an undocumented variable skipNormalize:<div><br></div><div>Set skipNormalize to 1 or true in your data source to disable the normalization process.</div><div><br><div>Adrian</div><div><br></div><div><div><div>On Mar 8, 2011, at 3:32 AM, Jeff Pyle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Adrian,</div><div><br></div><div>I did as you said but it is still normalizing the data. The top of cdr_generic.php now looks like this:</div><div><br></div><div><div>class CDRS {</div><div><br></div><div> var $CDR_class = 'CDR';</div><div> var $intAccessCode = '00';</div><div> var $natAccessCode = '0';</div><div> var $maxrowsperpage = 15;</div><div> var $status = array();</div><div>// var $normalizedField = 'Normalized';</div><div> var $DestinationIdField = 'DestinationId';</div><div> var $BillingIdField = 'UserName';</div></div><div><br></div><div>And there is no mention of normalizedField in /etc/cdrtool/global.inc.</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> Adrian Georgescu <<a href="mailto:ag@ag-projects.com">ag@ag-projects.com</a>><br><span style="font-weight:bold">Reply-To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Date: </span> Wed, 2 Mar 2011 03:52:24 -0500<br><span style="font-weight:bold">To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Subject: </span> Re: [OpenSIPS-Users] CDRTool - disable or minimize normalization<br></div><div><br></div><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">You may comment out any definition of $normalizedField variable in cdr_generic.php and global.inc, without it the normalization process will not save anything in the database.<div><div><br></div><div>Adrian</div><div><br></div><div>On Mar 1, 2011, at 11:25 PM, Jeff Pyle wrote:</div><div><div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Hello,</div><div><br></div><div>Is there a simple way to disable normalization in CDRTool? We use it only to view the CDRs, not do any billing or rating. And the Normalization process is doing some strange things to some of the fields.</div><div><br></div><div>Or perhaps, if it must run, to minimize the impact it has?</div><div><br></div><div>Specifically, it is mangling international numbers, then reporting "No destination for number xxxxxxxx". It changes some other fields that don't necessarily need to be changed, but less harmful.</div><div><br></div><div>I've played with the E164 field in global.inc for the data source but it doesn't seem to have any effect.</div><div><br></div><div><br></div><div>- Jeff</div></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></div></span></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></div></span></div></div></span></body></html>