Import parameters

Directory

/data/resource-groups

Files reference

  • filename : header

  • filename-levels : group levels

  • filename-values : group values

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.

Result specification

When the import is done, a file named resourcegrouplinks will be created to the import resource folder. This file is required for CSV import of resources.

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

2 characters max

Label

label

String

X

50 characters max

Validity end date

validityEndDate

String (ISO-8601)

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

If a resource group is reserved at an establishment, it is not possible to change this after, even to change the establishment.

Example

code;companyCode;establishmentCode;label;validityEndDate
01;01;;Group 1;
02;01;;Group 2;
03;01;;Group 3;2020-05-28T12:00:00Z

Levels

Data structure

Field Column Data type Required Business rules

Code

groupCode

String

X

10 characters max

Company code

companyCode

String

X

2 characters max

Level

level

Integer

X

Label

label

String

X

50 characters max

Example

groupCode;companyCode;label;level
01;01;Resources;0
01;01;Preparation;1
01;01;Production;2
02;01;Resources;0
02;01;Preparation;1
02;01;Production;2
03;01;Resources;0
03;01;Preparation;1
03;01;Production;2

Values

Data structure

Field Column Data type Required Business rules

Code

groupCode

String

X

10 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Level

level

Integer

X

Label

label

String

X

50 characters max

Value

value

String

X

20 characters max, if level is "0" then value is a resource code

Parent

upperLevelValue

String

20 characters max

French label

labelFr

String

50 characters max

English label

labelEn

String

50 characters max

Spanish label

labelEs

String

50 characters max

Portuguese label

labelPt

String

50 characters max

Example

groupCode;companyCode;establishmentCode;label;level;value;upperLevelValue;labelFr;labelEn;labelEs;labelPt
01;01;01;Value 0;0;VAL0;VAL1;Article;Item;Item;Item
01;01;01;Value 1;1;VAL1;VAL2;;Item;;
01;01;01;Value 2;2;VAL2;;;;Item;
02;01;01;Value 0;0;VAL0;VAL1;;;;Item
02;01;01;Value 1;1;VAL1;VAL2;;;;
02;01;01;Value 2;2;VAL2;;;;;
03;01;01;Value 0;0;VAL0;VAL1;;;;
03;01;01;Value 1;1;VAL1;VAL2;;;;
03;01;01;Value 2;2;VAL2;;;;;