EBISPOT / gwasdepo-deposition-service

0 stars 1 forks source link

Deposition - Populate Old Studies with Analysis Software values #242

Closed sajo-ebi closed 4 months ago

sajo-ebi commented 6 months ago

As part of persisting Analysis software to DB , we also need to populate old values so that API can access the field, Yue to share the mapping sheet for old studies , need to write some utility script to copy using the mapping sheet to Mongo DB

ljwh2 commented 5 months ago

@jiyue1214 just tagging you to provide information on analysis_software values to Sajo

eks-ebi commented 5 months ago

See spreadsheet link and further info in this ticket: https://app.zenhub.com/workspaces/gwas-59df823c4a6feb3786810391/issues/gh/ebispot/gwasdepo-deposition-service/239

sajo-ebi commented 4 months ago

@jiyue1214 @earlEBI the analysis software has been updated for the attached sheet , there were few rows where Yue had update that it depends upon Biobank , @earlEBI request you to check those if needed we can update again

sprintell commented 4 months ago

@earlEBI could you please help confirm this ?

earlEBI commented 4 months ago

Why does eg. GCST90296659 have no analysisSoftware populated in Mongo db?

sajo-ebi commented 4 months ago

@earlEBI the study 'GCST90296659' had two entries in DB one association to Metadata submission & other related to Sumstats submission, the query I ran was updating just one record, now I have updated the query to run for multiple entries for all studies , kindly confirm at your side.

earlEBI commented 4 months ago

ok I've checked a few and analysisSoftware is correctly populated in Mongo db.