[TIME-238] Excel view is missing hours
Hello,
When I look at my report in html the number of hours logged looks good but when I do an Excel View I am missing a lot of hours, sometime as much as half of them!
Ever seen this issue? How do I debug this?
Thank you for your help!
By desjardd/Daniel Desjardins on Mon, 19 Mar 2012 09:26:18 -0700
Comments (12)
-
reporter -
reporter Serious? No questions asked, just closing like that?
I am not asking for a miracle, I was actually asking for help on how can I debug this...
By desjardd on Tue, 17 Apr 2012 07:51:57 -0700
-
reporter Sorry, I really meant that I have no idea.
My thought was that it might be formatting issue, you may try to see downloaded file in notepad if it has the entries.
If you really want to debug, you may enable INFO logging for plugin and see if there is any difference in records for html and excel report. You should look for 'Query returned : ... worklogs' then.
E.g. add the following to jira/WEB-INF/classes/log4j.properties and restart jira
log4j.logger. com.fdu.jira.plugin = INFO, console, filelog
log4j.additivity.com.fdu.jira.plugin = falseFeel free to reopen the issue if more details available.
By azhdanov on Tue, 17 Apr 2012 10:19:32 -0700
-
reporter Hello,
I still have the same issue. I put the info in the log4 file, what should I look for? In which file? Thank you for your help on this.By desjardd on Wed, 26 Sep 2012 14:14:19 -0700
-
reporter Sorry for delay, you need to look at atlassian-jira.log
By azhdanov on Tue, 9 Oct 2012 07:45:48 -0700
-
reporter Ok, those logs are currently disabled, I will need to wait for the week-end to re-enable them. I will get back to you.
By desjardd on Mon, 15 Oct 2012 14:00:44 -0700
-
reporter Hi Daniel,
Have you solved the problem?
Thank you.
By azhdanov on Mon, 3 Dec 2012 11:36:58 -0800
-
reporter Hello,
no, I actually have looked in the log and couldn't find anything suspicous.
The weird part is that the report is ok, has all hours, but the Excel export doesn't.I realized that the Excel export is actually not an Excel export but simply a "simpler" html output, right?
So I figured I could ask my Excel to simply import the full report instead and it kind of work enough.But still, could the Excel output be debugged? (or improved?)
By desjardd on Wed, 5 Dec 2012 13:32:48 -0800
-
reporter Hi,
If you look excel export file in a browser or other viewer than Excel, are there missing hours ?
It may be that Excel just screws up the output, it's often that Excel think it's date and shows something weird, so it may be even worse in your case.
Thank you.
By azhdanov on Wed, 5 Dec 2012 14:00:31 -0800
-
reporter Hello Andrew,
Yes there are missing lines of data in the "Excel" export. For example, in my web page, I see over 1700 time entries, while in the Excel export I get about 1300. This is reflected if I try to sum the total hours.What more information could I provide you?
By desjardd on Thu, 6 Dec 2012 08:53:45 -0800
-
reporter - changed status to on hold
-
reporter - changed status to wontfix
- Log in to comment
Unfortunately, I can't reproduce it.
By azhdanov on Sun, 15 Apr 2012 15:02:39 -0700