Skip to end of metadata
Go to start of metadata

This guide will help you to import range, IP or device data that is contained in spreadsheets, comma, colon or tab separated.

There are a few options/methods available.

  • It is possible to import range or IP data via the mmcmd CLI. Please refer to this chapter in the Implementation Guide for details
  • It is possible to copy and paste record data (tab separated) into a single DNS Zone, as discussed here
  • It is possible to import zones via the File>Import Zone menu item. This is described here
  • It is possible to write a custom script to import the data using the SOAP API
  • It is possible to use the method described in this article to import range, IP and device data

Installing the Import Data web task

Icon

These steps assume you have installed Men & Mice and the Men & Mice Web Interface and are running version 6.3 or newer.

  1. Download the files for the Import Data web task: ImportData-1.3.zip
  2. Unzip the file from step 1 and move the MM directory in it over to the server hosting the Men & Mice web interface
  3. Change to the directory where the Web Interface was installed, e.g. on Windows the default is C:\Program Files\Men and Mice\Web Interface\web
  4. Create the directory "Custom" if it doesn't already exist, and put the MM directory from step 2 in this folder
  5. Login to the M&M Web UI as M&M built-in user "administrator". Click on "Tasks" on the left and click the install button in the screen
  6. Provide the following parameters, and click OK
    1. name: Import Data

    2. Folder: MM

    3. Filename: TaskImportData

  7. Now the "administrator" has access to this new web task, "Import Data",  which appears under the "Tasks" node on the left in the web interface. To give more users access to this task, use Tools>Global Access. A new access item will have appeared at the bottom for the web task.

    Icon

    If you are running version older than 6.4, you need to restart the Central service before you see the new access item.

Importing data using the Import Data web task

The web task recognizes tab, comma and colon separated data. When cells are copied in Excel they are by default tab separated. Therefore, the most convenient way to use the task is to copy cells or columns in Excel, and pasting into the web task.

The spreadsheet, or at least the part of it being copied, needs to be in a specific format. 

  1. The first line needs to be the header line, containing the names of the attributes or custom properties in Men and Mice for which the column contains data for
  2. At least one of the columns must identify the name of the object being imported. 
    1. To import ranges one column must be called Range, and contain the range in CIDR notation for each row. E.g. 192.168.1.0/24
    2. To import IP addresses one column must be called Address, and contain the IP addresses for each row 
    3. To import Interfaces and/or devices, there must be columns Interface and Device, respectively, containing names of the devices and interfaces in each row

 

Example of a properly formatted spreadsheet for Range import

rangeTitleDescriptionOwner
192.168.18.0/24My titlemy descriptionuser1
1.2.3.0/25the title is heredsuser2

This would create or update the ranges mentioned in the "range" column, with the property values for Title, Description and Owner in the other columns.

 

Example of a properly formatted spreadsheet for IP Address import

AddressDevice TypeClaimedOwner
192.168.18.18DHCP Server1user1
192.168.18.19DHCP Server1user1

This would update the IP Addresses in the address column with the property values for "Device Type" and "Owner", and set the Claimed flag as well for those IPs.


Example of properly formatted spreadsheet for importing Devices and Interfaces

devicebuildinginterfaceaddressesOwnerPurpose
sw018aH15eth018.2.89.253,18.2.14.227user1testing
sw018bH15eth1 user1testing

This would create or update the devices and their interfaces mentioned in the columns "device" and "interface", and the custom property values "Owner" and "Purpose". The eth0 interface on the first device is also linked to the two addresses in that cell.

Demonstration

Here is a simple demonstration of the workflow when importing the ranges in the example spreadsheet above.