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 or bill your customers.

We recommend loading all your DIDs into the [DIDMaster] table before importing CDR. This will allow us to recognize your CustomerIDs by DID. We also recommend loading all your customer's IPs into our [IPAddressMaster] so we can recognize your customers by IP address.

Bandwidth.com 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 Bandwidth.com and click 'Import Bandwidth 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 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
src --> item.src
dest --> item.dest
dst_rcs --> item.dst_rcs
lrn --> lrn
customerid --> blank
direction --> blank
calltype --> blank
rawduration --> 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.