File: Standard export of coverage

Voir la version française

Object of the interface

The interface makes it possible to extract the coverage (needs, resources, shortages and surpluses) built with Timesquare® so as to make the expected information available in a text file that can be read and interpreted by a third-party software solution. This export can be done on demand or automatically..

Learn more about setting up this export.

File name

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

Unique files

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

Examples: Coverage.txt, Actual_Timesquare.001.

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	Format	Notes
01	Task concerned	Alphanumerical	Code de la tâche
02	Date	DD/MM/YYYY
03	Start time timeslot	HH:NN
04	End time timeslot	HH:NN
05	Needs	Numerical
06	Resources	Numerical
07	Shortages	Numerical	In value or in percentage
08	Surpluses	Numerical	In value or in percentage
09	Time zone	Alphanumerical	Appears if the option is selected

Rules

If a task present in the export is deleted after the export is created, it is also deleted from the export. If the deleted absence 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

In values

AEA;03/08/2020;0800;0815;8;7;-1;0 
AEA;03/08/2020;0815;0830;9;9;0;0 
AEA;03/08/2020;0830;0845;9;9;0;0 
AEA;03/08/2020;0845;0900;10;12;0;2

In percentage

AEA;03/08/2020;0800;0815;8;7;-12.50;0 
AEA;03/08/2020;0815;0830;9;9;0;0 
AEA;03/08/2020;0830;0845;9;9;0;0 
AEA;03/08/2020;0845;0900;10;12;0;20,00