thr3ads.net - asterisk users - [asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2) [Sep 2008]

If this information is useful, please help other people find it:
Share via:

Hiren Mistry

2008-Sep-09 10:50 UTC

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

Dear All,

             I have configured here Asterisk-stat (Call Detail Records) 
for CDR ANALYSER. Here I am facing problem in web analyser when I 
Selection of the day as I require it can get data from asterisk postgres 
database. But in bottom side I have not seen graphical chart and I also 
can't make export file.


  CDR (Call Detail Records)

umber of calls : 21534

* - Call Logs - * 	Back to Top


	
* Calldate   
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=calldate&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* Channel *

	
* Source *

	
* Clid *

	
* Lastapp *

	
* Lastdata *

	
* Dst 
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=dst&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* APP *

	
* Disposition *

	
* Duration 
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=duration&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* Userfield *

	
* Accountcode *

1.  	2008-09-01 23:59 	Zap/84-... 	992 	992 	BackGround 
ivr_menu/mainmenu/PRESS_03 	s 	
	ANSWERED 	00:35 	Ij 	
2.  	2008-09-01 23:59 	Zap/83-... 	975 	975 	WaitExten 	10 	s 	
	ANSWERED 	00:19 	IP 	
3.  	2008-09-01 23:59 	Zap/82-... 	971 	971 	BackGround 
ivr_menu/mainmenu/guj_promp 	s 	
	ANSWERED 	00:34 	IGj 	
4.  	2008-09-01 23:59 	Zap/81-... 	7965 	7965 	Dial 	ZAP/R2/501|60 	s 	
	ANSWERED 	06:12 	ATA 	
5.  	2008-09-01 23:58 	Zap/80-... 	972 	972 	WaitExten 	10 	s 	
	ANSWERED 	00:20 	Ij 	



*I have not seen below graphical chart and I also can't make export file.*
* *----------------------------------------------------------* 
*----------------------------------------------------------* 
*----------------------------------------------------------* 
*----------------------------------------------------------
*TOTAL*
                                                                         
        * **ASTERISK MINUTES*
Date                         Duration                         GRAPHIC   
                        CALLS                                    ACT
2008-09-01               30000                                          
                                    27789                              
     


Export PDF file 	Export CSV file


-- 
With Regards,
Hiren Mistry

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/1e79fdb4/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 138 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/1e79fdb4/attachment.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 878 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/1e79fdb4/attachment-0001.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3845 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/1e79fdb4/attachment-0002.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3151 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/1e79fdb4/attachment-0003.gif

Hiren Mistry

2008-Sep-09 10:54 UTC

head link

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

Dear All,

             I have configured here Asterisk-stat (Call Detail Records) 
for CDR ANALYSER. Here I am facing problem in web analyser when I 
Selection of the day as I require it can get data from asterisk postgres 
database. But in bottom side I have not seen graphical chart and I also 
can't make export file.


  CDR (Call Detail Records)

umber of calls : 21534

* - Call Logs - * 	Back to Top


	
* Calldate   
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=calldate&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* Channel *

	
* Source *

	
* Clid *

	
* Lastapp *

	
* Lastdata *

	
* Dst 
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=dst&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* APP *

	
* Disposition *

	
* Duration 
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=duration&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
*

	
* Userfield *

	
* Accountcode *

1.  	2008-09-01 23:59 	Zap/84-... 	992 	992 	BackGround 
ivr_menu/mainmenu/PRESS_03 	s 	
	ANSWERED 	00:35 	Ij 	
2.  	2008-09-01 23:59 	Zap/83-... 	975 	975 	WaitExten 	10 	s 	
	ANSWERED 	00:19 	IP 	
3.  	2008-09-01 23:59 	Zap/82-... 	971 	971 	BackGround 
ivr_menu/mainmenu/guj_promp 	s 	
	ANSWERED 	00:34 	IGj 	
4.  	2008-09-01 23:59 	Zap/81-... 	7965 	7965 	Dial 	ZAP/R2/501|60 	s 	
	ANSWERED 	06:12 	ATA 	
5.  	2008-09-01 23:58 	Zap/80-... 	972 	972 	WaitExten 	10 	s 	
	ANSWERED 	00:20 	Ij 	



*I have not seen below graphical chart and I also can't make export file.*
* *----------------------------------------------------------* 
*----------------------------------------------------------* 
*----------------------------------------------------------* 
*----------------------------------------------------------
*TOTAL*
                                                                         
        * **ASTERISK MINUTES*
Date                         Duration                         GRAPHIC   
                        CALLS                                    ACT
2008-09-01               30000                                          
                                    27789                              
     


Export PDF file 	Export CSV file


-- 
With Regards,
Hiren Mistry

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/11ba72d8/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 138 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/11ba72d8/attachment.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 878 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/11ba72d8/attachment-0001.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3845 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/11ba72d8/attachment-0002.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3151 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080909/11ba72d8/attachment-0003.gif

Max Alex

2008-Sep-10 05:03 UTC

head link

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

Hi Hiren,
Can  you please confirm the php-gd is properly installed?

Thanks,
Max Alex
Voip Developer



On Tue, Sep 9, 2008 at 4:20 PM, Hiren Mistry
<hiren.mistry at mobilefundas.com>wrote:
>
> Dear All,
>
>              I have configured here Asterisk-stat (Call Detail Records)for
CDR ANALYSER. Here I am facing problem in web analyser when I Selection
> of the day as I require it can get data from asterisk postgres database.
But
> in bottom side I have not seen graphical chart and I also can't make
> export file.  CDR (Call Detail Records)
>   umber of calls : 21534       * - Call Logs - *  [image: Back to Top]
>   *  Calldate
>
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=calldate&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
> *   * Channel *   * Source *   * Clid *   * Lastapp *   * Lastdata *   *
Dst
>
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=dst&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
> *   * APP *   * Disposition *   *  Duration
>
<http://192.168.0.6/asterisk-stat-v2/?s=1&t=&stitle=&atmenu=&current_page=0&order=duration&sens=ASC&posted=1&Period=Day&frommonth=&fromstatsmonth=2008-09&tomonth=&tostatsmonth=2008-09&fromday=true&fromstatsday_sday=01&fromstatsmonth_sday=2008-09&today=true&tostatsday_sday=01&tostatsmonth_sday=2008-09&dsttype=1&sourcetype=1&clidtype=1&channel=&resulttype=min&dst=&src=&clid=>
> *   * Userfield *   * Accountcode *       1.  2008-09-01 23:59 Zap/84-...
> 992 992 BackGround ivr_menu/mainmenu/PRESS_03 s
>  ANSWERED 00:35 Ij
>    2.  2008-09-01 23:59 Zap/83-... 975 975 WaitExten 10 s
>  ANSWERED 00:19 IP
>    3.  2008-09-01 23:59 Zap/82-... 971 971 BackGround
> ivr_menu/mainmenu/guj_promp s
>  ANSWERED 00:34 IGj
>    4.  2008-09-01 23:59 Zap/81-... 7965 7965 Dial ZAP/R2/501|60 s
>  ANSWERED 06:12 ATA
>    5.  2008-09-01 23:58 Zap/80-... 972 972 WaitExten 10 s
>  ANSWERED 00:20 Ij
>
>
> *I have not seen below graphical chart and I also can't make export
file.*
> * *----------------------------------------------------------* *
> ----------------------------------------------------------* *
> ----------------------------------------------------------* *
> ----------------------------------------------------------
>  *TOTAL*
>
>      * **ASTERISK MINUTES*
> Date                         Duration                         GRAPHIC
>                      CALLS                                    ACT
> 2008-09-01               30000
>                                  27789
>
>
>    Export PDF file  Export CSV file
>
> --
> With Regards,
> Hiren Mistry
>
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> AstriCon 2008 - September 22 - 25 Phoenix, Arizona
> Register Now: http://www.astricon.net
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080910/9723eabd/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 138 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080910/9723eabd/attachment.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3151 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080910/9723eabd/attachment-0001.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3845 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080910/9723eabd/attachment-0002.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 878 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080910/9723eabd/attachment-0003.gif

asterisk users - Sep 2008 - Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)

[asterisk-users] Asterisk CDR Problem for Export CSV (Asterisk-stat-v2)