Implementing QATrack+ QC Database for Report Generation and Data Analysis
Presentations
(Saturday, 3/26/2022) [Central Time (GMT-5)]
Purpose: QATrack+ is an open-source database application that can be used to collect data from physics surveys and store the information in the cloud or on a dedicated server, in-house. Currently, large amounts of time and effort are required to extract the information from years of Excel data. Online database and its multiplatform (computer/tablet/smartphone) functionality can improve accessibility and minimize data transfer between devices and lost data. Extracted database information can be dropped into Excel-type spreadsheets or pdf reports, and can be automatically generated using a python application.
Methods: Implementation of a working server system is explored, by adding applicable tests for diagnostic annual and acceptance surveys. Useful data extraction is investigated utilizing the QATrack+ API (Application Programming Interface). QATrack+, Python coding and LibreOffice by combining together; automating the interface interrogation for the server and providing appropriate data constructs to produce professional level reporting and final documentation.
Results: Investigation of the online system provides a customizable selection for testing requirements. Many individual tests can be re-used or modified for multiple modalities or survey types. Surveys are reviewed and approved by appropriate groups on the server/database, and the QATrack+ JSON API is used to access or export data. Python code was created to selectively extract data from the server and provide information in a usable format for report generation. The data was organized and placed in LibreOffice Calc utilizing an appropriate template (an Excel-type spreadsheet, with variable placeholders). The automatically generated spreadsheet survey report results in a final report nearly identical to current practice forms (Excel spreadsheets) and can be accessed using LibreOffice or Excel.
Conclusion: Overall, the marriage of these technologies provides an achievable full diagnostic survey handling system. The added ability to extract the data and automate the report generation process may improve efficiency of the medical physicists’ workflow.
ePosters
Keywords
Templates, Data Acquisition, Quality Control
Taxonomy
IM- Dataset Analysis/Biomathematics: Informatics
Contact Email