Joe Clarke Mon, 03/08/2010 - 11:06
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

It sounds like you have modified the CSV file, and removed the header lines at the top.  The line that starts with:


Cisco Systems NM Data import, Source=DCR Export; Type=DCRCSV; Version=3.0


And the line that contains:


;HEADER: management_ip_address,host_name,domain_name,device_identity,display_name,sysObjectID,dcr_device_type,mdf_type,snmp_v2_ro_comm_string,snmp_v2_rw_comm_string,snmp_v3_user_id,snmp_v3_password,snmp_v3_auth_algorithm,snmp_v3_priv_password,snmp_v3_priv_algorithm,snmp_v3_engine_id,rxboot_mode_username,rxboot_mode_password,primary_username,primary_password,primary_enable_password,http_username,http_password,http_mode,http_port,https_port,cert_common_name,secondary_username,secondary_password,secondary_enable_password,secondary_http_username,secondary_http_password


Are mandatory for the CSV to be recognized by DCR.

avang2004 Tue, 12/28/2010 - 12:53
User Badges:

If you are using Excel to edit CSV's make sure to remove the extra characters in the CSV. Here is an example of a modified CSV using Microsoft Excel 2007


// Microsoft 2007 Saved file with extra padded characters (BEFORE)


; This file is generated by DCR Export utility,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Cisco Systems NM Data import, Source=DCR Export; Type=DCRCSV; Version=3.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
;,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
;Start of section 0 - Basic Credentials,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
;,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
;HEADER: management_ip_address,host_name,domain_name,device_identity,display_name,sysObjectID,dcr_device_type,mdf_type,snmp_v2_ro_comm_string,snmp_v2_rw_comm_string,snmp_v3_user_id,snmp_v3_password,snmp_v3_auth_algorithm,snmp_v3_priv_password,snmp_v3_priv_algorithm,snmp_v3_engine_id,rxboot_mode_username,rxboot_mode_password,primary_username,primary_password,primary_enable_password,http_username,http_password,http_mode,http_port,https_port,cert_common_name,secondary_username,secondary_password,secondary_enable_password,secondary_http_username,secondary_http_password
;,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

10.1.1.1,CoreSwitch1,test.com,,CoreSwitch1,,,,,,,,,,,,,,,,,,,,,,,,,,,


,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
;End of CSV file,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


// You must clean up the extra characters (AFTER)


; This file is generated by DCR Export utility

Cisco Systems NM Data import, Source=DCR Export; Type=DCRCSV; Version=3.0

;

;Start of section 0 - Basic Credentials

;

;HEADER: management_ip_address,host_name,domain_name,device_identity,display_name,sysObjectID,dcr_device_type,mdf_type,snmp_v2_ro_comm_string,snmp_v2_rw_comm_string,snmp_v3_user_id,snmp_v3_password,snmp_v3_auth_algorithm,snmp_v3_priv_password,snmp_v3_priv_algorithm,snmp_v3_engine_id,rxboot_mode_username,rxboot_mode_password,primary_username,primary_password,primary_enable_password,http_username,http_password,http_mode,http_port,https_port,cert_common_name,secondary_username,secondary_password,secondary_enable_password,secondary_http_username,secondary_http_password

;

10.1.1.1,CoreSwitch1,test.com,,CoreSwitch1,,,,,,,,,,,,,,,,,,,,,,,,,,,


;End of CSV file

Actions

This Discussion