Jump to content
Vodia PBX forum
YSJ3010

CVS on Que email

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 smile.gif )

 

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.

Share this post


Link to post
Share on other sites

How hard is it for you to add the scripted ( please help us smile.gif )

 

 

In Linux you would use something like "awk '{if($4="123")print $0}' < cdr.csv" and you would be all set already...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×