This document explains how to import parts using the Spreadsheets Import tool found in the Tools menu.
Importing part models vs. importing parts
Please see Managing Spare Parts for an explanation of part models vs. parts in Device42.
Part models can be created using the create or update spare parts import. The parts import can do both models and parts. The create or update spare parts models import can only create models.
Download current data
This document will demonstrate adding parts to existing part models - building on the imported models covered in the Importing Part Models document.
Tools>Imports/Exports (.xls) - download current data for spare parts models as highlighted above
A current data export sheet is pictured above. Creating parts from existing part models requires the part model ID.
Keep this sheet open.
Download sample file
Next we will download the Create or update spare parts sample sheet - Tools>Imports/Exports (.xls)
Note the help comments for each parameter.
We will use the data from the current data export to help populate the parts import.
Populating the sample sheet
Using the current data export, we have copied the partmodel_id for the new parts we are going to create
- Name or partmodel_id is required. Type is optional. part_id is required for updating existing parts
- Added the serial numbers - this can be accomplish manually or via laser handled scanner (see below)
This import will create the following:
ID 39 (3.5” 2TB Dell Drives)
4 line items with assignments and serial numbers. Unique line items are required to track serial numbers.
ID 47 (4GB PC3 8500R)
2 line items with assignments. Since we don’t care about serial numbers for these items, we are only tracking room assignment and count.
Save the file and import.
Re: handheld laser scanner. We have been using a DBPOWER scanner that we purchased on amazon for $60 (link below) - we think it works great. It comes with USB receiver and can be programmed to automatically go to the next row in Excel, making it very easy and quick to grab serial numbers or other bar codes. https://amzn.com/B00AA6EFMI
Go to: Tools>Imports/Exports (.xls) - choose file and click import. Pictured above are the results of our import.
Let’s have a look at these new parts in the UI
The new parts on separate line items - again these are unique line items as we are tracking serial numbers.
The new parts on two lines - not tracking serial numbers, we only need two lines to track the room assignments for these 40 RAM modules.