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. Both DIDs and IP Addresses can be loaded via the PHP Admin Portal as well.

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 scheduled rating jobs. You can also initiate rating manually using the 'Rate Calls' button on the 'Rating Queue' page of the PHP Admin Portal.

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.

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