Thinktel

Be sure to use the CDR from ThinkTel's BILLING tab in their control panel. Do not use the one from the 'Invoices' tab, they are different formats.

Be sure to load all your DIDs into the [DIDMaster] table before importing CDR. You can also enter your DIDs via the 'DIDs' link on the main page.

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

Thinktel CDR can be imported through our [PHP Admin Portal] or directly to the database. Instructions for both are available below. For large files, we recommend using the 'Direct to Database' method.

CDR Import Steps - PHP Admin Portal

Step 1 - Log into the [PHP Admin Portal] and click 'Rating Queue' then click OK.

Step 2 - Select the source file from Thinktel and click 'Import Thinktel CDR'.

Step 3 - Results of the import will be presented on-screen. Those CDR will now be in Rating Queue which will be picked up during the hourly rating jobs.

CDR Import Steps - Direct to Database

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.

Follow us on twitter to receive new feature notifications: http://www.twitter.com/opencdrrate/

Join our LinkedIn group to open discussions on features you would like to see in the system. http://www.linkedin.com/groups/OpenCDRRate-4381972