Vendors send price updates in a variety of formats. Determine the file format for the user-defined matrix upload before importing the file, and prepare the system to receive the correct format.
To define the file format for price updates:
Display the character based system.
Note: The Matrix Upload Utility functionality has not been incorporated into Solar Eclipse as of this release.
From the System > Printers menu, select Your Hold Entries to display the Spooler Control screen.
Scroll to the name of the update file, and use the Process hot key to display the User Defined Upload Processing screen.
In the Processing Type field, enter Matrix Upload User Defined.
Use the Begin hot key to display the User Defined Matrix Entry screen.
In the Work ID field, enter the work ID for this update.
A work ID can determine a format-specific template for processing a spreadsheet, and does not need to be vendor-specific. You can use the same work ID for different vendors if several vendors send their data in an identical format.
Use the File Format hot key to display the Upload File Format screen.
In the Record Type field, enter one of the following formats for the update file:
Blocked - fixed-length.
Variable - comma-delimited.
Note: You can also separate data elements in a blocked record by a delimiter.
In the Record Length field, do one of the following: The Record Length field is accessible only for blocked-type records.
Enter the number of characters necessary if the vendor specifies a record length.
Leave the field blank if no length is specified.
In the Delimiter Char field, enter the character used between each field as a delimiter. This field is accessible only for variable-type files.
In the Delete Chars field, enter any characters that you do not want read as data, such as quotation marks or the dollar sign.
The system does not recognize the dollar sign as a numeric value, so if the vendor puts a dollar sign in front of the prices enter $ in this field.
Press Esc to save the information and return to the User Defined Matrix Entry screen.
See Also:
Creating User-Defined Buy or Sell Matrix Cells During Price Updates