Solved: problems in bulk import in common services 3.1.1

harold.morales · ‎05-05-2010

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:

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?

Joel Monge · ‎05-10-2010

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.

View solution in original post

harold.morales · ‎05-05-2010

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

Joel Monge · ‎05-05-2010

Please post the actual CSV file you are using.

harold.morales · ‎05-10-2010

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

Joel Monge · ‎05-10-2010

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.