lms credentials

Unanswered Question
Mar 7th, 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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Joe Clarke Mon, 03/08/2010 - 11:06

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

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