To create a password import CSV file, two reference files are provided for you to help create your CSV file. To locate them:

1. Login to GFI OneConnect using an administrator account.
2. From the top-right menu, navigate to Settings > Users.

3. Click Upload Passwords.
4. To download a CSV template file that you can use to start your own CSV file, click Download Template.

Row number	A	B	C	D
1	Primary Email	Password	Welcomed	Notification
2	user1@example.com	user1-p4ssw0rd	Y
3	user2@example.com	user2-p4ssw0rd	N	user2@other.com
4	user3@example.com	user3-p4ssw0rd		user3@other.com
5	user4@example.com	user4-p4ssw0rd	Y

The first row must contain the import file header typed exactly as it appears below:

• First column: Primary Email
• Second column: Password
• Third column: Welcomed
• Fourth column: Notification

Each additional row must contain the following information for exactly one user:

Column	Required	Description
Primary Email	Required	This address must match the user’s existing email address in the system. If your file contains an unrecognized email address, the reset fails.
Password	Optional	The password to import for the user. During the import step, you can choose to enforce your organization’s password policy when importing these passwords or to ignore it. To leave a user’s existing password as it is, leave this column blank.
Welcomed	Optional	A flag indicating whether the user has already been welcomed to the system. To leave the user’s existing flag as it is, leave this column blank. To indicate that the user has already been welcomed, set to Y. To indicate that the user must be welcomed the next time they log in, set to N.
Notification	Optional	An optional notification address for the user. To set the notification address to the same value as the user’s primary address, set this column to Y. To set an alternate address, type the email address in this column. To leave the user’s existing notification address, leave this field blank.

Save your import file as a CSV file with UTF-8 encoding.

To import passwords by CSV file:

1. Login to GFI OneConnect using an administrator account.
2. From the top-right menu, navigate to Settings > Users.

3. Click Upload Passwords.
4. In Select Import File, click Browse to locate the CSV file you want to import. Locate the file, then click Open.

5. Under Import Options, select the options to apply to this import:

Option	Description
Overwrite passwords that were already created	Overrides any existing permanent passwords with those specified in the upload file. Leave this box blank (unchecked) to leave any existing permanent passwords.
Passwords must be at least 6 characters long and not the same as the user's primary email address or user ID.	Check this box to validate the passwords you are uploading against the criteria listed. If this box is checked, all passwords in the file must meet the listed criteria, or the import fails. Uncheck this box to upload all passwords in the file without applying any validation criteria.
Require users to change these passwords at next login.	Check this box to upload the passwords as temporary passwords that users must change immediately when they next log in. Uncheck this box to set the passwords as permanent, that can be used until they meet any expiration criteria defined by your organization.

6. Click Next.
7. The Validation Results page displays the total number of users found in the file, the number of users that will be imported or skipped, and any other important information. Click Download Validation Results to download a CSV file that shows any users that are skipped or whose information contains errors. You can use the information in this file to revise your import file, if necessary. Commented (informational) rows in the file begin with the # character. To find users whose information contains errors, look for rows that do not begin with the # character
8. If no validation errors are found, you can proceed with the bulk reset by clicking Import.