File: Avaya specific import

Voir la version française

Object of the interface

The purpose of this interface is to enable the automatic import of stored data as inbound calls and average call times by time slot. Thus, to make available the expected information in a text file which will be read and interpreted by the interface in order to update the data stored in the Timesquare® database.

Learn more about setting up this import.

File name

The file can be named in two different ways depending upon the third system which may build one different file for each day or a unique file containing one or more days of historical data.

Unique files

File name is free (Text + extension), but once it has been defined in the import setup it should not be
changed.

Example 1: the Label field in the configuration and the import file are both named incomingflows.txt.

Example 2: the Label field in the configuration and the import file are both named
history_Timesquare.001

Fichiers multiples

The file name must comply with a specific syntax including the date of the data provided. The Label field must define the naming chosen. Thus, LabelJJMMAAAA.EXT, LabelJJMMAA.EXT, LabelAAAAMMJJ.EXT or LabelAAMMJJ.EXT are the supported wordings in which:

• "Label" is made of a string of alphanumerical characters that can be personalized
• "JJ" stands for the day (DD), "MM" stands for the month, "AA" and "AAAA" stands for the year (YY or YYYY), that can be indifferently written with 2 or 4 characters
• "EXT" is an alphanumerical string with 3 characters maximum that can be personalized

Example 1: the Label field in the configuration is named site1_JJMMAA.txt and the three import files are
named site1_040520.txt, site1_050520.txt and site1_060520.txt.

Example 2: the Label field in the configuration is named siteflowAAAAMMJJ.001 and the three import
files are named siteflow20200504.001, siteflow20200505.001 and siteflow20200506.001.

Example 3: the Label field in the configuration is named AAMMJJ.txt and the three import files are
named 040520.txt, 050520.txt et 060520.txt.

Format

Text. UTF-8 encoding.

Separator between two information

The separator between two pieces of information is the semicolon (;).

Description of the file content

Order	Field name	Type	Notes
01	Site identifier	Alphanumerical	No space or special character
02	Date	Date	DD/MM/YYYY or DDMMYYYY
03	Start time slot	Time	HH:NN (hours, minutes)
04	End time slot	Time	HH:NN (hours, minutes)
05	Inbound calls	Numerical	Integer
06	Picked up call	Numerical	Integer
07	Average call length	Time	NN:SS (minutes and seconds)

Example of content

99999;20/09/2019;08:00;08:15;1;1;02:36
99999;20/09/2019;08:15;08:30;1;1;00:35
XYZW123456;20/09/2019;08:15;08:30;1;1;01:36
99999;20/09/2019;08:30;08:45;1;1;03:11
XYZW123456;20/09/2019;08:30;08:45;5;4;02:16
99999;20/09/2019;08:45;09:00;2;1;05:00
XYZW123456;20/09/2019;08:45;09:00;25;23;02:22
99999;20/09/2019;09:00;09:15;12;10;02:01