• Created by Unknown User (mathias.edblom@riada.se), last updated by Unknown User (joseph.oksenhendler) on Sept 23, 2020 2 minute read

To export objects from an Object Type you click on bulk actions and "Export objects". This will export the objects that you have filtered on. 

Select the export options:


オプション説明
区切り文字

What is the delimiter in the CSV export. Available options are

  • comma ( , ) (default)
  • semicolon ( ; ) 
  • タブ
エンコード

That should be the encoding of the created CSV file. Available options are

  • UTF-8 (default)
  • UTF-16
  • ISO-8859-1
  • ISO-8859-15
  • Windows-1250
  • Windows-1252
形式

This indicates whether the data stored in the CSV file should be Data consistent (unprocessed) or User friendly.

In case you import the data to Insight for data migration or recovery purposes, then Data consistent option will help you to preserve the references and date formats appropriately.

Alternatively, if you use the CSV file with your reporting tool like Power BI or open it in Microsoft Excel/Google Sheets then User friendly option will display the data in a meaningful manner.

Following is a quick reference of what is stored in the CSV file for certain object types in both formats:

User friendly format
属性タイプ                              Stored value                                                                                                                                     
Referenced ObjectLabel of the value
ユーザーThe display name of the user
ステータスName of the value
Date, DateTimeThe value in a format that is set in Jira.
TextareaOnly the plain text value is stored. All the HTML tags in the value will be removed.



Data consistent format
属性タイプ                                           Stored value                                                                                                                                                         
Referenced ObjectThe Key of the value
ユーザーThe account id of the user
ステータスThe Id of the value
Date, DateTimeThe value of the date in ISO-8601 format
TextareaThe entire HTML markup value


An example output from the export could be:

CSV
Key,Name,Email address,Work At,Salary,Address,JIRA User,Personal Docs
DEMO-1,Tommy Nordahl,tommy.nordahl@riada.se,DEMO-10,120000,Ipsum Lorum, Ipsum Lorum, 12345 Stockholm,tnor,234234
DEMO-2,Mathias Edblom,mathias.edblom@riada.se,DEMO-11,100000,Ipsum Lorum, Ipsum Lorum, 12345 Uppsala,medb,234454
DEMO-3,Johan Andersson,johan.andersson@riada.se,DEMO-12,80000,Ipsum Lorum, Ipsum Lorum, 12345 Lund,jand,534345
  • ラベルなし