Importing CSV file with 1 record gives Not Valid Issue error

[Bert Verleg]

With the correct specifications for CSV imports, I tested one record for importing an issue.

Here is the CSV file:

Nummer;App;Issue Type;Summary;Extra informatie;Oplossing - Resultaat;Reporter
258272300;GIDSO;Improvement;Bijzondere status;x;;151449

The error in the logging is as follows:

2019-09-30 14:41:49,201 INFO - Importer started!
2019-09-30 14:41:49,202 INFO - Engine is running in Validation-only mode
2019-09-30 14:41:49,203 INFO - All issues will be imported to project: FuBeMO (FUBEMO)
2019-09-30 14:41:49,203 INFO - Creating issue: [externalId='72753', summary='Herziening autorisatiematrix']
2019-09-30 14:41:49,203 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Story]
2019-09-30 14:41:49,206 ERROR - Issue can't be created due to the error/s [ Value  is not a valid issue ]
2019-09-30 14:41:49,207 INFO - Creating issue: [externalId='72744', summary='Contract management beheer opzetten + additioneel onderhoud opstarten']
2019-09-30 14:41:49,207 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Story]
2019-09-30 14:41:49,209 ERROR - Issue can't be created due to the error/s [ Value  is not a valid issue ]

What is wrong in the CSV file?

[Nic Brough -Adaptavist- · Accepted solution]

It's hard to tell, but it looks like your CSV is not right, and is not what you've shown us here.  The importer is trying to import two issues, not one, which implies your CSV has three lines (header and two records), and the summaries it is seeing are not what you have shown us.

The CSV it is reading also seems to be mapped to include issue links, and the CSV contains references to issues that do not exist.