EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC 4.0

From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project

Vinícius Lima, Rute Almeida, Izabela Calvi, Daniela Domingues, Rafael Martins, Filipe Bernardi, Luís Conceição, Alberto Freitas

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).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

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)

Electronic Health RecordsDatabases, FactualHealth Level SevenHumansDigital HealthPortugalLong-Term Care

Stichwörter der Autor:innen

FHIRREDCapmedication managementsmart medication dispenser

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}
}
Kostenlos starten →