...
Conversion name - enter a unique name for this conversion.
Conversion file type - this field determines the type of information that can be imported, the allowable types are:
Lens Inventory
Description - enter a description for this conversion
Number of header records - Enter the number of lines that contain header information within the CSV file
Conversion file column definition list
This is list is maintained by pressing one of the buttons to the right of the list. You may Add, Modify or delete entries. The list has the field that is contained in the CSV file, it’s its column number within the file, and optionally, any conversions from the CSV file to the Rx-Universe data.
...
The conversion field definition screen allows the user to select the field name, it’s its column position and any conversion to the data that may be required. You can enter a duplicate field only if the column numbers are the same (this allows for multiple field value conversions). If you enter a column that has already been assigned to a different field name, an error will appear and you will need to select a different column.
...
Select the desired conversion, then enter a CSV file name, either by typing in it’s its full path, or by using the search button to the right of the field to select one. Once the desired information has been entered, press the “Process” button to start the conversion.
...
When setting up a conversion for lens inventory, the CSV file and the conversion definition must contain an OPC code field. This will be the key to find inventory entries within Rx-Universe. The Lens inventory will be checked to see if the OPC entry exists, if it does not, then the “Lens Catalog” is checked to see if the desired OPC is available and if it defined in the Lens Catalog file the item is activated (along with any other associated Lens catalog entries for this OPC) and it’s its stock status is set to the value contained in the CSV file ( if a definition for the status field is available) or, the item is set to “Stocked” (this is the default).
...