Difference between revisions of "CDR Import"

From Kolmisoft Wiki
Jump to navigationJump to search
Line 14: Line 14:
Sometimes MOR can be used as separate billing software (that is, other than for real-time billing). When using MOR as separate billing software, it is possible to import CDRs from other switches (they need not be Asterisk) and bill these CDRs.
Sometimes MOR can be used as separate billing software (that is, other than for real-time billing). When using MOR as separate billing software, it is possible to import CDRs from other switches (they need not be Asterisk) and bill these CDRs.


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


The first step is to select a CSV file to import:
The first step is to select a CSV file to import:

Revision as of 13:02, 16 March 2011

Configuration

In Configuration, make sure you select the correct options for these values:

  • CSV Column Separator.
  • CSV Decimal Separator.

If the settings do not match your CSV file, you will not be able to import CDRs.



Import

Sometimes MOR can be used as separate billing software (that is, other than for real-time billing). When using MOR as separate billing software, it is possible to import CDRs from other switches (they need not be Asterisk) and bill these CDRs.

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

The first step is to select a CSV file to import:

Cdrimport1.png


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

Cdrimport2.png


In step 2, you can see the necessary fields to select. They are marked by a 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 the import process.

Select the appropriate settings and click Assign Columns:

Cdrimport3.png


Here you will be presented with a parsed file. If something is not right, click the Back button. If it's okay, click 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, the file is imported.

Export

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

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

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

Calls to DIDs

Calls to DIDs are billed as for calls to normal numbers.

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