Asterisk CDR import Files

This is a simple tool to map information for the cost of phone calls given by your VoIP provider, to the call log inside your Asterisk.
As a result, you will know how much each of your employees has spent for phone calls.

In order to use this tool, please follow these steps:

(1) add a column COST of type DOUBLE to the table CDR in database AsteriskCDRdb of your Asterisk VoIP appliance;
(2) add a column USER_ID of type MEDIUMINT to the table CDR in database AsteriskCDRdb of your Asterisk VoIP appliance;
(3) add a column TEL_INT of type SMALLINT to the table USERS in your ERP software (it stores the assigned extension phone number)
(4) add a column DEPART_ID of type SMALLINT to the table USERS in your ERP software (it shows the current department of this employee)
(5) create a table DEPARTMENT with 2 columns - ID (autoincrement) and DEPARTMENT (name of the department) and populate it with your departments

Additionally, this tool shows information about the assigned DID and CLIP numbers in Asterisk:
(a) DID number is the public phone number which your clients use to call a specific employee in your office (Direct In-line Dialing)
(b) CLIP number is the number your clients see as a caller ID when your employees make outgoing phone calls (Calling Line Identification Presentation)
This is helpful to identify obsolete, duplicate and multiple assignments.

Note:
You will certainly have to adjust PHP code for importing CSV files - your VoIP provider will not necessarily use the same order of columns as mine, 
or format the values in the same way.