The new Jira tooling does support importing ballot results from spreadsheets. In the near term, this is limited to HL7 participants with 'Manager' access - generally co-chairs or facilitators responsible for conducting the ballot. The intention is for balloters to eventually be able to import content from spreadsheets themselves (and to be responsible for ensuring the spreadsheet imports cleanly).
Ballot administrator steps
Before imports are possible, the ballot coordinator (someone with administrator privileges) must create the relevant ballot definitions for all closed ballots. This involves the following steps:
- Create a CSV that looks like this either by exporting information from the ballot desktop database or creating it manually.
- In Jira, use System, External System Import and select the spreadsheet file. Choose "Use an existing configuration file" and use the file maintained here.
- Click 'next' three times and complete the import
- Go to each of the imported projects and
- click on the Product Family to bring up a window that allows setting the appropriate Specification and, if necessary, Related Artifacts and/or Related Pages.
- Open the ballot
- Close the ballot
Ballot manager steps
To import a spreadsheet, first go to the HL7 Balloter dashboard. If you are a manager it should display a control that looks like this:
- You'll need to consolidate all of the ballot spreadsheets using the macro available from the HL7 ballot desktop
- The consolidation process will include submitter comments that say things like "see comments submitted by xxx" or "see attached spreadsheet". All of those rows should be removed. We only want comments that are actually 'comments' that ask for changes to the specification or that actually comment on the specification
- Simply choose the ballot file to import and click on "Import ballot comments". (Do not click 'ignore warnings' on your first import attempt.) The process takes a while to complete, so be patient. When complete one of two things will happen:
- You'll get a message indicating that the ballot content has been successfully imported into Jira (including an indication of how many issues were created and how many existing issues were linked to the ballot)
- More likely, you'll receive a message indicating that there were errors and/or warnings and letting you know that a revised spreadsheet has been emailed to you highlighting the problems