Spreadsheet upload

To upload bulk clinical data associated with your cohort, you can use the the spreadsheet upload functionality of XNAT which is found in the Upload > Spreadsheet menu.  This page will walk through uploading a spreadsheet of subject data.  The other main use cases for the DPUK project will be uploading dpukAssessmentData and dpukRiskFactorAssessmentData for which the same model can be followed.

You must first select the data type that your spreadsheet will import
You must first select the data type that your spreadsheet will import

Once you’ve created a spreadsheet upload, the template will be saved for future use, hence the requirement for a title – we suggest “cohortname subjects”.  Having selected the xnat:subjectData Root Data Type and clicked Submit you will be faced with a long list of values.  This is where you define your template.  Check the columns that you have/need as shown in the screen capture.  You’ll also need to select the xnat:demographicData join in order to upload year of birth etc.  See Subject data in the the hub for more detail.

Then you must select the columns that your spreadsheet will contain
Then you must select the columns that your spreadsheet will contain

Having selected the columns and clicked Submit you will be given the option to provide the spreadsheet to upload the data, or test values from a single subject in a web form.  It’s unlikely that you’ll be able to use your original spreadsheet.  Instead, you’ll need to craft a customised version of your cohort spreadsheet where the first column is the subject ID and following columns are selected to match the order of the columns that you’ve selected in the previous step.  The “Download Template” link at the top of the next page provides a CSV template of headers that you can use to create your customised spreadsheet.   If you wish to delete a template or add the dpuk subject id column to your template, you’ll need to ask a friendly sysadmin.

When you’ve uploaded or submitted that data you’ll see a test view of the data which you can use to make sure the columns line up correctly.

A draft run will be shown that allows you to see if the columns line up
A draft run will be shown that allows you to see if the columns line up

When you click the Save button a full data upload will be attempted. This stage will fail if column contents dont align with the valid contents of the data model, but if you succeed you’ll see a page like this.

The final wizard will tell you if you're import has been successful
The final wizard will tell you if you’re import has been successful

And when you return to the Project page you should see your newly uploaded subject data shown.

For subject data you'll see your data in the project details page
For subject data you’ll see your data in the project details page