Re: [asterisk-users] CDR-CSV Processing
There is an example in the asterisk gui (trunk/1.4/asterisknow) that has cdr-csv parsing. You could check that, and even use the javascript to generate reports, integrate it into a little bit of php and ezPDF generation and bam, you have some reports. The cdr viewer in the gui is very useful also. -bk - Original Message - From: Paul Hales [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Monday, August 13, 2007 10:31:34 PM (GMT-0800) America/Tijuana Subject: Re: [asterisk-users] CDR-CSV Processing http://areski.net/asterisk-stat-v2/about.php ??? PaulH On Mon, 2007-08-13 at 08:49 -0500, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don’t have anything specific in mind, I’d just like some reporting examples so I don’t have to reinvent the wheel. __ This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
We at Evariste have a lot of experience writing all sorts of custom CDR reports and would be happy to write what you need for you--very inexpensively, guaranteed. On Mon, 13 Aug 2007, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don't have anything specific in mind, I'd just like some reporting examples so I don't have to reinvent the wheel. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- Alex Balashov Evariste Systems Web: http://www.evaristesys.com/ Tel: +1-678-954-0670 Direct : +1-678-954-0671 ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
Free and inexpensive aren't quite the same. I don't follow the -biz list because I don't want to hear plugs from You at Evariste about this stuff. I sent a PHP snippet to the list maybe a year and a half ago, search something like site:lists.digium.com Mojo csv or site:lists.digium.com Mojo cdr or site:lists.digium.com Mojo php and see if you can find it, let me know if you can't. While it only totaled columns, it may be a nice starting point for you. Moj Alex Balashov wrote: We at Evariste have a lot of experience writing all sorts of custom CDR reports and would be happy to write what you need for you--very inexpensively, guaranteed. On Mon, 13 Aug 2007, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don't have anything specific in mind, I'd just like some reporting examples so I don't have to reinvent the wheel. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
I remember now, it totaled the *times* of cdr entries after grouping them by account code. Mojo Mojo with Horan Company, LLC wrote: Free and inexpensive aren't quite the same. I don't follow the -biz list because I don't want to hear plugs from You at Evariste about this stuff. I sent a PHP snippet to the list maybe a year and a half ago, search something like site:lists.digium.com Mojo csv or site:lists.digium.com Mojo cdr or site:lists.digium.com Mojo php and see if you can find it, let me know if you can't. While it only totaled columns, it may be a nice starting point for you. Moj Alex Balashov wrote: We at Evariste have a lot of experience writing all sorts of custom CDR reports and would be happy to write what you need for you--very inexpensively, guaranteed. On Mon, 13 Aug 2007, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don't have anything specific in mind, I'd just like some reporting examples so I don't have to reinvent the wheel. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
First, this is a non-commercial list, please do not post that stuff here. Alex, cdr csv is less then efficient for reporting, you should drive your cdr's to a database and then you can do some good reports based on that. Anthony Alex Balashov wrote: We at Evariste have a lot of experience writing all sorts of custom CDR reports and would be happy to write what you need for you--very inexpensively, guaranteed. On Mon, 13 Aug 2007, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don't have anything specific in mind, I'd just like some reporting examples so I don't have to reinvent the wheel. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
On Mon, 13 Aug 2007, Anthony Francis wrote: First, this is a non-commercial list, please do not post that stuff here. My apologies. Alex, cdr csv is less then efficient for reporting, you should drive your cdr's to a database and then you can do some good reports based on that. Definitely agreed. -- Alex Balashov Evariste Systems Web: http://www.evaristesys.com/ Tel: +1-678-954-0670 Direct : +1-678-954-0671 ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
Every little bit helps, thanks! I guess I'm actually going to look at cost/benefit analysis, trying to see where calls are going across IAX and tallying up what would have been LD cost(we're doing intra-office IAX calling where possible) to tag as savings to justify the systems to our ownership. I really only care about answered calls, though I can imagine 5-10 reports about unanswered, abandonded, congestion, etc that would benefit us in the long term as well. Thanks for your sample. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mojo with Horan Company, LLC Sent: Monday, August 13, 2007 12:28 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR-CSV Processing Free and inexpensive aren't quite the same. I don't follow the -biz list because I don't want to hear plugs from You at Evariste about this stuff. I sent a PHP snippet to the list maybe a year and a half ago, search something like site:lists.digium.com Mojo csv or site:lists.digium.com Mojo cdr or site:lists.digium.com Mojo php and see if you can find it, let me know if you can't. While it only totaled columns, it may be a nice starting point for you. Moj Alex Balashov wrote: We at Evariste have a lot of experience writing all sorts of custom CDR reports and would be happy to write what you need for you--very inexpensively, guaranteed. On Mon, 13 Aug 2007, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don't have anything specific in mind, I'd just like some reporting examples so I don't have to reinvent the wheel. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Anthony Francis wrote: First, this is a non-commercial list, please do not post that stuff here. Alex, cdr csv is less then efficient for reporting, you should drive your cdr's to a database and then you can do some good reports based on that. Anthony The really nice thing about dumping your CDR to a database is that you can use your favorite reporting tool (Crystal Reports, Open Office, MS Access, etc) to query it. Barry -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) iD8DBQFGwJ4BCFu3bIiwtTARAo2OAJ9XJEHQZs+9TmGa5jZ7/qKb0rc8FACgmh1e iekOkZkrvh7j1XwMv0YAFIY= =EyCb -END PGP SIGNATURE- ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
On Mon, Aug 13, 2007 at 08:49:11AM -0500, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? Throw them into a near-by spreadheet. -- Tzafrir Cohen icq#16849755jabber:[EMAIL PROTECTED] +972-50-7952406 mailto:[EMAIL PROTECTED] http://www.xorcom.com iax:[EMAIL PROTECTED]/tzafrir ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
Enable mysql loggin of cdr's by installing asterisk-addons and use asterisk-stat http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 On 13/08/07, Tzafrir Cohen [EMAIL PROTECTED] wrote: On Mon, Aug 13, 2007 at 08:49:11AM -0500, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? Throw them into a near-by spreadheet. -- Tzafrir Cohen icq#16849755jabber:[EMAIL PROTECTED] +972-50-7952406 mailto:[EMAIL PROTECTED] http://www.xorcom.com iax:[EMAIL PROTECTED]/tzafrir ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR-CSV Processing
http://areski.net/asterisk-stat-v2/about.php ??? PaulH On Mon, 2007-08-13 at 08:49 -0500, Jeremy Mann wrote: Does anyone have any tools to process CDR-CSV files into reports? I don’t have anything specific in mind, I’d just like some reporting examples so I don’t have to reinvent the wheel. __ This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Texas Health Management Group immediately at 1-817-310-4999. Texas Health Management Group, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
