プロジェクト

全般

プロフィール

Vote #73660

完了

CSV export of spent time ignores filters and columns selection

Admin Redmine さんが約4年前に追加. 約4年前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Time tracking_13
対象バージョン:
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
13
version_id:
71
issue_org_id:
13618
author_id:
68864
assigned_to_id:
1
comments:
10
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
60
ステータス-->[Closed]

説明

When you do a CSV export of spent time, it opens a dialog that lets you choose which columns you want to include in that export.

The problem is that the dialog is a form, and the form's action holds all the filter parameters. By design, GET actions in forms
remove all URL parameters upon submission, thus the exported CSV contains all the issues instead of the expected filtered issues.

It looks like exporting of issues to CSV (not to be confused with spent time) works, as the queries are pulled from session data
and don't rely on parameters. I think this would be the best solution for spent time queries, assuming that the ability to choose
which columns you want to export (selected versus all) is important.

The quickest solution would be to remove the modal altogether and always do selected columns only.

(The modal was introduced with #4742)


journals

--------------------------------------------------------------------------------
Fixed in r11696, thanks for pointing this out.
--------------------------------------------------------------------------------
Isn't the issue export also concerned as Andrew stated?

Haven't checked in details but it would seem logical.
--------------------------------------------------------------------------------
The issue export is not a problem and works as expected, as I noted in the description.
--------------------------------------------------------------------------------
Andrew Dahl wrote:
> The issue export is not a problem and works as expected, as I noted in the description.

Thanks to the session storage?
--------------------------------------------------------------------------------
Etienne Massip wrote:
> Andrew Dahl wrote:
> > The issue export is not a problem and works as expected, as I noted in the description.
>
> Thanks to the session storage?

That is correct.

Since the URL arguments are dropped off the form's action on submission, the time spent export has no way of knowing what filters and columns were selected. The issue export has query sessions, so it can recreate the query without the passed arguments. At least, that's my understanding from the code I read through.

So, with this patch, everything's working as expected. :-) (Also, thanks for the fix, Jean!)
--------------------------------------------------------------------------------
Merged.
--------------------------------------------------------------------------------
Andrew, can you please provide the code changes ? It would be very very helpful to me.
Because i have been struggling with this issue from almost 6 months !!

--------------------------------------------------------------------------------
Radhakrishna, the associated revision is located here: http://www.redmine.org/projects/redmine/repository/revisions/11696

I just removed the Modal, patch attached. I would recommend the associated revision (or upgrading your Redmine version to 2.3.1); however, I haven't tested it.
--------------------------------------------------------------------------------
>Andrew Dahl wrote:
> Radhakrishna, the associated revision is located here: http://www.redmine.org/projects/redmine/repository/revisions/11696
>
> I just removed the Modal, patch attached. I would recommend the associated revision (or upgrading your Redmine version to 2.3.1); however, I haven't tested it.

Andrew Thank you for your reply..

your solution worked great for me.

many many many Thanks
--------------------------------------------------------------------------------


related_issues

duplicates,Closed,13671,CSV-export of time enteries do not respect the selected columns
duplicates,Closed,13790,CSV Export problem

Admin Redmine さんが約4年前に更新

  • カテゴリTime tracking_13 にセット
  • 対象バージョン2.3.1_71 にセット

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

いいね!0
いいね!0