{"title":"A Software Tool for Automated Upload of Large Clinical Datasets Using REDCap and\n the CAPO Database","authors":"William A. Mattingly, C. Sinclair, Danna Williams, Matthew Grassman, S. Furmanek, Kimberley A Buckner, Mohammad Tahboub","doi":"10.18297/jri/vol2/iss1/7","DOIUrl":null,"url":null,"abstract":"Introduction: Obtaining clinical data from healthcare sources is necessary for conducting clinical research. New technologies now allow for connecting a research database to Electronic Medical Records remotely, allowing the automatic import of clinical research data. In this paper we design and evaluate a REDCap extension to import clinical records from an external health database. Methods: Many hospital EHRs are designed to use secure file transfer protocol (SFTP) repositories for data communication. We develop a REDCap plugin to connect to an external SFTP file repository for the import of clinical record data. We use the CAPO instance of REDCap and a sample set of clinical pneumonia variables for the connection. Results: The plugin allows the input of record data in a much shorter time than traditional data entry in addition to being less error prone. However, the formatting of the data in the SFTP file repository must be exact in order for the import to be successful. This can require setup time on the part of EHR IT staff. Conclusion: Developing a direct connection from EHR to research database can be an effective way to lower the overhead for conducting clinical research. We demonstrate a means to do this using REDCap and SFTP. DOI: 10.18297/jri/vol2/iss1/7 Received Date: February 12, 2018 Accepted Date: February 27, 2018 Website: https://ir.library.louisville.edu/jri Affiliations: 1University of Louisville Division of Infectious Diseases, Louisville, KY 40202 ©2018, The Author(s). *Correspondence To: William A Mattingly, PhD 501 E Broadway, Suite 120B Louisville, KY 40202 bill.mattingly@louisville.edu 31 ULJRI Vol 2, (1) 2018 ORIGINAL RESEARCH of SFTP-2-REDCap, a REDCap plugin to support the fast upload of data into a REDCap clinical research project.","PeriodicalId":91979,"journal":{"name":"The University of Louisville journal of respiratory infections","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2018-04-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"The University of Louisville journal of respiratory infections","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.18297/jri/vol2/iss1/7","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 2
使用REDCap和CAPO数据库自动上传大型临床数据集的软件工具
简介:从医疗保健来源获得临床数据是进行临床研究的必要条件。新技术现在允许将研究数据库远程连接到电子医疗记录,从而允许自动导入临床研究数据。在本文中,我们设计并评估了一个REDCap扩展,以从外部健康数据库导入临床记录。方法:许多医院的电子病历采用安全文件传输协议(SFTP)存储库进行数据通信。我们开发了一个REDCap插件来连接到外部SFTP文件存储库,以导入临床记录数据。我们使用REDCap的CAPO实例和临床肺炎变量的样本集进行连接。结果:与传统的数据输入相比,该插件可以在更短的时间内输入记录数据,并且不易出错。但是,为了导入成功,SFTP文件存储库中的数据格式必须精确。这可能需要EHR IT人员的设置时间。结论:建立电子病历与研究数据库的直接连接是降低临床研究费用的有效途径。我们演示了一种使用REDCap和SFTP的方法。DOI: 10.18297/jri/vol2/iss1/7接收日期:2018年2月12日接收日期:2018年2月27日网站:https://ir.library.louisville.edu/jri隶属机构:1路易斯维尔大学传染病科,路易斯维尔,肯塔基州40202©2018,作者。*通信给:William A Mattingly, PhD 501 E Broadway, Suite 120B Louisville, KY 40202 bill.mattingly@louisville.edu 31 ULJRI Vol 2, (1) 2018 src -2-REDCap的原创研究,一个REDCap插件,支持快速上传数据到REDCap临床研究项目。
本文章由计算机程序翻译,如有差异,请以英文原文为准。