CSV インポート
You can import data from a CSV file. This import method useful if you're still using spreadsheets or maintain your assets in CSV files. More about importing
インポートを作成、設定、有効化するには、ユーザーがオブジェクト スキーマのアセット マネージャーである必要があります。
次のセクションにジャンプ:
はじめる前に
Here are some additional details that you might need to know to import a CSV file:
Make sure you have an object structure already defined. If not, check out our Assets tutorial.
The CSV file needs to have headers, as they're used to create the data locators for the imports.
To divide multiple values, for the Assets Attributes with multiple cardinality, use
||(two pipe characters).
CSV データのフォーマット
If there's a syntax error in your CSV data file, your import might produce unexpected results or not run. Make sure to follow the formatting rules:
You can use any of the following formats: UTF-8 (default), UTF-16, ISO-8859-1, ISO-8859-15, Windows-1250, or Windows 1252.
The CSV file must include a single-character delimiter. The default delimiter is the comma
,. You can select a custom delimiter in the Delimiter field when you create an import configuration. To include a delimiter character, use a single character input. You can also enter\tto use a tab-delimiter.If you're importing Jira users, you must identify them by their Names, Emails, or User keys.
If you're importing Jira groups, you must identify them by their Names only.
If you're importing URLs, they must begin with a protocol, such as
http,https,ftp, orfilefollowed by://to be converted into the URL attribute type. If you don’t include the protocol, the value won’t be imported. Explore attribute typesIf you're importing CSV data from a Google Sheets link, edit the URL so it works properly. Remove
/edit#gid=0from the ending of the URL and replace it with/export?format=csv.
CSV ファイルのインポート
For testing purposes, you can use the following CSV file sample. This file includes the information about employees: name, employment start and end date, role, name that Jira uses to display them, and the assigned office location.
Name,Employment start date,Employment End date,Role,Jira User,Office
John Doe,2019-06-15,2023-04-30,Project Manager,John Doe,New York
Jane Smith,2021-03-01,,Developer,Jane Smith,London
Emily Johnson,2018-09-10,2022-12-31,Designer,Emily Johnson,Sydney
Michael Brown,2020-01-20,,QA Tester,Michael Brown,San Francisco
Emma Wilson,2017-11-05,,HR Specialist,Emma Wilson,Berlin
James Davis,2022-01-01,,Data Analyst,James Davis,Tokyo
Olivia Martinez,2016-07-25,2021-08-15,Marketing Coordinator,Olivia Martinez,Toronto
Liam Garcia,2019-11-18,,Sales Executive,Liam Garcia,Singapore
Sophia Lee,2023-05-01,,Customer Success Manager,Sophia Lee,DublinAfter importing and configuring the file, you should see the imported objects (employees, in this case) and objects' values (employee data). This will result in a configuration like this for a single object:
From your service project, go to Assets, then Object Schemas.
From the Object Schemas list, select More actions and then select Configure.
In the Schema configuration view, open the Import tab.
Under the Import tab:
If there’s no import structure, you’ll see the message “You don't have any import connections yet”. Select Create Import configuration to create a new import structure.
If an import structure has already been created, select Create Configuration.
Select CSV import, then select Next.
Fill in the General, Module, and Scheduling import fields.
7. Select Save Import Configuration.
Next, can create a predefined structure and configuration for your import.
事前定義済みの構造と設定
Create predefined structure – this will create object types with attributes and relationships in the schema
Create predefined configuration – this will create type mappings in the import configuration.
After you select Create predefined configuration, Assets will create configurations and mapping from the fields in the CSV file to the attributes in the object type. As these are created based on the default rules, you might need to review the mappings and make necessary changes. For the CSV import:
CSV ファイルの各列は既定のテキスト タイプのアセット属性として作成され、設定はそれに応じてマッピングされます。
作成されるオブジェクト タイプは常に同じです。
初期設定では、一部のオブジェクト タイプ マッピングが無効になっています。必ず関連するものを選択してください。
CSV ファイルからインポートしたデータで異なる属性タイプを作成する場合は、定義済みの構造を作成してから属性タイプを変更します。
作成されたインポート設定
これでインポート設定を表示できるようになりましたが、まだ準備が完了していません。引き続き、オブジェクト タイプと属性のマッピングを作成または確認して、インポート設定に問題がないことを確実にする必要があります。
When you're ready, go to 2. Create object type and attribute mapping.
最後に一言
オブジェクト タイプ マッピングの設定
次のステップでは、オブジェクト マッピングの設定を作成します。CSV インポート タイプに固有の設定をいくつか紹介します。
名前 | 説明 |
|---|---|
| セレクター | CSV インポートのセレクターは使用されません。AQL によって 任意のデータを CSV ファイルから絞り込みます。 |
| Confluence | For Confluence type attribute, the expected value is in the format of page ID instead of page title. |
既知の制限事項
The
textAreaattribute has a hyperlink option. However, this can't be used in the CSV import.For the
textAreaattribute, the value should be enclosed in the wrapper element, such as<div class="created-with-ak-editor content-wrapper"><p></p>. If the wrapper element isn’t present in the source, every sync will rewrite it, adding the wrapper each time and creating a new history event.