Mitel Forums > Mitel MiVoice Business/MCD/3300

Call Logging Software (Free?)

(1/2) > >>

bilbonvidia:
Hi, I am it admin for a small office and was wondering if there were any freeware programs available which will collect sort the smdr data so I can see calls by ext etc? Or has anyone created their own access database or similar?

Thanks
B

ralph:
This is something I've kept my ear to the ground for for a long time.   I've never seen a free or open source product available for the Mitel product line.

I would think that a simple program could be written to collect the data in a single daily flat file that would be named something like "Sep-15-08.txt".    A new file would be created everyday so you would always know what day you were looking at.   After that you could import it into Excel or Open Office and sort it any way you would like.

Hopefully someone here will know where to get the software, but if not and you happen to find something that will work, please be sure to let us know.  We'll promote it here.

Ralph

Chakara:
Yeah, Ralph is right once again.  Dumping the data to a flat text file is easy.  Translating the SMDR into something usable - given the variables in the SMDR options - is the key.

Not a hard programming trick, but beyond my programming skills...

-Chak

chadmaynard:
I have a set of python scripts that are capable of parsing mitel smdr output. They currently are not extremely robust in how they adapt to changes in the smdr format (so you must set your SMDR settings exactly like mine were when I wrote it). Python connects via MySQLdb to a MySQL database and inserts the records. You could then use a query browser or write a web front end to view the records. The version of these that I have that are currently under development are made to integrate with enterprise and are written in C and PHP for the webfrontend. This version can monitor many controllers at once and make relations between calls transfered across IP trunks, but I'm not willing to share the code to all of that.

I will, however, post the python stuff if anyone wants a crude script to parse SMDR to a relational DB.

Chakara:
  Chad, please post your scripts.  Who knows who might pick them up and and make good use of them.

    Thanks!

-Chak

Navigation

[0] Message Index

[#] Next page