Skip to end of metadata
Go to start of metadata

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 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.

The license could not be verified: License Certificate has expired!

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

NameName your import source. This name will identify this source across the system
TypeSelect 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

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

  • No labels