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.



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.



The import process always Adds a new device.

When a duplicate is found, you may elect to:

·

Update 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 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 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:



You can view the differences between the 2 devices and choose what action to take for that particular device.
Should you wish to you can also choose to Apply to all duplicates subsequent.
Pressing the Cancel button terminates the import process immediately.


When the import operation is complete, a message will appear.



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:



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.

Plain text values found in fields that are normally encrypted within the database (e.g. HostAddress, VTYPass, EnablePass SNMPRead, etc) will automatically be encrypted as part of the import process.