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

0 votes
Accepted answer

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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,787 views 18 22
Read article

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