PABX3 Plugin: 3COM NBX version 5

[Belinda Frick]

Requirements:

PABX software version:
'Version 5'.
The plugin is for Version 5. The Version 6 is by default in XTML
format. However it can be set to use the 'old' route and give
you the same "billing.txt" file.

Output file format is 'billing.txt'.
It keeps 30 days of information, each time you 'get' the file it
downloads the entire 30 days. Keep in mind the space that it will
require.
Please see: How do I receive data from the NBX 3COM?
SMDR data is not 'live' data. Not recommended for recording solutions,
see: Line recording, on private lines (No PABX) No SMDRdata for last 10 recordings

Plugin: 'PNBX_3COM_V5_HTTP.dll', version '2006.7.17.2' or newer.

SMDR data for NBX 3COM Version 5:

1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890

Sample of output data:

"2006/07/17","1410","1410","-1","0","1","7028","Jose Martins","","386992","","6112","Trunk","","11:16:39","132","0219302517","1","","Local ","","47161","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","Terminal","PRI Channel","Martins"
"2006/07/17","1411","1408","1408","0","2","6132","Trunk","","","","7005","P Peron","","11:18:32","35","0216585204","0","4001","Incoming ","","47035","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Terminal",""
"2006/07/17","1412","1412","-1","0","2","6105","Trunk","","","","4001","Caller ","","11:19:35","0","0215345616","0","4001","Incoming ","","46847","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Hunt Group",""
"2006/07/17","1413","1399","1404","0","2","6104","Trunk","","","","7056","Gary Ward","","11:18:01","117","0214019300","1","4000","Incoming ","","46848","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Terminal",""
"2006/07/17","1414","1414","-1","0","1","7055","Van Heilen","","071032","","6167","Cell Router","","11:18:23","98","0835994196","1","","Wireless ","","47169","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","ATA","TLIM","Van Hailen"
"2006/07/17","1415","1415","-1","0","1","7053","Jan Spies","","081421","","6109","Trunk","","11:20:04","13","4190000","1","","Local ","","47175","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","Terminal","PRI Channel","Jan Spies"
"2006/07/17","1416","1412","1412","0","2","6105","Trunk","","","","7005","P Peron","","11:19:35","43","0215345616","0","4001","Incoming ","","46847","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Terminal",""
"2006/07/17","1417","1417","-1","0","2","6133","Trunk","","","","4001","Caller ","","11:20:19","0","0214166104","0","4001","Incoming ","","47029","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Hunt Group",""
"2006/07/17","1418","1417","1417","0","2","6133","Trunk","","","","7005","P Peron","","11:20:19","20","0214166104","1","4001","Incoming ","","47029","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Terminal",""
"2006/07/17","1419","1419","-1","0","2","6106","Trunk","","","","4001","Caller ","","11:21:22","0","0393128200","0","4001","Incoming ","","46834","00:00:00","00:00:00","00:00:00","0","","","0","00:00:00","00:00:00","00:00:00","","","","","","0","","","0","PRI Channel","Hunt Group",""

NBX CDR CSV file field names and sequence:

0 DATE_FIELD
1 CALL_NUM_FIELD
2 ROOT_CALL_NUM_FIELD
3 PARENT_CALL_NUM_FIELD
4 RECORD_TYPE_FIELD
5 CALL_TYPE_FIELD
( CDR App interpret this data as 0 - INT i.e internal call,
1- OUT i.e outgoing call and 2 - IN i.e incoming call )6 ORIG_ID_FIELD
7 ORIG_NAME_FIELD
8 ORIG_DEPT_FIELD
9 ACCOUNT_CODE_FIELD
10 AUTH_CODE_FIELD
11 DEST_ID_FIELD
12 DEST_NAME_FIELD
13 DEST_DEPT_FIELD
14 START_TIME_FIELD
15 DURATION_FIELD
16 CALL_DATA_FIELD
17 COMPLETE_FIELD ( 0 - No and 1 - Yes )
18 HUNT_GROUP_FIELD
19 NOTES_FIELD
20 ROUTE_POINT_EXTENSION
21 GLOBALCALLID
22 MONITORTIME
23 WHISPERTIME
24 BARGEDINTIME
25 MALICIOUS
26 EMERGENCYATTENDANTNUMBER
27 INVOKINGEXTENSION
28 INVOCATIONDURATION
29 ENTRYTIME
30 EXITTIME
31 TERMTIME
32 DNIS
33 ACDNAME
34 ACDEXT
35 ENTRYCODE
36 EXITCODE
37 CALLINACDEXTCOUNT
38 TRANSFEREXT
39 AGENTNAME
40 TALKTIME
41 ORIGINATINGDEVICETYPE
42 TERMINNATINGDEVICETYPE
43 ACCOUNTNAME

Call actions used in this plugin:
Incoming calls:
atIncomingNormal
atIncomingInternal
atIncomingTransfered
atIncomingUnanswered
atIncomingInternalUnanswered
Outgoing calls:
atOutgoingNormal
atOutgoingTransfered
atOutgoingUnanswered