Import parameters

Directory

/data/resources

Files reference

  • filename : header

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

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Label

label

String

X

50 characters max

Nature

nature

String

X

IN(MACHINE=Machine,LABOR=Labor,STORAGE=Storage)

Area code

areaCode

String

10 characters max

Workshop resource type

workshopType

String

IN(PRODUCTION_LINE=Production line,SKILL=Skill)

Opening calendar code

openingCalendarCode

String

10 characters max

Max opening calendar code

maxOpeningCalendarCode

String

10 characters max

Hours per team

hoursPerTeam

Double

Validity end date

validityEndDate

String (ISO-8601)

AAAA-MM-JJTHH:MM:SSZ Set a passed date to make the entity inactive.

Example

code;companyCode;establishmentCode;label;nature;areaCode;openingCalendarCode;maxOpeningCalendarCode;hoursPerTeam;validityEndDate
01;02;03;TEST;MACHINE;001;01;02;52.3;2014-05-28T12:00:00Z
02;02;03;PREPARATION;LABOR;001;01;02;52.3;
03;02;03;PRODUCTION;STORAGE;001;01;02;52.3;2015-05-28T12:00:00Z

If technical data is exported from ERP VIF, this file is automatically generated by importing resource groups.

Data structure

Field Column Data type Required Business rules

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Reference group code

groupCode

String

X

Resource code

resourceCode

String

X

20 characters max

Reference value code

valueCode

String

X

Example

companyCode;establishmentCode;groupCode;resourceCode;valueCode
C1;01;REGRES1;RESS1;VALREG1
C1;01;REGRES1;RESS1;VALREG2