[cisco-voip] Excel CUCM6.x for Call Accounting?

[Madziarczyk, Jonathan]

Not anymore :)

Thanks!



-----Original Message-----
From: Ed Leatherman [mailto:ealeatherman at gmail.com] 
Sent: Tuesday, June 15, 2010 3:11 PM
To: Madziarczyk, Jonathan
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Excel CUCM6.x for Call Accounting?

Jon,

Is your problem converting timestamp from epoch to d/m/y (or similar) ?

http://www.blindhog.net/convert-epoch-time-in-excel/



On Tue, Jun 15, 2010 at 3:23 PM, Madziarczyk, Jonathan
<JMad at cityofevanston.org> wrote:
> Hey all, so I'm trying to figure out if this is possible or if I need
to
> look at 3rd party software for call accounting.
>
>
>
> Last time I tried to import the CDRs I ran into issues where Excel
didn't
> know what to do with the date/timestamp so I gave up on it.
>
>
>
> I only need the most basic of reporting:
>
> Number of calls (per hour, per day, per month)
>
> What number was called
>
> If the call was transferred
>
> If the call was dropped
>
> Average call time
>
>
>
> I think with some simple tinkering this is doable in excel.
>
>
>
> Does anyone have some experience with this (or a very inexpensive call
> accounting software) that could provide some direction/tips?
>
>
>
> Thanks!
>
>
>
> Jon
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>



-- 
Ed Leatherman