[Asterisk-Users] Master.csv Shell Script

[Mojo with Horan & Company, LLC]

I run it, make a call, and after the call disconnects, when I run the 
script again, I do get changed numbers:

[pbx at pbx ~]$ total_account_codes /var/log/asterisk/cdr-csv/Master.csv
"" total is 151974 seconds or 2532.9 minutes or 42.22 hours
[pbx at pbx ~]$ pbxmonitor
Mojo > 7478633
[pbx at pbx ~]$ total_account_codes /var/log/asterisk/cdr-csv/Master.csv
"" total is 151983 seconds or 2533.05 minutes or 42.22 hours
[pbx at pbx ~]$


Is this what you mean?  As you can see, I even allow blank accountcodes 
('cause we don't even use accountcodes), so there shouldn't be any 
issue.  Maybe * is not logging the call duration under certain 
disconnect circumstances.

As per the line near the top of my script, if I change the 12 to a 13 to 
capture BillSeconds instead of duration, I get the following:

[pbx at pbx ~]$ total_account_codes /var/log/asterisk/cdr-csv/Master.csv
"" total is 151639 seconds or 2527.32 minutes or 42.12 hours

which is slightly less than before...  You might try this and see if it 
helps.

Moj


Jeremy wrote:
> Can you think of any reason that this would not pick up on times after call
> is placed, and then disconnected. I noticed that the time does not change on
> the call times after a call has been made. 
> 
>  
> 
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Mojo with
> Horan & Company, LLC
> Sent: Monday, March 27, 2006 3:22 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] Master.csv Shell Script
> 
> If you've got PHP installed, here's one I made for our office:
> 
> http://horanappraisals.com/asterisk/total_account_codes/
> 
> Run it with no parameters to check Master.csv in the current directory, or
> pass the filename to parse as the first parameter.
> 
> # ./total_account_codes /var/log/asterisk/cdr-csv/Master.csv
> "test" total is 310 seconds or 5.17 minutes or 0.09 hours "" total is 33130
> seconds or 552.17 minutes or 9.2 hours
> 
> #
> 
> The second line totals all lines with no account code specified.
> 
> hth moj
> 
> Jeremy wrote:
>> Im not looking for anything super detailed, just something to run 
>> through the master.csv file and give total time per account code. . . 
>> .does anyone out there have a script like this I could work from?
>>
>> _______________________________________________
>> --Bandwidth and Colocation provided by Easynews.com --
>>
>> Asterisk-Users mailing list
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>>
> 
> --
> Mojo <mojo at horanappraisals.com>
> Office Manger, Horan & Company, LLC
> (907) 747-6666 x112
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 

-- 
Mojo <mojo at horanappraisals.com>
Office Manger, Horan & Company, LLC
(907) 747-6666 x112