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.
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.
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.
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.
And when you return to the Project page you should see your newly uploaded subject data shown.
