lms credentials

anandkumar.cisco · ‎03-07-2010

Dear all,

im getting the follwing error

while i m uploading the file in Csv format
by modifying the previous one

Invalidfileformat: no Header information in the input file

Joe Clarke · ‎03-08-2010

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 · ‎12-28-2010

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