File: Standard import of schedule pattern programming

Voir la version française

Object of the interface

The interface allows you to import schedule pattern programming into Timesquare®. The principle is to provide the expected information in a text file that will be read and interpreted by the interface in order 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.

Examples: SchedulePatternsProgramming_A.txt, SchedulePatternsProgramming_Timesquare.001, SchedulePatternsPg.csv.

Format

Text. UTF-8 encoding.

Separator between two information

The separator between two pieces of information is the semicolon, comma, tab or bar
vertical.

Description of the file content

#	Field name	Type	Max size	Note
01	Employee concerned	Alphanumerical	20	Identification
02	Label	Alphanumerical	30	Label filled + prefix (if there is)
03	Application start date	Date	10	According to the format selected in the configuration
04	Application end date	Date	10	According to the format selected in the configuration
05	Calendar code	Alphanumerical	40
06	Event code	Numerical	15	Empty = All
07	Number of periods	Numerical	2	From 1 to 99
08	Periodicity	Numerical	2	From 1 to 99 Empty = 1
09	Periodicity type	Numerical	2	1 = daily 7 = weekly 30 = monthly Vide = daily
10	Pattern type 1	Numerical	2	1 = daily 7 = weekly n = periodic of n days (n > 1 and n<>7)
11	Schedule pattern code 1	Alphanumerical	12
12	Pattern type 2	Numerical	2	Optional field. I use it if I have 2 schedule patterns on my programming. 1 = daily 7 = weekly n = periodic of n days (n > 1 and n<>7)
13	Schedule pattern code 2	Alphanumerical	12	Optional field. I use it if I have 2 schedule patterns on my programming.
14	Pattern type N	Numerical	2	Optional field. I use it if I have n schedule patterns on my programming. 1 = daily 7 = weekly n = periodic of n days (n > 1 and n<>7)
15	Schedule pattern code N	Alphanumerical	12	Optional field. I use it if I have n schedule patterns on my programming.

Rules

Fields 12 to 15 are optional. They depend on the number of schedule patterns in my programming.

Example of content

M200;Import de programmation de MH;01/06/2022;30/06/2022;Calendrier Paris;;1;1;1;1;ModeleLundi