File: Standard export of mobile workload

Voir la version française

Object of the interface

The aim is to import mobile workloads expressed in number of necessary work hours for each time slot. The principle consists in making available information in a text file, which will be read and interpreted by the interface in order to update 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 mobile workload.

Undated file (custom label)

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

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

Dated files (with date pattern)

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 task1_JJMMAA.txt and the three import files are named task1_040520.txt, task1_050520.txt and task1_060520.txt.

Example 2: the Label field in the configuration is named workloadsiteAAAAMMJJ.001 and the three import files are named workloadsite20200504.001, workloadsite20200505.001 and workloadsite20200506.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

Field name	Type	Length	Notes
Task code	Alphanumerical	50	With no space and no special character
Date	Date		DD/MM/YYYY (day, month, year)
Start time interval	Time		HH:NN (hours, minutes)
Start time interval	Time		HH:NN (hours, minutes)
Value	Numerical		Integer, Number of minutes

Example of content

File example

BRZFF;13/02/2026;10:00;19:00;2,00
BRZFF;14/02/2026;10:00;19:00;3,00
BRZFF;15/02/2026;10:00;19:00;4,00
BRZFF;16/02/2026;10:00;19:00;2,00
BRZFF;17/02/2026;10:00;19:00;3,00
BRZFF;18/02/2026;10:00;19:00;2,00
BRZFF;19/02/2026;10:00;19:00;2,00
BRZFF;20/02/2026;10:00;19:00;4,00
BRZFF;21/02/2026;10:00;19:00;2,00
BRZFF;22/02/2026;10:00;19:00;2,00