Difference between revisions of "M4 CDR Import Templates"
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
CDR Import Templates allow to | 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== | ||
Line 7: | Line 8: | ||
[[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]] | ||
Line 17: | Line 18: | ||
'''Billed Seconds''' - is answered time or time to be billed, without call setup time(post-dial delay). | '''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, after that Y seconds speaks/ | 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. | 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:
Here you can create a new CDR Import Template by clicking ADD NEW TEMPLATE:
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:
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: