File: Absences specific export - Initial

Voir la version française

Object of the interface

The interface makes it possible to extract absences from the initial schedule available in Timesquare® so as to provide the expected information in a text file that can be read and interpreted by a third-party solution. This export can be done on demand or automatically.

Learn more about setting up this import.

File name

The file can be named in several ways depending on whether Timesquare generates a different file for each day or a single file containing one or more days of absence.

The file name is free (label + extension) but once defined in the export settings, it should not change.

Examples: Absence_A.txt, Absences_Timesquare.001, Absence.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	Format	Notes
Absence start date	Date	DD/MM/YYYY
Employee ID	Alphanumerical
Absence reason code	Alphanumerical
Absence start time	Numerical	HH:NN (hours and minutes) I indicate the day change time in case of complete absence
Absence end time	Numerical	HH:NN (hours and minutes) I indicate the day change time in case of complete absence

Rules

New! If an absence, a task or a notification present in the export is deleted after the export is created, it is also deleted from the export. If the deleted absence, task or notification is the last one in the configuration, it is not deleted and an error message is displayed when the export is executed.

Example of content

19/07/2021;MAT01;RTT;00:00;00:00;
19/07/2021;MAT02;CP;00:00;00:00;
21/07/2021;MAT05;MALA;09:00;12:00;