iZySolutions - Documentation

FAQ - Excel format for lenses - Lenses tab

Below you will find the complete description of the Excel catalog format of the Lenses tab. If field lengths are not specified you can find them in our documentation. The same goes for the exact description of the fields. Here the goal is to offer help on how to enter the different information.

Tab

Possible fields and values for enumerations

Example

Mandatory / Optional / Conditional

Additional information

General

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Manufacturer code

IZY

Mandatory

 

Name manufacturer

iZySolutions

Mandatory

 

Distributor code

IZY

Mandatory

 

Distributor name

iZySolutions

Mandatory

 

Name

1,53 Photo Grey

Mandatory

Must take into account your export format (60 max.)

Short name

 

Optional

 

Manufacturer Product Code

A001XX

Mandatory

Code of the lens

Distributor product code

 

Optional

 

Order code

A001XX

Mandatory

Order code of the lens

Internal code

 

Optional

 

Lens type
0 : Afocal
1 : Single vision
2 : Bifocal
3 : Trifocal
4 : Progressive
5 : Intermediate

1

Mandatory

 

Type de verre pour remboursement
0 : Neutral
1 : Single vision
2 : Multifocal
4 : Progressive

1

Mandatory for the French market

 

Geometry
0 : Spherical

1 : Aspherical

2 : Toro-elliptical

0

Mandatory

 

Material
0 : Mineral

1 : Organic

2 : Polycarbonate

3 : Trivex

3

Mandatory

 

Material

TVX

Optional

 

Real refractive index

1,530

Mandatory

 

Reference refractive index

1,53

Mandatory

 

Code Sign

 

Optional

 

Public product code

 

Conditional

Put the product code of the public version only if a sign is filled in.

Technical

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Marking
0 : no
1 : yes

1

 

If empty then the value will be 0.

Engraved reference circle

0 : no
1 : yes

1

 

If empty then the value will be 0.

Signed lens
0 : no
1 : yes

1

 

If empty then the value will be 0.

Presence of titanium
0 : no
1 : yes

0

 

If empty then the value will be 0.

Lenticular lens
0 : no
1 : yes

0

 

If empty then the value will be 0.

Selective distribution
0 : no
1 : yes

0

 

If empty then the value will be 0.

Aphakik
0 : no
1 : yes

0

 

If empty then the value will be 0.

Engraved addition
0 : no
1 : yes

0

 

If empty then the value will be 0.

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

1

Mandatoryfor the European market

 

Restriction CEN alternative
0: No restriction

1: Not recommended for night driving

2: Not recommended for driving

 

Conditional

To be filled in if CEN Restriction is filled in with values 3 or 4.

CEN Category
0 : Confort
1 : Low luminosity
2 : Average luminosity
3 : High lumonisity
4 : Exceptionnal luminosity

1

Mandatory for the European market

 

Photochromic
0 : No

1 : Yes

1

 

If empty then the value will be 0.

Tinted
0 : No

1 : Yes

0

 

If empty then the value will be 0.

Aspherical diameter

 

Optional

 

Absorption infrarouge

 

Optional

 

Density

1,32

Optional

 

Number of abbe

35

Optional

 

Alpha protection

 

Optional

 

UVA absorption

 

Optional

 

UVB Absorption

 

Optional

 

Vertical distance from the minimum centering cross

Multi-focal only

Conditional

For the type of lens

  • Progressive

  • Mid-distance

  • Bifocal

  • Trifocal

Vertical distance from the maximum centering cross

Vertical distance vision

Horizontal distance vision

Min. distance for vertical near vision

Max. vertical near vision distance

Minimum distance for horizontal near vision

Max. horizontal near vision distance

Minimum mounting height

VP segment type
0 : Curved

1 : Straight

2 : Pantoscopic

3 : Round

4 : Executive

Bifocal

Trifocal

Conditional

 

Visible segment edge
0 : No

1 : Yes

If empty then the value will be 0.

Lower radius of the VP segment

 

Upper radius of the VP segment

Width of the VP segment

Height of the VP segment

Distance geometric center of the segment VP

Upper radius intermediate vision segment

 

 

Intermediate vision segment height

 

 

Display order

Specificity SF6

Optional

 

Command lens only
0 : Not possible
1 : Possible
2 : With fictive opposite lens

Optional

 

Percentage of total price for lens scales

Optional

 

Addition/deletion proximity lens

0 : No specification required
1 : Specify distance + addition
2 : Specify near + power decrease

Optional

 

Increases the contrast

0 : no
1 : yes

Optional

If empty then the value will be 0.

Marketing

 

 

 

 

 

 

 

 

 

Action
1 : Modified

2 : Deleted

Commercially active

1 : modified

2 : deleted = closed

 

 

Start of validity

 

Optional

 

End of validity

 

Optional

 

Refund class
A : Class A

B : Class B

Z : No class

A

Mandatory for the French market

 

Manufacturer's URL

 

Optional

 

Supplier URL

 

Optional

 

Other information

 

Optional

 

Essential feature

Description for the consumer. No abbreviation

Mandatoryfor the French market

 

Date of creation

 

Optional

If empty then the current date will be shown

Date of modification

 

Optional

If empty then the current date will be shown

 

© 2018 iZySolutions