Users in Halo can be bulk imported and passwords updated if Active Directory has not been enabled/configured. The steps below explain how.

Step 1: Amend CSV Separator

For imports into Halo, the CSV values need to be separated by a semicolon rather than the standard comma. To amend this, you need change the following setting in Windows:

1. Go to Window Settings
2. Click Time and Language
3. Click Region
4. On the right, under Additional settings, click ‘Additional Date, Time and Regional Settings’
5. In the new box, click ‘Change Date, Time and Number Formats’
6. In the region box, click Additional settings at the bottom
7. Under list separator, amend to a semi-colon and save.
8. Now, continue below to import users or any other content into Halo.

Step 2: Import Users

1. Export existing users as CSV

2. Split Text to Columns
3. Add a new column at the end labelled ‘Password’ and populate it with the password.
4. Add a new column at the end labelled 'Passwordchangeatfirstlogin' and populate with TRUE.
5. Save as CSV and import.