Create work items using the CSV importer
Comma-separated value (CSV) files are text files that represent tabulated data. Most spreadsheet and database systems support CSV files.
The CSV importer lets you import data from external systems that can export tabulated data. You can also create your own CSV file to perform bulk work item creation and updates.
You must have the following to do the things described on this page.
Role: Project admin, App admin
Permission: Create work items, Make bulk changes
Users without administrator permissions can import 250 work items per CSV file. If you're a Jira admin, check out the more advanced configuration.
The bulk work item creation option for CSV imports can't map work items with a parent-child hierarchy relationship (e.g. Initiative to Epic to Story to Subtask).
To map hierarchies, use the CSV external system import instead. Refer to Import data using a CSV file and CSV import parent-child mapping for details.
CSV ファイルを準備する
You can base your CSV file structure on the default Microsoft Excel CSV format. Fields should be separated by commas. Any content that must be treated literally (such as commas, new lines, or carriage returns) should be enclosed in quotes. Microsoft Excel and OpenOffice automatically quote cell values, so you do not need to quote these values manually.
CSV ファイルの要件
CSV files must be well-formed.
Each CSV file must have a header row with a Summary column. The header row is used to map data from the CSV file to fields in your project’s work items.
The header row should not contain punctuation (apart from commas separating columns), or the importer may not work correctly.
Do not omit commas for empty column values.
Valid example:
Summary, Assignee, Reporter, WorkType, Description, Priority
"Test work item", bob@example.com, bob@example.com, Task,Invalid example (missing commas for empty fields):
Summary, Assignee, Reporter, WorkType, Description, Priority
"Test work item", bob@example.com, bob@example.com, 1Structure data in your CSV file
複数行にまたがるデータ
Use double-quote marks (") to capture data that spans multiple lines. For example:
Summary, Description, Status
"Login fails", "This is on
a new line", Open文字通りに扱われる必要がある特殊文字
Use double-quote marks (") around text to treat special characters literally. Once imported, the special characters will be included in the field data. To include a double quote mark, ‘escape’ it with another double quote mark.
例:
"Selecting the ""Add"" button results in a page not found error"Will be stored as:
Selecting the "Add" button results in a page not found error
Aggregating multiple values into a single field
To import multiple values into a field that accepts them (such as Fix Version, Component, or Labels), specify the same column name for each value. The number of column names specified must match the maximum number of values to be aggregated into the mapped field.
例:
WorkType,Summary,FixVersion,FixVersion,FixVersion,Component,Component
bug,"First work item",v1,,,Component1,
bug,"Second work item",v2,,,Component1,Component2
bug,"Third work item",v1,v2,v3,Component1,Here the Component field of the second work item and the Fix Version field of the third work item will generate multiple values in appropriate fields upon import.
Only certain fields support multiple values. The CSV importer will not allow you to import aggregated data into fields that only support a single value.
添付ファイル
You can attach files to work items by specifying the URL in an Attachment column.
例:
Assignee, Summary, Description, Attachment, Comment
bob@example.com, "Work item demonstrating the CSV attachment import", "Please check the attached image below.", "https://jira-server:8080/secure/attachment/image-name.png", "01/01/2012 10:10;Admin; This comment works"
bob@example.com, "CSV attachment import with timestamp,author and filename", "Please check the attached image below.", "01/01/2012 13:10;bob@example.com;image.png;file://image-name.png", "01/01/2012 10:10;Admin; This comment works"Attachment URLs must use HTTP or HTTPS and be in a location that your Jira instance can access.
Import data into multiple projects
You can import work items from your CSV file into different projects through a CSV file import. To do this, add two columns to your CSV file with the "Project name" and "Project key" headings.
Make sure that every work item in your CSV file has a project name and project key in the relevant column. The project name and project key are the minimum project data required for importing work items from a CSV file into specific projects.
In the following example, the first and second work items will be imported into the 'Sample' project (with project key 'SAMP'), while the third work item will be imported into the 'Example' project (with project key 'EXAM'):
WorkType, Summary, Project Name, Project Key
bug, "First work item", Sample, SAMP
bug, "Second work item", Sample, SAMP
task, "Third work item", Example, EXAM作業ログ エントリー
CSV ファイルには作業ログ エントリーを含めることができます。経過時間の追跡には秒を使用します。例:
Summary,Worklog
Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200複数選択のカスタム フィールド
To populate a multi-select custom field with multiple values, use multiple columns with the same header. For example:
Summary,Multi Select,Multi Select,Multi Select
Sample work item,Value 1,Value 2,Value 3カスケード選択カスタム フィールド
次の構文を使用して、カスケード選択カスタム フィールドに値をインポートできます。'->' セパレーターを使用して階層をインポートできます。
Summary, My Cascading Custom Field
Example Summary, Parent Value -> Child ValueSelect list (cascading) custom fields can’t be imported this way. Track the feature suggestion. Instead, Jira administrators can go to Settings (), then System, then External system import.
Run the CSV file import wizard
To import work items from a CSV file:
In the sidebar, select Filters, then select Search work items.
Select More actions (•••), then select Import work items from CSV.
Choose the CSV file you want to import. If you do not have a configuration file, leave Use an existing configuration file unchecked. Configuration files map the column names in your CSV file's header row to fields in Jira, and you can create one after you import.
Select Next and fill in the required information. If your CSV file uses a different separator, specify it in the CSV delimiter field. If the separator is a tab, this can be entered using the format "/t".
Select Next and map the column headers of your CSV file to the fields in your project. You must map a CSV field to the Summary field. To map specific Jira field values to specific CSV values, select Map field value.
Select Next and map specific CSV field values to Jira field values, if needed. (For example, you might want to map the CSV field value “Feature request” to the Jira work type field value "New feature".)
Select Begin import to start importing your CSV data. To check for errors or warnings, select Validate before importing. You can save your configuration for future imports with similar settings.
注意
When mapping field values, leave a field cleared or clear any content within it to import the value as is.
If you have any trouble with the import or want more information about the process, you can download a detailed log.
CSV データを Jira フィールドにインポートするためのヒント
Below are some helpful tips when importing data from your CSV file into specific fields:
フィールド | インポート時の注意 |
|---|---|
Project | CSV データはプロジェクト単位でインポートされます。対象として既存の JIRA プロジェクトを指定できますが、指定しなくても、インポート時にインポーターが自動的に新規プロジェクトを作成します。 |
要約 | これは唯一の必須フィールドです。 |
コンポーネント | You can import work items with multiple components by entering each component in a separate column. |
Affects version(s) | You can import work items with multiple 'Affects Versions' by entering each version in a separate column. |
Fix version(s) | You can import work items with multiple 'Fix Versions' by entering each version in a separate column. |
期限 | CSV インポート ウィザードの 2 番目の手順で指定した日付形式を使用してください。 |
作業タイプ | If not specified in your CSV file, imported work items will be given the default (i.e. first) WorkType, as specified in your Jira instance. More about defining work type field values. インポートの過程で、まとめて新しい値を作成することもできます。 |
ラベル | You can import work items with multiple labels by entering each label in a separate column. |
優先度 | If not specified in your CSV file, imported work items will be given the default (i.e. first) Priority as specified in your Jira instance. インポートの過程で、まとめて新しい値を作成することもできます。 |
初期見積 | このフィールドの値は、秒数で指定する必要があります。 |
残余見積 | このフィールドの値は、秒数で指定する必要があります。 |
消費時間 | このフィールドの値は、秒数で指定する必要があります。 |
ユーザー | ユーザーを作成 ユーザー タイプのすべてのシステム フィールドで、以下をサポートしています。
担当者または報告者フィールドの値として、インポーターに Jira ユーザーを自動で作成させることも可能です。
ユーザーの更新 Portal-only customer data in Jira Service Management behaves differently than other user accounts data. If the portal-only customer data is different in the import and the destination, then we use the destination data. |
必須フィールド | When importing to projects with mandatory fields, you must include the field in the *Create work item* screen associated to the work type being used. More about specifying field behaviors. |
その他のフィールド | その他のフィールドをインポートする場合は、特定の Jira カスタムフィールド へのマッピングを行うことができます。JIRA にカスタムフィールドがまだ存在していない場合、インポーターは自動的にカスタムフィールドを作成します。カスタムフィールが日付フィールドの場合、CSV インポーター ウィザードの 2 番目の手順で指定した日付形式を使用してください。 |
ご不明な点がある、または CSV インポート プロセス中に問題が生じた場合は、アトラシアン サポートにご連絡ください。
この内容はお役に立ちましたか?