Importing Part Models

This document explains how to import part models using API Imports. For detailed explanation of Part Models and Parts, please see: https://d42docs.wpengine.com/spare-parts-management/models-and-parts/

Data example

Data example

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

Download sample spreadsheet

Tools>Imports/Exports (.xls)
Create or update spare parts models – Download Sample Excel File
Open the sample file

Comments

Comments

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

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

Choose file and import

Go to: Tools>Imports/Exports (.xls) – choose the file and select Import.

Import results

Import results

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

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:

HDD

RAM

Patch Cable