Can I Import Users from an Existing Database into SecurityGateway?
SecurityGateway has the ability to read information from a comma-separated-value (CSV) file to help automate the process of adding users to the database. The format that SecurityGateway looks for is as follows: Email, 'MailBox', 'Domain', 'FullName', 'Password' at the top of the list, with the relevent information in each column below.
To import users into SecurityGateway from a CSV file:
- Log into the SecurityGateway site with a global administrator account.
- Click on Setup / Users in the bottom-right corner.
- Under Users and Administrators on the right pane locate 'Manage Users'.
- Click on the domain you wish to import users into.
- Click on the Import button along the top to bring up the Import Users dialog box.
- Click on Browse, and then navigate to the location where the .CSV file is saved.
- Click on Import Users at the top of the pop-up window.
You will see an information window listing the results of the import, including all lines read, all accounts imported, any accounts that were skipped, and any new domains that were added.
Additional Notes:
If you have accounts from multiple domains in the CSV file when you import, they will be added to their respective domain in SecurityGateway's domain if you have already created the domain. You may also check 'Autocreate domains for users that are imported with domains that don't exist yet in SecurityGateway' in the Import Users pop-up window to automatically create any domains that are imported.
Imported accounts that already exist in the user database will be added, but with the full name filled with a random string of characters.
Related Articles
Addressing problems with the SecurityGateway database
SecurityGateway uses a Firebird database and this database type is not prone to corruption, but there are circumstances where it will envitably encounter problems such as where there is direct interaction by 3rd Party software (eg. 3rd party ...
Adding the Abusix Mail Intelligence blocklists to SecurityGateway
Abusix Mail Intelligence is a set of blocklists that are designed to help protect mail servers from spam, malware, phishing and ransom attacks. You can sign up for a free 14-day trial of Abusix Mail Intelligence at https://abusix.com/. The trial will ...
How do I move SecurityGateway to another machine?
You will need to make a backup of the database, download and copy the backup file to the new machine, install SecurityGateway, and import the database. To do so, please follow these steps: Log into the SecurityGateway site with a global administrator ...
Importing domain information into SecurityGateway from a CSV file
This article explains how to import domain information into SecurityGateway's database from a comma-separated-value (.CSV) file, if you have one exported from SecurityGateway, MDaemon, another application, or created manually. From the Dashboard, ...
Setting up automatic domain creation in SecurityGateway
This article explains how to enable SecurityGateway's automatic domain-creation feature, so that any email sent through the server with an unknown domain will be added to the database, with default information. SecurityGateway by default creates new ...