Import CDR data..

steffenluttge · ‎04-16-2010

Hello

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..

Regards

Steffen

David Hailey · ‎04-16-2010

Steffen,

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).

Hailey

Please rate helpful posts!

steffenluttge · ‎04-16-2010

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..

Regards

Steffen