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.