Import parameters

Directory

/data/customer-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 customergrouplinks will be created to the import customer folder. This file is required for CSV import of customers.

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

Description

description

String

500 characters max

Validity end date

validityEndDate

String (ISO-8601)

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

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

Example

code;companyCode;label;validityEndDate
01;02;TEST;2014-05-28T12:00:00Z
01;02;PREPARATION;
01;02;PRODUCTION;2015-05-28T12:00:00Z

Levels

Data structure

Field Column Data type Required Business rules

Code

groupCode

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

Level

level

Integer

X

Label

label

String

X

50 characters max

Example

groupCode;companyCode;label;level
01;02;TEST;1
01;02;PREPARATION;1
01;02;PRODUCTION;2

Values

Data structure

Field Column Data type Required Business rules

Code

groupCode

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

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 customer code

Parent

upperLevelValue

String

20 characters max

Example

groupCode;companyCode;label;level;value;upperLevelValue
01;02;TEST;1;VAL1;VAL0