{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","CDR Dump","Conversion","Troubleshooting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["                                                                   http://www.uccollabing.com |||| http://in.linkedin.com/in/avinashkarnani11/"]
[]
["Handy CDR Reporting - How to use?"]
["Step 1 - Download the CDR Dump from Cisco Unified Communication Manager\nStep 2 - Open the CDR Dump in Excel with Comma Delimited. Follow the steps on the link shared below\n                https://uccisco.wordpress.com/2014/05/16/cisco-cdr-call-detail-record-reporting/\nStep 3 - Before you open CDR-Reporting file, ensure that Macro is enabled\nStep 4- Copy the Dump in CDR Dump Tab in this Excel Sheet\n"]
["Want to convert Few Values only - How to use?"]
["Step 1 - Go to \"Conversion\" sheet\nStep 2 -Click on \"Copy Columns from CDR Dump\" button on \"Conversion\" sheet. This will copy data from CDR Dump Sheet to Conversion Sheet. Or Else you can copy and paste only the required column from your CDR Dump which you would like to convert. For example - If you would like to convert \"dateTimeOrigination\" to a readable format like \"DD/MM/YY HH:SS\", you may copy only that column from your CDR Dump to Column G and click on the button dateTimeOrigination to get the actual readable value in Column H\nStep 3 - Click on \"origIpAddr\" button to get the correct values in Column B\nStep 4 - Click on \"destIpAddr\" button to get the correct valuesin Column D\nStep 5 -  Click on \"Orig/Dest Cause Code\" button to get the correct values in the respective columns E and F.\nStep 6 - Click on \"dateTimeOrigination\" button to get the correct values in Column H.\nStep 7 - Click on \"Orig/Dest CallTerminationOnBehalfOf\" button to get the correct values in Column I and J.\nStep 8 - Click on \"Orig/Last RedirectReason\" button to get the correct values in K and L."]
[]
["Want to find Specific Number either by Calling Party Number or Called Party Number for Troubleshooting - How to Use?"]
["Step 1 - Click on \"Click to Find Specific Number\" Button on the current sheet i.e., \"Instructions\" sheet in Column C\nStep 2 - Enter the Calling Party Number or Called Party Number and Click on OK\nStep 3 - Click on Troubleshooting tab to find out the results"]
[]
["Want to Convert Values from CDR Dump for Troubleshooting- How to Use?"]
["Step 1 - Click on \"Convert All CDR Dump\" Button on the current sheet i.e., \"Instructions\" sheet in Column C\nStep 2 - Click on Troubleshooting tab to find out the results"]

{"sheet":"CDR Dump","index":1,"n_rows":1,"n_cols":112,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["cdrRecordType","globalCallID_callManagerId","globalCallID_callId","origLegCallIdentifier","dateTimeOrigination","origNodeId","origSpan","origIpAddr","callingPartyNumber","callingPartyUnicodeLoginUserID","origCause_location","origCause_value","origPrecedenceLevel","origMediaTransportAddress_IP","origMediaTransportAddress_Port","origMediaCap_payloadCapability","origMediaCap_maxFramesPerPacket","origMediaCap_g723BitRate","origVideoCap_Codec","origVideoCap_Bandwidth","origVideoCap_Resolution","origVideoTransportAddress_IP","origVideoTransportAddress_Port","origRSVPAudioStat","origRSVPVideoStat","destLegIdentifier","destNodeId","destSpan","destIpAddr","originalCalledPartyNumber","finalCalledPartyNumber","finalCalledPartyUnicodeLoginUserID","destCause_location","destCause_value","destPrecedenceLevel","destMediaTransportAddress_IP","destMediaTransportAddress_Port","destMediaCap_payloadCapability","destMediaCap_maxFramesPerPacket","destMediaCap_g723BitRate","destVideoCap_Codec","destVideoCap_Bandwidth","destVideoCap_Resolution","destVideoTransportAddress_IP","destVideoTransportAddress_Port","destRSVPAudioStat","destRSVPVideoStat","dateTimeConnect","dateTimeDisconnect","lastRedirectDn","pkid","originalCalledPartyNumberPartition","callingPartyNumberPartition","finalCalledPartyNumberPartition","lastRedirectDnPartition","duration","origDeviceName","destDeviceName","origCallTerminationOnBehalfOf","destCallTerminationOnBehalfOf","origCalledPartyRedirectOnBehalfOf","lastRedirectRedirectOnBehalfOf","origCalledPartyRedirectReason","lastRedirectRedirectReason","destConversationId","globalCallId_ClusterID","joinOnBehalfOf","comment","authCodeDescription","authorizationLevel","clientMatterCode","origDTMFMethod","destDTMFMethod","callSecuredStatus","origConversationId","origMediaCap_Bandwidth","destMediaCap_Bandwidth","authorizationCodeValue","outpulsedCallingPartyNumber","outpulsedCalledPartyNumber","origIpv4v6Addr","destIpv4v6Addr","origVideoCap_Codec_Channel2","origVideoCap_Bandwidth_Channel2","origVideoCap_Resolution_Channel2","origVideoTransportAddress_IP_Channel2","origVideoTransportAddress_Port_Channel2","origVideoChannel_Role_Channel2","destVideoCap_Codec_Channel2","destVideoCap_Bandwidth_Channel2","destVideoCap_Resolution_Channel2","destVideoTransportAddress_IP_Channel2","destVideoTransportAddress_Port_Channel2","destVideoChannel_Role_Channel2","incomingProtocolID","incomingProtocolCallRef","outgoingProtocolID","outgoingProtocolCallRef","currentRoutingReason","origRoutingReason","lastRedirectingRoutingReason","huntPilotDN","huntPilotPartition","calledPartyPatternUsage","outpulsedOriginalCalledPartyNumber","outpulsedLastRedirectingNumber","wasCallQueued","totalWaitTimeInQueue","callingPartyNumber_uri","originalCalledPartyNumber_uri","finalCalledPartyNumber_uri","lastRedirectDn_uri"]

{"sheet":"Conversion","index":2,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["origIpAddr","Converted IP Address","destIpAddr","Converted IP Address","Orig Cause Code","Dest Cause Code","dateTimeOrigination","Converted Time in GMT","origCallTerminationOnBehalfOf","destCallTerminationOnBehalfOf","origCalledPartyRedirectReason","lastRedirectRedirectReason",null,"DO NOT MODIFY THIS COLUMN"]
["994118154",null,1175063050,null,16,0,1435231789,null,12,0,354]
[1175063050,null,"994118154",null,0,16,1436194350,null,0,12,null,8]

{"sheet":"Troubleshooting","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}