Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

problems in bulk import in common services 3.1.1

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: problems in bulk import in common services 3.1.1

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.

4 REPLIES
New Member

Re: problems in bulk import in common services 3.1.1

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

Cisco Employee

Re: problems in bulk import in common services 3.1.1

Please post the actual CSV file you are using.

New Member

Re: problems in bulk import in common services 3.1.1

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

Cisco Employee

Re: problems in bulk import in common services 3.1.1

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.

637
Views
0
Helpful
4
Replies
CreatePlease to create content