Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-65502

Import from CSV to Jira does not update Resolved Date field

      Status Update

      This is now working in Cloud.

      Only, the resolution dates are not imported/updated from CSV if you do not import/update the Resolution field as well. 

      As per the "Is there a way to change the "Resolution Date" thread in the Atlassian Community, in order to update the resolution dates you need a CSV file with at least the below 4 fields:

      1. Issue Key
      2. Summary
      3. Resolution
      4. Resolved (to be mapped to "Date Resolved")

      Summary

      Import from CSV does not update Resolved Date field

      Environment

      Cloud

      Steps to Reproduce

      Prepare CSV file to include a Resolved Date field
      Go to External System Import > Use Jira Import Wizard > https://<instance>.atlassian.net/secure/admin/ExternalImport1.jspa
      Choose CSV > Import CSV file created in 1
      Click Next
      Define date as included in CSV and click Next
      Wait for Success message

      Expected Results

      Resolved Date Fields are updated with CSV values

          Form Name

            [JRACLOUD-65502] Import from CSV to Jira does not update Resolved Date field

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1619308 ] New: JAC Bug Workflow v3 [ 3361737 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Eric S (Inactive) made changes -
            Component/s New: Backup and Restore [ 46592 ]
            Component/s Original: Backup & Restore - Import From CSV [ 46639 ]
            Dario B made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Verified [ 10005 ] New: Resolved [ 5 ]
            Dario B made changes -
            Description Original: h3. Summary
            Import from CSV does not update Resolved Date field

            h3. Environment
            Cloud

            h3. Steps to Reproduce
            Prepare CSV file to include a Resolved Date field
            Go to External System Import > Use Jira Import Wizard > https://&lt;instance&gt;.atlassian.net/secure/admin/ExternalImport1.jspa
            Choose CSV > Import CSV file created in 1
            Click Next
            Define date as included in CSV and click Next
            Wait for Success message

            h3. Expected Results
            Resolved Date Fields are updated with CSV values

            New: {panel:title=Status Update|borderStyle=solid|borderColor=#ff7f7f|titleBGColor=#ff7f7f|bgColor=#e5e5e5}
            This is now working in Cloud.

            Only, the resolution dates are not imported/updated from CSV if you do not import/update the *Resolution* field as well. 

            As per the ["Is there a way to change the "Resolution Date" thread in the Atlassian Community|https://community.atlassian.com/t5/Jira-questions/Is-there-a-way-to-change-the-quot-Resolution-Date-quot-in-Jira/qaq-p/385739], in order to update the resolution dates you need a CSV file with at least the below 4 fields:
             # Issue Key
             # Summary
             # Resolution
             # Resolved (to be mapped to "Date Resolved"){panel}
            h3. Summary

            Import from CSV does not update Resolved Date field
            h3. Environment

            Cloud
            h3. Steps to Reproduce

            Prepare CSV file to include a Resolved Date field
             Go to External System Import > Use Jira Import Wizard > https://&lt;instance&gt;.atlassian.net/secure/admin/ExternalImport1.jspa
             Choose CSV > Import CSV file created in 1
             Click Next
             Define date as included in CSV and click Next
             Wait for Success message
            h3. Expected Results

            Resolved Date Fields are updated with CSV values
            SET Analytics Bot made changes -
            Support reference count Original: 4 New: 5
            SET Analytics Bot made changes -
            Support reference count Original: 3 New: 4
            Atiqah Roslan made changes -
            Description Original: h3. Summary
            Import from CSV does not update Resolved Date field

            h3. Environment
            Cloud

            h3. Steps to Reproduce
            Prepare CSV file to include a Resolved Date field
            Go to External System Import > Use Jira Import Wizard > https://&lt;instance&gt;.atlassian.net/secure/admin/ExternalImport1.jspa
            Choose CSV > Import CSV file created in 1
            Click Next
            Define date as included in CSV and click Next
            Wait for Success message

            h3. Expected Results
            Resolved Date Fields are updated with CSV values

            h3. Workaround
            Update in database, to do this you will need to Contact Atlassian Cloud Support
            New: h3. Summary
            Import from CSV does not update Resolved Date field

            h3. Environment
            Cloud

            h3. Steps to Reproduce
            Prepare CSV file to include a Resolved Date field
            Go to External System Import > Use Jira Import Wizard > https://&lt;instance&gt;.atlassian.net/secure/admin/ExternalImport1.jspa
            Choose CSV > Import CSV file created in 1
            Click Next
            Define date as included in CSV and click Next
            Wait for Success message

            h3. Expected Results
            Resolved Date Fields are updated with CSV values

            Bugfix Automation Bot made changes -
            Support reference count Original: 1 New: 3
            Confluence Escalation Bot (Inactive) made changes -
            Support reference count Original: 2 New: 1
            Kiran (Inactive) made changes -
            Occurrence Factor New: 25% [ 12831 ]

              Unassigned Unassigned
              nmuhi Nazri Muhi (Inactive)
              Affected customers:
              3 This affects my team
              Watchers:
              21 Start watching this issue

                Created:
                Updated:
                Resolved: