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

When importing issues from CSV, Original Estimate is imported as minutes instead of hours

      Summary

      When importing issues from CSV, despite estimates being listed in seconds according to Creating Issues using the CSV Importer and Importing Data from CSV, if default unit for time tracking is set to minutes, it will be imported as minutes instead of hours.

      Environment

      JIRA 6.5.*

      Steps to Reproduce

      1. Set Time Tracking default unit to Minutes (per Configuring Time Tracking)
      2. On a JIRA instance, Issues > Import from CSV
      3. Import the attached CSV
      4. Check the imported issues. Original Estimate will show 14m instead of 14h.

      Expected Results

      Importer would convert the seconds to minutes and then hours/days if necessary.

      Actual Results

      The minutes are converted to hours and then labeled as minutes. The default unit should only be used if not specified.

      Notes

      For example, Original Estimate is listed in CSV as 50400 seconds > 840 minutes > 14 hours
      Importer converts the 14 hours back to minutes, by default.
      Importer should know that 50400 is listed as seconds.

      Solution / Workaround

      1. Change Default Time Tracking unit to hours, and re-import the CSV issues.
      2. Confirm that Original Estimate shows correct time, and if desired, change the default time tracking back to minutes.

            [JRACLOUD-81938] When importing issues from CSV, Original Estimate is imported as minutes instead of hours

            Vittal Krishna added a comment - https://getsupport.atlassian.com/browse/CES-52272

            Bug still there, just tried 

            Alessandro Domanico added a comment - Bug still there, just tried 

            Hello!

            We’re looking to improve the import experience in Jira and are keen to understand how our community is using the Jira Import Module (JIM). If you’ve used JIM to migrate/move data into Jira recently, we’d love to hear about your experience. Please take a few minutes to fill out this survey. Your feedback will help us learn how we can improve your experience in importing data.

            Survey link - https://forms.gle/NYNkmS92r96z42QV9

            Thanks!

            Prashanth M
            Product Manager, Jira Platform

            Prashanth M added a comment - Hello! We’re looking to improve the import experience in Jira and are keen to understand how our community is using the Jira Import Module (JIM). If you’ve used JIM to migrate/move data into Jira recently, we’d love to hear about your experience. Please take a few minutes to  fill out this survey . Your feedback will help us learn how we can improve your experience in importing data. Survey link -  https://forms.gle/NYNkmS92r96z42QV9 Thanks! Prashanth M Product Manager, Jira Platform

            Rolando Castillo added a comment - - edited

            As Jira user, I need to multiply their figures by 60, in order to get the right "time estimate"...

            As Jira admin, this problem is not happening.

            Rolando Castillo added a comment - - edited As Jira user, I need to multiply their figures by 60, in order to get the right "time estimate"... As Jira admin, this problem is not happening.

            You'll be able to work around the default 'Minutes' setting in Time Tracking if you multiply the hours entry on your CSV file by 216000. So, 1 hour = 216000 on your CSV file.

            Brian Longstreet added a comment - You'll be able to work around the default 'Minutes' setting in Time Tracking if you multiply the hours entry on your CSV file by 216000. So, 1 hour = 216000 on your CSV file.

            Possible workarounds reported by developers at my company:

            Using the import from CSV option in the Jira admin console to import CSV is working fine. Original Estimates and Time Remaining are coming in as expected.

            And, if we give Original Estimates and Time Remaining in milliseconds (instead of seconds) and then use import option available under “Issues and filters” then it works. Original Estimates and Time Remaining come in as expected.

            So conclusion is, if we use

            • Import CSV option under Jira admin console then we need to provide Original Estimates and Time Remaining in seconds.
            • For the Import CSV option under Issues and filters we need to provide Original Estimates and Time Remaining in milliseconds.

             

            dave.drexler added a comment - Possible workarounds reported by developers at my company: Using the import from CSV option in the Jira admin console to import CSV is working fine. Original Estimates and Time Remaining are coming in as expected. And, if we give Original Estimates and Time Remaining in milliseconds (instead of seconds) and then use import option available under “Issues and filters” then it works. Original Estimates and Time Remaining come in as expected. So conclusion is, if we use Import CSV option under Jira admin console then we need to provide Original Estimates and Time Remaining in seconds. For the Import CSV option under Issues and filters we need to provide Original Estimates and Time Remaining in milliseconds.  

            This also occurs in Jira Server.
            I understand that there is a workaround, but please correct it as it is inconvenient.

            Oh ... just the same comments were on.

            Hidehiko Kuniya[Ricksoft] added a comment - - edited This also occurs in Jira Server. I understand that there is a workaround, but please correct it as it is inconvenient. Oh ... just the same comments were on.

            vivi yang added a comment -

            for the proposal, which includes an initial comparison of the two licenses.

            I like the table - it makes the differences and similarities quite clear.

            I have one nitpick on the comparison: For “other versions” it states
            for the GPL:

            “Compliance with any version automatically permitted if no version
            specified; otherwise no by default, but licensor may specify that
            later/other versions allowable. No additional obligations are
            imposed on authors where a reuser follows a later version. (§§14)”

            It would be nice to add, that the suggested license text allows any
            later version, and that there is an option to select a proxy who can
            decide for each later version whether the works may be used under this
            version (clause 14). Additionally clause 13 allows using the AGPL
            (which is a GPL with added copyleft protection for applications which
            are accessed over the network - a requirement for providing copyleft
            in remote services).,,,,

            vivi yang added a comment - for the proposal, which includes an initial comparison of the two licenses. I like the table - it makes the differences and similarities quite clear. I have one nitpick on the comparison: For “other versions” it states for the GPL: “Compliance with any version automatically permitted if no version specified; otherwise no by default, but licensor may specify that later/other versions allowable. No additional obligations are imposed on authors where a reuser follows a later version. (§§14)” It would be nice to add, that the suggested license text allows any later version, and that there is an option to select a proxy who can decide for each later version whether the works may be used under this version (clause 14). Additionally clause 13 allows using the AGPL (which is a GPL with added copyleft protection for applications which are accessed over the network - a requirement for providing copyleft in remote services).,,,,

            vivi yang added a comment -

            The possibility to use CC by-sa licensed works together with GPL
            licensed works to form a derivative work of both would make my life a
            lot easier.

            It would allow me to use works from Ryzoom together with works from
            Battle for Wesnoth in the free RPG books I work on.

            And it would make it easier to work on the writings, the artwork and
            the code for a game which uses the rules of the RPG for a tactical
            computer-RPG without having to worry about falling into licensing
            traps.

            Finally I could license my own drawings and poems under CC by-sa,
            which would make it much easier for others to reuse them, while
            preserving my ability combine all derivatives of my works with my
            other works - regardless of the kind of work (song, image, text or
            program - the latter two often require the GPL to preserve the
            possibility to reuse the improvements made to derivative in practice).

            Now know where I stand - I hope I can contribute to making the
            compatibility of CC attribution-sharealike and GPLv3 or later work
            out!

            Best wishes,
            Arne

            singing a part of the history of free software,,?

            vivi yang added a comment - The possibility to use CC by-sa licensed works together with GPL licensed works to form a derivative work of both would make my life a lot easier. It would allow me to use works from Ryzoom together with works from Battle for Wesnoth in the free RPG books I work on. And it would make it easier to work on the writings, the artwork and the code for a game which uses the rules of the RPG for a tactical computer-RPG without having to worry about falling into licensing traps. Finally I could license my own drawings and poems under CC by-sa, which would make it much easier for others to reuse them, while preserving my ability combine all derivatives of my works with my other works - regardless of the kind of work (song, image, text or program - the latter two often require the GPL to preserve the possibility to reuse the improvements made to derivative in practice). Now know where I stand - I hope I can contribute to making the compatibility of CC attribution-sharealike and GPLv3 or later work out! Best wishes, Arne – singing a part of the history of free software,,?

              Unassigned Unassigned
              Anonymous Anonymous
              Affected customers:
              26 This affects my team
              Watchers:
              38 Start watching this issue

                Created:
                Updated: