How to Access and View CDRs
To view the CDRs, click on the Billing tab.
VoIP Innovations has three distinct CDR categories that can be viewed (Archived, Current, Transacted CDRs).
Current CDRs are updated consistently throughout the day and contain up to the last 10,000 calls. This limit cannot be changed and is configured this way to avoid timeout issues when accessing the file. Current CDRs can be accessed by clicking the Billing -> CDRs ->
Current CDRs in the Back-Office. Use the drop-down list to select the desired CDR type (Termination, Tiered Origination, Toll-Free Origination, Toll-Free Incomplete, SMS Origination, 411, 911, Short Duration, Call Failures).
Upon selecting the type, the option to open the file or save it to the computer will appear. Data can be viewed in an Excel spreadsheet.
Transacted CDRs will allow viewing call records from both the current and previous month. CDRs can be searched by Charge ID here also so that all call records that are associated with a transaction can be pulled. CDRs can also search by the Call Type in your Transacted CDRs. More information about our different call types can be read about here.
Archived CDRs contain previous days' calls data records. To access the Archived CDRs from the Back-Office, click Billing -> CDRs -> Archived CDRs; there is an ftp link and an http link. Either link will go to to the Archived CDRs but please note the ftp link is designed to be used with an ftp client. Many customers have their own developers write scripts to automatically pull the data via ftp and this option is therefore provided. If ftp is not being used, click the http link. Clicking the links will prompt for a username/password. If a CDR password has not been created, the password will be the same as the main login for the Back-Office. The Archived CDRs page in the Back-Office has a form to submit if a separate password is wanted and can be used at user discretion.
By default, all accounts are set up to display only daily CDR dumps on the archived pages. Some customers also like to have all the daily information compiled into one monthly file. To have monthly CDR dumps made available on the archive page, simply open a ticket with support and request that we add the monthly file to the account. Monthly CDRs will be in zip format; a utility to unzip the files once downloaded will be needed. 7-Zip is one program and can be found here:7zip (Please ensure you choose the appropriate version for your system.)
Clicking the http link will give the index of all CDRs for the account. Each link in the index will be formatted as yearmonthday and will contain the previous day's call data records. For example, the link 20160107/ would be for January 7, 2016 and contain call records for January 6, 2016.
*{}Unlike Current CDRs, Archived CDRs contain ALL call types. Clicking the link from the index page will take you to another page containing .CDR files; these are the CSV files containing the records and can be opened with a text editor. These files can also be imported into Excel for easier viewing. For instructions on importing to Excel click here. For a detailed explanation of CDR file format/headings click here.
Accessing Archived CDRs via FTP
Retrieving VoIP Innovations Archived CDRs (FileZilla)
To retrieve archived CDR information from VoIP Innovations you will need an FTP program that can utilize FTP over TLS (Transport Layer Security) such as FileZilla, WINSCP, et cetera. Once you have FileZilla installed, simply perform the following:
Host: ftp://customercdr.voipinnovations.com
Username: your username
Password: your password
Click "Quickconnect"
Given the correct credentials you should now be logged in and able to view the archived CDRs on the right frame. To download, simply drag the folder to the preferred location in the left frame, or right-click and select 'Download'.
FileZilla Site Manager
Useful Information
CDRs are listed in GMT.
Current CDRs are updated approximately every 15 minutes
CDRs only contain billed transactions (does not contain failed calls)
You will occasionally see multiple .CDR files from the index link (this is normal and is due to how the files are processed. Ensure you are check all .CDR files for complete call data.