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

Thanks

Turner

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.

Thanks,

Marc

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

187 views 1 17
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