CSV Importer screen does not list any projects
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
This problem is not reproducible on Jira 8.x.
Problem
If an invalid character (like a line separator) is part of one or more project names, the Jira External Import for CSV will not be able to render the Project List, as seen on the following screenshot:
Steps to Reproduce
To reproduce this issue you will need to create a new project and add an non-ASCII character into it, as per instructions below. An example of an invalid project name that contains a line separator appended to its end:
1
Invalid Character Project
Go to Jira Administration (cog icon).
Click on External System Import and then select the CSV option.
Select a source file and click Next.
Select a project on the Import to Project combo box.
The combo box will show
No Matchesand the following appears in the browser Console:
1
Uncaught Error: AJS.Descriptor: expected property [label] but was undefinedDiagnostics
Run the following query to identify non-ASCII characters on the project names:
1
2
select pname from project where not pname ~ ( '^('||
$$[\09\0A\0D\xA1-\xFF]|$$|| -- ASCII ext')*$' );Alternative diagnostic steps
Run a select on the projects table, to extract the entire list of projects:
1SELECT pname FROM project;Export the results and open using a text editor like TextMate or Sublime.
Look around for any invalid characters. On TextMate these show up on a different color and within _<>_ characters.h3. Work-around
Cause
There is the character <U+2028> on the name of the project. You should be able to check it upon copying/pasting the project nameto a text editor like TextMate or Sublime.
Resolution
Find the projects with invalid characters by running the Diagnostics steps and rename it using the "Edit Project" option in the Project Administration section. No reindex or downtime is needed.
Was this helpful?