CDR Import

From Kolmisoft Wiki
Revision as of 15:42, 11 November 2009 by Admin (talk | contribs)
Jump to navigationJump to search

Configuration

Make sure you select correct options for values:

CSV Column Separator
CSV Decimal Separator

In Configuration.

If settings will not match your CSV file - you will not be able to import CDRs.



Import

Sometimes MOR can be used as separate billing software – not doing realtime billing. For that purpose it is possible to import CDRs from other switches (can be not Asterisk) and bill these CDR's.

CDR Import can be found in SETTINGS – Billing – Functions – CDR Import.

First step is to select some CSV file to import:

Cdrimport1.png


Press on Upload file and you will get next window where you will have to assign columns to CDR values:

Cdrimport2.png


On step 2 you can see necessary fields to select. They are marked by *(star). You can select to enter Date/Time in one line OR Date AND Time in separate lines. Without selecting at least one field marked by * you will not be able to continue import process.

Select appropriate settings and press Assign Columns:

Cdrimport3.png


Here you will be presented with parsed file. If something is not right – press Back button. If it's ok – Confirm columns:

Cdrimport4.png


Here we select the User to which we want to assign all these calls.

Cdrimport5.png


Here we select Device to which all these imported calls will be assigned and Provider.

Cdrimport6.png

Finally file is imported.


Export

You can export CDR in PDF or CSV formats. It can be done in Call Stats page (STATISTICS – Calls) and other places where you see:

  • Pdf.png Export to PDF
  • Excel.png Export to CSV

Just press on one of these links and you will get CDR in selected period.


Calls to DIDs

Calls to DIDs are billed as to normal numbers.

Calls to DIDs which belong to the caller are not billed at all. (Price = 0)