File: Standard import of day types and events of a calendar

Voir la version française

Object of the interface

The interface allows importing day types and events of a calendar from third-party software into 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

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

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

Format

Text. UTF-8 encoding.

Separator between two information

The separator between two pieces of information is configurable. It can be vertical bar, semicolon, comma or tab.

Description of the file content

Order	Field name	Type	Max length	Notes
01	Date	Date	10	Mandatory
02	Nature of the element	EV for event  TJ for day type	2	Mandatory
03	Calendar code	Alphanumerical	38	Mandatory
04	Element code	Alphanumerical	EV = 16 TJ = 38	Mandatory. For events: use event codes. (16 characters) For day types: use the day type codes: JO, JF, JFF, JFO... (38 characters)

Rules

• For existing calendars, the existing labels are copied into the Code field. As a reminder, both fields have the same number of characters.
• A date can only be associated with one type of day. If several day types are present for the same date in the import file, the last line is inserted and the first lines are rejected. Details of rejected lines are available in the logs.
• A check is made at the time of import. If a date is already characterized by a day type (closed day, closed public holiday or open public holiday) in the database, then the import of a new day type for this same date cancels and replaces the old type of day. existing day before import.
• It is possible to import several events for the same date. To do this, you must import one line per event. It is possible to import 10 events for the same day. If the number of events is exceeded, the rows are rejected.
• If an event takes place over a period of several days, it is necessary to import a row for each day of the period.
• If a day type occurs over a period of several days, it is necessary to import a row for each day of the period.

Example of content

Example of file

01/01/2026;TJ;CALBRZ;JFO
06/04/2026;TJ;CALBRZ;JFO
01/05/2026;TJ;CALBRZ;JFF
08/05/2026;TJ;CALBRZ;JFO
14/05/2026;TJ;CALBRZ;JFO
25/05/2026;TJ;CALBRZ;JFO
14/07/2026;TJ;CALBRZ;JFO
15/08/2026;TJ;CALBRZ;JFF
01/11/2026;TJ;CALBRZ;JFO
11/11/2026;TJ;CALBRZ;JFO
25/12/2026;TJ;CALBRZ;JFF
18/10/2025;EV;CALBRZ;ZONEA
19/10/2025;EV;CALBRZ;ZONEA
20/10/2025;EV;CALBRZ;ZONEA
21/10/2025;EV;CALBRZ;ZONEA
22/10/2025;EV;CALBRZ;ZONEA
23/10/2025;EV;CALBRZ;ZONEA
24/10/2025;EV;CALBRZ;ZONEA
25/10/2025;EV;CALBRZ;ZONEA
26/10/2025;EV;CALBRZ;ZONEA
27/10/2025;EV;CALBRZ;ZONEA
28/10/2025;EV;CALBRZ;ZONEA