Browse
Tools
Categories

Asset Tool - Importing Organization

Reference Number: AA-01049 Views: 383 Last Updated: 03-10-2023 04:06 PM 0 Rating/ Voters

Importing Organization Template

This article explains how to import an organization hierarchy into SiteAudit discovery. An import template file is attached at the bottom of this article and can be used to import your organization.

The Organization's IP addresses and networks where printers exist are known in most large environments. It is best to confer with IT personnel to obtain a list of printer IP addresses. Once this list is obtained, they can be imported easily into SiteAudit. 

Organization Import Template

Quick Start

  1. Open SiteAudit to the database where you would like to import the Hierarchy.
  2. Click "Tools" and select "Import...".
  3. Click the "..." button to the right of the Import file name box.
  4. Find the Organization.xml.
  5. Click "Import".
  6. The company data should display on the left of SiteAudit.

Create a New Organization

An excel file is way to mass import organization data into SiteAudit.

Step 1: Download the Organization_Import_Template.csv at the bottom of this page.

Step 2: Open the csv file with Microsoft Excel.

Step 3: Put the company name underneath the Parent Column.


Step 4: 

a) Add a second row.
b) In the second row, type the company name underneath the Parent column.
c) In the second row, type the sub-department name underneath the Child1 column.


The result will appear as:


Step 5:

a) Add a third row.
b) In the third row, type the company name underneath the Parent column.
c) In the third row, type a new sub-department name underneath the Child1 column.


The result will appear as:

Step 6:

a) Add a fourth row.
b) In the fourth, type the company name underneath the Parent column.
c) In the fourth, type a new sub-department name underneath the Child1 column.


The result will appear as:


Import the Organization Template

Once the Organization_Import_Template.csv file has been configured, Netaphor Support will be compile and ready the file for importing.

Step 1: Open SiteAudit and select a database where you would like to import the organization.

a) Select the 'Setup' tab and the click 'Database...'
b) To the right of the word 'Database:' click the drop down menu and select the database that will be used to import  and store the organization information.


Step 2: Using SiteAudit's Import functionality, import Organization.xml.

a) Select the Tools tab in SiteAudit and then select the Import...


b) Type in the path to your Organization.xml file or click the button '...' and then navigate to the Organization.xml file

In the example below, the path is: C:\Users\siteaudit\Desktop\Organization_Import\Organization_Import\dist\Organization\Organization.xml


The resulting organization should appear similar to the example below:


Quick Examples

Below are examples on creating organizations:

Example 1: Create an Organization using SiteAudit

Creating an Organization by using SiteAudit

Step a: Right click on 'MyCompany' on the left hand side of the screen and then select 'Company Organization...'


Step b: Select the department in which you want to create the child and then click 'Add Department' button.


The result after adding a department:


Example 2: Create an Organization using SiteAudit

Use SiteAudit to create an Organization with Multiple sub-departments.

In the example below, 'Earth Company' is the Parent in the organization. The sub-department 'Engineering' is a Child1 of 'Earth Company.' Furthermore, the sub-department 'Chemical' is Child2 of 'Earth Company.'


The result after adding multiple departments:

Example 3: Create Three Children

Create three children in the Child1 column.


The result after importing:


Example 4: Create Two children Using the Columns Child1 and a Child2

How to create a Parent and a Child1 and a Child2:


The result after importing:


Example 5: Add an IP Range

Add an IP range:


The result after importing:


Verify that the IP Range was imported, in this example, right click on the IT sub-department' and then select 'IT - Department Information...' then select the tab 'Device Assignments':


Example 6: Create Optional Information

Optional information:


The result after importing:


Verify that the information was imported, in this example, right click on Engineering and select 'Engineering - Department Information...':


Facts

There are a set of standards that Organization_Import_Template.csv has to adhere to to properly work

 Fill out the columns of Organization_Import_Template.csv according to the specifications:

The Parent column is the company name.
The Child1 column is a sub-department of the Parent (company)
The Child2 column is a sub-department of the Parent (company) and Child1 (sub-department)
The Child3 column is a sub-department of the Parent (company) and Child1 (sub-department) and Child2 (sub-department)

1. For every department, there should only be at most 1 Address ([Street1], [Street2], [City], [State], [Zip], [Country]). If an Address is listed twice for the same department, regardless if it's the same or not, it will create an invalid Organization.xml file.

2. IP addresses, Networks, and IP Ranges, must be assigned to a child (sub-department)


With these standards in mind, create as many columns as necessary. Organization_Import_Template.csv is currently set up in such a way where parent departments are separated by an empty column, though this is not required either

The csv file can be opened with Microsoft Excel for editing.


The Excel example above can produce the same results as if the organization was created in SiteAudit

Option Information

All information is optional, besides from the Parent column, such as: 
  • Street name, Phone, Contact, IP addresses, etc.

The example below demonstrates an organization without any optional information:

Result after importing:


Networks, IP Ranges, and IP addresses

Importing - networks or IP addresses: 
  • At least one sub-department to assign networks or IP addresses.
  • If a sub-net mask is not provided, then the mask '255.255.255.0' will be the default mask.
If only a starting IP address is provided, then only that IP address will be monitored.

Below are some examples of incorrect input that may cause an error:

If the IP Address and Networks are out of range, the file will not be imported correctly.
If the sub-net mask is incorrectly added the default will be used '255.255.255.0'

The example below just uses IP addresses:


In order to ensure that the Networks, IP ranges, and IP addresses have all been added, Right click on the department that was imported and then select '... - Department Information...', as shown in the example below:


Select the tab 'Device Assignments' and check that the IP addresses and ranges were imported properly.


Click the tab 'Network Assignments' to ensure all the networks were imported correctly.

Delete the Organization

In order to delete the organization hierarchy you must import a new XML file.

Attached Files

Attachments
Organization_Import_Template.csv 817 b Download File