FAQ - Excel format for lenses - Options tab

Tab	Possible fields and values for enumerations	Example	Mandatory/ Optional / Conditional	Additional informations
General	Manufacturer code	IZY	Mandatory
	Name manufacturer	iZySolutions	Mandatory
	Distributor code	IZY	Mandatory
	Distributor name	iZySolutions	Mandatory
	Name	SAR++	Mandatory
	Short name		Optional
	Manufacturer Product Code	MBL	Mandatory
	Distributor product code		Optional
	Order code	MBL	Mandatory
	Internal code		Optional
	Option type 01 : Special manufacturing 04 : Tint 05 : Coating 06 : Combined Option 07 : Option pack	05	Mandatory
	Special option type 01 : Thickness optimization 02 : Prismatic effect 04 : Mounting 05 : Edging 06 : special base curve 07 : Balancing 08 : Other 81 : Comfort addition 80 : CouloirProgression		Conditional	If the data Type of option = 01
	Thickness optimization type 01 : Manufacturer calculation 02 : Inset 05 : Special diameter 03 : Special thickness 04 : Knife edge 06 : Elliptic lens 07 : Round lens		Conditional	If the data Type of option = 01 and the data Type of special production = 01
	Prismatic effect type 02 : Prismatic balancing 01 : Prescribed prismatic effect 03 : Prismatic slab-off		Conditional	If the data Type of option = 01 and the data Type of special production = 02
	Type of tint 1 : less than 15% absorption 2 : Standard 4 : Gradient-tinted 5 : Double gradient-tinted 6 : Triple gradient-tinted 7 : Special		Conditional	If the data Type of optiont = 04
	Type of antireflective coating 5 : Multiple AR 9 : Back surface AR 2 : Single AR 8 : Super AR		Conditional	If the data Type of option= 05
	Type of edging 1 : With traced form 2 : In a provided frame 3 : In ordered stock frame		Conditional	If the data Type of option = 01 and the data Type of special manufacture= 04
	Control option 0 : No 1 : Yes			If empty then the value will be 0.
	Requires a tint 0 : No 1 : Yes	1		If empty then the value will be 0.
	Integrated option 0 : No 1 : Yes			If empty then the value will be 0.
	Allowed materials 0 : Mineral 1 : Organic 2 : Polycarbonate 3 : Trivex		Destiné au SF6	If empty then all materials are allowed otherwise put the material codes separated by one; if at least two are available.
	Option type Optimeyes 01 : Precal 04 : Coloration 02 : Antireflective 03 : Varnish 05 : Surface option	02	Mandatory
	Nature of control 00 : None 01 : Precal 02 : Prism 03 : Inset 04 : Special thickness 05 : Gradient tint 06 : Double gradient-tinted 07 : Oval facet 08 : Remote edging 09 : Special base 10 : Knife 11 : Special diameter 12 : Balance prism 13 : Balancing thicknesses 14 : Balancing weight 15 : Balancing bases 51 : Custom lens 69 : Birthday 59 : SPH/CYL 1/100°	00	Mandatory
	Groupment code		Optional
	Public product code		Conditional	Put the product code of the public version only if a groupment is filled in.
Technical	Processing Visibility 0 : No 1 : Yes	1		If empty then the value will be 0.
	Application to both lenses 0 : No 1 : Yes	1		If empty then the value will be 0.
	Available for order. 0 : No 1 : Yes	1		If empty then the value will be 0.
	Prism min.		Conditional Conditional	Si la donnée Type de supplément = 01, la donnée Type de fabrication spéciale = 02 et la donnée Type d'effet prismatique = 01
	Max. prism		Conditional Conditional
	Restriction CEN 0: No restriction 1: Not recommended for night driving 2: Not recommended for driving 3: Depends on center thickness and anti-reflective coating 4: No information provided	0	Mandatory for the European market
	alternative Restriction CEN 0: No restriction 1: Not recommended for night driving 2: Not recommended for driving		Conditional	A renseigner si la donnée Restriction CEN est complétée avec les valeurs 3 ou 4.
	CEN Category 0 : Confort 1 : Low luminosity 2 : Average luminosity 3 : High lumonisity 4 : Exceptionnal luminosity	0	Mandatory for the European market
	Photochromic filter 0 : No 1 : Yes	0		Si vide alors la valeur sera 0.
	Absorption (top)		Conditional	If the data Type of option = 04
	tint		Conditional	If the data Type of otpion = 04 (to be entered in hexadecimal)
	Color (middle)		Conditional	If the optionType data = 04 and the Tinting Type data = 6 (to be entered in hexadecimal)
	Absorption (bottom)		Conditional	If option Type = 04 and Tinting Type = 4, 5 or 6
	Color (bottom)		Conditional	If option Type = 04 and Tinting Type = 4, 5 or 6 (to be entered in hexadecimal)
	Mirror effect 0 : No 1 : Yes	1		If empty then the value will be 0.
	Hard coating 0 : No 1 : Yes	1		If empty then the value will be 0.
	Clean coating 0 : No 1 : Yes	1		If empty then the value will be 0.
	UV coating on the front side 0 : No 1 : Yes	0		If empty then the value will be 0.
	UV coating on the back side 0 : No 1 : Yes	0		If empty then the value will be 0.
	Polarized filter 0 : No 1 : Yes	0		If empty then the value will be 0.
	Hydrophobic 0 : No 1 : Yes	0		If empty then the value will be 0.
	Flash effect 0 : No 1 : Yes	0		If empty then the value will be 0.
	Coupure de la lumière bleue 0 : Non 1 : Oui	0		If empty then the value will be 0.
	Blue cut light 0 : No 1 : Yes	0		If empty then the value will be 0.
	Antiglare 0 : No 1 : Yes	0		If empty then the value will be 0.
	Contact angle	Specificity SF6	Optional
	Display order
	Increases the contrast 0 : No 1 : Yes			If empty then the value will be 0.
	UV cut-off
Marketing	Action 1 : Edit 2 : Delete	1	Mandatory
	Validity start date		Optional
	Validity end date		Optional
	Additional delay	0100	Optional	Should be completed in 4 digits. The first two (on the left) correspond to the number of days, the next two to the number of hours.
	Remisable 0 : No 1 : Yes 2 : Depends on the lens	Specificity SF6	Optional	If empty then the value will be 0.
	URL manufacturer		Optional
	URL distributor		Optional
	Other information		Optional
	Essential characteristic		Mandatory for the French market	Description for the consumer. No abbreviation.
	Creation date		Optional	If empty then the current date will be shown
	Modification date		Optional	If empty then the current date will be shown

iZySolutions - Documentation