How to Export Users to CSV from JIRA
Usage FAQ
- 'Road Map', 'Change Log ', and 'Versions' Project Tabs Are Not Visible
- Allow editing of Closed Issues
- Allowing users to create issues anonymously
- Anonymising JIRA Data
- Appending Email Addresses to Comments Made by Anonymous Users when Using a Mail Handler
- Asking for an attachment on the Create Issue page
- Can I store customer details, like company, address and contact information, in JIRA?
- Changing Custom Field Types
- Changing Templates Used by Export to Excel from the Issue Navigator
- Changing the default session timeout
- Changing the Default Tab Panel from Comments to All
- 期日の入力形式の変更
- Changing the Project Key
- Changing the Size of the Fix Versions and Affects Versions Select List
- Changing the Size of the Text Area Custom Field
- Changing the Temporary Directory
- Configuring project specific security
- SSL サービスに接続する
- Current Reporter Browse Project Permission
- CVS ssh Jira Integration
- Displaying a Field Based on Another Field Selection
- Editing a custom field option
- Field Layout Schemes in JIRA 3.x
- Fields Allowing Custom HTML or JavaScript
- Finding the Id for Issue Types
- How can I control the editing of issue fields via workflow?
- How do I assign issues to multiple users
- How do I disable Firebug for JIRA?
- How Do I Use an SSL Certificate Generated Using openssl?
- How to change Multi Select Custom field size using script
- How to change the location of stdout and stderr logs
- 課題の再オープン時に解決状況フィールドの値を削除する方法
- How to configure comment field to become mandatory in workflow transition
- How to convert types using Jelly
- How to deactivate comments for closed issues
- How to display a different format for the Number customfield
- How to ensure the Road Map tab is visible
- HTTPS の URL で Unicode "非 ASCII" 文字を適切に表示する方法
- How to have long component version names display properly in the Issue Navigator
- How to re-order statuses
- How to re-order the list of issue operation in an issue
- How to resize the 'Components' and 'Affects Versions' fields in the Issue Navigator
- How to Restrict the Subversion Commits Tab to Selected Projects or Users
- How To Send Notifications By Issue Type
- How to show a transition only when the Assignee is different from the Current User
- How to update custom field values during workflow transition.
- Letting customers only create issues
- Login problems
- Mail error - Unable to relay
- Making JIRA login case insensitive for JIRA 3.13.x
- Parsing utf-7 emails
- QuickSearch guesses the issue key prefix (sometimes)
- Receiving Notification for Select Issues or Updates
- Removing Commas for Values Held in Number Field Custom Field Type
- Removing invalid characters from XML backups
- Removing NONE from the Issue Security Drop-Down List
- Re-order workflow transactions
- Resolved issues appearing in Open issues filters
- Retrieving the JIRA Administrator
- Sending JIRA Data to Support
- Setting Additional Fields for Issues Created from Email
- Setting a Default Value in the Description Field
- Setting Priority field value based on customfield value
- Showing Extended Timestamp in the Created Column of the Issue Navigator
- Tracking the Time Taken for Each Workflow Transition
- Troubleshooting Issue Creation Via Email
- Using JIRA to Manage reusable modules
- Where are the application server logs?
- XML format for import & export files
- How to Enable the FishEye Plugin from the Plugin Administration Screen
- How to Change the Number of Rows Allowed in the Text Type Custom Field Renderer
- How to Make a Federated JIRA Instance
- How to Remove 'Unknown' Option from 'Component' and 'Fix Versions'
- Automatic Escalation of issues
- How to Activate Header Row for Subtask List in Issue Detail View
- How to Limit the Number of Characters Entered in a Summary Field
- JIRA's Timestamp Doesn't Match the System Time
- How to Remove Duplicate Entries for Names and Groups
- How to Export Users to CSV from JIRA
- How Come JIRA does Not Show Direct SQL Data Modifications
- How to get JIRA Pages to Render when URL Contains an Underscore
- How to disable or enable the GOT FEEDBACK button
- How do I reduce my user count in JIRA
- How to Bulk Edit Groups in JIRA
- How to enable "Attach Screenshot" on Linux Machine
- How to Configure Workflow to allow Certain Group to Perform Certain Workflow Transition
- How to Create a FishEye's Changeset or Crucible's Review Link on JIRA's Comment or Description
- How to make the 'Assignee' field required when 'Allow unassigned issues' is turn ON in General Configuration?
- How to allow users to view sub-task only but not its parent issue
- How to change the Date Time Range Picker format to 24h format
- What if you wish your Custom Field Appearing in Issue Navigator but not willing to set the context to All issue types
- Why Fix/Affected Version sort differently in issue screen after picking more than one version?
- Modify the gadget limit on a dashboard
- How to add comments to Excel export
- How to change the Original Step in Workflow Transition
- How to Hide the "Configure Fields" Button on the Create Issue Screen
- How to display the issue type name in issue navigator column beside the image icon
- How to Edit Bundled or System Plugins
- How to auto disable compatibility mode in Internet Explorer
- How to restore a single attachment to an issue
- JIRA does not pick up the data after running an UPDATE or DELETE SQL statement
- Why is Resolution Date set on Unresolved Issues after a CSV import
- How to Set Monday as First Day of Week in Date Picker Calendar
このページの内容
関連コンテンツ
- 関連コンテンツがありません
Sometimes it is useful to get a list of users exported to CSV for various purposes. JIRA doesn't currently have this functionality but you can leverage various database functionalities to do this.
ご利用のデータベースに応じて次のクエリのいずれかを実行します。出力には、ユーザーの ID、ユーザー名、名、姓が含まれます。
データベースの変更を行う場合は 必ず事前に バックアップ を取得してください。
MySQL
select id, user_name, lower_first_name, lower_last_name into outfile '/tmp/jirausers.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' from cwd_user;
this will not include headers
PostgreSQL
copy cwd_user(id, user_name, lower_first_name, lower_last_name) to '/tmp/jirausers.csv' delimiters',' CSV HEADER; this will include the headers.
最終更新日 2013 年 9 月 18 日
関連コンテンツ
- 関連コンテンツがありません
Powered by Confluence and Scroll Viewport.