File: Standard import of schedule patterns

Voir la version française

Object of the interface

The interface allows you to import schedule patterns to Timesquare. The principle is to make the expected information available in a text file which 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.

Examples: SchedulePatterns_A.txt, SchedulePatterns_Timesquare.001, SchedulePatterns.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

Order	Field name	Type	Notes
01	Pattern code	Alphanumerical	12 characters maximum
02	Pattern label	Alphanumerical	38 characters maximum
03	Structure code	Alphanumerical	Empty if employee concerned
04	Employee ID	Alphanumerical	Empty if employee concerned
05	Activ	Numerical	0 for No 1 for Yes
06	Calendar Code	Alphanumerical
07	Pattern type	Numerical	1 for Daily 7 for Weekly n for Periodic of n days (n> 1 and n <> 7)
08	Available for the Library	Numerical	0 for No 1 for Yes
09	Available for schedules	Numerical	0 for No 1 for Yes
10	Pattern day number	Numerical	1 for daily 1 to 7 for weekly 1 to n for periodic
11	Work period nature 1	Numerical	0 for fixed work period 1 for variable work period Empty if no work period
12	Telecommuting work period 1	Numerical	0 for fixed site 1 for variable site 2 for fixed telecommuting 3 for variable telecommuting Empty if no work period
13	Work period nature 2	Numerical	0 for fixed work period 1 for variable work period Empty if no work period
14	Telecommuting work period 2	Numerical	0 for fixed site 1 for variable site 2 for fixed telecommuting 3 for variable telecommuting Empty if no work period
15	Nature activity 1	Alphanumerical	T for Task R for Rest AC for Complete absence AP for Partial absence
16	Start time of activity 1	Time	HH:NN (hours, minutes)
17	End time of activity 1	Time	HH:NN (hours, minutes)
18	Activity code 1	Alphanumerical	Task code Absence code Empty if rest Empty or "N/A" for unassigned task
19	Property activity 1	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
20	Nature activity 2	Alphanumerical	T for Task AP for Partial absence
21	Start time of activity 2	Time	HH:NN (hours, minutes)
22	End time of activity 2	Time	HH:NN (hours, minutes)
23	Activity code 2	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
24	Property activity 2	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
25	Nature activity 3	Alphanumerical	T for Task AP for Partial absence
26	Start time of activity 3	Time	HH:NN (hours, minutes)
27	End time of activity 3	Time	HH:NN (hours, minutes)
28	Activity code 3	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
29	Property activity 3	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
30	Nature activity 4	Alphanumerical	T for Task AP for Partial absence
31	Start time of activity 4	Time	HH:NN (hours, minutes)
32	End time of activity 4	Time	HH:NN (hours, minutes)
33	Activity code 4	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
34	Property activity 4	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
35	Nature activity 5	Alphanumerical	T for Task AP for Partial absence
36	Start time of activity 5	Time	HH:NN (hours, minutes)
37	End time of activity 5	Time	HH:NN (hours, minutes)
38	Activity code 5	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
39	Property activity 5	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
40	Nature activity 6	Alphanumerical	T for Task AP for Partial absence
41	Start time of activity 6	Time	HH:NN (hours, minutes)
42	End time of activity 6	Time	HH:NN (hours, minutes)
43	Activity code 6	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
44	Property activity 6	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
45	Nature activity 7	Alphanumerical	T for Task AP for Partial absence
46	Start time of activity 7	Time	HH:NN (hours, minutes)
47	End time of activity 7	Time	HH:NN (hours, minutes)
48	Activity code 7	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
49	Property activity 7	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
50	Nature activity 8	Alphanumerical	T for Task AP for Partial absence
51	Start time of activity 8	Time	HH:NN (hours, minutes)
52	End time of activity 8	Time	HH:NN (hours, minutes)
53	Activity code 8	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
54	Property activity 8	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
55	Nature activity 9	Alphanumerical	T for Task AP for Partial absence
56	Start time of activity 9	Time	HH:NN (hours, minutes)
57	End time of activity 9	Time	HH:NN (hours, minutes)
58	Activity code 9	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
59	Property activity 9	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
60	Nature activity 10	Alphanumerical	T for Task AP for Partial absence
61	Start time of activity 10	Time	HH:NN (hours, minutes)
62	End time of activity 10	Time	HH:NN (hours, minutes)
63	Activity code 10	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
64	Property activity 10	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
65	Nature activity 11	Alphanumerical	T for Task AP for Partial absence
66	Start time of activity 11	Time	HH:NN (hours, minutes)
67	End time of activity 11	Time	HH:NN (hours, minutes)
68	Activity code 11	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
69	Property activity 11	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
70	Nature activity 12	Alphanumerical	T for Task AP for Partial absence
71	Start time of activity 12	Time	HH:NN (hours, minutes)
72	End time of activity 12	Time	HH:NN (hours, minutes)
73	Activity code 12	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
74	Property activity 12	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence
75	Nature activity 13	Alphanumerical	T for Task AP for Partial absence
76	Start time of activity 13	Time	HH:NN (hours, minutes)
77	End time of activity 13	Time	HH:NN (hours, minutes)
78	Activity code 13	Alphanumerical	Task code Absence code Empty or "N/A" for unassigned task
79	Property activity 13	Numerical	0 for fixed task 1 for variable task Empty for rest of ou absence

Rules

• If the schedule pattern concerns a person, the employee ID is mandatory and the structure code must be empty. If the schedule pattern concerns a structure, the structure code is mandatory and the employee ID must be empty.
• The maximum number of tasks allowed in a template is 13.
• Fields 20 to 79 are optional.
• Fields 01 to 09 are useful for creating the pattern and filling in the information available in the
  pattern creation panel.
  The imported models cannot be models with variable limits, they are therefore created in the
  database so that the “BORNES_VARIABLES” field of the “Modele_horaire” table takes the value
  0.
• Field 10 allows you to indicate the number of the pattern day concerned by fields 11 to 79.
  Note: It must take the value 1 for a daily pattern, 7 for a weekly pattern or n with n> 1 and
  different from 7 for a periodic pattern.
• When creating a weekly or periodic pattern, there are as many rows as there are non-empty
  days for the pattern and for each of these rows, fields 01 to 09 are filled in identically.
• When creating a pattern, field 03 or 04 must be entered. 
• During a modification, only the pattern code #01 and the fields to be modified are mandatory
  among fields 01 to 09. In that case, fields 03 or 04 must be empty.
• Fields 11 to 15 are used to define the fixed or telecommuting characteristics of the ranges of
  the day concerned.
• Tasks are all considered fixed.
• Fields 16 to 79 contain the information to be inserted as:
  • Rest day
  • Day of absence
  • Partial absence
  • Task
• Beware of task codes, absences or calendar, make sure that they are all available at the creation
  level of the schedules pattern.
  • Calendar not available: the pattern cannot be created
  • Task not available code: task not assigned
  • Absence code not available: the schedules pattern day cannot be created, the row is rejected
• The import cancels and replaces the existing schedule pattern day. 
  Work periods, partial absences, days of complete absences or rest are replaced by the data
  which is imported.
• A work period or a partial absence period must necessarily start and end at a multiple time of
  the schedule granularity to be imported.
• To enter a rest, it is necessary to enter the day change time for the start time and the day change time for the end time.

Example of content

QS001;Daily_Structure;STRLYON;;1;CALLYON;1;1;0;1;0;0;0;0;T;10:15;15:15;T01;0;T;17:00;21:00;T01;0 
QP001;Daily_Personne;;LYON;1;CALLYON;1;1;1;1;0;0;;;T;08:00;13:00;T02;0 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;1;0;1;0;1;T;08:00;11:00;;;T;12:30;15:30 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;2;0;0;0;0;T;08:00;11:00;;;T;12:30;15:30 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;3;;;;;R 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;4;0;0;0;0;T;08:15;11:15;;;T;12:45;15:45 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;5;0;0;0;0;T;08:00;11:00;;;T;12:30;15:30 
HS002;Weekly_Structure;STRLYON;;1;CALLYON;7;1;1;6;0;0;0;0;T;08:00;11:00;;;T;12:30;15:30 
PS001;Periodic_Structure;STRLYON;;1;CALLYON;3;1;1;1;0;0;0;0;T;10:00;12:00;T01;1;12:00;13:00;T02;1;13:00;17:00;T01;1 
PS001;Periodic_Structure;STRLYON;;1;CALLYON;3;1;1;2;R 
PS001;Periodic_Structure;STRLYON;;1;CALLYON;3;1;1;3;R