Patch #5957
closed
Export users list to CSV
Added by Yuki Kita over 14 years ago. Updated over 6 years ago.
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
Updated by Yuki Kita over 14 years ago
- File users_export2.patch users_export2.patch added
Fixed
The previous version was redundant
Updated by Yuki Kita over 14 years ago
- File users_export3.patch users_export3.patch added
Fixed again
Updated by David Escala almost 14 years ago
- File users_export4.patch users_export4.patch added
Thanks for sharing this patch!
I have updated it to apply cleanly to 1.1-stable.
Updated by Mizuki ISHIKAWA over 7 years ago
- File users_csv_link.png users_csv_link.png added
- File users_csv.png users_csv.png added
- File users_export5.patch users_export5.patch added
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
Updated by Go MAEDA over 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.
Updated by Brian Schwartz about 7 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
Updated by Mizuki ISHIKAWA about 7 years ago
- File users_export6.patch users_export6.patch added
Brian Schwartz, Thank you for trying users_export5.patch.
I fixed users_export5.patch to work on latest trunk (r17022)
Updated by Go MAEDA over 6 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.
Updated by Mizuki ISHIKAWA over 6 years ago
- File users_export7.patch users_export7.patch added
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_NAMESand rewriteusers_status_options_for_select,css_classesandusers_status_options_for_selectmethod.
Thank you for telling me the new change information.
I fixed the patch.
In addition, I also made changes according to #26279.
Updated by Go MAEDA over 6 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.
Updated by Go MAEDA over 4 years ago
- Related to Feature #33126: Support custom fields when exporting users to CSV added