プロジェクト

全般

プロフィール

Vote #67027

未完了

"% done" should provide data in text form too

Admin Redmine さんがほぼ2年前に追加. ほぼ2年前に更新.

ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Issues list_58
開始日:
2010/04/09
期日:
進捗率:

0%

予定工数:
category_id:
58
version_id:
32
issue_org_id:
5284
author_id:
7834
assigned_to_id:
0
comments:
13
status_id:
1
tracker_id:
2
plus1:
0
affected_version:
closed_on:
affected_version_id:
ステータス-->[New]

説明

I see "Issues list" page can have "% done" field, which shows info as a progress bar. This looks nice, but I also need to be able to import redmine data into other programs like Microsoft Excel.
Unfortunately, Microsoft Excel 2003 shows no values in imported column "% Done". I assume this is because the info in not provided in text format when Excel parses URL like http://demo.redmine.org/projects/ace/issues

is it possible to provide text info for "% done" field in this web page in addition to nice green "progress" bar? This would be really helpful to load tasks into excel and be able to use Excel calculations for remaining time and other parameters.


journals

--------------------------------------------------------------------------------
what I actually need to do is to estimate "remaining time" for all tasks for a particular target version.
If I could show "remaining time" column on "Issues list" page and then import it into Excel the same way - this would solve my problem and I would not really need text value for "% done" column (although I'd recommend to provide it there anyway to simplify redmine integration with all kinds of external tools, which can grep data from redmine web URLs).
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Issues/show has "% done" information next to the progress bar.
I would like to confirm the "% done" information on the Issues list as well.
This change is a very small change, so no one will be confused.

You can implement this feature by making the following changes.

<pre><code class="diff">
diff --git a/app/helpers/queries_helper.rb b/app/helpers/queries_helper.rb
index 9d3f2468e..40c481134 100644
--- a/app/helpers/queries_helper.rb
+++ b/app/helpers/queries_helper.rb
@@ -221,7 +221,7 @@ module QueriesHelper
when :last_notes
item.last_notes.present? ? content_tag('div', textilizable(item, :last_notes), :class => "wiki") : ''
when :done_ratio
- progress_bar(value)
+ progress_bar(value, :legend => "#{value}%")
when :relations
content_tag('span',
value.to_s(item) {|other| link_to_issue(other, :subject => false, :tracker => false)}.html_safe,
</code></pre>

--------------------------------------------------------------------------------
Mizuki ISHIKAWA wrote:
> Issues/show has "% done" information next to the progress bar.

Here is a screenshot of Mizuki's patch.

!{width: 756px; border: 1px solid #ccc;}.percent-done-with-number@2x.png!
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
I modified the style a little.
--------------------------------------------------------------------------------
LGTM. Setting the target version to 4.1.0.
--------------------------------------------------------------------------------
Go MAEDA wrote:
> LGTM. Setting the target version to 4.1.0.

Do you really think that we need the real value near the progress bar?
--------------------------------------------------------------------------------
Marius BALTEANU wrote:
> Do you really think that we need the real value near the progress bar?

Definitely yes. Do you think the value is unnecessary?

Currently, we cannot understand the accurate value in the issues list. It is difficult for me to distinguish 20% and 30% with the progress bar. In fact, several of our customers have asked us to display numbers as well as progress bars.

Not only our customers, I think many people want the real value. Some users in Japan have published hacks to show the value in the issues list.

http://blog.enjoyxstudy.com/entry/2016/09/04/000000 (Japanese)
https://qiita.com/cress_cc/items/fbccedcb1993bf22a818 (Japanese)
--------------------------------------------------------------------------------
Go MAEDA wrote:
> Marius BALTEANU wrote:
> > Do you really think that we need the real value near the progress bar?
>
> Definitely yes. Do you think the value is unnecessary?
>
> Currently, we cannot understand the accurate value in the issues list. It is difficult for me to distinguish 20% and 30% with the progress bar. In fact, several of our customers have asked us to display numbers as well as progress bars.
>
> Not only our customers, I think many people want the real value. Some users in Japan have published hacks to show the value in the issues list.
>
> http://blog.enjoyxstudy.com/entry/2016/09/04/000000 (Japanese)
> https://qiita.com/cress_cc/items/fbccedcb1993bf22a818 (Japanese)

Not unnecessary, but I find it awkward for the below example:
!{border: 1px solid grey;}done_ratio.png!

I see lots of 0% which are irrelevant from my point of view.

Also, the @padding-right: 40px@ added by the last patch is wrong (I think) because I don't see any reason for that empty space.

Maybe it is better to show only for values between 10% and 90% and inline (over the progress bar)?
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------


related_issues

duplicates,Closed,5534,percentage display in numbers in issue view

Admin Redmine さんがほぼ2年前に更新

  • カテゴリIssues list_58 にセット
  • 対象バージョンCandidate for next major release_32 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0