Stream: v2 to FHIR
Topic: spreadsheet download tool
Michael Hansen (Sep 14 2019 at 22:16):
I made a simple tool to download all the spreadsheets:
https://github.com/hansenms/sheet-it
Michael Hansen (Sep 15 2019 at 13:21):
I updated the tool to also download the vocabulary mappings.
Hans Buitendijk (Sep 16 2019 at 01:18):
Spreadsheet with list of message, segment, data type, and code system maps: https://docs.google.com/spreadsheets/d/1PaFYPSSq4oplTvw_4OgOn6h2Bs_CMvCAU9CqC4tPBgk/edit#gid=1930219638
Michael Hansen (Sep 17 2019 at 04:03):
Thanks @Hans Buitendijk , I have updated the download tool here https://github.com/hansenms/sheet-it to use this list.
A few things I noticed:
1. I think we should avoid using spaces or slashes in the names of tables/types/segments, etc. To make sure we can link things together in automation, we will have to generate file names from these type/segment names and slashes and spaces should be converted. If we don't have them in the first place, there is less ambiguity. So for instance, "Yes/No" is not a great name.
2. HL70136 and HL70532 are in the same file. I think for consistency, they should be broken into separate sheets.
3. The sheet for EI[udiCarrierDI] is not accessible (at least not for me).
4. HD[XON.8 should be HD[XON.8]
@robert worden , could you give it a go and see if you can pull the latest version of the tool and get all the sheets.
Michael Hansen (Sep 17 2019 at 04:13):
Few more comments. The links a not consistently the edit version, sometime the edit version and sometimes (like AL1) a different form: (/edit?usp=sharing). Maybe we should just have the id of the spreadsheet?
Michael Hansen (Sep 17 2019 at 04:22):
Several of the sheets have cells with line breaks, which can cause problems for automation once they are converted to CSV.
IAM sheet is inaccessible.
CNE[CodeableConcept] is inaccessible.
Participation-HL70912 is inaccessible
robert worden (Sep 17 2019 at 13:11):
@Michael Hansen - thanks for updating the tool. I'll give it a go when Hans has finished his current cleanup of the sheets.
robert worden (Sep 19 2019 at 11:10):
@Michael Hansen Thanks - the new download tool works fine and only 4 sheets seem to give problems: CWE[CodableConcept], IAM, EI[UDICarrierDI],and ParticipationHL70912
Last updated: Apr 12 2022 at 19:14 UTC