This document explains how to import part models using API Imports. For detailed explanation of Part Models and Parts, please see: https://docs.device42.com/spare-parts-management/models-and-parts/
The sample data in the spreadsheet (pictured above) is our starting point for this import. This data was exported from a legacy system into .csv format.
Download sample spreadsheet
Create or update spare parts models – Download Sample Excel File
Open the sample file
Note: hover-over column heading to reveal comments that specify usage, e.g.: required, optional or details (pictured below)
Note: the additional Part model type parameters for CPU, RAM, and HDD. Note: type is required.
Populating the sample sheet
The image above shows the sample spreadsheet that has been updated to include the data from our .csv export. These being new part models, only type is required. The parameters not being used have been deleted from the sheet (alternatively they can be left blank).
Note the additional parameters added for CPU and RAM models
Save the file.
Choose file and import
Go to: Tools>Imports/Exports (.xls) – choose the file and select Import.
Results of parts model import. If there is a problem with the import the results will show “The following were Not added…” Should there be a problem, be sure to review the body of the results as the cause is usually stated clearly, e.g.: missing parameter
Parts Model List
Datacenter>Parts>Model List – above we see the part models imported in the previous step.
Let’s drill into a few of the items to validate the import: