Migrate user data from Jira hosted to Jira OnDemand, LDAP users

We have our users synchronized from Active Directory, 10 users in total to be exact. I understand that you can't directly import users from Active Directory into Jira OnDemand. Therefore, I'm asking if theres a way we can map existing data to the new users that would be created on Jira OnDemand (the new users would be created identically to the AD users). The reason for this is so that when we start using OnDemand, all of the previous projects/issues should be able to point to the new user accounts that would serve as replacements to the AD sync'd accounts. What would have to be done? Are there any other alternatives?

2 answers

1 accepted

Hi Devon,

The best way to import users from an external source without doing an entire JIRA import (that overwrites everything currently in place) is to create a .CSV file of your users and another of their group memberships. You'll then raise a support ticket at support.atlassian.com and let us know you need to import users and have the .CSV files. We can then import them directly into your ondemand instance.

Please make sure the files are formatted properly:

Users.csv: username, first name, last name, email address, password hash (optional)

Group_membership.csv: username, parent group

Here is some sample sql to pull this infromation from JIRA's crowd/user table (applies to embedded crowd and postgres sql, just an example):

copy (SELECT user_name AS username, first_name AS first, last_name AS last, email_address AS mail, credential AS password_hash FROM cwd_user) to '/tmp/users.csv' csv header;

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

Of course if this doesn't work for you you can manually create the csv files and provide them to us



Hello Everyone,

I just wanted to double check this was still a valid option?  We have a team using the server version but moving to On-Demand. We would like to migrate users but they are hooked up to AD, but the user migration utilities are not available since it is not delegated LDAP.  We would like to ensure users, groups, and user data is in all migrated appropriately to the cloud.



Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,811 views 11 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot