Add New CDR File Type

Owned by Shawn Gordon
Last updated: Nov 07, 2023
2 min read

Hi Glen:

Adding new cdr types is one of those features that must be done in the back end..., that is using the SQL Tools directly.

To this please do the following:

  • 1) Open the Microsoft SQL Server Management Studio

    

 

  • 2) Accept the default credentials and log 

   

 

  • 3) Expand Database / CDR2Cloud / Tables

    

  • 4) Locate and right-click the table named

dbo.CodesCDRType, then click [Edit Top 200 Rows]

  • 5) Go to the bottom of the results table and enter the new information for the new CDRType.

    ID - 206 (simply take the last ID and increment by 1)

    Name - The name of the new CDRType that you would like to add

    Code - Enter the same number as the ID

    Delimiter - This defines how your cdr file records are separated (delimited). For example, is delimited

by a comma enter "," (without the quotation marks)

  • 6) Click Enter to save the data.