Laura Harris

Hi @earlEBI > Ontology mapping is missing for http://ftp.ebi.ac.uk/pub/databases/gwas/summary_statistics/GCST90427001-GCST90428000/GCST90428000/ , etc. we think these studies shouldn't have EFO as it's a prepub submission, could you just confirm that is correct...

@ljwh2 to confirm

confirmed

@eks-ebi to add to next user support epic

@earlEBI we confirmed analysis_software exists in mongo but not Oracle.

Verified this is an issue

we require a script to automate the process that is done at the moment -pulling info from log files in different places. To be run monthly to collate information per...

@ala-ebi to fin location on ftp to store files ,and set up cron job to run monthly

To be verified after 1st Oct

Another column indicating whether the study is published or prepublished - so the user knows which table to refer to for the metadata