This report is available in PDF only (Final Report [PDF, 1.6 MB]). People using assistive technology may not be able to fully access information in these files. For additional assistance, please contact us.
Purpose of Project
To promote the entry of structured data into the Systematic Review Data Repository (SRDR) to facilitate interoperability and use of systematic review data by end-users.
- Using an online survey of nine Project Leads we determined that Microsoft Excel and DistillerSR were the primary sources of flat file data that were recently submitted by Evidence-based Practice Centers (EPCs) to SRDR.
- We refined and pilot tested an approach for importing MS Excel files into SRDR.
- We developed and pilot tested an approach to import files from DistillerSR into SRDR.
- We developed detailed step-by-step instructions for both approaches.
Background. The Systematic Review Data Repository (SRDR) was launched in 2012 as a collaborative, Web-based platform for extracting data from studies included in systematic reviews. The vision was to create a free, open-access repository of extracted data which could reduce unnecessary duplication of effort and facilitate the efficient production of systematic reviews.
Objective. To promote the entry of structured data into SRDR to promote interoperability and use of systematic review data by end-users.
Methods. We completed two steps. First, we determined the sources of flat file data that were recently submitted by Evidence-based Practice Centers (EPCs) to SRDR. We conducted a survey of EPC Project Leads that had recently uploaded to SRDR data from a systematic review in a flat file. Second, we determined and pilot tested approaches for importing structured systematic review data.
Results. The survey was completed by nine of nine eligible EPC Project Leads (100%). In addition to information about usability of SRDR, the primary result was that MS Excel, MS Word and DistillerSR were the most used tools for extracting data and creating tables. An approach for importing MS Excel files into SRDR was refined and pilot tested. An approach was also developed and pilot tested to import files from DistillerSR into SRDR. Detailed instructions, with screenshots, were developed for both approaches.
Conclusions. Improving the ability to search for and produce reviews that are interoperable for users requires production and storage of systematic review data in a structured format. The results from this work will promote interoperability and use of systematic data in SRDR.
Suggested citation: Saldanha IJ, Senturk B, Smith BT, Robinson, KA. Pilot to Promote Entry of Structured Data Into the Systematic Review Data Repository. Methods Research Report. (Prepared by the Brown University and Johns Hopkins University Evidence-based Practice Centers under Contract Nos. 290-2015-00002-I and 290-2015-00006-I.) AHRQ Publication No.19-EH028-EF. Rockville, MD: Agency for Healthcare Research and Quality; October 2019. Posted final reports are located on the Effective Health Care Program search page. DOI: https://doi.org/10.23970/AHRQEPCMETHQUALIMPRSRDR.