The Import user page can be accessed through the navigation panel on the left side of the
The Excel file shall consist of both theThe fallback content to display on prerenderingand email field (ifThe fallback content to display on prerenderingis used for the user instance), values need to be correct for eachThe fallback content to display on prerendering.
Other columns are not mandatory to have in the Excel file, but any field to be updated or imported should have a column name that matches the name of this field in theThe fallback content to display on prerenderingrecords in the database. Overwise, new values with new field names will enrich existing user records in the database or make a mess in the reports.
Make sure that you have the right format in the Excel file
Select and upload the Excel file to the system
Analyze the Excel file (data)
The Analyze function performs a quick analyze on the
If there are any errors in the import phase, check the excel file:
- All problems (if any) reported after the analyze action is done. The problems should be solved within the excel file for the admin to proceed with the import.
When the problems have been solved, the admin can click import.
The import operation updates existing records and imports new records from the uploaded excel file.
The import operation can block and unblock existingThe fallback content to display on prerendering, if an excel file for import operation contains also the blocked field with 0 value (to unblock) or with "1" value (to block) in user’s row. The user’s row with empty blocked filed in excel file for import will not changeThe fallback content to display on prerenderingstatus (active, blocked).
After import ends, the system shows import statistics. Admin should check for any errors.