Feature #34040

Include all notes in issue list csv

Added by Mizuki ISHIKAWA about 1 year ago. Updated about 1 month ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues list
Target version:-
Resolution:

Description

Currently, only the latest note can be output as CSV, but I think that many people need all the notes.
Plugins for that are also being developed. https://github.com/suer/redmine_export_with_journals

draft.patch Magnifier (6.75 KB) Mizuki ISHIKAWA, 2021-09-02 07:21

screenshot.2021-09-02-13.59.56.png (77.4 KB) Mizuki ISHIKAWA, 2021-09-02 07:21

History

#1 Updated by Mizuki ISHIKAWA about 1 year ago

In order to implement this feature, we need to think about how to include notes in CSV.

My idea:
# Tracker Status Priority Subject Assignee Updated Note-# Notes
3 Bug New Normal Private issue on public project 09/08/2020 01:40 PM
3 1 test1
3 2 test2
3 3 * test3
* test4
2 Bug New Low Subproject issue two 09/01/2020 11:27 AM
1 Bug New Low Cannot print recipes User name 09/02/2020 11:27 AM
1 1 The quick brown fox jumps over the lazy dog
1 2 Some notes with Redmine links: #2, r2.

I've added a column called Note- # to make note sorting work.
For a issue with the same id: 3, there are 4 lines with 1 line of ticket information + 3 lines of notes.

#2 Updated by Go MAEDA about 1 year ago

Mizuki ISHIKAWA wrote:

In order to implement this feature, we need to think about how to include notes in CSV.

My idea:
# Tracker Status Priority Subject Assignee Updated Note-# Notes
3 Bug New Normal Private issue on public project 09/08/2020 01:40 PM
3 1 test1

I think an additional column that represents the user who wrote the note (stored as journals.user_id) is necessary.

#3 Updated by Go MAEDA about 1 year ago

Go MAEDA wrote:

I think an additional column that represents the user who wrote the note (stored as journals.user_id) is necessary.

And it is better to have journals.created_on and journals.private_notes.

#4 Updated by Mizuki ISHIKAWA about 1 month ago

I have created a draft patch for people to try out this feature. I have not written any tests.
If you output CSV from issues list and check "All notes" checkbox, notes related information will be added to CSV.
"All notes" checkbox is available only for CSV output.

Feedback is very welcome!

Also available in: Atom PDF