Stuart Ford I speak my mind involuntarily. It's both a blessing and a curse.

27Mar/118

Asterisk CDR Statistics

I've been a beneficiary of the open source software community for quite some time now. Ever since downloading Slackware Linux onto upteen floppy disks in 1995, I have used and profited from the use of open source software, whether it it be an operating system, programming language, server technology or desktop application. However, up until this point I've never given anything back to the open source community (I really don't count my Twitter CLI script), chiefly because every software system I have created or worked on has been proprietary and subject to non-disclosure agreements. I'm not grumbling about that, not all software is meant to be or should be open source and working on such systems has paid the bills (just about).

So, what have I written? Unhappy about the lack of a decent (and free of charge) system for analysing caller detail records (CDRs) generated by Asterisk PBX telephone systems, I decided that I would combine a number of techniques that I have learnt and developed over the past year or so to put my own package together, and it's now at the stage where I think it could be considered a beta. This means that it's not perfect but it's more or less there. I've started hosting it over at Google Code, including a tarball download and a Subversion repository.

Principal features

  • Clean, modern interface.
  • Supports multiple Asterisk servers which record their CDRs to a MySQL database.
  • Uses Google Chart API to generate dynamic charts.
  • Quick and advanced search facilities.
  • Rolling monthly and annual reports.
  • MVC framework*.

Screenshots

Further development

Where does it go from here? I'm open to suggestion, which is why I've published it and I would welcome comments from anyone who's interested and/or finds it useful, whether you are a developer or just an end user. Is it useful? Does it work out of the box on your system? Is it easy to install for someone who isn't a developer? What other features would be useful, bearing in mind that the data produced by the Asterisk CDR MySQL add-on is relatively limited?

I know that the documentation is a little rough around the edges and so I shall be paying attention to that, certainly. I also want to do some really thorough and structured testing in order to ensure it's as robust as possible. I've tested it, obviously, but I've not seriously tried to break it yet.

So please feel free to download it, either as a tarball for installation or from the Subversion repository if you would like a good look under the hood. Please submit any comments, suggestions or indeed any code you would like to contribute via the Google Code page in order that all information pertaining to it is kept in the same place. I won't publish any comments made directly on this blog post for this reason.

* Incidentally, the MVC framework which AGCDR uses is also of my own creation and is something that I'm working on with a colleague from work. It's called Syml and it's also available on Google Code if you would like a gander at that separately.

Filed under: Asterisk, Development, MySQL, PHP, Telecommunications 8 Comments
2Nov/070

Zurückgegangen VON Boston

Yeah, so I spent exactly four days and four hours traveling to Boston, being in Boston and travelling back from Boston this week. It's kind of a surreal feeling; I feel as if I should be totally overwhelmed by such an intense trip but I'm not, I'm really chilled out about it and it feels like Boston is no further away than London rather than being five timezones away over the Atlantic. Each journey and each day went off without a hitch; never before have I had such a relaxed and straightforward trip abroad. Would that all our holidays were the same!

The conference itself, Fall VON, was very interesting and I truly immersed myself in the IP communications world for two whole days, meeting some very clever people and some notable industry names. I've gathered a wealth of information that will prove to be very useful for my current project at work and so the trip was well worth it from a commercial point of view. A couple of the talks were by people who had used the technology with which I specialise in specific applications and while these applications were reasonable clever they weren't on the sort of scale that my current project is going to be, so I'm going to see if it's reasonable and feasible for me to do a talk myself at next year's event once my project is finished.

Boston is a marvellous place. My favourite city in the United States is of course New York, but Boston comes a very close second. Its relative age combined with its New England environs, cleanliness, friendly inhabitants and functional transportation systems make it a pleasure to be in. Manchester, Boston and New York are the three places in the world where I really feel at home, more-so even than my birthplace. The only thing it's really lacking is the sort of gay scene that I'm used to in Manchester, but then I'm willing to admit that my standards have been set pretty high in that regard. Not even New York comes close to Manchester, mostly thanks to the Republican Party, but that's a different story.

The local baseball team, the Red Sox, apparently won the "world" series last week, although unclear how much of the rest of the world beyond the United States were invited to participate in this tournament. There was a giant parade through Boston on Tuesday which lasted practically all day. I didn't see it because I was at the convention centre, but it was apparently enourmous.

Filed under: Asterisk, Telecommunications, Travel, United States No Comments
   

Recent Twitter updates

Recent Posts

Categories

Static Pages

Archives

Recent comments

4sq Checkins


    Software projects

    Stuff for sale on eBay

    • Currently no sales for stuii

    Blogroll

    • DJ Spook - Club and radio DJ in Manchester

    Other links

    RSS DJ Spook’s new music

    Site tools

    Disclaimer

    It is not my intention to cause offence through material posted to this site. However, since I am a person with strong opinions then I appreciate that this might happen from time to time. In such cases I apologise if readers feel offended by any content, but I will not, under most circumstances, apologise for the content itself.

    All content and opinion posted on this site is my own responsibility and does not represent the position or opinion of my employer or any clients.