![]() To do this, your CSV file must specify the same column name for each value you wish to aggregate into the mapped Jira field. Fix (for) Version, Affects Version, Component, Labels). ![]() You can import multiple values into a Jira field that accepts multiple values (e.g. Clicking the "Add" button results in a page not found errorĪggregating multiple values into single Jira fields."Clicking the ""Add"" button results in a page not found error" once imported, will be stored in Jira as:.To treat a double quote mark literally, you can 'escape' them with another double quote mark character. Examples of special characters include carriage returns/enter characters (as shown in the example above), commas, etc. Once this data is imported into Jira, these special characters will be stored as part of Jira's field data. Use double-quote marks ( ") around a section of text to treat any special characters in that section literally. For example, upon import, Jira will treat the following as a valid CSV file with a single record: Summary, Description, StatusĪ new line", Open Treating special characters literally Use double-quote marks ( ") in your CSV file to capture data that spans multiple lines. "Test issue", admin, admin, 1 Encapsulating Jira data structure in your CSV file Capturing data that spans multiple lines but this is not valid: Summary, Assignee, Reporter, Issue Type, Description, Priority Commas (as column/field separators) cannot be omittedįor example, this is valid: Summary, Assignee, Reporter, Issue Type, Description, Priority The header row must contain a column for 'Summary' data. The header row should avoid containing any punctuation (apart from the commas separating each column) or the importer may not work correctly. The CSV file import wizard ( below) uses a CSV file's header row to determine how to map data from the CSV file's 2nd row and beyond to fields in Jira. Each CSV file must possess a heading row with a Summary column In addition to being 'well-formed', CSV files have the following requirements. Fields are separated by commas and any content that must be treated literally, such as commas and new lines/'carriage returns' themselves are enclosed in quotes.įor Microsoft Excel and OpenOffice, it is not necessary to quote values in cells as these applications handle this automatically. ![]() The Jira Importers plugin assumes that your CSV file is based off a default Microsoft Excel-styled CSV file.
0 Comments
Leave a Reply. |