From Excel to Automation: The Transplant Mapper for Interoperable Transplant Data Management

Secure transplant data governance is essential for clinical decision support and research. At LMU Hospital, Eurotransplant waitlist and transplant reports were previously integrated via shared Excel files, causing workload, errors, and collaboration issues. We developed the Transplant Mapper, a modular framework that synchronizes Eurotransplant report data into REDCap and provides monitoring via Python Shiny dashboards. A Django web interface triggers organ-specific mapping scripts that perform differential updates, maintain waitlist consistency (including removal of outdated entries), and support multiple transplant instances using REDCap repeating events. Deployed for liver and kidney programs, typical synchronizations complete in <1 minute, replacing manual workflows with a scalable, auditable, FAIR-aligned infrastructure adaptable to other registries.