From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project
Studies in Health Technology and Informatics · 2026
DOI: 10.3233/shti260555 ↗Kurz gefasst
Fachartikel in der Zeitschrift Studies in Health Technology and Informatics, 2026. Verfasst von Vinícius Lima und 7 weiteren Autor:innen. Beteiligte Einrichtung: RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal. Hauptthemen laut MEDLINE: Electronic Health Records, Databases, Factual, Health Level Seven. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).
Abstract (Originalsprache)
Medication management in long-term care remains largely paper-based, resulting in fragmented records, transcription errors, and limited reuse opportunities. In the Portuguese use case of the RM4Health project, the Santa Casa da Misericórdia de Vagos adopted a structured datasheet template with embedded validations as the single point of entry for medication data. Two services were developed to convert XLS-based medication data into HL7 FHIR MedicationStatement resources and produce CSV files for semi-automated import into a REDCap database. The work also demonstrated the feasibility of converting semantically annotated REDCap exports back into FHIR resources, enabling bidirectional flows. Initial use indicates that the template is easy to adopt, while downstream partners may benefit from automated integration into clinical and research systems. This experience demonstrates how low-friction changes at the entry point, combined with open standards, can support data flows in long-term care settings.
Schlagwörter
MeSH-Schlagwörter (MEDLINE)
Stichwörter der Autor:innen
Autor:innen und Institutionen
- RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal.
- Santa Casa da Misericórdia de Vagos, Portugal.
- GECAD/LASI, ISEP, Polytechnic of Porto, Portugal.
Zitieren
APA
Lima, V., Almeida, R., Calvi, I., Domingues, D., Martins, R., Bernardi, F., Conceição, L., & Freitas, A. (2026). From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project. Studies in Health Technology and Informatics. https://doi.org/10.3233/shti260555
Vancouver
Lima V, Almeida R, Calvi I, Domingues D, Martins R, Bernardi F, et al. From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project. Studies in Health Technology and Informatics. 2026. doi:10.3233/shti260555
BibTeX
@article{Lima2026,
author = {Lima, Vinícius and Almeida, Rute and Calvi, Izabela and Domingues, Daniela and Martins, Rafael and Bernardi, Filipe and Conceição, Luís and Freitas, Alberto},
title = {From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project},
journal = {Studies in Health Technology and Informatics},
year = {2026},
doi = {10.3233/shti260555}
}
EUVIMED