Invalid CSV file format in OneCollect

[ebala]

type,subTypes,host,username,password,privileged_password,port,sudo_enabled,sudo_pass,privatekey,mfa_enabled,mfa_key
Storage Controller,ontap,x.x.x.x,admin,pass,,,,,,true,mfa_key_path
Storage Controller,ontap,x.x.x.x,admin,pass
Storage Controller,seven,x.x.x.x,root,pass
Storage Controller,SolidFire Cluster,x.x.x.x,admin,pass,,555
Storage Controller,SolidFire Node,x.x.x.x,admin,pass
Storage Controller,E-Series Webproxy,x.x.x.x,admin,pass
Storage Controller,E-Series SMCLI,x.x.x.x,admin,pass
Storage Controller,ServiceProcessor - ONTAP,x.x.x.x,admin,pass
Hybrid switch,Cisco Nexus 5000,x.x.x.x,admin,pass
Hybrid switch,Cisco Nexus 6000,x.x.x.x,admin,pass
Hybrid switch,Cisco Nexus 9000 ,x.x.x.x,admin,pass
Ethernet Switch,NetApp Switch,x.x.x.x,admin,pass,pass2
Hybrid switch,Cisco Nexus 7000 Switch,x.x.x.x,admin,pass
Ethernet Switch,Cisco Switch,x.x.x.x,admin,pass
FC Switch,Cisco Switch,x.x.x.x,admin,pass
FC Switch,Brocade Switch,x.x.x.x,admin,pass
FC Switch,QLogic Switch,x.x.x.x,admin,pass
FC Switch,McData i10k,x.x.x.x,admin,pass
FC Switch,McData,x.x.x.x,admin,pass
Host,Linux,x.x.x.x,root,pass,,22,true,xxx,
Host,Windows,x.x.x.x,domain\administrator,pass
Host,HPUX,x.x.x.x,root,pass
Host,AIX,x.x.x.x,root,pass
Host,Solaris,x.x.x.x,root,pass
Host,Cisco UCS,x.x.x.x,root,pass
Hypervisor,VMware ESXi,x.x.x.x,root,pass
Hypervisor,PowerVM,x.x.x.x,root,pass
Hypervisor,OracleVM Manager,x.x.x.x,root,pass
Hypervisor,OracleVM Server,x.x.x.x,root,pass
Hypervisor,KVM,x.x.x.x,root,pass
Hypervisor,HMC,x.x.x.x,hscroot,pass
Hypervisor,Citrix XenServer,x.x.x.x,root,pass,,22,true,xxx,
Hypervisor,VMware vCenter Server,x.x.x.x,root,pass
Hypervisor,Microsoft Hyper-V,x.x.x.x,root,pass
Other Storage Controller,Isilon Controller,x.x.x.x,admin,pass
Cloud Services,NetApp Cloud Backup,x.x.x.x,admin,pass,,,,,private_key_text,,
Cloud Services,Cloud Volumes ONTAP,x.x.x.x,admin,pass,,,,,private_key_text,,
Cloud Services,StorageGRID Webscale,x.x.x.x,admin,pass

[ebala]

anyone knows the solution for this? Im importing a 200++ ESXi hosts in OneCollect using csv, format should be 

type,subTypes,host,username,password,privileged_password,port,sudo_enabled,sudo_pass,privatekey,mfa_enabled,mfa_key

Hypervisor,VMware ESXi,x.x.x.x,root,pass

Ive tried editing it in the excel directly, opening to excel and "save as" it to different csv format, convert unix2dos and dos2unix but still has an error "invalid csv format"

anyone can help? Thanks

[NithinR]

Hi @ebala,

   Please ensure you are using the template that came along with the installation. A .csv template can be found inside the installation directory. Also, let us know if you are using the latest OneCollect 1.6 version.

  If that does not solve, you may copy the template you use here (after removing/masking credentials). We can check issue with file and send you updated one.

Thanks,

   Nithin

[NithinR]

I will send a sample with 100 dummy ESXi hosts, pm your email address. Also note that for ideal performance, it is recommended to limit to 50 hosts per job. But that is not a hard limit and that should not block the import.

Thanks,

   Nithin

[ebala]

I cannot attached a file

[ebala]

Here's the content

type,subTypes,host,username,password,privileged_password,port,sudo_enabled,sudo_pass,privatekey,mfa_enabled,mfa_key
Hypervisor,VMware ESXi,x.x.x.x,root,pass,,,,,,,