• 製品
  • 使用を開始する
  • 関連ドキュメント
  • リソース

データ マネージャー - フラット ファイル アダプター

Assets Data Manager for Jira Service Management Cloud is currently rolling out in Open Beta and will be available to all Premium + Enterprise sites by end of October 2024.

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.

    データにスペースを含む文字列値が含まれている場合は、修飾子を使用して 1 つの文字列として指定できます。たとえば、「Microsoft Windows」は設定によってはエラーを返すことがありますが、値「"Microsoft Windows"」はエラーを返しません。 データ ソースで修飾子が使用されている場合は、新しいジョブを作成する際にデータで使用されるその修飾子を含めることが重要です。

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"

 

 

さらにヘルプが必要ですか?

アトラシアン コミュニティをご利用ください。