Jump to content

CVS on Que email


YSJ3010

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

Link to comment
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.

Link to comment
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.

Link to comment
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

Link to comment
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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...