Y24-422 - As an SSR, I would like to bulk upload study data from a CSV file generated from the SSR's Study Setup Google Form

[harrietc52]

User story As the SSR team, we would like to be able to bulk upload study data from a CSV file generated from our Google Study Setup Form, to reduce the manual load and errors created when Study data is copy and pasted into the Sequencescape study creation page.

Currently, for HumGen and GenGen, Study data is added to a word document, which it is then copied into Sequencescape from. This is being replaced with a Google Form that outputs a CSV. There would be one row per Study

This form would support the data required for both EGA & ENA release strategies.

Who are the primary contacts for this story @harrietc52

Who is the nominated tester for UAT Liz C

Acceptance criteria To be considered successful the solution must allow:

• [ ] Keep the SSR team updated with the Study creation headers required to create a study in SS
• [ ] The SSR teams Google Study Setup Form CSV export, includes headers that match the fields in SS Study creation page
• [ ] A new page is created to handle the creation of Studies via uploading a CSV
• [ ] From the new page, you can upload data from a CSV
• [ ] Each header in the CSV corresponds to a field in the SS Study creation
• [ ] Each row in the CSV, contains new Study data
• [ ] CSV upload can create 1 or more Studies
• [ ] User friendly messages are shown if successful or not

Dependencies This story is blocked by the following dependencies:

• 4443

References This story has a non-blocking relationship with:

• Research story Y24-374

Additional context

Fields to be added: PSD Google Sheet with DAA fields

[harrietc52]

Questions (Liz C)

• Where would you like this to appear? e.g. as a Link on the right pane “Bulk Study upload from CSV”, which opens to a new page?
• Hows best to keep Sequencescape Study headers in sync with SSR Google Study Set Up Form?