What is the "Import Excel" feature for OSD permissions?
The IEC EMS allows NC administrators (NC Admin) to assign OSD permissions to multiple users in a single operation by importing an Excel file. This avoids having to add rights one by one manually.
Accessing the import feature
-
Log in to the EMS.
-
Go to NC User Management (main menu).
-
Click the OSD Permissions tab.
-
Click the Import Excel button (top right of the list).
How do I get the template file?
When the import dialog opens, a download link is available. Click the download icon to the right of the filename:
Template: osd_access_import_template.xlsx
Filling in the OSD access import Excel template file?
The file contains 3 columns:
|
Column |
Description |
|---|---|
|
|
Email address of the user to assign the permission to |
|
TC/SC |
The committee(s) concerned (ALL for all, or a comma-separated list, e.g. TC 1, TC 32/SC 32B, TC 18) |
|
ROLE |
The OSD role to assign: OSD VOTER, OSD MANAGER, or OSD COMMENTER |
Important rules:
• Do not modify the first row (column headers).
• The email address must match a user from the same NC as the administrator importing the file.
• Each row = one combination of user / committee(s) / role.
• Only one role is allowed per row.
Example of valid content:
EMAIL
|
TC/SC
|
ROLE
|
|---|---|---|
john.smith@dnc.org
|
ALL
|
OSD VOTER
|
mary.jones@dnc.org
|
TC 1, TC 32/SC 32B
|
OSD MANAGER
|
paul.brown@dnc.org
|
TC 9
|
OSD COMMENTER
|
How do I import the file once it is filled in?
5. In the Import Excel dialog, click Choose File and select your file.
6. Click Next.
7. The EMS moves to the File Validation step and analyses the file.
What happens during validation?
The EMS checks each row of the file and displays a summary:
• OK: the row is valid and will be imported.
• Error: the row contains an error and will not be imported (unless corrected).
Most common errors:
|
Error message |
Likely cause |
|---|---|
|
unknown email address |
The email address does not match any user from your NC in the EMS |
|
The email field cannot be empty |
A row in the file does not contain an email address |
Fixing errors in the interface?
During the File Validation step, you can:
• Edit the rows with errors directly in the grid (click the Edit button).
• Click Validate Again after making corrections to re-run the validation.
• Click Finish to import only the valid rows (error rows are skipped).
What if all rows return an "unknown email address" error?
Check that:
• The email addresses used are the ones registered in the EMS for users in your NC.
• You are using the template downloaded from the EMS (not a file created from scratch).
• You are logged in as an administrator of the correct NC.
What are the three available OSD permissions?
OSD Voter
OSD Manager
OSD Commenter
Exporting the existing list of OSD permissions
In the OSD Permissions tab, click Export Excel to download the full list of currently registered permissions, with any filters applied.