Jira Service Management Assets: CSV importer not detecting all entries from a CSV file due to extra double quote(s)
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
After importing objects from a CSV file,
Some rows in a CSV file are not imported into Assets as new objects
Double quotes in some values are missing
Some values have unintended change
Example
Here's a CSV file to create 3 new objects namely ABC, DEF and PQR. Description column is to be mapped with an attribute of type Text area in Assets (Formely Insight).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Name,Description
ABC,"Line 1
Line 2
Line" 3"
DEF,"wqferghr
wqferghr
reg"
PQR,"
Minim eirmod eligendi mei eu. Pri odio elaboraret cu, duo eruditi appetere eu. Vel eius fuisset efficiendi an, id mea iusto latine maiorum. Omnes tantas laoreet ea ius. Usu ""option"" accusam inciderint id.
Cum at nullam numquam, vel utroque meliore repudiandae at."Expected Result
3 entries are detected in the CSV file
3 new objects with its complete description are created as shown below
Actual Result
Only 1 entry is detected in the CSV file
Only 1 object is created with the description that includes the data that should be in the next object
The following appears in the insight_import.log
1
2
3
021-10-25 13:03:27,831 [insight-InsightImportThreadGroup-worker-thread-1] | Row not read on line number (heading row included) 3 due to The number of columns to be processed (1) must match the number of CellProcessors (2): check that the number of CellProcessors you have defined matches the expected number of columns being read/written
2021-10-25 13:03:27,831 [insight-InsightImportThreadGroup-worker-thread-1] | Row not read on line number (heading row included) 4 due to The number of columns to be processed (1) must match the number of CellProcessors (2): check that the number of CellProcessors you have defined matches the expected number of columns being read/written
2021-10-25 13:03:27,831 [insight-InsightImportThreadGroup-worker-thread-1] | Row not read on line number (heading row included) 5 due to The number of columns to be processed (3) must match the number of CellProcessors (2): check that the number of CellProcessors you have defined matches the expected number of columns being read/writtenOr in the backend logs:
1
message: Row not read on line number (heading row included) <Number> due to unexpected end of file while reading quoted column beginning on line <Number> and ending on line <Number>Cause
Multiple lines are allowed for Text area type attribute and the complete value should be placed between 2 double quotes. Any additional double quote(s) will cause data to be created in an unexpected way
Resolution
Make sure that the complete value is placed correctly between 2 double quotes.
To include a delimiter or a double quote character, another pair of double quotes should be used (e.g. Line 13 in the example CSV file below)
The modified CSV file is as follows.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Name,Description
ABC,"Line 1
Line 2
Line 3"
DEF,"wqferghr
wqferghr
reg"
PQR,"
Minim eirmod eligendi mei eu. Pri odio elaboraret cu, duo eruditi appetere eu. Vel eius fuisset efficiendi an, id mea iusto latine maiorum. Omnes tantas laoreet ea ius. Usu ""option"" accusam inciderint id.
Cum at nullam numquam, vel utroque meliore repudiandae at."Was this helpful?