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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

I need to import users into Jira cloud from a CSV file. Does someone know how it can be done? Edited

I want to move users from Jira server to jira cloud. The users from Jira server have been exported to a csv file and it has the following heading.

"Full name","Username","Login details","Group name","Applications","Directory","Is Active","Email Address","Last Login" 

How do I import this list of users into Jira cloud?

2 answers

0 votes

Hi Anoja,

This will depend on your exact Cloud instance and you will need to provide the files to our Cloud Support Team.

I recommend that you follow the formats exactly as they are listed here:

Importing users from CSV Files - see specifically the two example files under Preparing your files

Submit this as a ticket to our Cloud team, and they will be able to let you know whether or not your instance is eligible for import and they can proceed with those files.

Let us know if you have any questions!

Kind Regards,
Shannon

Thanks Shannon ! Is the Password column mandatory in the csv file? 

@Shannon Spaniol

the link you added had steps to the crowd directory server, not to the cloud site? please provide steps on how to import users into the Jira cloud?

Thanks,

Medhat

Medhat,

This question from 2017 doesn't apply now, but the article's CSV files worked for Server, Data Center, and Cloud.

If you're currently migrating from Server to Cloud, I recommend following our new migration process. If you get stuck or have any issues, we have a migration team that can help you out when you raise a ticket with Atlassian Support (select help with Migration Support).

Let me know if you have any trouble.

Shannon

Dear @Shannon Spaniol 

I have a new cloud implementation and want to know if it's possible to import 500 users from a CSV file instead of creating it one by one? I want to know if Atlassian support can help with that? what are CSV format details? should I sent the CSV to Atlassian support and they import the CSV file into the cloud site?

BR,

Medhat

Medhat,

The Atlassian Support team can certainly help you import your users. smile

To create the user data file, you can do something like this:

\copy (SELECT email_address AS "email", user_name AS "username", display_name AS "displayname" FROM cwd_user) to '/tmp/users.csv' csv header

The format of the user data file should be:

email, username, displayname

To create the groups (memberships) data file:

\copy (SELECT DISTINCT parent_name AS "groupname", child_name AS "username" FROM cwd_membership) to '/tmp/group_memberships.csv' csv header

The format for the groups data file should look like this:

groupname, username

I hope that helps, but if you have any doubts, contact the support team, and we can help walk you through it!

Take care,

Shannon

 


Note to Community members from the future: This information is subject to change depending on our import script. Contact support directly for requests like this so we can verify if anything has changed on our end.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you