YSJ3010 Posted October 25, 2011 Report Share Posted October 25, 2011 Hi I have a lot of customers that want the ACD(Cue) midnight REPORT IN A .CVS format please post what i need to change in the email_queue.htm that the email should display everything that it's displaying now + attached cvs "Tab Delimited " From To Time Account IVR Ringing Talking ( Hold Time ) XXX-XXX-XXXX XXX-XXX-XXXX 23:37 102 0:04 0:02 0:16 1:55 XXX-XXX-XXXX XXX-XXX-XXXX 23:34 102 0:04 0:03 0:17 2:05 XXX-XXX-XXXX XXX-XXX-XXXX 23:24 102 0:04 0:02 0:17 XXX-XXX-XXXX XXX-XXX-XXXX 23:20 102 0:04 0:03 0:21 XXX-XXX-XXXX XXX-XXX-XXXX 23:19 102 0:04 0:02 0:39 XXX-XXX-XXXX XXX-XXX-XXXX 23:18 0:03 XXX-XXX-XXXX XXX-XXX-XXXX 23:18 0:03 XXX-XXX-XXXX XXX-XXX-XXXX 23:16 102 0:04 0:07 0:17 5:04 Please advise Thanks Quote Link to comment Share on other sites More sharing options...
Vodia PBX Posted October 25, 2011 Report Share Posted October 25, 2011 You mean right now you are receiving the list in HTML format and you want it in CSV instead (comma sepersated values)? Right now it is pretty much hard coded in HTML; you can copy & paste it into Excel and then save it a CSV. No tsur eif you can automate that step easily. The alternative could be to save the CDR in CSV on the system level and then filter out those messages which are for the ACD. Quote Link to comment Share on other sites More sharing options...
YSJ3010 Posted October 25, 2011 Author Report Share Posted October 25, 2011 Thank You for the quick reply , on pbxnsip tire isn't a way to filter calls so i wanted to do it in excel when i copy and past some rows are not right and i cant filter it How hard is it for you to add the scripted ( please help us ) Thank you in advanced You mean right now you are receiving the list in HTML format and you want it in CSV instead (comma sepersated values)? Right now it is pretty much hard coded in HTML; you can copy & paste it into Excel and then save it a CSV. No tsur eif you can automate that step easily. The alternative could be to save the CDR in CSV on the system level and then filter out those messages which are for the ACD. Quote Link to comment Share on other sites More sharing options...
gotvoip Posted October 25, 2011 Report Share Posted October 25, 2011 If you want some really good ACD information i.e. commercial grade check out call scout. http://www.vertical.com.co/vertical/EN/callScout.html Quote Link to comment Share on other sites More sharing options...
Vodia PBX Posted October 26, 2011 Report Share Posted October 26, 2011 How hard is it for you to add the scripted ( please help us ) In Linux you would use something like "awk '{if($4="123")print $0}' < cdr.csv" and you would be all set already... Quote Link to comment Share on other sites More sharing options...
YSJ3010 Posted October 26, 2011 Author Report Share Posted October 26, 2011 Any way on windows ? Quote Link to comment Share on other sites More sharing options...
Vodia PBX Posted October 26, 2011 Report Share Posted October 26, 2011 I believe findstr is the command you need to use. Maybe someone can help out with the exact way how to use it. Quote Link to comment Share on other sites More sharing options...
YSJ3010 Posted October 31, 2011 Author Report Share Posted October 31, 2011 Hi when I setup the pbx to save the cdr as csv (file:disk) this is what it saves in the cdr only the fist line is in comma delimited How can I setup that all the info should save in comma delimited format , Thank You enduser2.pbxnipconfig.com,3ecbfe6144832dcd303f3c7c41ecb41f@25.25.25.25,3ecbfe6144832dcd303f3c7c41ecb41f@25.25.25.25,WIRELESS CALLER (718-809-5555),212-444-1111,I,trunk,20111031093853,20111031093853,20111031093914,RR_Global_SIPGW_O_01,,+17188095555,,,udp:24.24.24.24:5060,VQSessionReport: CallTerm LocalMetrics: Timestamps:START=2011-10-31T13:38:52Z STOP=2011-10-31T13:39:14Z CallID:3ecbfe6144832dcd303f3c7c41ecb41f@25.25.25.25 FromID:"WIRELESS CALLER" <sip:7188095778@25.25.25.25>;tag=as46dc37d8 ToID:<sip:12124441111@nycinpro01.siptest.net>;tag=e822d4ba40 SessionDesc:PT=0 PD=pcmu SR=8000 FD=20 FO=160 FPP=1 PPS=50 PLC=3 LocalAddr:IP=24.24.24.24 PORT=17606 SSRC=0x0ff8f7a9 RemoteAddr:IP=25.25.25.25 PORT=18302 SSRC=0x14334146 x-UserAgent:pbxnip/4.2.1.4025 x-SIPterm:SDC=OK SDR=AN PacketLoss:NLR=0.0 JDR=0.0 BurstGapLoss:BLD=0.0 BD=0 GLD=0.0 GD=0 GMIN=16 Delay:RTD=0 ESD=0 IAJ=3 QualityEst:MOSLQ=4.1 MOSCQ=4.0 ,,2292 Quote Link to comment Share on other sites More sharing options...
pbx support Posted October 31, 2011 Report Share Posted October 31, 2011 Actually, "VQSessionReport" is 1 parameter (all the way up to comma before 2292). If you don't care about the VQSessionReport, then you can disable that field altogether being written into the file. To do that, there is "cdr_call_quality_report" hidden global setting on the PBX. You can set the value of this to false using method described in http://wiki.snomone.com/index.php?title=Global_Configuration_File: or manually editing the pbx.xml file. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.