User Upload Error report

This report contains errors encountered when importing the User Upload Template, used to manage study users in bulk.

The User Upload Error report generates automatically after an user upload template is imported with errors. See Add and update study users in bulk. This report includes details about what has failed, which you can use to know what to correct in the template file for a successful upload. If after importing a file, the Bulk User Upload notification indicates any user with errors, download the User Upload Error report to review and address any import issues.

Tip:

This report uses the same format as the User Upload template. You can fix errors directly in this report and upload it as the user upload template to create and update users in bulk.

For information about using the User Upload Template, see Add and manage study users in bulk.

The report can also be manually generated at any time. Manually generated reports are cumulative and include all errors encountered in all imports processed during the specified date range. If no date range is specified, the report includes all errors encountered over the last seven (7) days.

Note:

We don't recommend importing cumulative reports for user upload. Cumulative reports might contain duplicated records and even contradictory information for a same user.

Modes

Available in 3 modes: Testing, Training, and Production.

Permission required to run the report

Users assigned to a role that includes the Run the User Upload Error Report permission can run this report. This is a permission available for sponsor type study roles, assigned in Testing, Training and Production modes.

Report filters for manually-generated reports.

Filter	Description
Date Range	The report output includes import errors encountered during the range specified. Errors are retained for seven (7) days unless addressed. Tip: If you need import information for an import processed on the 15th, use the range from the 14th to the 16th.
File Type	XLSM

Filter

Description

Date Range

The report output includes import errors encountered during the range specified. Errors are retained for seven (7) days unless addressed.

Tip: If you need import information for an import processed on the 15th, use the range from the 14th to the 16th.

File Type

XLSM

Report output fields for system and manually generated reports

Header fields	Description
Customer Name	The customer name used to purchase the cloud subscription.
Study Name	The study ID entered by the study manager when the study was created.
Mode	The mode the report was run in, either Testing, Training, or Production.
Report Generated By	System-generated displays System. Manually-generated displays the user name of the person who generated the report.
Created Date	The date and time, in UTC, when the report was created.
Date Range	Only included in user-generated reports. The date range entered when the report was run.

Column name	Description
First Name	First name of the user.
Last Name	Last name of the user.
Email	Email address of the user.
User Name	User name assigned to the user.
Start Date	The first day the user can access the study.
End Date	The last day the user can access the study.
Role	The name of the study role assigned to the user. Tip: To populate the drop-down click Enable Content then go to the Study Roles tab and click Validate Roles.
Site IDs	The site or sites the user was assigned to.
Depot IDs	The depot or depots the user was assigned to.
Comment	Comments entered by the user, in the user interface, while processing the import file.
Uploaded by	The user name of the person who imported the user upload template.
Uploaded at	The date and time, in UTC, when the user upload template was imported.
Error Message	Details about the error.

Related Topics

Parent topic: Report descriptions