Import devices from tab delimited file
Previous  Top  Next

This menu allows you to import devices from a tab delimited file.

The current database is backed up before the import operation occurs.

This first screen that appears will prompt you to confirm the import operation.

importmsgbox1

Press Yes to continue. Press No or Cancel to exit the import operation.

Next, you need to select the file to import from. By default, the file mask is set to "Export_Device.txt".

Select the file to import and press Open.

You are now given options as to how to handle imported devices that have the same names as existing devices.

importmsgbox2

The import process always Adds a new device.

When a duplicate is found, you may elect to:

Update the existing device with the imported device's data. This overwrites the current device data with any fields that are found in the import data. Any fields that are not found in the import data are not changed in any way.
Rename the imported device. A new device is created with _imported_0 appended to the current device name. The last character is a sequential digit that is incremented when more than 1 devices with the same name are encountered.
Skip the imported device. The imported device data is ignored.
Choose action for each imported device. Any time a duplicate name is found the following dialogue is displayed:

importmsgbox3

You can view the differences between the 2 devices and choose what action to take for that particular device.

Should you wish you can also select to apply that action to all subsequent duplicates.

Pressing the cancel button terminates the import process immediately.

When the import operation is complete, the following or similar message will appear.

importmsgbox4

This will tell you how many devices were imported from the file. If any warnings or error are shown you should check the Info Log for more details.


Device import file format.

The file must start with a header row that defines the fields. The rows following the header are treated as data.

For example:

importfileformat

The fields can be in any order, but must follow the same naming convention as the Kiwi CatTools Export devices to tab delimited file function.

At a minimum, the file must contain the following fields:

·Type (The type of device)  
·Name (A unique name for the device)  
·HostAddress (The IP address or hostname for the device)  
·Filename (A unique filename for the device. No path or extension required)  

Below are a list of the device fields.

·Type  
·Group  
·Name  
·HostAddress  
·Filename  
·Model  
·ConnectVia  
·Telnet  
·Session  
·VTYPass  
·ConsolePass  
·EnablePass  
·PrivilegeLevel  
·AAAUsername  
·AAAPassword  
·SNMPRead  
·SNMPWrite  
·RequireVTYLogin  
·LoginUsesAAA  
·EnableUsesAAA  
·VTYPrompt  
·ConsolePrompt  
·EnablePrompt  
·AAAUserPrompt  
·AAAPassPrompt  
·Address1  
·Address2  
·Address3  
·ContactName  
·ContactPhone  
·ContactEmail  
·ContactOther  
·AlertEmail  
·SerialNumber  
·AssetTag  
·Identification  
·SerialOther  
·ActivitySpecific1  
·ActivitySpecific2  

The best way to create a template to start with is to add a few example devices to CatTools first. Then use the File | Export | Export devices to tab delimited text file menu. The file created will contain all the required fields you need to use.