FHIR Chat · spreadsheet download tool · v2 to FHIR

Stream: v2 to FHIR

Topic: spreadsheet download tool


view this post on Zulip Michael Hansen (Sep 14 2019 at 22:16):

I made a simple tool to download all the spreadsheets:

https://github.com/hansenms/sheet-it

view this post on Zulip Michael Hansen (Sep 15 2019 at 13:21):

I updated the tool to also download the vocabulary mappings.

view this post on Zulip 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

view this post on Zulip 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.

view this post on Zulip 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?

view this post on Zulip 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

view this post on Zulip 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.

view this post on Zulip 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