Stream: JIRA/Confluence
Topic: Importing Ballot Spreadsheets
Bryn Rhodes (May 19 2020 at 03:15):
I'm trying to import the ballot spreadsheets for CDS ballots, but I don't see any 2020 May cycle ballot definitions. I'm trying to follow the instructions here: https://confluence.hl7.org/display/HL7/Importing+ballot+results+from+spreadsheets, but I'm not sure how to export information from the ballot desktop database and I'm not totally sure how to construct the ballot codes manually?
Lloyd McKenzie (May 19 2020 at 05:20):
You can't. That can only be done by an admin. Done for those ballots that have their specification definitions loaded into Jira.
Lloyd McKenzie (May 19 2020 at 05:20):
(which includes yours)
Bryn Rhodes (May 19 2020 at 05:21):
Thanks Lloyd!
Bryn Rhodes (May 19 2020 at 05:23):
I see FHIR Guidance: Quality Reporting, but I don't see CQL?
Lloyd McKenzie (May 19 2020 at 15:45):
That's because it wasn't organized under FHIR. (We should fix that :>) Added
Bryn Rhodes (May 19 2020 at 16:46):
Thanks Lloyd!
Mark Kramer (May 19 2020 at 17:21):
Mark Kramer1:03 PM
@Lloyd McKenzie I queried the Ballot Definitions as instructed, and the code for Shorthand is 2020-May - SHORTHAND R1 STU. But that's not accepted. What then is the correct string to put in column B?
Vassil Peytchev (May 19 2020 at 18:14):
I believe the code is what is on the spreadsheet: FHIR_IG_SHORTHAND_R1_D1_2020MAY
Mark Kramer (May 19 2020 at 18:30):
I tried, @Vassil Peytchev , but that didn't work. image.png
Lloyd McKenzie (May 19 2020 at 18:31):
not what's on the spreadsheet - we try to make it slightly more user-friendly when we bring it into Jira. If you browse the Ballot Definitions project (BALDEF), you'll see your project and within that, you'll see your code. @Mark Kramer, you won't be able to import until we transition your ballot definition to 'complete', which we can't do until I get a pull request with the spec definition
Mark Kramer (May 19 2020 at 18:31):
I can't do a pull request on that repo, @Lloyd McKenzie
Mark Kramer (May 19 2020 at 18:32):
Otherwise you would have had it several days ago.
Lloyd McKenzie (May 19 2020 at 18:33):
I'd indicated that you'll need to do the pull request from a local fork in your own repository. Did you try that approach?
Mark Kramer (May 19 2020 at 18:41):
Will do.
Mark Kramer (May 19 2020 at 19:02):
@Lloyd McKenzie PR is in.
Lloyd McKenzie (May 19 2020 at 19:24):
Merged and BallotDefinition updated
Lloyd McKenzie (May 19 2020 at 19:25):
https://jira.hl7.org/projects/BALDEF/issues/BALDEF-1659
Vassil Peytchev (May 19 2020 at 20:16):
My being curious about how the ballot definition looks like led to clicking the "Reconciliation Sheet" button. Fortunately that doesn't seem to have broken anything, but wanted to bring it up in case it did...
Mark Kramer (May 19 2020 at 20:33):
I'm wasting a lot of time trying playing guessing games to figure out what goes into the "Resource(s)" column (H) and the HTML Page name(s) column (I). I've tried everything I can think of. Playing guessing games is not fun.
Mark Kramer (May 19 2020 at 20:41):
I defined <page name="Language Reference" key="languagereference"/>
Yet, none of these work for the HTML Page Name(s):
Language Reference
languagereference
http://hl7.org/fhir/uv/shorthand/2020May/reference.html
http://hl7.org/fhir/uv/shorthand/2020May/reference
Lloyd McKenzie (May 19 2020 at 20:59):
"Language Reference" should work for pages. I don't think you defined any resources?
Lloyd McKenzie (May 19 2020 at 21:00):
Is the specification set correctly in the spreadsheet?
Lorraine Constable (Sep 23 2020 at 18:41):
I have a set of spreadsheets where the ballot code is wrong (error 15, column B). Where do I find the valid list of ballot codes?
Vassil Peytchev (Sep 23 2020 at 19:02):
Which ballot is that? If you look at the empty spreadsheet for the specific ballot, at the first empty row on the second sheet column B is pre-populated with the appropriate code.
Lloyd McKenzie (Sep 23 2020 at 19:14):
The code pre-populated is not the right code, unfortunately. I'm going to work with @Lynn Laakso to change that for future ballots.
Lloyd McKenzie (Sep 23 2020 at 19:14):
(Currently it tends to be a code representing the WG, not the ballot)
Lorraine Constable (Sep 23 2020 at 19:17):
Yes, I just went and checked the pre-populated code, and it is the work group not the correct code. I replaced it with the value from jira project BALDEF, and am currently waiting for the error spreadsheet to return. This one has only tracker links and votes, so I will be interested to see what was wrong
Lorraine Constable (Sep 23 2020 at 19:19):
It is logging errors on all the blank lines. Do lines flagged as not in error load, or is it an all or none thing?
Lloyd McKenzie (Sep 23 2020 at 19:23):
There's two phases. On the initial phase, it won't apply anything until all issues are fixed. However, once it starts applying changes, there are a few issues that only show up when writing things to Jira. If it runs into a problem then, it'll tell you what line it stopped at - and you should delete prior lines before re-submitting.
Lorraine Constable (Sep 23 2020 at 19:24):
so, in this case it would not have loaded anything unless it told me?
Lloyd McKenzie (Sep 23 2020 at 19:32):
Right
Lorraine Constable (Sep 24 2020 at 23:29):
I am trying to import a sheet without tracker numbers. In this case, the url is http://hl7.org/fhir/us/vitals/2020Sep/index.html#introduction
And I am getting this is not a valid url. Is this because the validation does not allow the # anchors in the URL?
Additionally, the voter referenced the section headers as the "HTML page" the import says those are not valid. Do I have to generalize all of those to an actual HTML page? It seems that losing that specificity from the balloter is counter productive
Lloyd McKenzie (Sep 24 2020 at 23:36):
What specification is the ballot against?
Lloyd McKenzie (Sep 24 2020 at 23:36):
You can't specify a URL that corresponds to any specification other than the one being balloted against
Lloyd McKenzie (Sep 24 2020 at 23:37):
You need to look up the page text from within Jira that's a recognized page for that particular specification
Lloyd McKenzie (Sep 24 2020 at 23:37):
(Yes, importing from spreadsheets is a painful process because there's no way to ensure users specify valid information in their spreadsheets.)
Lorraine Constable (Sep 24 2020 at 23:48):
Vital Signs IG
Lorraine Constable (Sep 24 2020 at 23:49):
If I click the link, the spec opens where it should
Lorraine Constable (Sep 24 2020 at 23:49):
this appears to be valid info
Lorraine Constable (Sep 24 2020 at 23:50):
additional question - what is the max length for a summary? I am trying to edit them down
Lorraine Constable (Sep 24 2020 at 23:50):
The voter specified the section tag within the page
Lorraine Constable (Sep 25 2020 at 00:00):
Any one looking at what this balloter specified would say it looks ok
Lloyd McKenzie (Sep 25 2020 at 02:23):
Is it a whitespace issue? Because the base looks like it should be fine based on what's in Git for that project.
Lloyd McKenzie (Sep 25 2020 at 02:23):
Did they specify more than one URL?
Lloyd McKenzie (Sep 25 2020 at 02:23):
If you can't figure it out, send me the sheet and I'll take a look
Lorraine Constable (Oct 01 2020 at 22:13):
I am back to trying to load spreadsheets. Today, directly after I click the Import Ballot Comments button, it returns immediately with "Unknown Error" Any hints?
Lorraine Constable (Oct 01 2020 at 22:15):
I tried different spreadsheets, reloading, and re-logging in
Lloyd McKenzie (Oct 01 2020 at 22:56):
Temporarily disabled. Hope to have it back up for tomorrow
Last updated: Apr 12 2022 at 19:14 UTC
