Export / Import

The Export / Import features are accessed from the Configure > Database Menu. This brings up a dialog which enables you to export device properties from IntraVUE™ or import device data to IntraVUE™ from other sources.

Export

If you select the Export button, a standard Windows file download dialog will ask if you want to save the file or open it. If Microsoft Excel or similar spreadsheet program is installed, you may open the file directly into that. Export files are saved comma separated value (CSV) format.

By default this IntraVUE™ will export all of the checked boxes except the plant layout coordinates.

To export just specific device properties simply select from the check boxes below what you want to export:

Device Information: This will export all devices with its respective device info (i.e. image, other name, vendor, model, description). SeeDevice Side View

Device Configuration: This will export all devices with its respective general settings (email and critical status), advanced settings, & snmp settings. See also Device Configure - General, Device Configuration - Advanced Tab, Device Configure - SNMP

Include N/A Nodes: This will only export 'n/a' nodes. SeeNA Nodes

Weblinks: This will export all devices with its respective weblinks. See Device Configure - Links

Plant Layout Coordinates: This will export all devices with its respective X-axis and Y-axis coordinates used in the plant layout. See Creating Plant Documentation

 

Import

If you select the Import button, the file listed in the filename field will start to be imported. Import files have to be in plain text, comma separated value (CSV) format.

Data is primarily imported based on the IP address field of the saved file. This makes it possible to import data from files that have been saved from other IntraVUE™'s or from previous databases on the host computer.

If a match by IP address is not possible, IntraVUE™ tries to make a match based on the parent switch and switch port of a field.

Usually only fields for manually inserted devices connected to other manually inserted devices would have problems being imported.

You must select the Proceed With Import button to complete the process.

Always import IntraVUE™exported *.csv files so that these can be imported back without any problems. This will prevent you from having to modify your regional windows settings to English as some countries (e.g. Germinay) use comma as a csv separator instead semi-colon as in the U.S. In any case IntraVUE™ supports both comma and semi-colon separated csv files.

Import & Export Functions - CSV File

When you look at the exported data in a spreadsheet program you will find many columns. There are 3 basic sections:

• Reference data
• Configuration data for each IntraVUE™ 'View'
• Configuration data from the device's General Tab
• When saving the file, use CSV as the type and use quotes as the field marker. Don't use quotes in any view names.

Although the export function outputs many columns, you may delete columns you are not interested in EXCEPT the ipAddres, ref, and parentRef columns. These are used during the import process. You may not change any values to the left of DeviceName. They are shown in the image below.

• IP - IP Address or n/a if the line represents an auto inserted node.
• Active - 1 if the device is currently connected.
• MAC - MAC Address.
• Ref - internal database reference number.
• ParentRef - internal database reference of the device's parent.
• ParentIP - The IP Address of the device's parent. This will be a switch, router, or the top parent of the IntraVUE™ network.
• ParentPort - The port number from the parent to the device.
• UlinkPort - If the parent is a switch, the uplink is the port leading back to the top parent, otherwise it is 0.

It is particularly useful to SORT the exported data by the ParentIP column and then by the ParentPort column. This will give you a list of all your devices arranged by the switch they are connected to, in port number sequence. This is very useful if you want to compare what IntraVUE™ says to what your documentation says.

The next section contains contains columns for names, weblinks, and images. There is one sub-section for each of the 6 views of IntraVUE™. Note there is no column for IP View Name because you can not change that.

• xxxViewName - The name to appear for this view.
• xxxViewWeblink1Title - name to appear to user in the browser.
• xxxViewWeblink1URL - url that will be called when the user clicks on the link.
• xxxViewWeblink2Title
• xxxViewWeblink2URL
• xxxViewIconImage - icon image to display for this view
• xxxViewThumbnailImage - thumbnail image to display for this view

The last section contains items from the Device Configuration General Tab.

• Category
• Auto Connect
• AutoBootp
• IsWireless - this corresponds to the WAP checkbox.
• Send Alarms - to 'this' device's specific recepient.
• AlarmEmailAddress - email for 'this' device's specific recepient.
• SendToDefaultUser- to email alarm recepient in the System Configure Email tab.
• Verified - Admin Verified checkbox.
• Properties - An encapsulation of several items on the Device's General Tab. This column is not meant to be edited. It is meant to be copied from one device configured the way you want to another device without modification. This includes columns such as 'disable all snmp', 'ignore bridge mib', 'use snmp for mac', and snmp community.
• PKI.critical - This column is only available when you have enabled critical status for the KPI System on at least one device. See Device Configure - General

See CSV Column Values for a list of available values for selected columns

 

Importing Device Information other sources

See tech note Importing Device Names From Third Party Sources