Difference between revisions of "M4 CDR Import Templates"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(4 intermediate revisions by 4 users not shown)
Line 1: Line 1:
CDR Import Templates allow to create templates with specific columns for CSV files. These templates can be used to import CDRs.
CDR Import Templates allow to the creation of templates with specific columns for CSV files. These templates can be used to import CDRs.


<br><br>
==How to create CDR Import Template==
==How to create CDR Import Template==


CDR Import Templates can be accessed in '''Billing -> CDR -> Export -> Templates''':
CDR Import Templates can be accessed in '''Billing -> CDR -> Import -> Templates''':


[[File:M2 cdr import menu.png]]
[[File:M2 cdr import menu.png]]


Here you can create new CDR Import Template by clicking '''ADD NEW TEMPLATE''':
Here you can create a new CDR Import Template by clicking '''ADD NEW TEMPLATE''':


[[File:M2 cdr import new.png]]
[[File:M2 cdr import new.png]]


You will be asked to configure CDR Import Template name, column separator, decimal separator, number of lines to skip, date format and CSV columns:
You will be asked to configure the CDR Import Template name, column separator, decimal separator, number of lines to skip, date format, and CSV columns:


[[File:M2 cdr import form.png]]
[[File:M2 cdr import form.png]]


'''Billed Seconds''' - is answered time or time to be billed, without call setup time(post-dial delay).
Let's say a call comes in and no answer for X second, after that answered, and after that Y seconds speaks/plays something and hangs up.
So '''Duration''' will be X + Y, while '''Billed Seconds''' (time to be billed) will be Y.
<br><br>
==Using CDR Import Templates==
==Using CDR Import Templates==


Before uploading CSV file, you can choose which CDR Import Template to use:
Before uploading the CSV file, you can choose which CDR Import Template to use:


[[File:M2 cdr import template select.png]]
[[File:M2 cdr import template select.png]]

Latest revision as of 12:35, 29 November 2022

CDR Import Templates allow to the creation of templates with specific columns for CSV files. These templates can be used to import CDRs.



How to create CDR Import Template

CDR Import Templates can be accessed in Billing -> CDR -> Import -> Templates:

M2 cdr import menu.png

Here you can create a new CDR Import Template by clicking ADD NEW TEMPLATE:

M2 cdr import new.png

You will be asked to configure the CDR Import Template name, column separator, decimal separator, number of lines to skip, date format, and CSV columns:

M2 cdr import form.png

Billed Seconds - is answered time or time to be billed, without call setup time(post-dial delay).

Let's say a call comes in and no answer for X second, after that answered, and after that Y seconds speaks/plays something and hangs up.

So Duration will be X + Y, while Billed Seconds (time to be billed) will be Y.



Using CDR Import Templates

Before uploading the CSV file, you can choose which CDR Import Template to use:

M2 cdr import template select.png