Contents

1. 1 Description
2. 2 Installation
3. 3 Creating a new CDR Format
4. 4 Creating a new CDR Schedule
5. 5 Script syntax

Description

Netsapiens NCE works with an NMS server providing scheduled CDR export and delivery. NCE is a java based application running under Netsapiens-tomcat. Configuration changes can be in the normal SiPbx UI. There are 2 parts, CDR_format and CDR_schedule. Any number of CDR formats can be added/modified through an Ajax based configuration page at System -> CDR export -> CDR Format. Any number of CDR schedules can be added/modified through the configuration page at System -> CDR export -> CDR Format.

Installation

• Confirm netsapiens-tacserver is installed.
• Install the application
• "yum install netsapiens-nce"

• Copy over the configuration file and edit it
• "cp /etc/netsapiens/netsapiens-nce.conf.example /etc/netsapiens/netsapiens-nce.conf"
• "vi /etc/netsapiens/netsapiens-nce.conf"

• Confirm that "CDR export" is running and updating on the Status page of the SiPbx.  If it isn't running, then on the cmd line:
• "touch /var/lib/tomcat5/webapps/netsapiens-nce.war" and check again

Creating a new CDR Format

• Go to System -> CDR export -> CDR Format
• Click "Add"
• Enter a name and description for the new Format
  • Example: name = "Daily w/ PAC" description = "Daily format including PAC codes"
• Find the format from the previous page and click "Select"
• Click and drag available field from the left to the right.
• Can arrange fields in order desired. Starting from the top down will format cdr field form left to right.
• Click "Save CDR Format" when all modifications have been made.

Creating a new CDR Schedule

• Go to System -> CDR export -> CDR Schedule
• Click "Add"
• Enter a name for new Schedule
• Select domain to filter on and User to filter on.
• Select period to time between cdr pulls and exports.
• Select CDR Format, created a format in the previous section.
• If you want to use the normal CDR format, please select "Standard"
• Select whether or not you want to include the cdr header titles in the .csv file.
• Select whether or not you want to include the inbound calls.
• Select whether or not you want to include the outbound calls.
• Configure (optional) Script
  • Select whether or no a script will run on each export
  • Select from available Scripts on the server
  • To add a script copy the script file it to /usr/local/NetSapiens/SiPbx/bin it +x rights
  • More info in next section
• Select export method
  • Email
    • Sends email to recipient listed in field "E-mail"
  • Scp Copy
    • Secure copy of file to remote server
    • Uses the remotepath field for destination e.g: 192.168.88.80:/backup/cdr/
    • SSH key exchange must be setup for the two servers.
  • Ftp Upload
    • Uploads the file to a remote FTP Server
    • Uses hostname field for remote hostname/ip or the ftp server
    • Username and password are required upload a file.
  • Backup Locally
    • Copy of file to local path
    • Uses the remotepath field for destination e.g: /backup/cdr/
• Set the Next Run Time for the time and date it is to be run

Script syntax

• The script will be executed with the temporary .csv file as the first argument
• A script can echo a new filename if they wish to change the name of the exported file.
• A script should be customized to a specific CDR Format
• Example Script : Example Export Script