Import CDR data..

Unanswered Question
Apr 16th, 2010
User Badges:


Anyone who has a SQL script, which import´s the CDR files from CUCM7 ??

Manuel import works fine, but i´m trying to make som automatited SQL which

import the CDR files, into a table, removes the file, and proces the next..



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
David Hailey Fri, 04/16/2010 - 12:14
User Badges:
  • Purple, 4500 points or more


I'll let others speak up here as well but I believe you're going to end up in the following boat (and FYI - we have a customer that does essentially what you're speaking of).

1) Set up an SFTP server

2) Configure a "Billing Server" for CDR which is the SFTP server in #1 above.  This will push the CDR flat files to the SFTP server for you to manipulate.

3) Write your own or possibly garner a script or series of scripts that process the flat files and parses them into the format which you wish to view them (XML, CSV, HTML, etc).


Please rate helpful posts!

steffenluttge Fri, 04/16/2010 - 13:08
User Badges:

I have the SFTP server, and the billing setup correctly.

It´s the SQL script, i can´t figure out, and thought that somebody has already fixed..




This Discussion

Related Content