Skip to Content

Import servers from a CSV file into Ezeelogin

How to import servers from a file into the Ezeelogin SSH gateway?


Overview: This article describes how to efficiently import servers from a CSV file into the Ezeelogin SSH gateway, which also covers mandatory fields, validation steps, and handling of success and error messages.



To import servers from a CSV file into the Ezeelogin SSH gateway, follow these steps:

Step 1: To import a list of servers from a CSV file, navigate to Servers -> Import and choose the CSV file and click upload

Step 2: Once you click upload, the CSV file will be parsed and if the format is correct, then the import button will show up so that you can import the list of servers. Using this feature you can import multiple servers quickly.

Step 3: After the successful import of the servers, it will display the message "Servers imported" as shown in the screenshot below.

Step 4. If the server already exists, it will display the error message "No valid new servers to import" (The server exists) as shown in the screenshot below.

Step 5: If the server group does not exist, it will display the error message "No valid new servers to import" (No such server group) as shown in the screenshot below.

  • This is what the importing CSV file would look like. The first line would be the header and the second line would be the server that has to be imported. You can also use the export feature to get a CSV file as shown below which can be later used as a template to import more servers.

"name"|"ip_address"|"group"|"password"|"ssh_port"|"ssh_user"|"keep_password"|"enable_ssh"|"controlpanel"|"datacenter"|"description"|"tunnel_host"|"switch_user"|"switch_pass"|"switch_sudo"|"prompt1"|"prompt2"|"prompt3"|"cp_user"|"cp_pass"|"rc_host"|"rc_user"|"rc_pass"|"onhost"|"ishn"|"rack_id"|"machine_id"|"comments"|"use_dns"|"passphrase"|"ssh_key"|"rdp"|"windows_domain"|"ipmi_host"|"ipmi_protocol"|"ipmi_port"|"ipmi_request_method"|"ipmi_user_field"|"ipmi_username"|"ipmi_passwd_field"|"ipmi_password"|"ipmi_basic_auth"|"ipmi_request_uri"|"ipmi_extra_vars"|"ipmi_enable"

"ez.noc.com"|"118.7.63.62"|"LINUX"|""|"22"|"root"|"S"|"Y"|""|""|"TestMachine"|""|""|""|"N"|""|"Password:"|""|""|""|""|""|""|""|"N"|""|""|""|"N"|""|""|"N"|""|""|"https"|"80"|"POST"|""|""|""|""|"N"|""|""|"N"


What are the mandatory fields required to import the servers from a CSV file?

+------------------------------------------------------------------------------------------------+
| name       | ip_address  | group | password | ssh_port | ssh_user | keep_password | enable_ssh |
+------------------------------------------------------------------------------------------------+
| ez.noc.com | 118.7.63.62 | Linux |          | 22       |          | S             | Y          |
+------------------------------------------------------------------------------------------------+

name FQDN or name of the server
ip_address  Remote server IP
group  Server group that exists in Ezeelogin
password  The password of the remote SSH user (leaving blank will be asked for prompt)
ssh_port  SSH port of the remote server
ssh_user  The username of the remote SSH user (leaving blank will be asked for prompt)
keep_password 

Set password management for the server (leaving blank will set it to automatic)

Y (keep given password), N (automatic), S (keep server password)

enable_ssh  Enable SSH access for the remote server (leaving blank will set enable_ssh to no)

Related Articles:

Add/update/delete servers through Ezeelogin API.

Password management option in Ezeelogin.

Export server into CSV file.

Common errors while importing servers