CDR CCM4:does database deleted if I use flat file

Unanswered Question
Jul 19th, 2010


I'm still working on a CCM4.2 that is working in live.

His CDR is still working on CCM Database,not in Flat File.

If I'll use flat file, does the database still have the CDR like in CCM5, and 6



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Jaime Valencia Mon, 07/19/2010 - 08:20

Not sure what you mean by that, all the CUCM releases use flat files as the 1st step before sending the info to the respective DB.

The fields have changed and so does the method. In Windows you had CDR/CAR DBs, in Linux only CAR DB exists.



If this helps, please rate

iantra123 Mon, 07/19/2010 - 08:25

I want to use a billing system like stonevoice. So i want flat files.

So if i'll use flat file, does CDR is will still inserted in the CM database?

With this I'll have at the same the same time the flat file data and DB data.



Jaime Valencia Mon, 07/19/2010 - 08:34

If you take the flat files before they're processed and uploaded to CDR, CDR DB will be empty.

Not sure how/where your system will pull the flat files and if it will just copy or cut the files.



If this helps, please rate

Aaron Harrison Mon, 07/19/2010 - 09:12


Don't get hung up on the mechanics of what will happen with the flat files - just let CCM put them into the DB as it is designed to do.

If StoneVoice support CM4 for their billing software, it will access the data from the database. Just follow their instruction manual...

If they don't support CM4, get different software.

Keep it simple :-)


iantra123 Tue, 07/20/2010 - 04:01

Thank yo for answers,

I want to do this because the CCM system will be upgraded to 8. Operating Systems are differents.

So I want take the modularity : The CCMAdministrator want to have the CAR output from CCM, and the billing system want to have its output with the billing software because it gives good reports and graphical chart.


Aaron Harrison Tue, 07/20/2010 - 05:02


So it works like so in CM4.x:

  • CCM service outputs flat files
  • CCM CDR insert service inserts files to the 'CDR' SQL DB.
  • From there, CAR has it's own database named 'CAR' or something similar that is seperate to the CDR DB. It has it's own service that reads from the CDR database into the CAR DB.
  • Your CDR package should do the same thing - read from the CDR DB into it's own DB.

There's no reason why CAR and the third party app can't coexist without any problems - lots of my customers do this.

When you upgrade to CM8.x, it will work a little differently - CAR will be compatible with the new mechanisms in CM8, and will read data in to it's own DB as it does on 4.x

The third party app if compatible with CM8.x will use one of the new 8.x mechanisms - usually CM is set to FTP the flat files off to an FTP server that is part of the third party app server.

So on both versions, you can enable and configure CAR as well as having a third party app configured.



Please rate helpful posts and mark answered questions that you've got a satisfactory response from to help identify useful content in the forums...


This Discussion