CSPC import file format

[graham.kirtley]

Within the CSPC GUI and via the collector CLI the is the ability to import (add new devices) to the collector.  This data file is referred to as being the seed file.

There are several stated seed file formats that are available:

CISCO_WORKS_DCR, CISCO_WORKS_CSV, CISCO_CNC_CSV, PARI_CREDENTIALS, SIMPLIFIED_CSV

Can anyone provide the exact format of this ‘Simplified CSV' file format, i.e. the number and content of the fields?

Thanks,

Graham

[Zachary Spicer]

Hello Graham, 

Here is the information you are looking for: 

Simplified Seed File Format

Header in Simplified Seed file contains these fields:
• IPAddress
• protocol
• port
• username
• password
• enableusername
• enablepassword
• SnmpRO
• SnmpRW
• SnmpV3Id
• SnmpV3Password
• SnmpV3EngineId
• Snmpv3AuthAlogorithm
• SnmpV3PrivAlgorithm
• SnmpVPrivPassword

[graham.kirtley]

Hi Zachary,

Many thanks for this info.  would you be able to provide an example of the file header for the 'simplified' format, as I'm looking to automate its population from another source.  Is it like the following header for the CISCO_CNC_CSV format?

; This file is generated by the export utility of Service Appliance 1.0 ; If you edit this file, be sure you know what you are doing;Cisco Systems NM data import, source = export utility; Version = 1.0; Type = Csv;; Here are the columns of the table.; Column 1 and eiether column 9 or 11 are required.; Columns 2 to 8,12 to 36 and 10 are optional.
; Col# = 1: IP Address (including domain or simply an IP)
; Col# = 2: Host Name
; Col# = 3: Domain Name
; Col# = 4: Device Identity
; Col# = 5: Display Name
; Col# = 6: SysObjectID
; Col# = 7: DCR Device Type
; Col# = 8: MDF Type
; Col# = 9; Snmp RO
; Col# = 10; Snmp RW
; Col# = 11; SnmpV3 User Name
; Col# = 12; Snmp V3 Auth Pass
; Col# = 13; Snmp V3 Engine ID
; Col# = 14; Snmp V3 Auth Algorithm
; Col# = 15; RX Boot Mode User
; Col# = 16; RX Boot Mode Pass
; Col# = 17; Primary User(Tacacs User)
; Col# = 18; Primary Pass(Tacacs Pass)
; Col# = 19; Primary Enable Pass
; Col# = 20; Http User
; Col# = 21; Http Pass
; Col# = 22; Http Mode
; Col# = 23; Http Port
; Col# = 24; Https Port
; Col# = 25; Cert Common Name
; Col# = 26; Secondary User
; Col# = 27; Secondary Pass
; Col# = 28; Secondary Enable Pass
; Col# = 29; Secondary Http User
; Col# = 30; Secondary Http Pass
; Col# = 31; Snmp V3 Priv Algorithm
; Col# = 32; Snmp V3 Priv Pass
; Col# = 33; User Field 1
; Col# = 34; User Field 2
; Col# = 35; User Field 3
; Col# = 36; User Field 4
; Col# = 37; Status_Msg
; Here are the rows of data.

192.168.51.54,etc,etc,,,

[Lynden Price]

Hi Graham,

For the CISCO_CNC_CSV format:

If using SNMPv1 or v2, Column 1 (IP Address) and 9 (SNMP RO String) are required, the rest are optional. If using SNMPv3, then Column 1 (IP Address) and Column 11 (SNMPv3 Username) are required, along with Columns 12, 14, 31 and 32 depending on your SNMPv3 setup. 

Here is an example of that the row in Excel would look like if you had an SNMP RO string.

192.168.1.1

public

Have you tried using the "Simplified Format" that Zach posted above where each bullet corresponds to each column? It should work in a similar way.

Thanks,

Lynden

[Lynden Price]

Hi Graham,

After further testing, I don't think the Simplified Seedfile format is working according to documentation. Could you use the CNC format? It works from a CSV the same way.

From Settings > Device Credentials you can create a credential using the Add button, give it *.*.*.* or whatever wild cards you want in the IP address field, and then export that in CNC format. Then you can use that as a template for making other CNC formatted seedfiles that you can import.

Let me know if you need any clarification.

Thanks,

Lynden