{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,15]],"date-time":"2026-10-15T16:43:06Z","timestamp":1792082586769,"version":"4.4.0"},"reference-count":0,"publisher":"IOS Press","isbn-type":[{"value":"9781643686615","type":"electronic"}],"license":[{"start":{"date-parts":[[2026,5,21]],"date-time":"2026-05-21T00:00:00Z","timestamp":1779321600000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2026,5,21]]},"abstract":"<jats:p>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\u00f3rdia 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.<\/jats:p>","DOI":"10.3233\/shti260555","type":"book-chapter","created":{"date-parts":[[2026,5,21]],"date-time":"2026-05-21T22:08:19Z","timestamp":1779401299000},"source":"Crossref","is-referenced-by-count":1,"title":["From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health Project"],"prefix":"10.3233","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-2467-358X","authenticated-orcid":false,"given":"Vin\u00edcius","family":"Lima","sequence":"first","affiliation":[{"name":"RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rute","family":"Almeida","sequence":"additional","affiliation":[{"name":"RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Izabela","family":"Calvi","sequence":"additional","affiliation":[{"name":"RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Daniela","family":"Domingues","sequence":"additional","affiliation":[{"name":"Santa Casa da Miseric\u00f3rdia de Vagos, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rafael","family":"Martins","sequence":"additional","affiliation":[{"name":"GECAD\/LASI, ISEP, Polytechnic of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Filipe","family":"Bernardi","sequence":"additional","affiliation":[{"name":"RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Lu\u00eds","family":"Concei\u00e7\u00e3o","sequence":"additional","affiliation":[{"name":"GECAD\/LASI, ISEP, Polytechnic of Porto, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Alberto","family":"Freitas","sequence":"additional","affiliation":[{"name":"Santa Casa da Miseric\u00f3rdia de Vagos, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","Opening the Personal Gate between Technology and Health Care"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI260555","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,5,21]],"date-time":"2026-05-21T22:08:20Z","timestamp":1779401300000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI260555"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,5,21]]},"ISBN":["9781643686615"],"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti260555","relation":{},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"value":"0926-9630","type":"print"},{"value":"1879-8365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,5,21]]}}}