Ask a Question

Unable to add owner field when imported test case via .csv file

SOLVED
madhupriya
Occasional Contributor

Unable to add owner field when imported test case via .csv file

What is the format to add owner name in the field. I get the following warning message saying 

 

 

  • Cannot add value Madhu Pishke to field Owner - Invalid user value. User fields should match the key of an existing Jira user. E.g. "john.doe".

 

What is the correct format to do so?

 

madhupriya_0-1663928675408.png

 

9 REPLIES 9
MisterB
Community Hero

Does this user have permissions to the project in Zephyr Scale?  E.g. go to Project Settings > People > and search/add user there

 

Connect with me on LinkedIn: https://www.linkedin.com/in/andrew-barbet-548a234/
madhupriya
Occasional Contributor

Yes . Here is the snapshot

madhupriya_0-1664193834429.png

 

madhupriya
Occasional Contributor

Hi, 

 

Thank you for your response. 

I would like to add test cases via .csv file, in that I have added a column for owner field as well. When I upload the file and match all the columns data. Owner field is not getting updated.

madhupriya
Occasional Contributor

I don't think it's something related to permissions issue because it's the basic test case file upload via .csv . Anyone who can create test cases will be able to do so. 

mohana
Occasional Contributor

When I created a test cases manually.in scale, I notice owner name was having a "." between. eg. Madhu Pishke would be Madhu.Pishke

MisterB
Community Hero

Hi.  I've come across this issue since last posting.  I think you have to use the hex(?) value of the user ID (not the username that's displayed).  The way I currently find that value is to create a Jira issue, assign the user I want to import as the reporter or assignee, then use the "Export to XML" function (which opens a new tab) and find the username and corresponding user value.  I then record the userIDs into a table in the Jira issue so that I have a record for the future if needed...

 

MisterB_0-1667218201871.png

 

 

Connect with me on LinkedIn: https://www.linkedin.com/in/andrew-barbet-548a234/
madhupriya
Occasional Contributor

Hi, 

Thank you for the response.

I got solution for this via REST API , GET call.

In fact, to comply with Jira and GDPR changes with Jira Server, the owner field and fields such as Executed by and others, are automatically converted to JIRAUSER<NNNNN> to anonymize user keys and usernames, read more about Jira GDPR changes from here.

Knowing this information, in Zephyr Scale, when importing a file, user would need to use the value JIRAUSER<NNNNN> in the Owner field, instead of using the username(s) for example. And this is also applied when exporting data from the UI or fetching data via the REST API as well.

 

Or simply by making a call/request against a user to find the corresponding Jira Key.

MisterB
Community Hero

Thanks for sharing with the community 🙂

Connect with me on LinkedIn: https://www.linkedin.com/in/andrew-barbet-548a234/
madhupriya
Occasional Contributor

Thank you Mister B.

 

Madhu.

cancel
Showing results for 
Search instead for 
Did you mean: