Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,730
Community Members
 
Community Events
176
Community Groups

Import a attribute Jira User into a Insight ObjectType

Hi,
I have an Object Type with the Jira User attribute. Now I want to do a csv import, but both the name and email address in the Jira User column get the error "Validation failed for attribute: jira user. Reason: Invalid value provided." What value should I use in the csv to import Jira User?

Regards, Groeten, Marco

4 answers

Not having much luck with this either.  I've tried importing users as first last, email address, as well as Jira's internal user ID.

 

The object attribute I have set is a user object.  If I set the attribute to be a default text field, it imports fine.  But it is obviously just a text field then and can't be used for anything (like being pulled into an Approver field!!)

Worst case, I'll spend an hour going through and manually adding a bunch of users.  uggh, that's no fun.

no fun at all 

I found that if you export the assets from the schema and choose the data consistent format, you will see how Insight looks at that field. For instance, I have an attribute set up as "User" and tied to all users in my instance, however, I can't use their proper name (First Last) or their email address. It appears that I would have to know their internal user ID to do an import, and I'm hoping someone else has solved for this so that I don't have to do this... 

I learned the same today. Lack of functionality. However you can import all Jira users to CSV from Jira's user management and that file has internal user IDs. After that you need to play with the excell and map the Ids to the users.

I was able to get this to work.

As @Arto Kovalainen mentioned above, I had to export all Jira users to a csv, which contained the jira internal user IDs.  Then I had to use XLOOKUP in Excel to line up the user IDs with the email addressed that I already had in my csv.

 

Once I had the IDs, I was able to go through the import successfully.

Only thing that worked for me in a similar case is to use user's unique identifier in the import source file column (e.g. 54cd23de234ed23).

You can get unique identifier by searching for the user in People > Search > click on the found user - unique ID will be in the URL.

Hi Marco,

Did you manage to find out how to import Assets via csv with Jira Users assigned?

I haven't been able to find any information on how to do this.

I'm also trying to find information on this process, and what format I need to enter the jira user names into the csv, to avoid validation error when importing the csv.

Suggest an answer

Log in or Sign up to answer