This feature requires server version 10.7.1 or higher.

After either downloading a template or exporting user data, the .CSV file may be edited in a spreadsheeting application (preferably), or in a plain-text editor.

The first row of the CSV is ignored in the Bulk Update utility as it is always assumed to be the column headers.

Actions 

The first column in the CSV is the Action column. The Action Code specified in this column defines what changes (if any) will be performed on the user described in that row. Each Action requires at least one field as mandatory.

The utility supports different actions being taken on different rows. i.e. It is possible to Add accounts, Delete accounts, Change accounts and Update accounts all with a single file load.

Action	Action Code	Required fields
Add	A	All mandatory fields (columns marked with a leading asterisk in the template) are required.
Delete	D	IRN required, all other fields optional.
Change	C	IRN required, all other fields optional. If fields marked mandatory are empty in the template, they will not be changed. If optional fields are empty in the template, they will be cleared.
Update	U	If IRN is set with a valid user account IRN, the corresponding account will be updated. If the provided IRN is not a valid user account IRN, an error will be displayed. If IRN is not set, the ID field will used to retrieve the user account. If the ID matches as existing account, it will be updated. If the ID does not match an existing account, it will be created.
Do nothing	(Null)

Caution: The Change action will clear (set to null) any optional fields with no value.

Once the CSV has been updated to include all the required details, save the file locally before using the Import File feature.