Uploading reviews

It is possible to bulk upload research output reviews for the REF2029 module. This article explains how to prepare the spreadsheet, and how to upload it to Pure. Pure's review model uses templates which contains a set of questions, and the REF2029 research output review uses a specific review template. It is only possible to use the upload functionality for this specific review template. It is not possible to edit the review template that this import functionality uses.

Preparing data

To upload research output reviews to Pure, a spreadsheet must be prepared.  The template that is needed for the upload can be downloaded from within Pure. Go to the REF2029 overview page, and use the link: Download XLSX template.

Excel template

The template consists of 9 columns. The names of these columns must not be changed in the spreadsheet, otherwise the import will not work.

Column name	Description	Required
Research output ID	The Pure ID of the research output that is under review	✅
Title	Helper column, this is not imported. This is to help read and prepare the spreadsheet.
Review ID	Pure ID of existing review in Pure (introduced in 5.29.3)
Reviewing user ID	The Pure ID of the user, not the person, that have done the review. This user will be linked to the review, so it is reportable etc.	✅
Name	Helper column, this is not imported. This is to help read the spreadsheet
How would you rate this?	REF2029 star rating of the output. 1-4.  When using the 13 point scale, indicate the ratings with a + or - after the number, e.g. 3+ or 2-. To enable the 13 point scale An administrator is needed to enable the 13 point scale. It is disabled by default. To enable the 13 point scale go to Administrator tab → system settings → REF2028	✅
Comment	Any reviewer comments to be included
Which UOA should this be assigned to?	Suggestion to which Unit of Assessment this output should be assigned to if you're running Pure version prior to 5.28.2 Before 5.28.2 the grade must have a * prefixed, e.g. 4*, 4*-	✅
Final grade	REF2029 star rating. This is to record the final grade on the review.	✅
Review summary	Overall summary to store on the review.
Requested by (user ID)	Which user had requested the review. Use the Pure ID of the person.  This value must be the same, when entering multiple responses for the same output.  Introduced in version 5.31.2
Name	Name of user requested, only for reading purposes. Introduced in version 5.31.2
Summary visible (leave blank to follow review template)	Yes/no option. This value must be the same, when entering multiple responses for the same output. If not specified, the value on the template will be used. Introduced in version 5.31.2
Final grade visible (leave blank to follow review template)	Yes/no option. This value must be the same, when entering multiple responses for the same output. If not specified, the value on the template will be used. Introduced in version 5.31.2

You can have multiple rows in the spreadsheet for a single output, one per reviewer of said output. The final grade and overall summary should be the same for all those rows.

It is possible to have multiple rows per research output, and there are two different scenarios for this:

• if the research output ID and the UOA is the same, then each row will be created as additional responses for one review
• if the research output ID and UOA is NOT the same, then each row will be created as different reviews.

This way it is possible to bulk import/create multiple reviews or multiple responses for one review depending on the use case.

Importing reviews

To upload the prepared spreadsheet, go to the REF2029 module → overview. Here, it is possible to drag and drop the file, or to click and select the spreadsheet. Once this has been selected, or placed, the upload process starts automatically. 

It is possible to see a detailed status of the last 3 uploads, under the Import status just below the upload section. Here it is possible to see if there are any warnings or errors that need to be addressed to complete the import of reviews.