Generic Import Source

This page provides a guide to configuring a Generic Import Source in Verba.

Verba’s capabilities are now further expanded by the Generic Import functionality: import any supported media - with CDR contained in .csv, .xml, or .json files - exported from your existing recordings directly to the Verba Platform. This feature enables you to import the files yourself or to significantly decrease handle time.

For a general description of Verba Import sources, please refer to Import sources.

Creating a genric import source

Step 1 - Open the Verba Web interface then select Data > Import Sources from the top menu

Step 2 - Click on the Add New Import Source link on the top right

Step 3 - Complete the configuration according to the requirements in the following table

Configuration item	Description
Name	Name your import source. This name will identify this source across the system
Type	Select Generic
Source Files Type	CSV JSON XML
CSV Separator	the delimiter character
Source Files Folder	Path to the files. Local storage or NAS is supported.
Custom cred	Field for credentials if the NAS requires it.
On Completion	Select the action taken for the successfully imported files.
Timezone	Timezone of the conversations in the file
Stop words	The list of possible denotations of empty value

Step 4 - Click Save to save the settings

Import / Export

All settings can be imported from, or exported to a JSON format, except the custom credential information.

After pressing the export configuration button the current configuration's JSON file will be available to copy to the clipboard. This configuration can be pasted into a different Verba instance, using the import configuration button.

Configuring CDR field mapping

These three pre-defined CDR fields are mandatory in the Verba recording system. It is possible that one of the fields is not specified in the import source, the system will accept any of the two out of the three, and calculate the third one. The Start Time and End Time fields can be configured for the format in the source, for the required time format, please refer to Generic Import Time/Date patterns.The Duration Interval is expected in seconds.

The full list of valid field can be found at Generic Import CDR fields.

Expression types

Constant

The constant expression type can be either a pre-defined value or an editable textbox depending on the Field.

Field

The field expression type is a pointer for a value in the source file. As the supported source file types have different structures, the setup for them differs slightly.

The import service is case sensitive for the fields.

CSV

For a CSV source file, the name of the column needs to be specified. Using the Column and the number of the call in the list the value can unambiguously defined

JSON

For a JSON source file, the required property names and array indexes need to be chained together.["Extensions"][1]["Office"]

The specification used is ECMA-404

XML

For an XML source file, the required property names and array indexes need to be chained together. The Attribute values can be referered to as well.

//Extensions/List[1] /Office

The specification used is XML 1.0 3rd edition

Function

The function expression type is a collection of tools for transforming the source data if needed, and combining fields if one to one mapping is not possible.

The full list of valid Functions can be found at Generic Import functions