topic Re: Invalid CSV file format in OneCollect in Active IQ Unified Manager Discussions

Invalid CSV file format in OneCollect

ebala — Wed, 04 Jun 2025 12:57:31 GMT

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

Re: Invalid CSV file format in OneCollect

ebala — Tue, 15 Jan 2019 10:15:48 GMT

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

Re: Invalid CSV file format in OneCollect

NithinR — Tue, 15 Jan 2019 11:51:36 GMT

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

Re: Invalid CSV file format in OneCollect

NithinR — Tue, 15 Jan 2019 12:00:08 GMT

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

Re: Invalid CSV file format in OneCollect

ebala — Tue, 15 Jan 2019 12:06:15 GMT

I cannot attached a file

Re: Invalid CSV file format in OneCollect

ebala — Tue, 15 Jan 2019 12:08:55 GMT

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,,,,,,,