[asterisk-users] Reporting for Asterisk Call Center

[bilal ghayyad]

Dear;

Are the below are used any more in asterisk 1.8 version, and for what we use them:

;dial trunk
exten => _X.,1,Dial(SIP/trunk/${EXTEN})

;exten h must be in same context!
exten => h,1,noop("extended CDR")
exten => h,n,set(CDR(hangupcause)=${HANGUPCAUSE}) ; hangupcause
exten => h,n,set(CDR(peerip)=${CHANNEL(peerip)}) ; like 10.0.0.5 if behind nat
exten => h,n,set(CDR(recvip)=${CHANNEL(recvip)}) ; like 194.79.52.192 - public ip
exten => h,n,set(CDR(from)=${CHANNEL(from)}) ; like sip:1111 at sip.proxy.cz
exten => h,n,set(CDR(uri)=${CHANNEL(uri)}) ; like sip:1111 at 10.0.0.5
exten => h,n,set(CDR(useragent)=${CHANNEL(useragent)}) ; useragent like Aastra_57i
exten => h,n,set(CDR(codec1)=${CHANNEL(audioreadformat)}) ; codec *
exten => h,n,set(CDR(codec2)=${CHANNEL(audiowriteformat)}) ;
exten => h,n,set(CDR(llp)=${CHANNEL(rtpqos,audio,local_lostpackets)}) ; lost packets by local end **
exten => h,n,set(CDR(rlp)=${CHANNEL(rtpqos,audio,remote_lostpackets)}) ; lost packets by remote end
exten => h,n,set(CDR(ljitt)=${CHANNEL(rtpqos,audio,local_jitter)}) ; the same for jitter
exten => h,n,set(CDR(rjitt)=${CHANNEL(rtpqos,audio,remote_jitter)})


Regards
Bilal
-------------
> > Hi All;
> > 
> > Anyone advise for a free (open source) reporting to be
> used for asterisk
> > call center?
> > 
> > Regards
> > Bilal
> 
> Problem is, reporting is such a nebulous thing, about the
> only thing that will 
> give you the required level of "generality of purpose" is a
> programming 
> language.  So you might find it simplest just to roll
> your own.
> 
> Assuming you have set up CDR using some kind of database
> backend, then all you 
> really need to do is devise a set of queries which will
> provide the 
> information you want to present in your reports; then write
> a script in your 
> favourite language to make a CSV file  (which will
> load into any modern 
> spreadsheet program)  and e-mail it to whoever needs
> it.  Lastly, put an entry 
> in your crontab to run the report whenever required.
> 
> Note that OpenOffice.org calc will treat an entry in a CSV
> starting with an = 
> sign as a formula, so you can insert things such as
> 
> "${name}",${ext},${answd},${busy},${unobtain},=C${row}+D${row}+E${row}
> 
> and then column F in each row will contain the total of
> columns C, D and E in 
> that row  (assuming you are properly updating $row as
> you go along .....)  My 
> own preference is to use the spreadsheet program to
> evaluate formulae rather 
> than hard-code the answer into the spreadsheet.  That
> way, if you edit a cell, 
> you will not throw everything else out.
> 
> 
> I know from past experience that Microsoft Excel will
> happily accept CSV files 
> with an XLS extension  (N.B. it might need \r\n for
> line endings);  however, I 
> am unable to test whether or not it will accept formulae as
> above, as I do not 
> have access to a machine with Windows and Excel.
> 
> 
> -- 
> AJS
>