<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18372"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Consolas;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
PRE {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"; COLOR: black; FONT-SIZE: 10pt; mso-style-priority: 99; mso-style-link: "HTML Preformatted Char"
}
SPAN.HTMLPreformattedChar {
FONT-FAMILY: Consolas; COLOR: black; mso-style-priority: 99; mso-style-link: "HTML Preformatted"; mso-style-name: "HTML Preformatted Char"
}
SPAN.EmailStyle19 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US link=blue bgColor=white vLink=purple>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>Check these
links:</FONT></SPAN></DIV>
<DIV><SPAN class=687371922-22072009><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009>
<DIV><SPAN class=687371922-22072009></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009><A
href="http://www.blindhog.net/convert-epoch-time-in-excel/">http://www.blindhog.net/convert-epoch-time-in-excel/</A></SPAN></DIV>
<DIV><SPAN class=687371922-22072009><FONT color=#0000ff><A
href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml#understand">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml#understand</A></FONT></SPAN></DIV>
<DIV><SPAN class=687371922-22072009><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 16px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 13px"
class=Apple-style-span>
<P>you can translate the timestamp with this method:</P>
<OL type=1>
<LI>
<P>Put the timestamp in cell a1.</P></LI>
<LI>
<P>In cell a2, enter<SPAN
class=Apple-converted-space> </SPAN><B>=a1/86400+25569</B>.</P></LI>
<LI>
<P>To apply a new format to this cell, right-click and choose<SPAN
class=Apple-converted-space> </SPAN><B>Format cells > Numbers >
Custom</B>. In the Type field, enter<SPAN
class=Apple-converted-space> </SPAN><B>dd:mmm:yyyy hh:mm</B>.</P>
<P>The output looks like this:</P>
<BLOCKQUOTE
style="COLOR: rgb(0,0,0); FONT-WEIGHT: normal; TEXT-DECORATION: none"><PRE style="FONT-SIZE: 13px">04 Apr 2001, 13:57</PRE></BLOCKQUOTE></LI></OL></SPAN></SPAN></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial> All examples
shown assume that the CDR time stamp is in column A.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>GMT - Greenwich Mean
Time - This is the standard example you see across the
Internet<BR>=(A1/86400)+25569</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>EST - Eastern
Standard Time (GMT - 5:00)<BR>=((A1-18000)/86400)+25569</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>CST - Central
Standard Time (GMT - 6:00)<BR>=((A1-21600)/86400)+25569</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>MST - Mountain
Standard Time (GMT - 7:00)<BR>=((A1-25200)/86400)+25569</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>PST - Pacific
Standard Time (GMT - 8:00)<BR>=((A1-28800)/86400)+25569</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=687371922-22072009><FONT size=2 face=Arial>Now set your column
format to a Date field to your liking.</FONT></SPAN><SPAN
class=687371922-22072009><FONT size=2 face=Arial></FONT></SPAN></DIV>
<DIV><SPAN class=687371922-22072009><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=687371922-22072009><FONT
color=#0000ff></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Voice
Noob<BR><B>Sent:</B> Wednesday, July 22, 2009 6:25 PM<BR><B>To:</B> 'Wes
Sisk'<BR><B>Cc:</B> 'CiscosupportUpuck'<BR><B>Subject:</B> Re: [cisco-voip]
Excel CDR file<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">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?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="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">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: windowtext; FONT-SIZE: 10pt">From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: windowtext; FONT-SIZE: 10pt">
Wes Sisk [mailto:wsisk@cisco.com] <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<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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"><voicenoob@gmail.com></A>
wrote:<BR><BR><o:p></o:p></P>
<P style="MARGIN-BOTTOM: 10pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'">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><o:p></o:p></P><PRE><o:p> </o:p></PRE><PRE style="TEXT-ALIGN: center">
<HR align=center SIZE=4 width="90%">
</PRE><PRE><o:p> </o:p></PRE><PRE>_______________________________________________<o:p></o:p></PRE><PRE>cisco-voip mailing list<o:p></o:p></PRE><PRE><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><o:p></o:p></PRE><PRE><A href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><o:p></o:p></PRE><PRE> <o:p></o:p></PRE>
<P class=MsoNormal><o:p> </o:p></P></DIV></BODY></HTML>