Spreadsheet Imports and Exports

Use the spreadsheet imports and export functionality to modify data, add data to Device42, and export current data. The import and export feature uses the Device42 API without you needing to construct the API calls yourself and provides feedback on whether the records were successfully updated or why they were not.

It may be useful to import and export resource IP addresses for analysis by another tool or to reflect a new network configuration by making bulk changes to the IP addresses and then reuploading the data to Device42.

Overview

The spreadsheet import functionality is located under Tools > Imports/Exports (xls).

Importing Data

To load a set of data, choose a category on the left and click Download Sample Excel File. You'll add your data to the sample spreadsheet and import it.

Below is the sample spreadsheet for the Buildings - Create/Update Buildings category.

• The first three rows should not be modified. They consist of the API endpoint, request method, and column headings.
• The fourth (and sometimes fifth) row contains sample data. Delete the sample data and add the data to import to rows four and up.
• Save the .xls or .xlsx file.

Now upload the file. Head back to the Import/Export (xls) page, browse to add the modified sample spreadsheet, and click Import.

Below the Browse button, you'll see a message listing all the records that were added or updated successfully. If any records were rejected, you'll see a reason for each rejection.

Getting Help

If you want to learn more about a data field, hover over the small triangle in the upper right of the field name cells. Alternatively, click the View Documentation link on the Imports/Exports (xls) page to be redirected to the online documentation.

Exporting Data

Click the Download Current Data link to download a spreadsheet of the current data for the chosen category. This is a simple way to export your data.

As of Device42 19.06, the export feature will generate a spreadsheet in a new browser tab for each 1,000,000 records generated.

For example, the spreadsheet below shows exported data for the Buildings - Create/Update Buildings category.

Modifying Data

This same functionality can be used to modify your data. Simply download the current data, modify the data in the spreadsheet, and import by clicking the Browse and Import buttons as described above.

If a category has the Create or Add options visible to its left and not Modify or Update, then the records in the imported spreadsheet will be added. So, if you Download Current Data and re-import it, you will get duplicates.

To prevent duplicate records, download and modify the data in the spreadsheet and then delete the existing records before you do the re-import step. Find the list view for the primary object of your category of interest to bulk delete the existing records. For example, go to the racks list view for the Create Racks category.

Exporting Passwords

By default, the password export does not export the actual passwords even for users with the necessary permissions to view passwords. Go to Tools > Settings > Password Security to change the default setting. Password exports will then contain the literal string passwords for users with the correct permissions.