Migrating from OnDemand to a Crowd installed site

You can extract your user data from a Confluence or Jira application installed site instance. Use these queries to export your users and memberships to CSV, and then import them into Crowd.

Migrate Jira Cloud or Confluence Cloud

First you'll need to migrate Jira/Confluence Cloud to your server versions:

Confluence Cloud から Data Center への移行

Jira Cloud から Server アプリケーションに移行する

Exporting user data

If you are using Postgres as your database with Jira or Confluence, you can generate the required CSV files from either of those systems, with the following queries. If you are using a different database, you may need to tweak these.

To generate users.csv
// Run on JIRA/Confluence
copy (SELECT user_name AS "Username", first_name AS "First Name", last_name AS "Last Name", email_address AS "Email Address", credential AS "Password" FROM cwd_user) to '/tmp/users.csv' csv header;
To generate group_memberships.csv
// Run on JIRA/Confluence
copy (SELECT DISTINCT child_name AS "Username", parent_name AS "Groupname" FROM cwd_membership) to '/tmp/group_memberships.csv' csv header;

特殊文字またはアクセントつき文字を含むユーザー データに対する互換性を確保するため、CSV ファイルが UTF-8 (ユニコード)でエンコードされていることを確認します。


The files will be generated in /tmp, or in the folder specified in the query above.



  • ユーザー アカウント
  • グループ
  • Memberships

Importing the data into Crowd

  1. Follow the instructions in Importing Users from CSV Files
  2. Connect Crowd to your applications: Adding an Application
  3. Ensure that the Crowd Directory is placed above the Internal Directory in your User Directories in all downstream applications: Configuring User Directories. This is important because you will have the same users in both directories, and the users will authenticate against the highest directory in the hierarchy.
最終更新日 2024 年 4 月 15 日


Powered by Confluence and Scroll Viewport.