[CANMEDLIB] medRxiv instructions to export records

[Couban, Rachel]

Apologies for cross posting. Lots of people are interested in medRxiv for Covid content and my colleague shared with me a way to export records from medRxiv for screening that I thought you might me interested to know about!
Have a great weekend,
Rachel

Re exporting from medrxiv and importing into Rayyan, please find my steps below (not very sophisticated, but it worked!):

1. Accessed the "COVID-19 SARS-CoV-2 preprints from medRxiv and bioRxiv" page, if you scrolled to the bottom, in the left corner there are links to "Collection RSS" or "JSON"
2. Click on JSON and a new tab with simple text will pop open, this is the whole archive in simple text.
3. Select all and copy all of the text.
4. Open an online JSON to CSV/excel converter (I used this one: https://www.convertcsv.com/json-to-csv.htm) - it takes a while to convert into excel or csv
5. Download the csv/excel
6. Format the relevant columns with the titles that Rayyen needs for indexing (detailed on their upload page) https://rayyan.qcri.org/reviews/131265/searches/new
7. upload into rayyan

Hope this helps!