Click here to view the Lens Database menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to contact us.

Introduction

This document provides instructions for retrieving and loading lens data from Optifacts

Procedure

From the Optifacts main menu:

Select Option 3 - Editor Utilities and press Enter.

Select Option 3 - Lens Database Editor and press Enter.

Select Option 5 - Download Data from Optifacts and press Enter.

Select Option 2 - Retrieve Lens Data and Load and press Enter.

• Enter the Manufacturer Code to retrieve and press Enter.
• Do you want Semi-Finished or Finished lenses (S/F):
• Press “S” for semi-finished and press Enter,
• Or, press “F” for finished and press Enter.
• Enter the style code (without seg size) to retrieve (* for all): and press Enter.
• Enter the progressive or aspheric type code to retrieve (* for all): and press Enter.
• Enter the material code to retrieve (* for all): and press Enter.
• Enter the color code to retrieve (* for all): and press Enter.

Example: 

The example below would load the semi-finished lens data from all manufacturers in the SV and FFSV styles, all Aspheric types with type code ASV, all two-character material codes, in all the Polarized Gray colors with intensity 1, 2, and 3.  

The process to analyze and load lens types data will run only if progressive or full field styles get added. This step will skip if only NA types get added, improving the speed of the update. In addition, the program will not delete and replace a lens_types record if customized for the lab (i.e., if the inset_rot_angle was modified).

After data files transfer from Optifacts to your local server, the lens load program starts automatically.

Encountering New Materials and Colors

Since the Easy-lite material code EL was included in the semi-finished download but not in your database, Optifacts prompts you to confirm that the material should get added to your database.

If it doesn’t exist, you can:

• Add it using the Optifacts default material code.
• Add it using a different material code.
• Not add it at all.

If your database already contains material EL, the prompt to add it will not appear.

If the database already contains the material you specified, you get prompted to:

• Enter “Y” to substitute or “N” to enter a different code.

Answering “N” will allow you to enter a different material code. “Y” will substitute your entered code for the default when the SKUs are loaded. Optifacts will further check while loading the lenses to match existing material codes if what you entered doesn’t match lenses already in the database.

Optifacts added color DR (with Intensity Required set to “Y”) to the color master table in the following example. The DriveWear SKUs will load as color DR3. Any changes you like to make to the color description, billing categories, etc., can be done through the Color Database Editor.

Once all discrepancies are taken care of, the program will insert the lenses and SKUs from the unload file.

Other Prompts

You may get presented with other prompts such as:

Lenses with matching descriptions but different SKUs.

Lenses with matching SKUs but different descriptions.

If found in the database with a different SKU, you get prompted to decide.

• Entering “R” will replace the current lens, deleting the existing SKU and description and inserting the new lens in its place.
• Entering “A” will replace all lenses with matching descriptions and different SKUs (avoid being prompted for each SKU).
• Entering “I” causes the program to ignore this SKU from the load file, leaving the existing lens as is.
• Entering “G” causes the program to ignore all SKUs from the load file that match descriptions of existing lenses (avoids being prompted for each SKU).

If other differences such as diameter size are found, you get prompted to make a decision.

• Entering “R” will replace the current lens, deleting the existing SKU and description and inserting the new lens in its place.
• Entering “A” will replace all lenses with matching descriptions and different SKUs (avoid being prompted for each SKU).
• Entering “I” causes the program to ignore this SKU from the load file, leaving the existing lens as is.
• Entering “G” causes the program to ignore all SKUs from the load file that match descriptions of existing lenses (avoids being prompted for each SKU).

Additional Steps Needed

Blank selection

Base curve table

Color Exceptions

Pricing (colors, progressive columns, etc.)

Refer to the applicable documentation for instructions on the functionality mentioned above.

To view and download these instructions as a PDF file, click on the following document image.

Click here to return to the top of the page.