Get started with Jira Service Management for admins
Your first stop for learning how to get started with Jira Service Management.
Data Manager - Flat File Adapter
Assets Data Manager for Jira Service Management Cloud is a Premium and Enterprise only feature that is currently in Open Beta development. View and vote on our list of upcoming features.
If you find a bug or have questions, please reach out to Atlassian Support or the Atlassian Community.
This task requires Data Manager Adapters admin permissions to complete. See how permissions and roles work in Data Manager.
The Flat File Adapter is a general adapter for importing data from a CSV or TXT file into Assets Data Manager. To configure and use the Flat File Adapter, you need to create a Flat File job.
How to create and configure a Flat File job.
Formatting a CSV file for Assets Data Manager
To ensure that Assets Data Manager can understand your data, you must follow some basic standards in formatting. ou must specify the standards you have followed when you create and configure your job in Adapters.
Formats - you can use any of the following formats:
UTF-8 (default)
UTF-16
ISO-8859-1
ISO-8859-15
Windows-1250
Windows 1252.
Header - the CSV file must have a header to be read correctly.
Delimiter - the CSV file must include a single-character Delimiter.
Dividing multiple values - you can use “||” (2 pipe characters) within the CSV file. This is useful for the Assets attributes with multiple cardinalities.
Qualifier - A Qualifier is a unicode character that is wrapped around a section of text that includes spaces. This character tells Data Manager that this section of text is a single value and not multiple values.
When the data includes string values with spaces, a qualifier may be used to demarcate a single string. For example: Microsoft Windows may return an error in some configurations, but the value "Microsoft Windows" will not. If a qualifier is used in the data source, it is important to include the qualifier that is used in the data when you Create a new job.
Here’s some sample CSV data that contains information about three business services. Note that a Qualifier is used where the string includes a space:
1
2
3
4
"Name", "Owner", "Service Category", "Hosts"
"Confluence", "Ellen McDonald", "Finance", "Oracle-E-Business-Server"
"Email Service", "Bea Owenstein", "Infrastructure", "http://exchange.prod.main1"
"Partner portal", "Les Weinen", Marketing", "http://mysql.prod.app7"
Was this helpful?
Still need help?
The Atlassian Community is here for you.