Master.csv com.x import not right fields imported from tng

[alex]

hi,

I have a com.x2 and the data imported from the master.csv file to the tng is not correct.

I have extensions with pincodes and extensions without pin codes. attached are the cdr file of the com.x aswell as the tng.

can I set the fields of the tng accordingly to the com.x cdr so that data are correctly imported?

thnx

Alex


TNG log:
100903|1899/12/30 19:20:24|9090001|Please Add||Not Set|27796992050||ADDITIONAL VODACOM C - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100904|1899/12/30 19:20:25|9090001|Please Add||Not Set|27727742107||ADDITIONAL VODACOM C - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100905|1899/12/30 19:20:26|9090001|Please Add||Not Set|27829466511||GSM VODACOM EXPANSIO - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100906|1899/12/30 19:20:27|9090001|Please Add||Not Set|27824147608||GSM VODACOM EXPANSIO - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100907|1899/12/30 19:20:28|100|Pretoriuis||Kronendal|27126611297||PRETORIA - (ZA)|I|00:00:00|+27126611297 <+2712661129|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100908|1899/12/30 19:20:29|100|Pretoriuis||Kronendal|27832506202||GSM MTN - (ZA)|I|00:00:00|+27832506202 <+2783250620|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100909|1899/12/30 19:20:30|9090001|Please Add||Not Set|27726264101||ADDITIONAL VODACOM C - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100910|1899/12/30 19:20:31|9090001|Please Add||Not Set|27824621339||GSM VODACOM EXPANSIO - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100911|1899/12/30 19:20:32|9090001|Please Add||Not Set|27726264101||ADDITIONAL VODACOM C - (ZA)|O|00:00:00|DAHDI/1|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100912|1899/12/30 19:20:33|192168102|Please Add||Not Set|OUTGOING|||O|00:00:00|SIP/192.168.10.2|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100913|1899/12/30 19:20:34|192168102|Please Add||Not Set|OUTGOING|||O|00:00:00|SIP/192.168.10.2|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100914|1899/12/30 19:20:35|101|Reception||Kronendal|27824147608||GSM VODACOM EXPANSIO - (ZA)|O|00:00:00|SIP/101|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Cellular|012|0||
100915|1899/12/30 19:20:36|101|Reception||Kronendal|271026||TIME - (ZA)|O|00:00:00|SIP/101|O_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Local|012|0||
100916|1899/12/30 19:20:37|100|Pretoriuis||Kronendal|27124600029||PRETORIA - (ZA)|I|00:00:00|+27124600029 <+2712460002|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100917|1899/12/30 19:20:38|251|Nel 702||Kronendal|27129090152|||I|00:00:00|PABX5/a3|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100918|1899/12/30 19:20:39|251|Nel 702||Kronendal|27129090151|||I|00:00:00|PABX5/a3|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100919|1899/12/30 19:20:40|251|Nel 702||Kronendal|27129090151|||I|00:00:00|PABX5/a3|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100920|1899/12/30 19:20:41|101|Reception||Kronendal|320||Sekuriteit|O|00:00:00|VOIP-INT|O_UNANSWER|0|N|0||0||0|Kronendal|Please Add||do_not_cost|Other|012|0||
100921|1899/12/30 19:20:42|317|Versorgingseenheid||Kronendal|27129090210|||I|00:00:00|309 <9090210>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100922|1899/12/30 19:20:43|317|Versorgingseenheid||Kronendal|27129090210|||I|00:00:00|309 <9090210>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100923|1899/12/30 19:20:44|316|Versorgingseenheid||Kronendal|27129090210|||I|00:00:00|309 <9090210>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100924|1899/12/30 19:20:45|317|Versorgingseenheid||Kronendal|27129090210|||I|00:00:00|309 <9090210>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100925|1899/12/30 19:20:46|317|Versorgingseenheid||Kronendal|27129090210|||I|00:00:00|309 <9090210>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100926|1899/12/30 19:20:47|301|Oosthuizen 10PR||Kronendal|27129090210|||I|00:00:00|PABX7/a3|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||
100927|1899/12/30 19:20:48|285|Kriel 9V||Kronendal|27129090204|||I|00:00:00|303 <9090204>|I_UNANSWER|0|N|0||0||0||Please Add||za_telkom|Other|012|0||

Com.x2 cdr:

"","9090001","0796992050","from-internal","9090001","DAHDI/1-1","SIP/Voip-00000007","Dial","SIP/Voip/0796992050,300,TwWb","2013-04-16 12:44:25","2013-04-16 12:44:48","2013-04-16 12:45:38",73,50,"ANSWERED","DOCUMENTATION","1366116265.17",""
"","9090001","0727742107","from-internal","9090001","DAHDI/1-1","SIP/Voip-00000008","Dial","SIP/Voip/0727742107,300,TwWb","2013-04-16 12:46:38","2013-04-16 12:47:01","2013-04-16 12:47:41",63,40,"ANSWERED","DOCUMENTATION","1366116398.19",""
"","9090001","0829466511","from-internal","9090001","DAHDI/1-1","SIP/Voip-00000009","Dial","SIP/Voip/0829466511,300,TwWb","2013-04-16 12:49:04","2013-04-16 12:49:45","2013-04-16 12:50:00",56,15,"ANSWERED","DOCUMENTATION","1366116544.22",""
"","9090001","0824147608","from-internal","9090001","DAHDI/1-1","SIP/Voip-0000000a","Dial","SIP/Voip/0824147608,300,TwWb","2013-04-16 12:50:08","2013-04-16 12:50:29","2013-04-16 12:51:08",60,39,"ANSWERED","DOCUMENTATION","1366116608.24",""
"","+27126611297","100","from-did-direct","""+27126611297"" <+27126611297>","SIP/Voip-0000000b","DAHDI/1-1","Hangup","","2013-04-16 14:58:44","2013-04-16 14:59:00","2013-04-16 14:59:02",18,2,"ANSWERED","DOCUMENTATION","1366124324.26",""
"","+27832506202","100","from-did-direct","""+27832506202"" <+27832506202>","SIP/Voip-0000000c","DAHDI/1-1","Hangup","","2013-04-17 06:10:07","2013-04-17 06:10:23","2013-04-17 06:10:26",19,3,"ANSWERED","DOCUMENTATION","1366179007.28",""
"","9090001","0726264101","from-internal","9090001","DAHDI/1-1","SIP/Voip-0000000d","Dial","SIP/Voip/0726264101,300,TwWb","2013-04-17 07:42:03","2013-04-17 07:42:23","2013-04-17 07:43:15",72,52,"ANSWERED","DOCUMENTATION","1366184523.30",""
"","9090001","0824621339","from-internal","9090001","DAHDI/1-1","SIP/Voip-0000000e","Dial","SIP/Voip/0824621339,300,TwWb","2013-04-17 07:55:08","2013-04-17 07:55:28","2013-04-17 07:56:19",71,51,"ANSWERED","DOCUMENTATION","1366185308.32",""
"","9090001","0726264101","from-internal","9090001","DAHDI/1-1","SIP/Voip-00000000","Dial","SIP/Voip/0726264101,300,TwWb","2013-04-17 08:23:21","2013-04-17 08:23:41","2013-04-17 08:24:02",41,21,"ANSWERED","DOCUMENTATION","1366187001.0",""
"","192168102","s","from-sip-external","""192.168.10.2"" <192168102>","SIP/192.168.10.2-00000001","","Playback","ss-noservice","2013-04-17 08:33:16","2013-04-17 08:33:16","2013-04-17 08:33:23",7,7,"ANSWERED","DOCUMENTATION","1366187596.2",""
"","192168102","s","from-sip-external","""192.168.10.2"" <192168102>","SIP/192.168.10.2-00000002","","Playback","ss-noservice","2013-04-17 08:35:30","2013-04-17 08:35:30","2013-04-17 08:35:35",5,5,"ANSWERED","DOCUMENTATION","1366187730.3",""
"1015","101","0824147608","flexpath-post-pins","101","SIP/101-00000003","SIP/Voip-00000004","Dial","SIP/Voip/0824147608,300,TwWb","2013-04-17 08:37:07","2013-04-17 08:37:19","2013-04-17 08:37:21",14,2,"ANSWERED","DOCUMENTATION","1366187823.4",""
"1015","101","1026","flexpath-post-pins","101","SIP/101-00000005","SIP/Voip-00000006","Dial","SIP/Voip/1026,300,TwWb","2013-04-17 08:37:30","2013-04-17 08:37:31","2013-04-17 08:37:34",4,3,"ANSWERED","DOCUMENTATION","1366187846.6",""
"","+27124600029","100","from-did-direct","""+27124600029"" <+27124600029>","SIP/Voip-00000007","DAHDI/1-1","Hangup","","2013-04-17 08:42:28","2013-04-17 08:42:44","2013-04-17 08:42:46",18,2,"ANSWE

PS: the first field is for acount codes, but not all extension have account codes to dial out. most dial out without account codes.

[Belinda Frick]

Please also post the 'tng.ini' file.

On Asterisk installs you will usually find it in the folder:

Code: Select all

/opt/datatex/tng

[alex]

sorry about that.

tng.ini


[SERIALCOMM]
PabxSerialEnabled=1
TermChar=10
ComPort=ASTERISK
PabxBaud=9600
Bits=8
Parity=N
Stop=0
SoftFlow=0
HardFlow=0

[NETWORK]
TCPEnabled=0
PABXIP=127.0.0.1
PABXPort=12345
PABXAuthenticationInformation=

[PLUGIN]
localnumber=0129XXXXXX
localcode=012
countrycode=27
internationalaccesscode=00
pluginName=new installation
pluginPath=./plugins/
defaultratebook=za_telkom
swoppinaccount=0
lograwdata=0
autoupdatenames=1
Branch Code=012

[DATA]
Interval=60
loc=2data_1.1.0.7
Memory=25
Version=1.1.0.7
lcs=Check:[C1D0DDFCC76175188856EAA0024C2CD3]
Import Extensions=0
Import Users=0
Import Phonebook=0

[OPTIONAL]
abring=18
abduration=240
abcost=10
localshort=10
longdistanceshort=10
internationalshort=10
cellularshort=10
othershort=10
EX1=18FB05BA05FA261D0B0DE20DAD90CB0E
EXCHANGEVERSION=2009.08.01.01
tcpclientport=20003
GMT Offset=2
tp=iKoXTXcbJFw=
ap=mK4ARAN+XF8=
globalphonebook=1
lre=41401.6810540972
fid=zv9FFlorEHXN+VQUQiEVbPzPdCV3GyRY
ReportArchiveRoot=/opt/datatex/tng/reportarchive/
restrictphonebook=0
syncdefaultrange=Yesterday
maxcallduration=0
maxdurationaction=none
tcpbarringport=20009

[SMTP]
server=127.0.0.1
port=25
user=
password=
reply=you@youremailaddress.co.za

[SUPPORT]
Support Company=callsave
Support Tel=01529XXXXX
Support Fax=
Support email=louis@callsave.co.za
Dealer Code=
Installer=alex
Installer Cell=079XXXXXXX

[COMPANY]
Company Name=kronendal
Company Tel=01294XXXXX
Company Fax=
Company email=louis@callsave.co.za
VAT Factor=1.14
Product Serial=XXXX-XXXX-XXXX-XXXX-XXXX
VAT No=
Currency String=R

[LICENSE]
Serial Number=XXXXX-XXXXX-XXXXX-XXXXX

[DTXT]

[WEBSERVER]
defaultport=7080

[ASTERISK]
Host=192.168.10.200
Port=5038
Login=tng
Password=iKETFEUoJF4=
Use CDR File=1
CDR File Location=/var/log/asterisk/cdr-csv/Master.csv
Strip Breakout Digit=0

[alex]

hi,

any news as yet??

how to resolve this issue?