This program allows the user to setup the parameters of a comma delimited file that can then be imported into Rx-Universe. The file can update existing data or add new data. The program is accessed via the “Supervisor” menu, “File Conversions”. The following screen appears:
This screen allows the user to create, modify or delete file conversion definitions using the appropriate button from the toolbar. When modifying or deleting a file conversion definition, select the desired entry in the “Conversion name” list before pressing the button.
Setting up a conversion definition
Pressing create or modify causes the Conversion file definition screen to appear.
This screen allows the user to maintain a file conversion definition. The “Conversion name” and “Conversion file type” fields cannot be modified after the definition is created.
Available fields:
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 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 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.
Running a conversion
Select the desired conversion, then enter a CSV file name, either by typing in it’s 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.
Types of Conversions
Lens Inventory
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 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).
If the Lens inventory contains the OPC from the CSV file, any other field definitions are modified within the Lens inventory item and the record is saved with the new values. The conversion/import program also creates an error file “CSVERRORS.TXT” that contains a copy of the records whose OPC code could not be found.