Stream: JIRA/Confluence
Topic: Ballot Spreadsheet Upload# format
Hans Buitendijk (May 13 2021 at 02:08):
Running into the following issues for the SMART App Launch spreadsheet:
Generally the upload generates lots of errors due to fields being formulas. When those fields are changed to plain text, error messages disappear. Still left though with the following
- Column B was created with the wrong name (missing "-" before HL7 in F1 on the Submitter tab : "2021-May HL7 FHIR IG SMART APP LAUNCH R2 STU"). Per error message needs to be exactly according to the JIRA ballot desktop ("2021-May-HL7 FHIR IG SMART APP LAUNCH R2 STU"). Copied that to get the match expected, still not accepted. What is the correct name? Just to be sure, what are the other correct names for ballots that can be done with JIRA?
- Column I as a result also gives an error that the tracker is not tied to the correct project Hopefully if the above is fixed, this will work.
- Column O could have benefitted from clarity that it should be the name on the JIRA, not the name of the submitter of the spreadsheet.
Problems do not seem to be with what the submitter fills out, but the original template not being defined correctly.
Lloyd McKenzie (May 13 2021 at 04:06):
@Lynn Laakso note on the issue with Column B. The value must be "2021-May - HL7 FHIR IG SMART APP LAUNCH R2 STU" - i.e. with spaces on either side of the dash following the time-period. An exact match is needed
Agree that column I issue should go away when B is fixed.
The 'submitter' in the spreadsheet is always the person voting. onBehalfOf is never specified if you're referencing an existing Jira item. If you're referencing a new item to be created, it's the person who actually has the comment - and should be the 'reporter' of the issue when it gets created in Jira. This must be someone who has a Jira account. Everyone you're gathering comments from in your organization needs to have a Jira account for you to be able to submit their comments correctly.
Hans Buitendijk (May 13 2021 at 12:58):
Thank you! Will be checking this ouw. Then I expect that the "-" issue is in play with every spreadsheet looking at my dashboard. I'll check that out .
Hans Buitendijk (May 13 2021 at 19:29):
I was able to upload after those adjustments. Discovered an area in need of clarity that is that if you have after an initial upload you need to upload more, that one better not forget to remove those that already were uploaded and restart the vote number in column A.
Lloyd McKenzie (May 13 2021 at 19:51):
You don't have to restart the vote number. If you want your numbers to be contiguous, you can just set the 'ignore warnings' flag once the "you're not starting at one?" is the only remaining issue.
Hans Buitendijk (May 14 2021 at 19:56):
Another template problem where the spreadsheet template contained the wrong ballot name for Column B: "2021-May FHIR IG BULKDATA R1 STU". I replaced the formula and the text with "2021-May - FHIR IG BULKDATA R1 STU", but that did not work either. Turns out it needed to be "2021-May - FHIR IG BULKDATA R2 STU".
Lloyd McKenzie (May 14 2021 at 19:58):
@Lynn Laakso
Last updated: Apr 12 2022 at 19:14 UTC
