Skip to main content

Importing Data from Existing Spreadsheets

This article will guide you through getting started with Device42 using existing data in .xls format. This includes any data you already have in a spreadsheet, and data that you exported from other systems like Rackmonkey. If the data exists in a spreadsheet, or if you have a way of getting your data into a spreadsheet, then the Device42 import feature makes it easy for you to import.

Note that the import and auto discovery features are complementary, not alternatives. That is, you can still enable auto discovery before or after importing data from a spreadsheet. Device42 will correlate the data appropriately.

Importing XLS (spreadsheet) files

Navigate to Tools > Imports/Exports(xls).

Select import/export menuSelect import/export menu

On this page you will find sample spreadsheets and links to detailed documentation.

Select import/export menuSelect import/export menu

Notes regarding Sample Files:

  • Row 1 and 2 - Required, do not change.
  • Row 3 - Parameters must be on Row 3. However, only the parameters required for the specific API call are needed - all other parameters can be removed from file, though it is not required to do so. The parameters can be arranged in any order on Row 3.
  • The parameters used in the following steps are those required and commonly used. Please refer to the documentation for additional options. Parameters for adding various data elements not covered here.

Step 1 - Add Buildings

Step 1 - Add Buildings

Sample file: Create or update buildings.
Name = building name is the only parameter required

  1. Enter your information, save file
  2. On the Import Page, click Choose File (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Datacenter | Buildings

Step 2 - Adding Rooms

Step 2 - Adding Rooms

Sample file: Create Rooms.
Name = room name, and building name are both required

  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Datacenter | Rooms

Step 3 - Adding Racks

Step 3 - Adding Racks

Sample file: Create Racks.
Name = rack name, size (u size), and room name are all required

  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Datacenter | Racks

Step 4 - Adding Hardware Models

Step 4 - Adding Hardware Models

Sample file: Create or update hardware models.
Name = hardware model name is required. Type, size (u size)*, and manufacturer are optional, but recommended if known.

  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Datacenter | Hardware

*Note: U Size is required for adding devices to racks. Devices are based on hardware models, U size should be specified when adding hardware models. U size can be updated for existing hardware models in Device42: Tools | Templates & Bulk Operations | Bulk Hardware Edit

Step 5 - Adding Devices

Step 5 - Adding Devices

Sample file: Create or update devices.
Name = hardware model name is required.

  1. Enter your information, save file
  2. On the Import Page, click Browse File (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Devices | All Devices

Step 6 - Adding Devices to Racks

Step 6 - Adding Devices to Racks

Sample file: Add devices to racks.
Device = device name and start_at are required. Start_at = starting U location of device, starting with version 5.3.5, "auto" can be used to automatically mount the device in next available slot.

  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Datacenter | Racks

Adding Assets

Adding Assets

Sample file: Create assets.
Type = asset type is required. Patch panel models must be created manually, this can be done before or after creating asset*. Vendor must already exist.

  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. the imported data can be viewed here: Devices | Assets | Assets

*Note: Creating Patch Panel Models

Adding Assets to Racks

Adding Assets to Racks

Sample file: Modify assets.
rack_id, start_at (starting U location, specify or us "Auto"), size (U size), and asset_id are required. All other parameters are optional. Optional parameters can be removed from the file.

  • Rack ID's can be found by exporting rack info: Tools | Export > Rack
  • Asset ID's can be found by exporting /assets: Tools | Export > Asset
  1. Enter your information, save file
  2. On the Import Page, click Browse (selecting the file saved in step 1)
  3. Click Import, the following message will appear "Importing File Please Wait..." Upon completion, results of the import will be displayed
  4. The imported data can be viewed here: Resources > All Assets