Mapping for the CSV format

The import task maps the comma-separated value (CSV) formatted file. You can export the CSV file from Microsoft Excel.

The CSV format supports importing the auxiliary interface data.  

Mapping of GUI fields to CSV file columns

The following table shows the fields on the TrueSight Network Automation GUI and the corresponding columns in the CSV file.

  1. These attributes are for the primary interface.
  2. These attributes are for the auxiliary interface.

CSV formatting guidelines

Follow these guidelines when preparing a CSV file:

  • The first row in the CSV file must contain the column field labels exactly as specified in the table.
  • Field labels are case-sensitive.
  • Ordering of fields is user defined.
  • Device field data must follow the field label order on subsequent lines.
  • Dynamic fields are identified by using the field label (for example, Location).
  • Enclose multiple groups in double quotation marks.
  • Specify any character except single quotes (') and double quotes (") to separate multiple groups.
  • Separate multiple values in Dynamic Field with the help of double quotes (") and space between two values (for example, "C1700" "C1200").

Example CSV formatted file

Note

The column labels must use the letter case shown in the previous table (for example, name, externalId).

name, address, realm, deviceType, agent, Location, category, snmpOid, agentNIC, groups
ATL-cisco-1760, 10.1.2.45, Speeding Print Service, BE2B2D21-1CAA-53C3-05C3-CBB0A5D151B8, Local, Atlanta,1, 1.3.6.1.4.1.9.1.416, 10.1.64.4, "Device Location, Contract PO Number"

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*