VOIP CDR Auto Processing from FTP Server

Nowadays every business is seeking to achieve the decrease of manual effort in the essential processes. Great news for our customers, who need the Voice billing engine to rate VoIP calls, LTE data transfers or work with full mobile services. Starting from Splynx v.2.3 it is now possible to automate the CDRs processing.

Splynx voice billing engine allows you to automatically import the CDRs from your provider’s FTP server to charge the customers and print the register of calls in their invoices.

The process is quite similar to the manual CDR import, however, now it is possible to import multiple CDRs at once. To configure the automatic import from the FTP server, first of all, we need to add the “Import Data Source” in the system.  This can be done at Config → Voice → Import Data Source. 

Auto CDR Processing

 

Create Import Data Source

In this menu, we need to add the import source for our CDRs and the folder path. There are 3 possible types of data sources:

  • FTP – we need to set a server host, port, your credentials
  • SFTP – the same parameters as for FTP plus RSA private key
  • Local – if you select “Local” then you will need to set only the Title and Folder path

The next step is the configuration of CDR auto processing.

CDR auto processing

CDR auto processing

After the selection of recently added Data Source, we need to specify the file name pattern to process all the files that have pattern entrances in a file name. The system uses Regex for filtering the file names (PCRE syntax). The examples can be found here.

Data Source

Pattern Description
AB Will filter the file names that have ‘AB’ symbols
CDR Will match all 3 files
2019 Will match the first two files which contain ‘2019’ in their names
516891[A-Z] Will match the first two files with matches 516891F, 516891C
516891[F2] Will match the first and the third files with matches 516891F, 5168912
516891[F2]-\d{6} Will match only the first one

The auto processing frequency is set by the option “Launch time interval“, which allows you to choose the suitable time interval.

In the last step, we choose the required columns for the import, such as Source, Datetime(or separate Date, Time columns), Destination, Duration, etc. Note that the number of columns and their order should be the same as it is in the imported file.

Once the Auto CDR processing is configured, you will be able to start it manually or the process will be automatically started at the previously scheduled time frame. In case something is failed during the import, it is possible to see the History log or even reproduce the errors.

More in System configuration

System configuration NetFlow Protocol in MikroTik

Understanding NetFlow Protocol in MikroTik: Relevance after the end of support of the IP Accounting in RouterOS 7

In the realm of network management, MikroTik is a popular choice for its robust features and cost-effectiveness. One of ...

System configuration Voip CDR auto processing from FTP server in Splynx

VOIP CDR Auto Processing from FTP Server

Nowadays every business is seeking to achieve the decrease of manual effort in the essential processes. Splynx voice bil...

System configuration

How to configure SMS and email notifications to monitor your device

Your team should be constantly aware of the status of your network. If any device goes down, the system will automatical...

System configuration New business opportunities with Splynx API

Splynx API

Splynx system is a powerful set of modules and open application interfaces (API), so we call it a Framework.

System configuration

Splynx self-registration

Splynx's self-registration functionality allows your clients to register and helps you skip the routine process of addin...

System configuration

Blocking of non-paying customers in Splynx

Splynx blocks non-paying customers automatically. The administrator can also block the customer manually.

System configuration Ubiquiti EdgeRouters pppoe Radius support

Ubiquiti EdgeRouters PPPoE RADIUS support

UBNT EdgeRouters can act as a PPPoE server, with authentication of CPEs, providing statistics, blocking end-users, and s...

Find out how Splynx helps ISPs grow

Learn more