-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 10.3.0, 11.3.0, 11.3.11, 10.3.25
-
Component/s: Request Type Configuration
-
Severity 3 - Minor
Issue Summary
When importing issues via CSV or JSON using the integrated Jira Importers Plugin (JIM), the "Customer Request Type" (com.atlassian.servicedesk:vp-origin) field fails to accept request types using their display name.
This is a regression of JSDSERVER-1335, which was initially fixed in JSM 5.15.2 (Jira 9.15.2).
Steps to Reproduce
- Install Jira Service Management Data Center.
- Create at least one service project.
- Prepare a CSV import file (Importing data from CSV), targeting that project with a populated "Customer Request Type" column.
- From ⚙️ (gear icon) > System > External system import > CSV, import the test CSV file.
Expected Results
The "Customer Request Type" custom field is correctly mapped, and the request type is set on the imported issue.
Actual Results
The import finished page reports:
1 projects and 1 issues imported successfully!
Cannot add value [ [IT help] ] to CustomField Customer Request Type in Issue with summary 'My laptop is consistently above 90% CPU'. Probably value was in incorrect format
In the imported issue's service project request panel, the "request type" is "no request type".
Workaround
Replace the display name with the internal portal/request type storage format. You can obtain these values for a particular project with this database query:
SELECT p.pname AS project_name, p.pkey AS project_key, vpf."NAME" AS request_type_name, (vp."KEY" || '/' || vpf."KEY") AS request_type_key FROM "AO_54307E_VIEWPORTFORM" vpf JOIN "AO_54307E_VIEWPORT" vp ON vpf."VIEWPORT_ID" = vp."ID" JOIN project p ON vp."PROJECT_ID" = p.id WHERE p.pkey = 'ITHD' ORDER BY project_name, request_type_key;
Replace "ITHD" with the project key. For the example above, the replacement value is: ithd/getithelp
- is a regression of
-
JSDSERVER-1335 Can't import CSV generated from JIRA due to incorrect Customer Request Type format
-
- Closed
-
- links to