CSV Import Error: Parameter Values Exceeding 100 Characters in Jira

VENUGOPAL KAMAKKAGARI
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2024

Hello Community,

I'm encountering an issue while attempting to import a CSV file converted from an Excel file into Jira. The Excel file contains information about test cases, including details such as testcase name, request, response, etc.

After converting the Excel file to CSV, each time I try to import the CSV file using the CSV import functionality in Jira, I encounter the following error:

"The CSV file contains parameter values with more than 100 characters."

This error prevents the import process from completing successfully. Upon reviewing the CSV file, it seems that some parameter values, such as  request exceed the 100-character limit imposed by the Jira API.

 

I'm using the following endpoint for the import process:

$JIRA_BASE_URL/rest/raven/2.0/api/dataset/import?issueId=$ISSUE_ID&testIssueKey=$ISSUE_KEY

 

I need assistance in understanding how to handle this error and successfully import the CSV file into Jira, even if some parameter values exceed the 100-character limit.

Has anyone else encountered a similar issue when importing CSV files converted from Excel into Jira for test case management? Are there any workarounds or approaches I can try to resolve this error?

Any insights or suggestions would be greatly appreciated.

Thank you!

1 answer

0 votes
Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 5, 2024

Hi @VENUGOPAL KAMAKKAGARI 

Welcome to the community.

You do mention Cloud on the tags, but hte URL is DC related

Are you on DC or Cloud, as the URL you are mentioning is for to make the API call is DC related and not Cloud.

Cloud has a specific URL endpoint for the Xray API And the Cloud API has no dataset import option

See API cloud doc's on Xray; https://docs.getxray.app/display/XRAYCLOUD/REST+API 

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 5, 2024

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events