#185 - Worklog import incorrectly parses decimal hours

sundquistm commented on Jun 05, 2022

I log my time in decimal format (e.g., 12.5 = 12h 30m.) This works fine when I do it through JIRA/Tempo.

With JA's Import Worklog feature, the values seem to get parsed literally.

Example: Using JA's own sample_worklog.csv file (which demonstrates various value formats), a value of "12.5" gets read as "12h 5m" instead of "12h 30m". Example: A value of "0.1" gets read as "1m" instead of "5m" Example: A value of "0.11" gets read as "11m" instead of "7m"

I think this could cause fairly severe issues if someone doesn't notice it.

DaniilLyzo commented on May 03, 2021

Same here. 30 minutes is logged in downloaded excel file in Flat Worklogs as 30 h. 1 h 30 min is logged as 1 hour.

Sure, it will cause severe issues. Thank you, guys.

shridhar-tl commented on May 09, 2021

@DaniilLyzo @sundquistm - This issue has been resolved and is not available for you to test. Please update your extension if it did not happen automatically and verify if it is working as expected.

DaniilLyzo commented on May 15, 2021

WEB IMAGE

EXCEL IMAGE:

@shridhar-tl Thank you for your reply. :) Updated to version 2.31. Unfortunately, the Issuer still remains. Check the above-attached screenshots. P.S. And probably it is not a problem of decimal hours. I think I updated the wrong ticket.

shridhar-tl commented on May 27, 2021

Hi @DaniilLyzo , I just realized what the issue was after trying couple of times in past one week. I will try to fix it ASAP, but till then you can do small workaround to fix it.

Go to worklog report and click on Settings icon from top right corner of the page Change the Log hour format like shown in the following screenshot:

Now try to export and you should see it properly. You can use it this way untill you have the issues resolved. Once again thank you for reporting this issue. Please feel free to let me know if you face any other issues.