Embedded Files
On the CDR Importer main menu Input 4 and press enter:
The screenshot below shows a outbound CDR with the column names, each column name must have the correct column number input in CDR Importer when creating a new VoIP carrier. Column titled "tag" is column 1, column titled "number_dialled" is column 2, column titled "description" is column 3 etc
(A SIP trunk supplier may have more columns on their CDR present but they are unnecessary for CDR Importer when creating a new VoIP carrier)
The screenshot below shows a call rate card with the column names, each column name must have the correct column number input in CDR Importer when creating a new VoIP carrier. Column titled "description" is column 1, column titled "charge_code" is column 2, column titled "price_per_minute" is column 3 etc
(A SIP trunk supplier may have more columns on their call rate card present but they are unnecessary for CDR Importer when creating a new VoIP carrier)
Due to SIP trunk suppliers having different CDR formats, CDR Importer was designed to allow the administrator to apply the correct column number for each required column in the CSV file. The prgram was also designed to allow an administrator the option to ignore the first line of the rate card, some suppliers use the first row for the title of each column which CDR Importer does not require
To add a new VoIP carrier the following must be input into the Option 4 sub-menu:
A VoIP carrier name with no spaces
The direction of the calls in the CDR, either inbound or outbound
The path of the call rate card (the call rate card must be in CSV file format)
Select the option to ignore the first line of the call rate card CSV, either yes or no
The CDR column number for the tag (usally a phone number/CLI or SIP trunk ID/username)
The CDR column number for the phone number(s) dialled
The CDR column number for the call description
The CDR column number for the charge code
The CDR column number for the call duration
The CDR column number for the date (this column will also take a combined date and time)
The CDR column number for the time or n/a (not applicable) (enter n/a if the date and time is combined in the previous column)
The CDR column number for the month and year (01/2026) Note: this column will probably not exist on a SIP trunk suppliers CDR and will need to be added to the CDR before importing into CDR Importer
The rate card column number for the description
The rate card column number for the charge code
The rate card column number for the price per minute
The rate card column number for the price per call
Google Sites
Report abuse