FHIR Chat · Spreadsheets · IG creation

Stream: IG creation

Topic: Spreadsheets

view this post on Zulip Grahame Grieve (Aug 31 2021 at 00:35):

The current version of the IG publisher produces a excel spreadsheet for profiles. e.g. https://www.hl7.org/fhir/us/core/StructureDefinition-us-core-allergyintolerance.xlsx

The next version of the IG Publisher will also produce these for Terminology Artefacts: Code Systems, Value Sets, Concept Maps. I will make a proposal to add links for these to the standard template

view this post on Zulip Grahame Grieve (Aug 31 2021 at 00:36):

I will be working with Vocab to refine the spreadsheet representation (it's not intended to be for authoring)

view this post on Zulip Rob Hausam (Sep 02 2021 at 19:26):

This seems to be causing a problem in the IPS IG (you can see it here in the connectathon-2 branch):
@Grahame Grieve 

ips: The workbook already contains a sheet named 'Include from SNOMED CT' (03:05.0492)
java.lang.IllegalArgumentException: The workbook already contains a sheet named 'Include from SNOMED CT'
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeSystem(ValueSetSpreadsheetGenerator.java:117)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:87)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40)
    at org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815)
    at org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882)
    at org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840)
    at org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)
    at org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)
    at org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)
    at org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910) (03:05.0493)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863) (03:05.0493)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeSystem(ValueSetSpreadsheetGenerator.java:117) (03:05.0493)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:87) (03:05.0493)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40) (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815) (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882) (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840) (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)        (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)         (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)          (03:05.0493)
   org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)            (03:05.0493)
Previous POST attempt returned HTTP<422> from url -> http://tx.fhir.org/r4/ValueSet/$expand?_limit=1000&_incomplete=true.
Exception generating resource /scratch/ig-build-temp-3ADHB4/repo/input/vocabulary/valueset-result-coded-value-laboratory-gps-uv-ips::ValueSet/result-coded-value-laboratory-gps-uv-ips: The workbook already contains a sheet named 'Include ValueSets' (03:06.0542)
java.lang.IllegalArgumentException: The workbook already contains a sheet named 'Include ValueSets'
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeValueSets(ValueSetSpreadsheetGenerator.java:111)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:89)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40)
    at org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815)
    at org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882)
    at org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840)
    at org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)
    at org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)
    at org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)
    at org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910) (03:06.0542)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863) (03:06.0542)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeValueSets(ValueSetSpreadsheetGenerator.java:111) (03:06.0542)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:89) (03:06.0543)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40) (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815) (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882) (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840) (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)        (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)         (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)          (03:06.0543)
   org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)            (03:06.0543)
Previous POST attempt returned HTTP<422> from url -> http://tx.fhir.org/r4/ValueSet/$expand?_limit=1000&_incomplete=true.
Exception generating resource /scratch/ig-build-temp-3ADHB4/repo/input/vocabulary/valueset-core-problem-finding-situation-event-gps-uv-ips::ValueSet/core-problem-finding-situation-event-gps-uv-ips: The workbook already contains a sheet named 'Include from SNOMED CT' (03:09.0175)
java.lang.IllegalArgumentException: The workbook already contains a sheet named 'Include from SNOMED CT'
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeSystem(ValueSetSpreadsheetGenerator.java:117)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:87)
    at org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40)
    at org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815)
    at org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882)
    at org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840)
    at org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)
    at org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)
    at org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)
    at org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:910) (03:09.0176)
   org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:863) (03:09.0176)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genIncludeSystem(ValueSetSpreadsheetGenerator.java:117) (03:09.0176)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.genInclude(ValueSetSpreadsheetGenerator.java:87) (03:09.0176)
   org.hl7.fhir.r5.renderers.spreadsheets.ValueSetSpreadsheetGenerator.renderValueSet(ValueSetSpreadsheetGenerator.java:40) (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.generateOutputsValueSet(Publisher.java:7815) (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.generateResourceHtml(Publisher.java:6882) (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.generateHtmlOutputs(Publisher.java:6840) (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.generate(Publisher.java:5052)        (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.createIg(Publisher.java:908)         (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.execute(Publisher.java:752)          (03:09.0176)
   org.hl7.fhir.igtools.publisher.Publisher.main(Publisher.java:8664)            (03:09.0176)
[truncated]

view this post on Zulip Grahame Grieve (Sep 02 2021 at 19:46):

it doesn't stop the build, right?

view this post on Zulip Rob Hausam (Sep 02 2021 at 19:52):

Yes, that's right - and seeing that made it less immediately concerning.

view this post on Zulip Jose Costa Teixeira (Sep 02 2021 at 19:59):

Grahame Grieve said:

it doesn't stop the build, right?

I don't know if my issue is related - I just tried to build the same IG, and it hangs

view this post on Zulip Jose Costa Teixeira (Sep 02 2021 at 19:59):

other IGs seems to be OK

view this post on Zulip Grahame Grieve (Sep 02 2021 at 20:11):

hangs where?

view this post on Zulip Jose Costa Teixeira (Sep 02 2021 at 20:20):

https://chat.fhir.org/#narrow/stream/179252-IG-creation/topic/Missing.20'fragment-summary-table.2Ehtml'.20file/near/251768815

view this post on Zulip Jose Costa Teixeira (Sep 02 2021 at 20:20):

right after jenkins

view this post on Zulip Michael Lawley (Sep 02 2021 at 22:02):

What are the design / use criteria for these spreadsheet representations?

view this post on Zulip Grahame Grieve (Sep 02 2021 at 22:08):

help people do ad-hoc stuff with excel

view this post on Zulip Lloyd McKenzie (Sep 03 2021 at 01:24):

Analysts :heart: spreadsheets...

Last updated: Apr 12 2022 at 19:14 UTC


An HL7 Website -