Difference between revisions of "M4 CDR Import Templates"
| Line 15: | Line 15: | ||
[[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, after that Y seconds speaks/play something and hangs up. | Let's say a call comes in and no answer for X second, after that answered, after that Y seconds speaks/play something and hangs up. | ||
So '''Duration''' will be X + Y, while ''' | So '''Duration''' will be X + Y, while '''Billed Seconds''' (time to be billed) will be Y. | ||
==Using CDR Import Templates== | ==Using CDR Import Templates== | ||
Revision as of 07:50, 8 June 2022
CDR Import Templates allow to create 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 new CDR Import Template by clicking ADD NEW TEMPLATE:
You will be asked to configure 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, after that Y seconds speaks/play 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 CSV file, you can choose which CDR Import Template to use:
