Convert Seconds into Days Hours

[Terri Berry]

I found this code on this site for a version of JIRA from 2015. This is code to place in the highlighted file to convert seconds for the time into days and hours, etc. The code is specific to version. We are on version 7.3/7.4. Can someone tell me if there is more updated code that what I have placed below which was for the 5.x versions.

Filename: WEB-INF/classes/templates/jira/issue/field/duration-columnview.vm

Script:

#if ($displayParams.excel_view && $duration)

    #set ($seconds = $textutils.parseInt($duration))

    #set ($minutes = $seconds / 60)

    #if ($minutes >= 60)

        #set ($hours = $minutes / 60)

        #set ($remainder = $minutes % 60)

        #if ($remainder > 0)

            #set ($remainder = $remainder * 100)

            #set ($remainder = $remainder / 60)

        #end

    #else

        #set ($hours = 0)

        #set ($remainder = $minutes * 100)

        #set ($remainder = $remainder / 60)

    #end

    $textutils.htmlEncode("${hours}.${remainder}")

#else

    $textutils.htmlEncode($duration)

#end

[Andy Heinzer]

Hi Terri,

I believe the thread you are referring to is https://community.atlassian.com/t5/Jira-questions/Export-Estimates-in-hours-Day/qaq-p/58647

I'm not sure if the code needs to be changed to make this work with more recent Jira versions or not yet.  However starting with Jira 7.2, the Excel export feature was deprecated and in its place Jira got the CSV exporter instead. This means that, by default your current version of Jira doesn't actually have this Excel exporter enabled.

That said, you can still enable the old Excel exporter in Jira 7.3 and 7.4.  Please see the KB JIRA Excel export of issues no longer opens correctly

From that page:

We removed the Excel export option in JIRA 7.2, as we've introduced a more robust, flexible exporter in the CSV export. We hope you find this more beneficial. We do plan on removing this functionality entirely, however in the meantime, it can be unlocked with the following steps:

1. Stop JIRA.
2. Locate the jira-config.properties file in the $JIRA_HOME directory. If the file does not exist, please proceed to create it.
3. Open the file and add the below on a separate line:

jira.export.excel.enabled=true

4. Save this file.
5. Restart JIRA.

So it very well might be that the modifications to that .vm file might still work in your version of Jira.  But only after you enable the excel exporter again, and then export to Excel instead of CSV.

[Terri Berry]

Thank You, Andrew. Yes....we have already manually enabled the Export to Excel feature. Can you actually put in a request to maintain the Export to Excel (though I know CSV is still accessible in Excel). We used Employee IDs that are tagged to an Employee Name. O screen in JIRA, we see the name but when exporting via CSV, it exports the ID. Only the Export via Excel will send the name and NOT the ID. If Atlassian is going to get rid of this feature, they must make that tweak and allow the CSV to export what the user sees on screen and NOT some derivation of it please

[Andy Heinzer]

Hi Terri,

There does exist a feature request to change the behavior of the CSV exporter using the userid to instead use usernames in https://jira.atlassian.com/browse/JRASERVER-62887 I would recommend following that request for additional updates.

Any user can create new suggestions in that JRASERVER project.  However I don't really have high hopes of Atlassian continuing to invest in this deprecated feature that is the Excel exporter. 

If this is something that you need going forward, you might take a look at a 3rd party vendor solution such as the Better Excel plugin for Jira.

Or it might be possible to extract the data you are looking for via SQL queries against the Jira database directly.