Teneo !!!

Aaron’s blog on Networking, and Enterprise Technology

Archive for October 9th, 2007

Parsing Cisco CDR into PostgreSQL DB

Posted by Aaron Paxson on October 9, 2007

Over the last 2 days, I’ve been wanting to develop a program which will report Call Metrics from my Cisco Call Manager systems. The first thing I needed to do was create a quick script that will parse the CDR’s from Cisco, and place them into a Database. More specifically, a PostgreSQL database. Personally, I’m a MySQL guy, but that’s another posting……. Technically, if you are Python-aware, it shouldn’t be very hard to change this to use MySQL, SQL, etc.

I first started out using Java to parse the data, but I needed to develop a prototype faster, so I chose Python. Basically, it goes through each CDR in a folder, parses it, places it in the database, then archives it for historical reasons.

Read the rest of this entry »

Posted in Networking, Voice | 15 Comments »