Patch #5957

Export users list to CSV

Added by Yuki Kita over 8 years ago. Updated 4 months ago.

Status:ClosedStart date:2010-07-25
Priority:NormalDue date:
Assignee:Go MAEDA% Done:

0%

Category:Accounts / authentication
Target version:4.0.0

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.

users_export.patch Magnifier (3.14 KB) Yuki Kita, 2010-07-25 16:03

users_export2.patch Magnifier (3.03 KB) Yuki Kita, 2010-07-25 16:08

users_export3.patch Magnifier (2.95 KB) Yuki Kita, 2010-07-25 16:13

users_export4.patch Magnifier (2.88 KB) David Escala, 2011-02-15 15:03

users_csv_link.png (136 KB) Mizuki ISHIKAWA, 2017-06-22 09:21

users_csv.png (79.3 KB) Mizuki ISHIKAWA, 2017-06-22 09:21

users_export5.patch Magnifier (8.53 KB) Mizuki ISHIKAWA, 2017-06-22 09:21

users_export6.patch Magnifier (8.51 KB) Mizuki ISHIKAWA, 2017-11-10 07:32

users_export7.patch Magnifier (6.44 KB) Mizuki ISHIKAWA, 2018-07-17 07:43

Associated revisions

Revision 17463
Added by Go MAEDA 4 months ago

Export users list to CSV (#5957).

Contriubted by Mizuki ISHIKAWA and Yuki Kita.

History

#1 Updated by Yuki Kita over 8 years ago

Fixed
The previous version was redundant

#2 Updated by Yuki Kita over 8 years ago

Fixed again

#3 Updated by David Escala almost 8 years ago

Thanks for sharing this patch!

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

#4 Updated by Mizuki ISHIKAWA over 1 year 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

#5 Updated by Go MAEDA over 1 year 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.

#6 Updated by Brian Schwartz about 1 year 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

#7 Updated by Mizuki ISHIKAWA about 1 year ago

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

#8 Updated by Go MAEDA 4 months 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.

#9 Updated by Mizuki ISHIKAWA 4 months 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.

#10 Updated by Go MAEDA 4 months 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.

Also available in: Atom PDF