Import parameters

Directory

/data/day-templates

Files reference

  • filename : header

  • filename-periods : day periods

Other parameters

Import mode

Imports can be done with "full" or "update" mode.

  • Full mode : All entities in the file but not in the target application are created. All entities present in the target application but not in the file are deleted. The others are updated.

  • Update mode : same as "full" mode except that the entities present in the target application but not in the file are not deleted.

Files content

Data structure

Field Column Data type Required Business rules

Code

code

String

X

10 characters max
All characters in uppercase accepted except characters \ ; | " < > µ and spaces at the beginning and at the end

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Label

label

String

X

50 characters max

Color

color

String (hexadecimal)

7 characters max

Style

style

String

Within (MAINTENANCE=Maintenance, HOLIDAY=Holiday, NOT_WORKED=Not worked)

Validity end date

validityEndDate

String (ISO-8601)

YYYY-MM-DDTHH:MM:SSZ Set a passed date to make the entity inactive.

Example

code;companyCode;establishmentCode;label;validityEndDate;color;style
01;02;03;TEST;2014-05-28T12:00:00Z;#FF0000;style1
01;02;03;PREPARATION;;;
01;02;03;PRODUCTION;2015-05-28T12:00:00Z;;

Day periods

Data structure

Field Column Data type Required Business rules

Code

dayTemplateCode

String

X

10 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Begin hour

beginHour

String

X

HH:MM

End hour

endHour

String

X

HH:MM

Production day

productionDay

String

X

IN(CURRENT,PREVIOUS,NEXT)

Team code

teamCode

String

15 characters max

Example

dayTemplateCode;companyCode;establishmentCode;beginHour;endHour;productionDay;teamCode
01;02;03;11:23;23:23;CURRENT;MATIN
01;02;03;23:23;07:23;NEXT;APREM