Import parameters

Directory

/data/items

Files reference

  • filename : header

  • filename-conversions : unit conversions

  • filename-groups : groups links

  • *(optional) filename-substitutes* : substitute items

  • *(optional) filename-downgraded* : downgraded items

  • *(optional) filename-sites* : expedition sites

  • *(optional) filename-qualityinfos* : quality infos

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

20 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

Label

label

String

X

50 characters max

Short label

shortLabel

String

12 characters max

First unit code

firstUnitCode

String

X

5 characters max

Second unit code

secondUnitCode

String

5 characters max

Price unit code

priceUnitCode

String

5 characters max

Customer’s price unit code

consumerPriceUnitCode

String

5 characters max

Normalized item code

GTIN

String

14 characters max

Outer

outer

Integer

9999

Related to all expedition sites

allExpeditionSites

Boolean

Validity end date

validityEndDate

String (ISO-8601)

YYYY-MM-DDTHH:MM:SSZ

First stock unit code

firstStockUnitCode

String

5 characters max

Second stock unit code

secondStockUnitCode

String

5 characters max

Third stock unit code

thirdStockUnitCode

String

5 characters max

Sales description

salesDescription

String

350 characters max

Example

code;companyCode;label;validityEndDate;firstUnitCode;secondUnitCode;firstStockUnitCode;secondStockUnitCode;thirdStockUnitCode
01;02;TEST;2014-05-28T12:00:00Z;KG;MG;;;
01;02;PREPARATION;2014-05-28T12:00:00Z;KG;MG;;;
01;02;PRODUCTION;2015-05-28T12:00:00Z;KG;MG;;;

Item unit conversions

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Reference unit code

referenceUnitCode

String

X

5 characters max

Reference quantity

referenceQuantity

Double

X

Unit code

unitCode

String

X

5 characters max

Quantity

quantity

Double

X

Constant quantity

isConstantQuantity

Boolean

X

Example

itemCode;companyCode;referenceUnitCode;referenceQuantity;unitCode;quantity;isConstantQuantity
01;02;KG;10.2;PAL;1;true
01;02;PAL;1;L;1;false

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

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Reference group code

groupCode

String

X

Reference value code

valueCode

String

X

Example

itemCode;companyCode;establishmentCode;groupCode;valueCode
01;02;03;CADENCE;C100
C32;02;03;TYPCLIENT;GMS

Substitute items

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Substitute item code

substituteItemCode

String

X

20 characters max

Example

itemCode;companyCode;substituteItemCode
01;02;03
01;02;04
01;02;05

Downgraded items

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Downgraded item code

downgradedItemCode

String

X

20 characters max

Example

itemCode;companyCode;downgradedItemCode
01;02;03
01;02;04
01;02;05

Expedition sites

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Expedition site code

expeditionSiteCode

String

X

10 characters max

Example

itemCode;companyCode;expeditionSiteCode
01;02;03
01;02;04
01;02;05

Quality information

Data structure

Field Column Data type Required Business rules

Code

itemCode

String

X

20 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

Use duration

useDuration

Double

X

Locking duration

lockingDuration

Double

X

Preservation duration

preservationDuration

Integer

Preservation duration unit

preservationDurationUnit

String

X (only if preservationDuration is added)

DAYS or MONTHS

Optimal preservation duration

optimalPreservationDuration

Integer

Shipping guaranteed duration

shippingGuaranteedDuration

Integer

Example

itemCode;companyCode;establishmentCode;useDuration;lockingDuration;preservationDuration;preservationDurationUnit;optimalPreservationDuration;shippingGuaranteedDuration
01;02;03;0.0;1.0;5;DAYS;2;3
01;02;04;2.0;3.0;1;MONTHS;1;6
01;02;05;5.0;6.0;10;DAYS;7;4