The CiscoWorks import tool creates switch entries in the data store. The import tool creates and updates the following node types:

• Switch
• PortInterface

Entries in the data store for a switch and its ports are overwritten if a switch in the input data has the same name.

A limitation of the importer is that a switch already in the data store for which a matching name cannot be found in the input data will not be removed. Therefore if a switch has been renamed since a previous import, it will appear in the data store as a second switch.

Importing Data from CiscoWorks

The CiscoWorks importer loads the data file exported from CiscoWorks LMS using the Campus Manager User Tracking tool, and loads any existing switch data from the Tideway Foundation data store. It then compares the sets of data. The supported versions are Campus Manager 3.x and 4.x (UT CLI 1.0, 1.1, and 1.1.1).
The switch name is used as the index. Therefore, if two switches have the same name, they are treated as the same switch.

• If a new switch is found in the exported file, it is added to the Foundation data store. The name of the switch is used as its primary key. See the note below regarding deletion of switches.
• The ports on each switch are updated. These are indexed by IP address (the primary key). Port attributes that are updated include speed, duplex, and IP address. New ports (identified by IP address) are added, and any ports removed from the CiscoWorks data are removed from the data store.

Importing a CiscoWorks Data File

To import a CiscoWorks Data File:

1. From the Discovery section of the Administration tab, select Ciscoworks Import. The Import Ciscoworks Data page is displayed.
   
   The options on this page are described below:
   

   Field Name	Details
   File To Upload	The file to upload. Click the Browse... button to display a file browser window. Select the file to import and click Open.
   File Type	Choose the type of file to import. Choose either XML or delimited from the drop-down list. If you select XML the File Delimiter and File Has Header Line fields are disabled.
   File Delimiter	For a delimited file only, select the delimiter type from the drop-down list. This may be one of Comma, Tab, or Space.
   File Has Header Line	Choose Yes or No from the drop-down list depending on whether the delimited file has a heading line.
   Remove existing Switches	Do you want to remove existing switches from the Foundation data store that are not present in the file you are importing? Choose Yes or No from the drop-down list.
   Logging Level	Choose the logging level from the drop-down list. This may be Debug, Info, Warning, Error, or Critical.

2. Click Apply to import the CiscoWorks Data File.

There is also a command line utility available for importing CiscoWorks data. It is described in Switch Import Script.

Generating CiscoWorks Data

To export data from CiscoWorks in a layout which the importer can use, you must create a custom layout. To do this:

1. From the CiscoWorks LMS Portal, select Reports.
2. Select Custom Layouts.
3. Click the Create button.
4. In the Add Layout dialog, select End Host.
5. Select the columns that you want displayed in the report from the Available Sources list and click Add to add them to the Selected Sources list.
6. Arrange these into the required order using the up and down arrows.
   Note: The import file must be in the following order otherwise data will be imported into the wrong attribute, and the import will fail. More or fewer columns will also cause the import to fail:
   

   CM 3 to 4 layout	CM 4.0.6 layout
   UserName MACAddress HostName IPAddress Subnet DeviceName Device Port PortName PortState VTPDomain VLAN VLANType LastSeen Notes PortDuplex PortSpeed VLANId	User Name MAC Address Host Name IP Address Subnet Device Name Device Port Port Name Port State VTP Domain VLAN VLAN Type Last Seen Prefix Port Duplex Port Speed VLAN Id

   1. Specify the name of the layout as StandardTideway and enter a description.
   2. Click Add to create the StandardTideway layout.

As of 7.2 you can populate an optional field of Port Negotitation (with values of "AUTO" or "FORCED")

Note: The full instructions are available on the Cisco Systems website.

The following methods of generating the CiscoWorks data are supported.

Generating CSV Files

Generating CSV files on the CiscoWorks server:

C:\Program Files\CSCOpx\campus\bin\ut -cli -query all
   -layout StandardTideway -export c:\data.csv 
   -u user -p password

This command produces a Java stack trace. This is a known issue and can be ignored.
The file that is produced can be imported by running the following command on the Tideway Foundation appliance:

$TIDEWAY/bin/tw_imp_ciscoworks --delimiter=',' 
   --username name --password password 
   --file ~/tmp/data.csv

Generating XML Import Files

Generating XML files on the CiscoWorks server:

C:\Program Files\CSCOpx\campus\bin\cmexport ut -u userid 
   -p password -host -layout StandardTideway

The file is written into the following directory:
C:\PROGRAM FILES\CSCOpx\files\cmexport\ut
The file that is produced can be imported with the following command on the Tideway Foundation appliance:

$TIDEWAY/bin/tw_imp_ciscoworks --xml --username name 
   --password password --file ~/tmp/2006516154526ut.xml

The following attributes are imported into the data store, where they exist in the input file: