I have used Pivot tables in Excel for this very purpose on the raw cdr exports. Just search for cdr pivot tables in google and you will see some good examples, or you could search in the dreaded excel help files.<br><br>Shawn<br>
<br><div class="gmail_quote">On Wed, Jul 22, 2009 at 8:24 AM, Voice Noob <span dir="ltr"><<a href="mailto:voicenoob@gmail.com">voicenoob@gmail.com</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 bgcolor="white" link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">If someone already has an excel spreadsheet that has some macros
to search for specific fields and convert the time stamps correctly. Does CDR
still export in EPOCH time?</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt; color: windowtext;">From:</span></b><span style="font-size: 10pt; color: windowtext;"> Wes Sisk [mailto:<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>] <br>
<b>Sent:</b> Wednesday, July 22, 2009 9:10 AM<br>
<b>To:</b> Voice Noob<br>
<b>Cc:</b> CiscosupportUpuck<br>
<b>Subject:</b> Re: [cisco-voip] Excel CDR file</span></p>
</div>
</div><div><div></div><div class="h5">
<p> </p>
<p>CAR has an export features that dumps to CSV format. that
imports directly into excel. can you clarify what else you may desire?<br>
<br>
On Tuesday, July 21, 2009 10:26:49 PM , Voice Noob <a href="mailto:voicenoob@gmail.com" target="_blank"><voicenoob@gmail.com></a> wrote:<br>
<br>
</p>
<p style="margin-bottom: 10pt;"><span>Does
anyone have an excel spreadsheet that they can share to use with dumping the
CDR files form CUCM 6.x and above? I will dump all of the records for a 7 day
period into a single file and then want to display that in excel in a somewhat
readable format. Thanks. </span></p>
<pre> </pre><pre style="text-align: center;"><hr align="center" size="4" width="90%">
</pre><pre> </pre><pre>_______________________________________________</pre><pre>cisco-voip mailing list</pre><pre><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></pre><pre><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></pre>
<pre> </pre>
<p> </p>
</div></div></div>
</div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br>