Bandwidth

This is a first-release of the documentation. Additional detail will be added as the project matures.

Be sure to load all your DIDs into the [DIDMaster] table before importing CDR.

The following steps allow you to import Thinktel CDR directly into our system and then push them to our RATING queue.

CDR Import Steps

Step 1 - Install Navicat for Postgres utility. Download: http://www.navicat.com/en/products/navicat_pgsql/pgsql_overview.html

You can use any other import utility if you are more comfortable with it.

Step 2 - Retrieve your CSV file from your Thinktel. Note: Do not open the file in any editors before importing into OpenCDRRate.

Step 3 - Log into Navicat for Postgres, highlight the ThinktelCDR table and click 'Import Wizard'.

Step 4 - Select 'Text file' and click Next.

Step 5 - Select the Thinktel CDR file and click Next.

Step 6 - Select 'Comma' in 'Field delimiter' and click Next.

Step 7 - Enter '1' as the 'Field name row', enter '2' as the 'First data row', enter 'YMD' as the 'Date order', enter '-' as the 'Date delimiter' and click Next.

Step 8 - Choose 'ThinktelCDR' as the target table and click Next.

Step 9 - Map the following fields and click Next.

sourcenumber --> Source Number
destinationnumber --> Destination Number
calldate --> Call Date
usagetype --> Usage Type
rawduration --> Raw Duration
customerid --> blank
direction --> blank
calltype --> blank
rowid --> blank

Step 10 - Select 'Append' and click Next.

Step 11 - Select Start.

Step 12 - You will now see records in the ThinktelCDR table.

Step 13 - Execute the [fnMoveThinktelCDRtoTBR] function. This function will transform the ThinktelCDR records into a format suitable for our [CallRecordMaster_TBR] table and will put them in there.

If you have any questions, please contact [Support].

-The OpenCDRRate team.