[FOLIO-1987] Import Gap Analysis/Feature Ranking data into JIRA Created: 26/Apr/19  Updated: 03/Jun/20  Resolved: 02/May/19

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P3
Reporter: Holly Mistlebauer Assignee: Holly Mistlebauer
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: JPEG File ErrorMessageOnScreen-Final.JPG     Text File Finallog.txt     Microsoft Word Import Rankings - Final.csv     JPEG File UXPROD-37.JPG     JPEG File UXPROD-38.JPG    
Issue links:
Relates
relates to FOLIO-1998 Duplicate Issue Keys in UXPROD JIRA P... Closed
Sprint:
Tester Assignee: Holly Mistlebauer

 Description   

"Rank: <institution>" columns from the OPEN FEATURES tab of the Gap Analysis and Feature Ranking 2019 Google spreadsheet located at https://docs.google.com/spreadsheets/d/1abGWXoVtOIuPH7Z-zOaQ0RBYz8Gyu0jILrdnaniyDYY/edit#gid=2074261517&range=A1 will be batch imported into JIRA project UXPROD "Rank: <institution>" fields (as we have done before). The column headings in RED indicate that the rankings for that institution should NOT be pulled in from the spreadsheet as the institution has chosen to update JIRA directly.



 Comments   
Comment by Holly Mistlebauer [ 01/May/19 ]

Despite running 2 tests before importing the full file (Import Rankings - Final.csv, which is attached), I ran into a problem (see attachments ErrorMessageOnScreen-Final.JPG and Finallog.txt). I was able to trace the problem to either UXPROD-38 Open or the issue just before it, UXPROD-37 Closed . When I tried to access both issues to see what state they were in, I received this error message: "UXPROD-XX cannot be opened. The issue may have been deleted or you might not have permission to see the issue." (I have attached the screen prints for both issues, UXPROD-37 Closed .JPG and UXPROD-38 Open .JPG.) I was able to successfully import the remaining 118 issues after UXPROD-37 Closed and UXPROD-38 Open .

Comment by Holly Mistlebauer [ 01/May/19 ]

I am doing a verification process to check two things:
1) That the Chalmers, 5 Colleges and U of AL rankings have not been adjusted.
2) That the JIRA Rank fields for the other institutions now match what was in the spreadsheet.

With regard to #1, I have found some changes. It's possible there were changes made today, but I need to check into this.
With regard to #2, it looks like about 105 imports were not processed properly. I know why 1 wasn't, but not sure about the others.

I have a meeting with Cate and Jakub at 8:00 AM tomorrow morning and will discuss this with them at that time.

Comment by Holly Mistlebauer [ 01/May/19 ]

I have JIRA backups before and after the imports--they are too large to attach to this issue.

Comment by Holly Mistlebauer [ 02/May/19 ]

I have some answers...
1) Chalmers, 5Colleges and U of AL rankings are fine. The process I used to verify results was flawed.
2) I have found reviewed a few of the 105 mismatches. Two are actually correct in JIRA. Two issues I can't get to. I will need to check these one by one tomorrow.

Comment by Holly Mistlebauer [ 02/May/19 ]

Major breakthrough today. The problem was caused by 5 duplicate issues. Read all about it in FOLIO-1998 Closed .

Comment by Holly Mistlebauer [ 02/May/19 ]

Still need to manually update UXPROD-37 Closed and UXPROD-38 Open ...

Generated at Thu Feb 08 23:17:22 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.