CSV Upload - Vertical Separator not acknowledged

Question

Hi, i am trying to load new Stories to a Project, but the vertical seperator is not recognized. All 10 columns are realized only in one, instead of getting pulled into 10 seperate fields.
In the screen "Map Fields" all line content from the CSV is shown in the first csv column target only - all other 9 remain empty, and so the load fails due to missing type, summary,...
How to overcome this problem? I tried using different separators, I created one manual Story in Jira, downloaded CSv with "|", used it as blueprint for the file but still no chance.

Thanks for help

michael Wardin · Answer

I just found this out: when taking out the column description it is perfectly identifying all columns. So it seems there is something wrong with the textfield for the description. Although it is downloaded from tasks in Jira (the * are bullet points in Jira, and the hyperlink is actually only displayed with the word "link")

So how do I import a nice looking description with bullet points and line breaks?

michael Wardin · Answer

@Trudy P Claspill here is the example from the CSV:
Work Package|Summary|Description|Start date|Issue Type|Component/s|Priority|Due Date|Assignee
R22.1-D-001|Prototype Demo and fit-to-template gaps|* Workstreams to demonstrate in an end to end mode
* The baseline are selective 1.5 integration test cases
* Additional functional review to be performed if requested and required
* Determine any fit to template concerns
* Create change request for any new processes required and receive GPO approval
* Update process master list where required and add request to Jira
* Findingslist 
* Process Master List Template: [link|https://trw1.sharepoint.com/:x:/r/sites/site712/Library BTP Core Platform/ZF ERP Template-Interactions/Process Master List/Process Master List - BPN/Process Master List - BPN.xlsx?d=waad3726d560945c8b2f610ea97c044b9&csf=1]|01/Sep/21|Story|X-domain|Major|31/Dec/21|BrengmaP

Thanks for looking

Trudy P Claspill · Answer

There is no option to upload files in these user community posts. You would need to just type in a small sample of your data. If you post something here, I'll let you know if I see if any problems.

I work with Jira Cloud, and the vertical separator option works for me. I don't have access to a Jira Server/Data Center instance for testing, though.