[FOLIO-1981] Import Reporting SIG Master Spreadsheet metadata into JIRA Created: 24/Apr/19  Updated: 03/Jun/20  Resolved: 27/Apr/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: PDF File External System Import - FOLIO Issue Tracker.pdf     PDF File External System Import - FOLIO Issue Tracker2.pdf     Text File JIRA_Add_Log_2019-04-27.txt     Text File JIRA_Import_Log_2019-04-27.txt     Microsoft Word REP-Fix-Comments.xlsx     Microsoft Word REP-Import-Metadata_FINAL.csv     Microsoft Word REP-New-Issues_FINAL.csv     Microsoft Word REP_Backup_Post-Import.xlsx     Microsoft Word REP_Backup_Pre-Import.xlsx     Microsoft Word Reporting SIG Master Spreadsheet.xlsx    
Issue links:
Gantt End to Start
has to be done after FOLIO-1979 Create custom fields for Reporting JI... Closed
Sprint:
Tester Assignee: Holly Mistlebauer

 Description   

The Reporting SIG previous tracked reports in both the JIRA Reporting project and the Reporting SIG Master Spreadsheet (https://docs.google.com/spreadsheets/d/1svUM74Dkg4KvTXLzKZK_2k_SxeukX-87NnYf8CaTrYQ/edit?usp=sharing and attached). We have decided to only use JIRA from now in. In order to do that, we need to have metadata from the Reporting SIG Master Spreadsheet migrated to JIRA. This will be done using JIRA's import .cvs option.



 Comments   
Comment by Holly Mistlebauer [ 27/Apr/19 ]

Just finished updating 188 REP-XXX issues (in the attached file REP-Import-Metadata_FINAL.csv). The log is attached. There were 2 user and several URL errors that I needed to fix. All is well now. Next I need to batch load about a dozen new JIRA issues into the REPORTING JIRA project.

Comment by Holly Mistlebauer [ 27/Apr/19 ]

Just batch imported 14 new issues (in the attached file REP-New-Issues_FINAL.csv). The log is attached. The only error was with one user--I fixed the related errors.

Comment by Holly Mistlebauer [ 27/Apr/19 ]

I have attached the pre- and post- state of the JIRA issues "just in case"...

Comment by Holly Mistlebauer [ 29/Apr/19 ]

This morning I noticed that some of the Comments that were imported were chopped off. I went through the 29 issues that had Notes imported into the Comments field and fixed the ones that were bad. The attached REP-Fix-Comments.xlsx contains the correct Comments values.

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