Use the User-Defined Customer Part # Entry utility to upload customer part numbers for existing products in the system. The uploaded part numbers display in Customer/Vendor Specific Part Numbers. You can upload part numbers from a spreadsheet or a text file.
This topic contains the following procedures:
To upload customer part numbers:
From anywhere in the system press Shift F2 to display your Report Queue.
Upload the file containing the part numbers if necessary.
Select Tools >Process to display the User Defined Upload Processing screen.
Note: If prompted, log on to the character-based system.
In the Processing Type field, enter Customer Part # Import.
Click Begin to display the User Defined Customer Part # Entry dialog box.
In the Work ID field, do one of the following:
Leave the field blank - Does not save the template after this upload.
Enter a name that identifies the upload file - Creates a new template for use with future uploads.
Select an ID - Uses an existing template.
In the Description field, enter a complete description for the upload.
In the Customer field, enter a name to identify which customer part numbers you are uploading.
Select File > Format to prepare the system for the upload file as described in the following procedure.
In the 
Start or Element
# field of the Data
Format section of the window, scroll down the list to find
the data format to match in the update file.
For blocked records:
Start - For each Data Format, enter the number for the starting position on the upload file.
Lngth - For each Data Format, enter the number of characters needed for the data on the upload file.
For variable records:
Elmt#- For eachData Format, enter the column number from the upload file.
In the Dec#field, enter one of the following for numeric data:
The appropriate number of decimal places if the decimal point is not embedded, but the numeric data contains a defined number of decimal places.
A zero if the decimal point is embedded.
More Options for Uploading Customer Part Numbers
The following are some common options you might use while uploading customer part numbers:
To... | Select the following... |
Start the upload. | File > Begin The system imports customer part numbers into the ENTITY.PN.IDS table. |
Delete the upload template | File > Delete Type delete at the prompt. Note: If the system finds errors in the report data, it generates a Failed Entries report and places it in your Hold file. |
From the User Defined Customer Part # Entry dialog box, select File > Format to display the Upload File Format dialog box.
In the Record Type field, enter one of the following formats for the upload file:
Blocked - Fixed-length.
Variable - Comma- or tab-delimited.
Note: Data elements in a blocked record may also be separated by a delimiter.
In the Record Length field, enter one of the following:
Enter the number of characters necessary if specifying a record length.
Leave the field blank if not specifying a record length.
Note: This field is accessible only for blocked-type records.
In the Delimiter Character field, enter the character used between each field as a delimiter, such as a comma (,). This field is active only for variable record type files.
In the Delete Characters field, enter any characters you do not want read as data, such as quotation marks or the dollar sign.
See Also: