Import parameters

Directory

/data/customers

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

Nature

nature

String

IN(CUS=Customer,PRO=Prospect,OOC=Other customer,DVT=Delivered to)

Reference

deliveredTo

String

10 characters max

Reference data

referenceDate

String

IN(ORD=Order date, SHI=Expedition date,DEL=Delivery date)

Validity end date

validityEndDate

String (ISO-8601)

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

Example

code;companyCode;label;validityEndDate;nature;deliveredTo;referenceDate
01;02;CUST1;2014-05-28T12:00:00Z;CUS;08;SHI
01;02;CUST2;;;;
01;02;CUST3;2015-05-28T12:00:00Z;;;

If technical data is exported from ERP VIF, this file is automatically generated by importing customer 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

Customer code

customerCode

String

X

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

Reference value code

valueCode

String

X

Example

companyCode;establishmentCode;groupCode;customerCode;valueCode
C1;null;REGCLI1;CLI1;VALREG1
C1;null;REGCLI1;CLI2;VALREG1