Stream: ihe
Topic: convert CSV to CodeSystem
John Moehrke (Feb 04 2022 at 20:09):
Request. PCC is working on some EMS projects and they need the NEMSIS dictionary coverted from the CSV that NEMSIS publishes into some form of CodeSystem.
From NEMSIS publication page - https://nemsis.org/technical-resources/version-3/version-3-data-dictionaries/
specifically the "v3 Required National and Recommended State Elements"
Oliver Egger (Feb 04 2022 at 20:25):
we use for csv just an excel (or google) sheet. import the data, add a column to the right and use the string concatenate function for each value, and then add at the bottom to concatenate everything, not something if you need to do it often, but if it is a one time conversion, why not :smile:
John Moehrke (Feb 04 2022 at 20:31):
I presume this means there is CSV support as input in IG builder?
Oliver Egger (Feb 04 2022 at 21:17):
not that i'm aware of ...just constructing the fsh or json by excel :-)
Grahame Grieve (Feb 04 2022 at 21:28):
I've never tried to do csv support in the IG publisher because there's a myriad of micro-formats out there, so I've left it to other people to do the conversion
John Moehrke (Feb 04 2022 at 22:11):
drat. well, I know I can hand manipulate it. just was hoping that there was someone willing to create a script.
Jens Villadsen (Feb 05 2022 at 18:09):
@John Moehrke The lack of spec makes it near impossible to create such a tool
Jens Villadsen (Feb 05 2022 at 18:14):
I did this tool ( https://github.com/trifork/fhir-xsv-translator ) originally intended to be generic, but I ended up tailor fitting it for my own case
Jens Villadsen (Feb 05 2022 at 18:42):
The reason for the tooling is because the Codesystem is updated on a quarterly basis. If that wasnt the case I would do as Oliver suggest
John Moehrke (Feb 05 2022 at 18:47):
I expect to need to combine tools. I expect I will need to rearrange the csv columns, run your tool, then edit the codesystem root
John Moehrke (Feb 05 2022 at 18:49):
Ugly for now, but effective to show potential for original to maintain fhir format
Jens Villadsen (Feb 06 2022 at 07:16):
I would need to adjust my tool I think... Ill have a look later on
Last updated: Apr 12 2022 at 19:14 UTC
