04-16-2010 11:59 AM - edited 03-15-2019 10:19 PM
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
04-16-2010 12:14 PM
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!
04-16-2010 01:08 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide