Bandwidth

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

Our integration with Bandwidth.com allows you to import their CDR records which also contain your wholesale rate/cost. Once the CDR have been rated in our system, you will be able to run profit analysis reports.

We recommend loading all your DIDs into the [DIDMaster] table before importing CDR. This will allow us to recognize your CustomerIDs by IP address.

The following steps allow you to import Bandwidth/iNetwork CDR directly into our system and then push them to our RATING queue. A future version will allow CDR import via the PHP portal.

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 Bandwidth/iNetwork. Note: Do not open the file in any editors before importing into OpenCDRRate.

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

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

Step 5 - Select the Bandwidth/iNetwork CDR file and click Next.

Step 6 - Enter the pipe "|" symbol in the 'Other symbol' field and click Next.

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

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

Step 9 - Map the following fields and click Next.

debtor_id --> DEBTOR_ID
itemid --> item.id
billable_minutes --> computed.billable_minutes
itemtype --> item.type
trans_rate --> computed.trans_rate
amount --> AMOUNT
record_date --> RECORD_DATE
dest --> item.dest
src --> item.src
dst_rcs --> item.dst_rcs
lrn --> lrn
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 BandwidthCDR table.

Step 13 - Execute the [fnMoveBandwidthCDRtoTBR] function. This function will transform the BandwidthCDR 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.