UNMS - Imports Feature


Overview


This article provides introductory information on UNMS's Imports feature. This feature is a good way to create a site/client structure in UNMS. It also allows the authorization of specific devices into a particular position in that structure.


Table of Contents


  1. Introduction
  2. Structure
  3. Adding Devices
  4. Examples

Introduction


Back to Top

The Imports feature is meant for users who would like to add a large number of devices into UNMS or create a complex site/client structure. A single .csv file must be created according to the set of rules described below and then applied to UNMS. This is currently the only way to authorize devices in bulk.


Structure


Back to Top

Here is the basic structure of the .csv file. Each site/client that will be added must keep a space for each value: filled if you wish to specify that value, or empty if you don't want to provide that information. You will see examples below with filled, and empty values.

type Mandatory value. Possible values [site, client]
name Mandatory value. Represents a site or client name. Each value has to be unique within the currently imported file(s) 
site name Mandatory value when the type=client. For type=site this value is empty.
address Site or client postal address
note Add a note to the site or client. Do not use any special characters here.
contact name Define a contact person for this site/client and provide their name.
phone Provide a phone number for the contact person for this site/client.
email Provide an email address for this site's or client's contact person.
longitude The site/client's GPS coordinate number for longitude.
latitude The site/client's GPS coordinate number for latitude.
elevation Number in meters representing height of this point above sea level.
height Useful for towers, this number shows how high client/site is.
MAC addresses Multi-value field. Individual values to be separated by a comma ,. If a device with this MAC address is added to UNMS it will be automatically authenticated for this site/client.
IP addresses Multi-value field. IP address in cidr format; individual values to be separated by a comma ,. If a device with this IP address is added to UNMS it will be automatically authenticated for this site/client.

Adding Devices


Back to Top

It is possible to pre-define which device should be authorized for any imported site/client. Have a look at this example:

site;TowerA;;;;;;;;;114.111.228.245,23.203.159.57;0E:16:10:F6:B1:15, 5D:25:5D:7D:64:CF

This will import a site with the name TowerA and if there is any device already present in UNMS with either one of the IP addresses 114.111.228.245, 23.203.159.57 or one of the MAC addresses '0E:16:10:F6:B1:15', '5D:25:5D:7D:64:CF' the import will move that device (or devices) to the new TowerA site. Furthermore, if a new device with a single match from the pool of these IP and MAC addresses, is discovered in the future, it will be automatically authorized for this site. 

User Tip: If you have several sites with the same IP or MAC address imported this way devices will be attached to the first matching site they happen to find.   

Examples


Back to Top

Let's start with an easy example. This will add a single site with no further information:

site;SiteB-CentralCity;;;;;;;;;;;;

Here is an example of adding a site with a contact person and GPS data:

site;SiteB-CentralCity;;1 Tower Bridge Road, London;;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;;

This example will add a single client with no further information. Please note that it is mandatory to have a parent site specified. We will use the site from the previous example 'SiteB-CentralCity':

client;Client10_MainStreet;SiteB-CentralCity;;;;;;;;;;;

If we add some info about address and contact person it will look like this:

client;Client10_MainStreet;SiteB-CentralCity;3 Main Street, London;;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;;

Now let's add several sites and clients at once. It's alright to define the structure in any order. You can set a client to have a parent site and define the site after that:

client;Client10_MainStreet;SiteB-CentralCity;;;;;;;;;;;
site;SiteB-CentralCity;;;;;;;;;;;;
client;Client11_SecondStreet;SiteB-CentralCity;;;;;;;;;;;
site;SiteA-Market;;;;;;;;;;;;
client;Client02_MarketStreet;SiteA-Market;;;;;;;;;;;

And finally here is a final example with previous sites and clients, but where all possible information is provided:

client;Client10_MainStreet;SiteB-CentralCity;3 Main Street, London;VIP customer note;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;10;04:18:d6:a0:87:a4,05:19:d6:a0:88:a5;
site;SiteB-CentralCity;;1 Tower Bridge Road, London;;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;c6:93:d1:4f:7e:bd;
client;Client11_SecondStreet;SiteB-CentralCity;13 Second Street, London;Problematic customer note;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;10;10;a1:b5:6b:9b:9e:ec,a2:24:a7:70:0b:0a;
site;SiteA-Market;;1 NightMarket Road, London;;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;06:20:d6:a0:89:a6;
client;Client02_MarketStreet;SiteA-Market;256 Baker St., London;Special needs customer note;John Doe;0044123123123;john@doe.com;51,4944747;0,08447369999998955;47;18;10;10;a1:b5:6b:9b:9e:ec,a2:24:a7:70:0b:0a;

We're sorry to hear that!