UX Caucus Database Tips

Many thanks to Ben Harnke, MLIS from the Strauss Health Sciences Library, University of Colorado (ben.harnke@cuanschutz.edu) for this week's tip!   Overview The following are instructions to export records from clincicaltrials.gov (Trials) to EndNote, with the ultimate goal of sending the records to a screening software, namely Covidence. The new Trials website ( https://www.clinicaltrials.gov /) will only export in JSON (Java Script format) and Comma Separated Values (CSV) formats. We will be using the CSV export format, the format for spreadsheets. These instructions are simply slight modifications to the Clarivate instructions for importing tab-delimited files (spreadsheets) into EndNote. Before proceeding with the following instructions, first decide whether it is necessary to export directly from clinicaltrials.gov to begin with. Cochrane CENTRAL contains records from Trials and is more user friendly. CENTRAL is limited to "randomized and quasi-randomized controlled tri...

This post was updated on October 10, 2022 with new instructions for #3 under "For EndNote users..." For years, I kept hearing from colleagues that I should be searching Google Scholar as part of my systematic review projects. I didn't, for 3 reasons: I didn't know GS' search syntax GS notoriously does not allow bulk export to reference managers I didn't have a sense of how many results I should export.   Last fall, I finally said enough was enough and it was time to learn how to wrangle this beast. It turns out that there is now a third-party tool that facilitates bulk export from Google Scholar, Harzing's Publish or Perish . Here's how you get started: Download PoP for free Paste your query into the Keywords field Set your maximum number of results. I follow the guidelines on p. 135 of Wichor Bramer's dissertation , which is a great handbook for expert searching. Bramer suggests the first 200 results, or 100 if you are getting low numbers of res...