Plugin version: 2011.08.22.1 or newer
The latest plugin:
History:
- 2012-03-28: Added check for the "." at the start of the date and time, when the Cisco fails to connect to the NTP server. The date were being interpreted incorrectly.
How to update a Plugin
Example of output format:
Cisco Call Manager 8.X
- Code: Select all
"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_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","huntPilotPartition","huntPilotDN","calledPartyPatternUsage"
INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(50),VARCHAR(128),INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(64),VARCHAR(64),INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(50),VARCHAR(50),VARCHAR(128),INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(64),VARCHAR(64),INTEGER,INTEGER,VARCHAR(50),UNIQUEIDENTIFIER,VARCHAR(50),VARCHAR(50),VARCHAR(50),VARCHAR(50),INTEGER,VARCHAR(129),VARCHAR(129),INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(50),INTEGER,VARCHAR(2048),VARCHAR(50),INTEGER,VARCHAR(32),INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(32),VARCHAR(50),VARCHAR(50),VARCHAR(64),VARCHAR(64),INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,VARCHAR(32),INTEGER,VARCHAR(32),INTEGER,INTEGER,INTEGER,VARCHAR(50),VARCHAR(50),INTEGER
1,1,4291,26796422,1307254728,1,26796422,50987274,"27112637807","",0,16,4,50987274,17270,11,20,0,0,0,0,0,0,"0","0",26796426,1,0,134457536,"7986","7986","",0,0,4,134457536,19968,11,60,0,0,0,0,0,0,"0","0",1307254740,1307254743,"7986","f43ba112-2d15-439a-9377-7d94f4aacf20","Internal","","VMPilotNumberPT","Internal",3,"MPLS_Trunk","CiscoUM-VI49",12,0,5,5,2,2,0,"OASIS-CPT-CUCM",5,"","",0,"",0,3,0,0,8,8,"","","","10.1.10.3","192.168.3.8",0,0,0,0,0,0,0,0,0,0,0,0,1,"78BC57B18E7211E0B51B975E39CA30DB",3,"00000000000010C30198E18700000000",0,0,0,"","7888",7
Callmanager Express Compact Format
- Code: Select all
"Unix_time","Call-ID","CDR-Type","leg-type","h323-conf-id","peer address","peer-sub-address","h323-setup-time","alert-time","h323-connect-time","h323-disconnect-time","h323-disconnect-cause","disconnect-text","h323-call-origin","charged-units","info-type","paks-out","bytes-out","paks-in","bytesin","Username","clid (Calling Number)","dnis(Called Number)","Voice Feature","Feature-op-time"
1311070875,151774,1,1,"7CF6CC19 B12711E0 B44DBD60 6E0F6C5","8488","","12:19:57.949 SAST Tue Jul 19 2011","","12:20:12.389 SAST Tue Jul 19 2011","12:21:15.969 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","answer",0,"speech",0,0,3725,596000,"8488","8488","","TWC","07/19/2011 12:19:57.954","8488","",0,204143,7CF6CC19 B12711E0 B44DBD60 6E0F6C5,250DE,"","","",""
1311070875,151775,1,1,"7CF6CC19 B12711E0 B44DBD60 6E0F6C5","0113705129","","12:20:00.195 SAST Tue Jul 19 2011","12:20:01.365 SAST Tue Jul 19 2011","12:20:12.385 SAST Tue Jul 19 2011","12:21:15.985 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","originate",0,"speech",3725,625800,3729,596640,"8488","8488","0113705129","TWC","07/19/2011 12:20:00.166","8488","0113705129",0,204144,7CF6CC19 B12711E0 B44DBD60 6E0F6C5,250DF,"","","",""
1311070876,151778,1,1,"AB8D914B B12711E0 B457BD60 6E0F6C5","8819","","12:21:16.107 SAST Tue Jul 19 2011","","12:21:16.777 SAST Tue Jul 19 2011","12:21:16.777 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","answer",0,"speech",0,0,0,0,"8819","8819","","TWC","07/19/2011 12:21:16.113","8819","",0,204147,AB8D914B B12711E0 B457BD60 6E0F6C5,250E2,"","","",""
1311070876,151777,1,1,"A89BCA1E B12711E0 BD6CC89C 1DAE3F80","8485","","12:21:11.175 SAST Tue Jul 19 2011","12:21:11.175 SAST Tue Jul 19 2011","12:21:16.825 SAST Tue Jul 19 2011","12:21:16.825 SAST Tue Jul 19 2011","13 ","no user answer (19)","originate",0,"speech",0,0,0,0,"0711723553","0711723553","8485","CFNA","07/19/2011 12:21:16.825",0,204148,A89BCA1E B12711E0 BD6CC89C 1DAE3F80,250E0,3,1,"8485","0711723553","8819","8485"
1311070876,151777,1,1,"A89BCA1E B12711E0 BD6CC89C 1DAE3F80","8485","","12:21:11.175 SAST Tue Jul 19 2011","12:21:11.175 SAST Tue Jul 19 2011","12:21:16.825 SAST Tue Jul 19 2011","12:21:16.825 SAST Tue Jul 19 2011","13 ","no user answer (19)","originate",0,"speech",0,0,0,0,"0711723553","0711723553","8485","TWC","07/19/2011 12:21:11.177","0711723553","8485",0,204146,A89BCA1E B12711E0 BD6CC89C 1DAE3F80,250E1,"","","",""
1311070882,151756,1,1,"2426D011 B12711E0 B41DBD60 6E0F6C5","8421","","12:17:28.953 SAST Tue Jul 19 2011","","12:17:59.713 SAST Tue Jul 19 2011","12:21:22.373 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","answer",0,"speech",0,0,10127,1620320,"8421","8421","","TWC","07/19/2011 12:17:28.947","8421","",0,204125,2426D011 B12711E0 B41DBD60 6E0F6C5,250CC,"","","",""
1311070882,151757,1,1,"2426D011 B12711E0 B41DBD60 6E0F6C5","0825236357","","12:17:36.149 SAST Tue Jul 19 2011","12:17:42.139 SAST Tue Jul 19 2011","12:17:59.699 SAST Tue Jul 19 2011","12:21:22.449 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","originate",0,"speech",10127,1701336,10132,1621120,"8421","8421","0825236357","TWC","07/19/2011 12:17:36.111","8421","0825236357",0,204126,2426D011 B12711E0 B41DBD60 6E0F6C5,250CD,"","","",""
1311070883,151719,1,1,"C70F4250 B12611E0 B3D6BD60 6E0F6C5","8414","","12:14:52.759 SAST Tue Jul 19 2011","","12:15:01.669 SAST Tue Jul 19 2011","12:21:23.929 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","answer",0,"speech",0,0,19247,3079520,"8414","8414","","TWC","07/19/2011 12:14:52.765","8414","",0,204091,C70F4250 B12611E0 B3D6BD60 6E0F6C5,250A7,"","","",""
1311070884,151725,1,1,"C70F4250 B12611E0 B3D6BD60 6E0F6C5","0114486405","","12:14:58.645 SAST Tue Jul 19 2011","12:14:58.875 SAST Tue Jul 19 2011","12:15:01.665 SAST Tue Jul 19 2011","12:21:23.995 SAST Tue Jul 19 2011","10 ","normal call clearing (16)","originate",0,"speech",19247,3233496,19251,3080160,"8414","8414","0114486405","TWC","07/19/2011 12:14:58.617","8414","0114486405",0,204097,C70F4250 B12611E0 B3D6BD60 6E0F6C5,250AD,"","","",""
NOTE: This solution will only work with TNG and not TOPAZ. TNG works with encrypted data.
Using the plugin:
- Install the 'FileSplitter' program.
To accommodate the long string of the CISCO CDR file, we need to use the 'FileSplitter' program.
Install steps:
Extract the file FileSplitter .exe.
The service will install but not be running.
Go to the C:\Program Files\Datatex\FileSplitter directory
Open the ini and look at the files create the directories that are there ini e.g.- Code: Select all
LOGPATH=C:\Program Files\Datatex\FileSplitter\logs\
INPATH=C:\Program Files\Datatex\FileSplitter\ciscoin\
OUTPATH=C:\Program Files\Datatex\FileSplitter\ciscoout\
WORKPATH=C:\Program Files\Datatex\FileSplitter\ciscowork\
Once the ini file is created start the service up in services:
START -> CONTROL PANEL -> ADMINISTRATIVE TOOLS -> SERVICES,
it’s name will be FileSplitter.
Copy the cdr_*.* files into input path(Field in ini is INPATH).
The output will go to the folder ciscoout(Field in ini is OUTPATH).
Now configure TNG to read the files in via the file reader option and point the file path to the field configured as OUTPATH. To see the rawdata file name check in the location configured as OUTPATH.
- PCisco_Call_Manager_8_ftp_beta.txt
You need to create a txt file with the same name as the plugin and the extension "txt" that contains the trunks of the system. This is used by the extended format. - PCisco_Call_Manager_8_ftp_beta.ext
There also needs to ba a file with the same name as the plugin and the extension "ext" that contains a extension mask.
E.g.
if your extensions are in the range 8100 to 8400, you can use the following:- Code: Select all
81xx
82xx
83xx
84xx
use the "x" as a wilde card / place holder - TNG: The files needs to be in the same folder as the plugins
C:\Program Files\datatex\tng\plugins
Anything else: The files needs to be in the folder of the application that is using the Plugin.