• 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:


OptionDescription
Delimiter

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

  • comma ( , ) (default)
  • semicolon ( ; ) 
  • tab
Encoding

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
Format

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
Attribute type                              Stored value                                                                                                                                     
Referenced ObjectLabel of the value
UserThe display name of the user
StatusName 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
Attribute type                                           Stored value                                                                                                                                                         
Referenced ObjectThe Key of the value
UserThe account id of the user
StatusThe 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
  • No labels