Netaphor SiteAuditâ„¢ Asset Tool
The SiteAudit Asset Tool is a new tool that is installed with SiteAudit version 7.0. This tool can be used to perform the following actions:
- Import a company organization including department addresses, contacts, networks, and other details
- Automatically import discovery networks, ranges, and IP addresses or save an import file to import at a later time
- Automatically import the organization hierarchy or save an import file for import at a later time
- Create, edit, and delete custom fields
- Export or import asset information and custom field values
Using the SiteAudit Asset Tool
The SiteAudit Asset Tool can be launched from the Windows Start menu

- When used with SiteAudit OnSite, the Asset Tool connects automatically to the same database configured in the SiteAudit Viewer
- A DCF file, that provides access to one or more customer, is used to access SiteAudit Hosted customer databases
The SiteAudit Asset Tool application

Using a DCF file with the Asset Tool (Control Panel can create DCF file)
A DCF file is required to connect to SiteAudit Hosted customers. Refer to the following article to learn how to create your DCF file.
- Click the button, 'Use DCF file' which opens the Open file dialog
- Navigate to the folder where the DCF file resides and select it
- Click the 'Open' button
- Use the Database dropdown list to select the desired customer

Exporting Asset Data with the SiteAudit Asset Tool
The SiteAudit Asset Tool can be used to change the value of asset information and custom fields. It is always recommended to first export the asset data, which creates a CSV file containing the existing information properly formatted. Open the CSV file in Excel, edit the desired fields, then save an import the modified file.
- Open the 'Netaphor SiteAudit Asset Tool'
- Click the button 'Asset Data'
- Select 'Export...' from the drop down menu

A File Explorer will appear once 'Export...' has been selected.
Select the folder where the file is saved and enter a file name

The exported data now can be opened with excel and modified with excel

A successful export log will also be displayed in the Asset Tool's TextBox

The file can be edited in Microsoft Excel and imported to update the customer database with the desired changes. The image below is an example of asset information that has been exported from a customer database.

Import Asset and Custom Field Information into Customer Database
In order to import asset information and custom field values into a SiteAudit customer database, it is necessary to provide a properly formatted file as shown in the example below. This file can be generated by first exporting the asset data as described in the previous section.
New data has been added to the following columns (The columns have been selected in grey):
- asset_tag
- nss_string_0
- nss_date_0
- nss_integer_0
The CSV file now ready to be imported back into the SiteAudit Viewer, to Import back into SiteAudit.

Importing asset data with the SiteAudit AssetTool
- Open 'Netaphor SiteAudit Asset Tool'
- Click the button 'Asset Data'
- Select 'Import...' from the drop down menu

Select the CSV file that should be imported.
example:
- Name of the CSV file: export.CSV
- Path of the CSV file: C:\tmp\export.csv

The example below shows SiteAudit View before an import.
*Note the values in the column, 'Asset Tag'

After an import has occurred, the column 'Asset Tag' has been updated.

An export log will be displayed in the Asset Tool's TextBox, which is underneath the 'Database' field
In the example below, a successful export log is displayed.

Import company information with the SiteAudit Asset Tool
The SiteAudit Asset Tool takes Company information in a CSV File and then transforms the CSV File into two XML files. Once the transformation as has taken place,
a prompt will be generated asking whether to import the information into SiteAudit Viewer or not.
Company Information:
- Organizational hierarchy
- Printer department assignments,
- Contact information
- Discovery ranges
- Other data
For more information, read these articles:
1. Open the 'Netaphor SiteAudit Asset Tool'
2. Click the button 'Company'
3. Select 'Import Information...' from the drop down menu

'Select Import Template' dialogue should appear.
4. Select the the CSV file to import
5. Click 'Open'

6. Click 'Yes'

Two new XML files have been created.
The XML files will be imported into the SiteAudit Viewer

Note: If the inventory has not updated after a Company Information import has occurred.
- right click on the first node in the inventory section
- select 'Company Organization...'

Company Organization Before an import has occurred

Company Organization After an Import has occurred

Inventory Before an import has occurred

Inventory After an Import has occurred

A successful Import log will also be displayed in the Asset Tool's Text Box

Sample Organization Import File
The organization import is a CSV file. A sample import file is installed with the SiteAudit Viewer or SiteAudit Control Panel and is located in the following folder C:\Program
Files\Netaphor\SiteAudit\Samples\en\Organization_Import_Template.csv This file is also attached at the bottom of this article and produces the following organization.

Create and modify Custom Fields with the SiteAudit Asset Tool
The SiteAudit Asset Tool Custom Fields tool allows the user
- Save: 15 custom fields
- 6 string fields
- 3 date fields
- 6 integer fields
- Reset
- Resets the text fields before the custom field is saved, once the field is saved, the field cannot be reset.
- Delete
1. Open the 'Netaphor SiteAudit Asset Tool'
2. Click the button 'Custom Fields'
3. Select 'Modify Custom Field Properties...' from the drop down menu

'Modify Custom Field Properties' window opens

Add String
4.a. Click the button, 'Add String'
5.a. Fill in the fields:
- Column Name (Mandatory)
- Category
- Description
6.a. Click the button, 'Save'
A Custom Field String is added to SiteAudit

Add Integer
4.b. Click the button, 'Add Integer'
5.b. Fill in the fields:
- Column Name (Mandatory)
- Category
- Description
6.b. Click the button, 'Save'
A Custom Field Integer is added to SiteAudit

Add Date
4.c. Click the button, 'Add String'
5.c. Fill in the fields:
- Column Name (Mandatory)
- Category
- Description
6.c. Click the button, 'Save'
A Custom Field Date is added to SiteAudit

Delete a Custom Field
1. Select the Custom Filed to be deleted
2. Click the button, 'Delete'

Viewing the Custom Fields in SiteAudit
1. Open SiteAudit Viewer
2. Click on the Inventory Tab
3. Right Click the column header
4. Select the 'Column Chooser'

'Customization' window appears
5. Double-Click on the custom fields that were created in order to add them to the SiteAudit Viewer

The Custom Fields Appear in the SiteAudit Viewer

To quickly update Custom Fields
1. Export asset data from the SiteAudit Asset Tool
2. Open the CSV file with excel
4. Modify the Custom Fields
5. Save the modified CSV File
6. Import the modified CSV file with the SiteAudit Asset Tool
7. Verify the imported data is correct in SiteAudit

To inspect each printers Custom Fields Closely:
1. Right-Click on the printer that should be inspected
2. Select 'Details...' from the drop down menu

3. Click the 'Custom Fields' tab
