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

Question

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?

cbenard1 · 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

Thanks

Turner