File: Standard import of notifications

Voir la version française

Object of the interface

The interface is used to import the notifications from a third-party system into Timesquare. The objective is to make available the expected information in a text file that will be read and interpreted by the interface so as to update the database.

Learn more about setting up this import.

File name

The name of the file is up to the user (label + extension) but once defined in the setting of the import, it must not change anymore. It may contain information concerning one or more counters relating to one or more employees.

Examples: Notifications_A.txt, Notifications_Timesquare.001, Notifications.csv.

Format

Text. UTF-8 encoding.

Separator between two information

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

Description of the file content

Field name	Type	Note	Mandatory
Structure code	Alphanumerical		Yes
Notification code	Alphanumerical	It must be a unique value.	Yes
Notification label	Alphanumerical	It must be a unique value.
Colour	Alphanumerical	Hexadecimal code. Example: #E11C2E
Qualifying	Alphanumerical	0 for No. 1 for Yes.
Task code 1	Alphanumerical
Skill level 1	Alphanumerical	Skill level code
Contribution level 1	Alphanumerical
Task code 2	Alphanumerical
Skill level 2	Alphanumerical	Skill level code
Contribution level 2	Alphanumerical

Rules

By default, if the Qualifying fiel dis empty, the field is valued 0: the task is not qualifying.

If the Colour fiel dis empty, the field is valued with the first value of the color list in the database.

If the notification is qualifying (value 1), there must be a combination of task code / skill level / contribution level soi t is correctly imported.

Example of content

STRUCTURE1;CONV1;Imported notification 01;#E11C2E;0 
STRUCTURE1;CONV2;Imported notification 02;#94C5D0;0 
STRUCTURE2;CONV3;Imported notification 03;#26BCD7;1;TACHE1;2;Optimum 
STRUCTURE2;CONV4;Imported notification 04;#97971F;1;TACHE2;3;Medium; TACHE1;1;Optimum