Spare Parts Export/Import

System Maintenance Menu -> Configure System Settings -> Operations Tab -> Inventory -> Spare Parts List -> UPDATE button -> Spare Parts Export/Import

These utilities can be used to update the sales and rental products in the Spare Parts List for a Product, Class, Group, or Spare Parts selection range, by exporting the existing values and re-importing the modified values.

Select one of the following actions:

•Create Spare Parts Worksheet:
 Click Export option in the radio group to generate a spreadsheet with the existing Spare Parts for the products as outlined in Spare Parts Export.

•Move the Saved Text File to the Server:
 Click Upload File to copy the tab-delimited text file created from the saved Spare Parts Export from your client machine to the data directory on the server in preparation for importing.
 The Select a File to Upload utility is used to search for the file and to rename it to "spare_parts.txt" before completing the upload.
 File upload success is confirmed.

•Update the Spare Parts List with the new Values:
 Click Import to update the Spare Parts for each product per the text file.
 Only records in the import text file will be updated.

•Exit 'Spare Parts Export/Import' sub-menu:
 Click Cancel when no further action is required.

Finished?

Click OK to initiate the action selected in the radio group.

Topic Keyword: RSPL02 (7004)