Stream: JIRA/Confluence
Topic: When will excel comments be added to JIRA?
Yunwei Wang (Feb 04 2020 at 19:37):
I cannot find my ballot comments submitted in excel in JIRA.
Lloyd McKenzie (Feb 05 2020 at 02:53):
Whenever the co-chair/facilitator responsible for the ballot imports them...
Brett Marquard (Feb 05 2020 at 15:10):
@Lloyd McKenzie What is best way to determine what goes in ballot column in excel? Here is what I tried:
2020-Jan - US Da Vinci ATR (FHIR)
2020-Feb - FHIR IG ATR R1 STU
2020-Jan - US Da Vinci ATR (FHIR)
2020-Jan - FHIR IG ATR R1 STU
FHIR_IG_RISK_CONTRACT_R1_D1_2020FEB
2020-JAN - [FHIR-us-davinci-atr]
2020-FEB - [FHIR-us-davinci-atr]
2020-01 - US Da Vinci ATR (FHIR)
2020-02 - FHIR IG ATR R1 STU
2020-01 - US Da Vinci ATR (FHIR)
2020-01 - FHIR IG ATR R1 STU
FHIR_IG_RISK_CONTRACT_R1_D1_2020FEB
2020-01 - [FHIR-us-davinci-atr]
2020-02 - [FHIR-us-davinci-atr]
2020-JAN - FHIR-us-davinci-atr
2020-FEB - FHIR-us-davinci-atr
Joshua Procious (Feb 05 2020 at 15:44):
I'm seeing line wraps which I assume zulip is doing. I also see that some of them follow the YYYY-MM-[coded label] format rather than YYYY-MMM-[codel label] format (note the extra month spec)
Joshua Procious (Feb 05 2020 at 15:45):
have you tried with all same format using YYYY-MMM?
Brett Marquard (Feb 05 2020 at 15:48):
2020-JAN? or 2020-FEB?
Joshua Procious (Feb 05 2020 at 15:48):
No, the 2020-01-US Da Vinci ATR (FHIR) one for example
Joshua Procious (Feb 05 2020 at 15:49):
that is in an incorrect format
Joshua Procious (Feb 05 2020 at 15:49):
per the error message
Brett Marquard (Feb 05 2020 at 15:50):
sure, I agree some of the above don't match the error message -- but i am not getting consistent error messages
Brett Marquard (Feb 05 2020 at 15:50):
Do you mind suggesting what I try for this IG?
Joshua Procious (Feb 05 2020 at 15:51):
ok. well first, are you getting alternative error messages or is it accepting some and rejecting others with the one error message?
Brett Marquard (Feb 05 2020 at 15:51):
Brett Marquard (Feb 05 2020 at 15:52):
Brett Marquard (Feb 05 2020 at 15:52):
will email you excel file if you want to try :)
Joshua Procious (Feb 05 2020 at 15:52):
Ok, thanks for the images. I'm looking at something quickly
Joshua Procious (Feb 05 2020 at 15:53):
ok sure please do!
Joshua Procious (Feb 05 2020 at 15:53):
i'll give it a try
Brett Marquard (Feb 05 2020 at 15:53):
thanks. I don't quite speak JIRA and I tried to get inside lloyd's brain on this one and failed.
Joshua Procious (Feb 05 2020 at 15:56):
no problem. so before i try the excel i'm not seeing a 2020-JAN entry at all
Joshua Procious (Feb 05 2020 at 15:56):
Joshua Procious (Feb 05 2020 at 15:57):
so that's where that Da Vinci ATR one is getting the error I think.
Joshua Procious (Feb 05 2020 at 15:57):
The others are almost surely the formatting error of YYYY-MMM - [coded label]
Joshua Procious (Feb 05 2020 at 15:58):
it is doing an explicit search for that string and catching the incorrect format on those that exist and are incorrect and then giving the cannot find error when it just doesn't exist.
Joshua Procious (Feb 05 2020 at 15:58):
still looking
Brett Marquard (Feb 05 2020 at 15:58):
k, good, ruled out the 2020-JAN part
Joshua Procious (Feb 05 2020 at 16:03):
yes, and after looking at the excel and Jira it seems those error messages are accurate. I cannot find those entries at all. For example: FHIR_IG_RISK_CONTRACT_R1_D1_2020FEB doesn't seem to be an item.
Brett Marquard (Feb 05 2020 at 16:04):
tottally agree-
Brett Marquard (Feb 05 2020 at 16:04):
My goal is to find the ONE value that passes
Joshua Procious (Feb 05 2020 at 16:04):
do you think this to be incorrect? like should that item definitely exist?
Joshua Procious (Feb 05 2020 at 16:04):
ok
Joshua Procious (Feb 05 2020 at 16:04):
looking here
Brett Marquard (Feb 05 2020 at 16:04):
My best guess is 2020-FEB - [FHIR-us-davinci-atr]
Joshua Procious (Feb 05 2020 at 16:08):
i'm not seeing any in the excel also existing in Jira.
Joshua Procious (Feb 05 2020 at 16:08):
here are the options
Joshua Procious (Feb 05 2020 at 16:08):
Brett Marquard (Feb 05 2020 at 16:08):
Risk Contract R1 STU
Brett Marquard (Feb 05 2020 at 16:09):
...totally logically :)
Joshua Procious (Feb 05 2020 at 16:09):
lol
Brett Marquard (Feb 05 2020 at 16:09):
so...
2020-FEB - [Risk Contract R1 STU]?
Brett Marquard (Feb 05 2020 at 16:09):
or 2020-FEB - Risk Contract R1 STU
Joshua Procious (Feb 05 2020 at 16:10):
the second.
Brett Marquard (Feb 05 2020 at 16:10):
I will try...
Joshua Procious (Feb 05 2020 at 16:10):
however I also see R1 D1 in the excel save empty cells
Joshua Procious (Feb 05 2020 at 16:10):
I only see*
Joshua Procious (Feb 05 2020 at 16:11):
let me know how it goes please
Brett Marquard (Feb 05 2020 at 16:13):
Brett Marquard (Feb 05 2020 at 16:13):
2020-FEB - Risk Contract R1 STU
Brett Marquard (Feb 05 2020 at 16:14):
honestly, we can stop and wait till Lloyd wakes up
Brett Marquard (Feb 05 2020 at 16:14):
I just wanted to make sure i wasn't missing an easy answer
Brett Marquard (Feb 05 2020 at 16:15):
and I have 90 mins into this and think that' s enough.
Joshua Procious (Feb 05 2020 at 16:18):
can you try one last attempt with lower month and all caps in coded label like 2020-Feb - RISK CONTRACT R1 STU please?
Joshua Procious (Feb 05 2020 at 16:18):
if not this, i'll need to look some more and we may need to appeal to Lloyd
Joshua Procious (Feb 05 2020 at 16:20):
to be sure this
Joshua Procious (Feb 05 2020 at 16:20):
2020-Feb - RISK CONTRACT R1 STU
Brett Marquard (Feb 05 2020 at 16:20):
sure.
Joshua Procious (Feb 05 2020 at 16:24):
any luck?
Brett Marquard (Feb 05 2020 at 16:24):
success.
Joshua Procious (Feb 05 2020 at 16:24):
awesome
Brett Marquard (Feb 05 2020 at 16:24):
now a whole set of new errors :)
Joshua Procious (Feb 05 2020 at 16:24):
of course :)
Joshua Procious (Feb 05 2020 at 16:24):
so on the comments themselves?
Brett Marquard (Feb 05 2020 at 16:24):
Thanks for your help.
Brett Marquard (Feb 05 2020 at 16:24):
yep.
Joshua Procious (Feb 05 2020 at 16:25):
you're welcome.
Joshua Procious (Feb 05 2020 at 16:25):
so my thought is you might have an out of date spreadsheet?
Joshua Procious (Feb 05 2020 at 16:25):
i'll get with lloyd later on this
Brett Marquard (Feb 05 2020 at 16:26):
I don't think JIRA was configured prior to folks downloading excels
Brett Marquard (Feb 05 2020 at 16:26):
I think JIRA should be able to import based on the Ballot Artifact ID (FHIR_IG_RISK_CONTRACT_R1_D1_2020FEB)
Joshua Procious (Feb 05 2020 at 16:26):
:)
Joshua Procious (Feb 05 2020 at 16:26):
yes that would be nice
Joshua Procious (Feb 05 2020 at 16:26):
I think that is already on his to-do list but I'll bring it up
Brett Marquard (Feb 05 2020 at 16:28):
i am assuming goal is this is self-service. I suspect this is one of several small tweaks in future
Joshua Procious (Feb 05 2020 at 16:29):
yes i suspect the same
Brett Marquard (Feb 05 2020 at 16:29):
Will be interesting when used by broader audience...
Brett Marquard (Feb 05 2020 at 16:29):
for example
Brett Marquard (Feb 05 2020 at 16:29):
Brett Marquard (Feb 05 2020 at 16:29):
http://hl7.org/fhir/us/davinci-atr/2020FEB/index.html
Brett Marquard (Feb 05 2020 at 16:29):
I try index in the column and index.html
Brett Marquard (Feb 05 2020 at 16:29):
not happy.
Joshua Procious (Feb 05 2020 at 16:30):
yes, it's very strict
Joshua Procious (Feb 05 2020 at 16:30):
i don't know if some percent matching for user interaction would be the answer or not.
Joshua Procious (Feb 05 2020 at 16:32):
the ballot item itself is a specific item in Jira not a string. so is the same with some of the other columns
Joshua Procious (Feb 05 2020 at 16:32):
that's why the strictness as best I can tell
Brett Marquard (Feb 05 2020 at 16:34):
Joshua Procious (Feb 05 2020 at 16:42):
I see that there should be related artifacts but it looks to me those are there.
Joshua Procious (Feb 05 2020 at 16:42):
Just for clarity sake I'll wait for Lloyd to respond on email and takes notes on his response.
Joshua Procious (Feb 05 2020 at 16:42):
Thanks for your patience on this Brett
Yunwei Wang (Feb 05 2020 at 16:44):
I see, line 3 does not have html page link. I missed that. The same error are on line 21 and 23
Brett Marquard (Feb 05 2020 at 16:48):
this isn't from your file Yunwei...
Brett Marquard (Feb 05 2020 at 16:48):
when I start yours I expect loads of other 'errors'.
Lloyd McKenzie (Feb 05 2020 at 20:27):
Jira imports the ballot definitions from the desktop - but it transforms the codes to be more human-friendly. Base algorithm is moving the period to the beginning, stripping the ballot number and changing underscores to spaces and the level code to an actual level. You can find the ballot definitions by looking at the BALDEF project. I'll update the error message to tell you where to look.
Lloyd McKenzie (Feb 05 2020 at 20:29):
The import process forces you to fix the same stuff you had to fix in order to import into gForge plus a bit more. Once we have full Jira balloting, this won't be the job of co-chairs but the balloter. (Which may nudge some to not use spreadsheets at all, because frankly spreadsheets are a pain.)
Lloyd McKenzie (Feb 05 2020 at 20:35):
I expect the page expects "index". Surrounding with () is for (NA) and (profiles) and generally denotes things that aren't real pages.
Brett Marquard (Feb 05 2020 at 20:54):
Many of the error messages have been helpful.
Brett Marquard (Feb 05 2020 at 20:55):
I have an excel that I thought was fully fixed and it won't load.
Brett Marquard (Feb 05 2020 at 20:55):
will forward to you.
Brett Marquard (Feb 05 2020 at 20:57):
nobody should have to lookup the ballot 'code', it should be baked into the excel file the user downloads -- unique artifact id is present, seems logical that would populate the excel column also (or the transformed user friendly code you suggest)
Brett Marquard (Feb 05 2020 at 20:58):
I expect the page expects "index". Surrounding with () is for (NA) and (profiles) and generally denotes things that aren't real pages.
tried index, no luck.
Lloyd McKenzie (Feb 05 2020 at 21:37):
The plan in the future is that we won't be offering ballot-specific spreadsheets at all. Have you looked to see what's available in the jira dropdowns for your IG?
Lloyd McKenzie (Feb 06 2020 at 00:17):
From JiraArtifacts: <page name="IG Home Page" key="index"/>
So it should be "IG Home Page"
Lloyd McKenzie (Feb 06 2020 at 00:18):
(Or we should change the label in Jira)
Brett Marquard (Feb 06 2020 at 00:32):
That is no longer my problem, see image at 1134 am
Brett Marquard (Feb 06 2020 at 00:33):
On index, I decided it didn't matter to me for management, removed field
Lloyd McKenzie (Feb 06 2020 at 00:52):
You have to have an artifact or a page for each row
Lloyd McKenzie (Feb 06 2020 at 00:53):
(Which is exactly that that message is telling you...)
Brett Marquard (Feb 06 2020 at 01:56):
I expected the error to match the ballot columns, not make up new termionlogy
Brett Marquard (Feb 06 2020 at 01:57):
(and all prior errors colored cells)
Brett Marquard (Feb 06 2020 at 02:03):
here is a message we all can enjoy
Brett Marquard (Feb 06 2020 at 02:03):
Brett Marquard (Feb 06 2020 at 02:05):
I am impressed with the direction of this new load process -- you did good. I think the usability on errors is still an opportunity.
Brett Marquard (Feb 06 2020 at 02:05):
(one small example, how does one find the JiraArtifacts)
Lloyd McKenzie (Feb 06 2020 at 03:15):
We change the ballot columns in Jira because they become more important - they're visible in many places and need to be searchable. The values in the balloting desktop are constrained by rules in the database and human-friendliness was not much of a consideration. (We're also driven by the Jira tooling requirements for 2-level hierarchical fields, which we need to be able to filter by ballot cycle as well as specific ballot.)
Lloyd McKenzie (Feb 06 2020 at 03:31):
I don't see a message related to JiraArtifacts in the code. If you're referring to my message above, that's just the source for the dropdowns in Jira (was faster for me to go there than to look in Jira).
Brett Marquard (Feb 12 2020 at 01:10):
I get some interesting errors on a PC also -- if I seem to ignore I can still open an then address items.
Brett Marquard (Feb 12 2020 at 01:10):
Brett Marquard (Feb 12 2020 at 01:10):
Lloyd McKenzie (Feb 12 2020 at 01:13):
Yeah. That happens if the spreadsheets has macro modules - even empty ones. And for some reason, the ballot templates HL7 ships always do. @Lynn Laakso, is that something we can fix?
In any event, the checking process strips out any macro modules that are there to avoid triggering anti-virus software when mailing out the spreadsheets containing the errors & warnings. But the code seems to leave some remnants of them behind.
Brett Marquard (Feb 12 2020 at 15:58):
FYI to all - a new check was added last night to require population of Disposition WG (column W).
Last updated: Apr 12 2022 at 19:14 UTC
