Editions ENI

Access the import service

From your ENI Portal administration console, click on the icon 

A window will open to guide you through:

• Creating users
• Editing users

Explanations are provided to help you with your imports

Creating users by import

Creating the import file

1. Open the creation template in Excel
2. Fill in the various columns (see appendices "Rules for filling in import files" for more detail)

Columns marked with an asterisk are mandatory

• Identifier*
• First name
• Name

Other columns can be deleted if not needed.

If only the email is filled in, then the user’s email will be the default Username. 

If both the email address and the username are filled in, the username will be selected by default.

1. In Excel, export the file to the correct format: "File"; "Save as"; "CSV UTF-8 (comma delimited) (*.csv)".
2. Limit: you can only import 2,000 rows at a time

Note: the file must be in .csv UTF8 format (delimited by commas). Files in CSV format (separator: semicolon) will also work, but CSV (Macintosh) or CSV (DOS) formats are not supported.

Select the file and the "Create users" option

1. In the import window, select the "Create users" action
2. Select the previously prepared file
3. Select your file format separar
   • Semicolon separator "; ".
   • Separator ", "

Once the file has been selected, a preview of the first line shows the file format and confirms which separator was generated by Excel when you saved it.

1. Select the date format used in the .csv file
   • DD/MM/YYYY
   • MM/DD/YYYY

NB: Date and time format is not permitted, only the date format is supported.

Selecting users to create

1. In the user selection screen, each cell in the table can be clicked on and edited in order to:
   • Correct lines with errors reported by the import tool (in red)
   • Edit certain values if necessary

The colour code used identifies whether the line can be imported or not

• Green: no functional error identified on the line
• Orange: The line has at least one non-blocking error for import.
• Red: The line contains an error and cannot be imported without a correction.

Each cell in the error or alert table has an information icon explaining the problem when you hover over it.

NB: If more than 5 lines come back in error (red), it is preferable to make the necessary corrections in your Excel file and then re-import it.

1. Tick the lines to be imported.
2. Click on the "Next" button to continue the import process. 

On the domain and user options selection screen: 

• Select the domain in which users are to be created.
• Select the group(s) or new group(s) to which users are to be enrolled.
• Define user options on the right of the screen 

The selection made will be applied to all users, with priority given to the data in the file.

1. You will then be able to choose from a range of buttons, such as "Close" to close the window or perform a "New Import".

Editing users by import

Preparing the “Edit users” file

NB: It is only possible to deal with one domain at a time.

NB: click on the "Export" button again to make the selection menu disappear. 

1. Open the exported file in Excel.
2. Keep only the rows and columns you wish to edit.
3. Choose between the "Username" or "#" column (ENI user reference) to reconcile the users to be edited. 

If both columns are filled in, the "#" column will be used for reconciliation.

1. Modify the required data (see appendices "Rules for filling in import files" for more detail).
2. In Excel, export the file to the correct format: "File"; "Save as"; "CSV UTF-8 (comma delimited) (*.csv)".
3. Limit: you can only edit 2000 lines at a time

Please note that the file must be in .csv UTF8 format (delimited by commas). Files in CSV format (separator: semicolon) will also work, but CSV (Macintosh) or CSV (DOS) formats are not supported.

Selecting the file and the "Edit users" option

1. In the import window, select "Edit users"
2. Select the previously prepared file
3. Select your file format
   • Semicolon separator "; ".
   • Separator ", "

Once the file has been selected, a preview of the first line shows the file format and confirms which separator was generated by Excel when you saved.

1. Select the date format used in the .csv file
   • DD/MM/YYYY
   • MM/DD/YYYY

NB: Date and time format is not permitted, only date format is supported.

Select the users to edit

1. In the user selection screen, each cell in the table can be clicked on and modified in order to:
   • Correct lines with errors reported by the import tool (in red)
   • Edit certain values if necessary (e.g. user email here)
   • Please note: the Username, first name and last name of learners who have already logged on to their learning environment cannot be changed. 

The colour code used identifies whether the line can be imported or not

• Green: no functional error identified on the line
• Orange: The line has at least one non-blocking error for import.
• Red: The line contains an error and cannot be imported if not corrected.

Each cell in the error or alert table has an information icon        detailing the problem when you hover over it.

1. Tick the lines to be imported for editing
2. Click on the "Next" button to continue the import process. 

Selecting domains and user options

1. In the selection screen for domains and user options: 
   • Domain selection in edit mode is automatic
   • Select the group(s) or new group(s) to which users are to be enrolled.

NB: If no group is selected, only the learner information will be edited and no additional enrollments will be made in a group. 

The selection made will be applied to all users, with priority given to the data in the file.

Tick boxes in an "intermediate" state allow data not to be updated (e.g. “password required” or the “validity period”).

1. A window will then show you detailed results of your import
2. You will then be able to choose from the various buttons available, "Close" in order to close the window or proceed with a "New import".

Use the Previous button to return to the user selection screen: the changes made to the screen the first-time round are retained, and users who have already been imported no longer appear.

This makes it easier to process the same file several times.

All that's left to do is the final phase (choosing the domain/group and selecting the options).

The New import button takes you back to the first import start-up screen, where you can choose a file to import.

Appendices

Rules for filling in import files

The user selection screen

The "Refresh" button is used to refresh the chosen filters according to the fields corrected or edited on the screen (Rows without errors - green, Rows with alerts - orange or Rows with errors - red) as well as the filters and sorts applied to the columns.

Click on the cross to remove filters if necessary.

You can display additional columns using the button 

Or filter on certain items using the dedicated fields or the button 

Specific administration rights

A Super Administrator is not restricted in terms of creating or editing users.

A Standard Administrator can only create or edit users if he/she has "Modification permitted" and "User management" rights for a given domain. They will only have access to learners in the domain to which they have rights. 

NB: Assigning rights to a group alone is not enough to give a Standard Administrator the rights to create and edit users. 

 If a Standard Administrator tries to edit a user to which he or she does not have rights, the line will be highlighted in red and an alert will appear on the user selection table.