An Eight in a Million chance (consultants, interns, MS Access)

Re:An Eight in a Million chance (consultants, interns, MS Ac... by bradleyland on Thursday February 09, 2012 @09:35AM (#3571241)

I don't run in to many telecom folks these days. Are you still working in the industry?

I used to do a lot of telecom consulting for a large customer who we transitioned to a 100% SIP carrier. This particular carrier used AdTran TA 900 series gateways to provide T1-CAS/PRI to older phone switches. The project was particularly interesting because the carrier let me (a third-party analyst) have unheard of access to their infrastructure. Once I earned their trust, I had access to all of the AdTran devices, as well as their core switching and CDR reporting tools.

I actually just put wraps on a Ruby script that I use to analyze call concurrency from CDR exports (from CDRTool [1]). I dropped it in a Gist if you're interested. It takes a CDRTool query export (CSV data) and outputs a tab-delimited concurrency datafile that can be used pretty easily with gnuplot. The script could be easily adapted to any CDR report that uses single-line call entries.

https://gist.github.com/1706903

1 - http://www.ag-projects.com/CDRTool.html

PS - If you find this at all interesting, hit me up on Twitter to keep in touch https://twitter.com/#!/bradleyland

[ Parent | on HN ]

Re:An Eight in a Million chance (consultants, interns, MS Ac... by willvarfar on Thursday February 09, 2012 @03:45PM (#3572981)

Nope, after I graduated I moved country and industry and wasted a good decade programming the mobile phones that help people create the CDRs that torment you.

These days I'm swung back more towards DBs and servers and stuff, but not a CDR in sight thankfully.

Liked your ruby; not a ruby ninja myself but it looks quite readable and almost pythonic :)

[ Parent | on HN ]