[TIME-238] Excel view is missing hours

[Andriy Zhdanov]

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

[Andriy Zhdanov]

Unfortunately, I can't reproduce it.

By azhdanov on Sun, 15 Apr 2012 15:02:39 -0700

[Andriy Zhdanov]

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

[Andriy Zhdanov]

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 = false

Feel free to reopen the issue if more details available.

By azhdanov on Tue, 17 Apr 2012 10:19:32 -0700

[Andriy Zhdanov]

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

[Andriy Zhdanov]

Sorry for delay, you need to look at atlassian-jira.log

By azhdanov on Tue, 9 Oct 2012 07:45:48 -0700

[Andriy Zhdanov]

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

[Andriy Zhdanov]

Hi Daniel,

Have you solved the problem?

Thank you.

By azhdanov on Mon, 3 Dec 2012 11:36:58 -0800

[Andriy Zhdanov]

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

[Andriy Zhdanov]

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

[Andriy Zhdanov]

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