[CANMEDLIB] medRxiv instructions to export records

[Pinotti, Rachel]

Thanks for sharing.  Here's another way to accomplish this that I used with a rapid review team I'm working with:

  1.  Download Zotero<https://www.zotero.org/download/> application and browser extension for Chrome. If it's your first time using Zotero, you'll also need to set up an account on the Zotero website.  (Application, browser extension and account are all free.)  Make sure the Zotero program is open when you complete the remaining steps.
  2.  Run search in MedrXiv.
  3.  On the results page for each search, change the Items/Page setting to 75. Click the Zotero browser plugin, click the Select all results option, then click ok.  Be sure to repeat this process for all pages of search results.
  4.  Once you've exported all the results from all searches to Zotero, go to the Zotero program.  Click File, then Export Library.  From the Format dropdown menu, select RIS.
  5.  Import RIS file into Covidence, Rayyan or other screening venue of choice.

Best regards,
Rachel


Rachel Pinotti, MLIS, AHIP

Director, Library Education and Research Services

Levy Library, Icahn School of Medicine at Mount Sinai

1 Gustave Levy Place, Box 1102

New York, NY 10029

212-241-7204

rachel.pinotti at mssm.edu<mailto:rachel.pinotti at mssm.edu>



Follow us on Twitter @Levy_Library<https://twitter.com/Levy_Library> to learn about Levy Library events and initiatives.

________________________________
From: expertsearching <expertsearching-bounces at pss.mlanet.org> on behalf of Couban, Rachel <rcouban at mcmaster.ca>
Sent: Friday, April 24, 2020 4:15 PM
To: canmedlib at chlaabsc.koumbit.org <canmedlib at chlaabsc.koumbit.org>
Cc: expertsearching at pss.mlanet.org <expertsearching at pss.mlanet.org>
Subject: [Expertsearching] medRxiv instructions to export records

USE CAUTION: External Message.

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://urldefense.proofpoint.com/v2/url?u=https-3A__www.convertcsv.com_json-2Dto-2Dcsv.htm&d=DwICAg&c=shNJtf5dKgNcPZ6Yh64b-A&r=rjUBvtGxtgQ1p_hssCnBbq95pBHNNB-W_uH3-XYwiiM&m=9Bs_n6yq_g2LPQ5r1bVzYktjbpb4vetbbOJzci62yNA&s=NIKMdMgco4FDd7CptbYmpQfIM31x3_EyVjoQ2a8E1D8&e= ) - 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://urldefense.proofpoint.com/v2/url?u=https-3A__rayyan.qcri.org_reviews_131265_searches_new&d=DwICAg&c=shNJtf5dKgNcPZ6Yh64b-A&r=rjUBvtGxtgQ1p_hssCnBbq95pBHNNB-W_uH3-XYwiiM&m=9Bs_n6yq_g2LPQ5r1bVzYktjbpb4vetbbOJzci62yNA&s=AIwDA9LTrtOVoqIRjyFvz2Q2m9hmhQ8nASAVeCXPMb4&e=
7. upload into rayyan

Hope this helps!
_______________________________________________
expertsearching mailing list
expertsearching at pss.mlanet.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__pss.mlanet.org_mailman_listinfo_expertsearching-5Fpss.mlanet.org&d=DwICAg&c=shNJtf5dKgNcPZ6Yh64b-A&r=rjUBvtGxtgQ1p_hssCnBbq95pBHNNB-W_uH3-XYwiiM&m=9Bs_n6yq_g2LPQ5r1bVzYktjbpb4vetbbOJzci62yNA&s=F8FMrLjWYmIFYiTclShtmvIpr2fPyw1vGPL2dAoYah8&e=
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/canmedlib-chlaabsc.koumbit.org/attachments/20200424/92b6806c/attachment-0001.html>