nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

anoja sahoo

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?

Accepted answers

All comments

Shannon S

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

anoja sahoo

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

Medhat Ahmed

@Shannon S

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

Shannon S

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

Medhat Ahmed

Dear @Shannon S

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

Shannon S

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.

Trịnh Tùng Anh

I found a work around.

Use the User invitation form.

Step 1: Export list of existing user

Step 2: Copy severals emails that we need since the invitation is limited (I didn't count how many)

Step 3: Unselected all un-wanted product then Invite. We can select the particular group if we want.

In my case, I just want to add bunch of user to newly created Jira service management project which require user need to be added to "jira-servicemanagement-customers-xxxxxx"

After step 3: the users that I need are added to the group. Yay.

Hope Atlassian will not take this away from us (praying)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira