Project

General

Profile

Actions

Patch #5957

closed

Export users list to CSV

Added by Yuki Kita over 13 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Accounts / authentication
Target version:
Start date:
2010-07-25
Due date:
% Done:

0%

Estimated time:

Description

It would be better if Redmine can export all users' information to CSV file.
It is difficult for an administrator to manage users without this feature.


Files

users_export.patch (3.14 KB) users_export.patch Yuki Kita, 2010-07-25 16:03
users_export2.patch (3.03 KB) users_export2.patch Yuki Kita, 2010-07-25 16:08
users_export3.patch (2.95 KB) users_export3.patch Yuki Kita, 2010-07-25 16:13
users_export4.patch (2.88 KB) users_export4.patch David Escala, 2011-02-15 15:03
users_csv_link.png (136 KB) users_csv_link.png Mizuki ISHIKAWA, 2017-06-22 09:21
users_csv.png (79.3 KB) users_csv.png Mizuki ISHIKAWA, 2017-06-22 09:21
users_export5.patch (8.53 KB) users_export5.patch Mizuki ISHIKAWA, 2017-06-22 09:21
users_export6.patch (8.51 KB) users_export6.patch Mizuki ISHIKAWA, 2017-11-10 07:32
users_export7.patch (6.44 KB) users_export7.patch Mizuki ISHIKAWA, 2018-07-17 07:43

Related issues

Related to Redmine - Feature #33126: Support custom fields when exporting users to CSVClosedGo MAEDA

Actions
Actions #1

Updated by Yuki Kita over 13 years ago

Fixed
The previous version was redundant

Actions #2

Updated by Yuki Kita over 13 years ago

Fixed again

Actions #3

Updated by David Escala about 13 years ago

Thanks for sharing this patch!

I have updated it to apply cleanly to 1.1-stable.

Actions #4

Updated by Mizuki ISHIKAWA almost 7 years ago

I do appreciate Yuki Kita and David Escala work.
I think this feature is very useful for security audit in an organization. Probably there are so many people who want this feature.

I have updated the patch:

  • Compatible with latest trunk (r16680)
  • Add status to field.
  • Remove custom_fields from export contents because it take very long time to export thousands users.
  • Add tests.

Link to export CSV

exported CSV

Actions #5

Updated by Go MAEDA almost 7 years ago

  • Target version set to 4.1.0

The patch works fine and passed all test. Looks good to me.
I think 3.4.0 is feature freezing now, so setting target version to 3.5.0.

Actions #6

Updated by Brian Schwartz over 6 years ago

From the list of users page in Admin, you can just right click and save as HTML.

Then open the file in excel and extract the user data you need.

It's the easy way, and I figured it out because the patch was not working for me.

~ Brian

Actions #7

Updated by Mizuki ISHIKAWA over 6 years ago

Brian Schwartz, Thank you for trying users_export5.patch.
I fixed users_export5.patch to work on latest trunk (r17022)

Actions #8

Updated by Go MAEDA over 5 years ago

Mizuki, maybe you can simplify the patch because array constant LABEL_BY_STATUS was introduced by #15201 so your patch does not need to introduce STATUS_NAMES and rewrite users_status_options_for_select, css_classes and users_status_options_for_select method.

Actions #9

Updated by Mizuki ISHIKAWA over 5 years ago

Go MAEDA wrote:

Mizuki, maybe you can simplify the patch because array constant LABEL_BY_STATUS was introduced by #15201 so your patch does not need to introduce STATUS_NAMES and rewrite users_status_options_for_select, css_classes and users_status_options_for_select method.

Thank you for telling me the new change information.
I fixed the patch.

In addition, I also made changes according to #26279.

Actions #10

Updated by Go MAEDA over 5 years ago

  • Subject changed from Export all users' information to Export users list to CSV
  • Category changed from Administration to Accounts / authentication
  • Status changed from New to Closed
  • Assignee set to Go MAEDA
  • Target version changed from 4.1.0 to 4.0.0

Committed. thank you all to those who contributed to this issue.

Actions #11

Updated by Go MAEDA almost 4 years ago

  • Related to Feature #33126: Support custom fields when exporting users to CSV added
Actions

Also available in: Atom PDF