problems in bulk import in common services 3.1.1

Answered Question
May 5th, 2010
User Badges:

I have a problem,


I need to import multiple devices to cisco works, I have the following file format:


; 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_engine_id,snmp_v3_auth_algorithm,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
;
1.1.1.1,name1,cisco.com,,name1,,,,public_RO,,,,,,,,,,,,,,,,
1.2.2.2,name2,cisco.com,,name2,,,,common_RO,common_RW,,,,,,,user,pass,passSA,,,,,,

;End of CSV file


however, when i try import, as in the attached image, The following error occurs:CW.JPG


Import from file failed. Reason: Invalid file format. Line 7 of the input file has more fields than the HEADER



what is the error in my. csv file?






Correct Answer by Joel Monge about 7 years 1 month ago

Try attached file.  The best way to resolve these types of problems is performing a DCR export from the server.  Then, edit this file using Notepad++ to include the devices you want.  Sometimes if you open with Excel it can change the format of the file making it unusable after saving.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
harold.morales Wed, 05/05/2010 - 07:57
User Badges:

to clarify, I'm sure the same number of fields in the HEADER is the same number of field devices

Joel Monge Wed, 05/05/2010 - 08:39
User Badges:
  • Cisco Employee,

Please post the actual CSV file you are using.

harold.morales Mon, 05/10/2010 - 09:47
User Badges:

the name of the archive is ciscoworks.csv



this is the archive:


; 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_engine_id,snmp_v3_auth_algorithm,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
;
192.168.1.13,FDQ2345_BOG_Calle100,,,FDQ0011_BOG_Calle100,,,,COMM_RO,,,,,,,,,,,,,,,,
192.168.2.24,Sw_Cll12_P5_C1_01,,,Sw_Cll12_P5_C1_01,,,,CISCO_RO,CISCO_RW,,,,,,,usradm,Admin123,4dm1nLTDA,,,,,,

;End of CSV file

Correct Answer
Joel Monge Mon, 05/10/2010 - 11:48
User Badges:
  • Cisco Employee,

Try attached file.  The best way to resolve these types of problems is performing a DCR export from the server.  Then, edit this file using Notepad++ to include the devices you want.  Sometimes if you open with Excel it can change the format of the file making it unusable after saving.

Attachment: 

Actions

This Discussion