Import users and groups from CSV files

Before you import users, create a CSV file containing the users you want to add to Adobe Connect. The CSV file you create must include user information in the following format:

first-name,

last-name,

login,

email,

password

Mary,

Betts,

mbetts1@mycompany.com,

mbetts1@mycompany.com,

private1

Robert,

Blatt,

rblatt2@mycompany.com,

rblatt2@mycompany.com,

private1

Ron,

Bloom,

rbloom3@mycompany.com,

rbloom3@mycompany.com,

private1

Charles,

Bond,

cbond4,@mycompany.com,

cbond4@mycompany.com,

private1

Jennifer,

Cau,

jcau5@mycompany.com,

jcau5@mycompany.com,

private1

Here are some additional tips for using CSV files:

  • Because of browser limitations, if you have a large number of users to add, create several smaller CSV files instead of one large CSV file.

  • If the file contains empty lines, the import operation fails.

  • Names that contain a comma must be in quotes. For example, the name John Doe, Jr., must appear in the CSV file as “John Doe, Jr.”.

  • The header format for custom fields is x‑ field‑id (for example, x‑45704960 ). To determine the field ID, in Connect Central, select Administration > Users and Groups > Customize User Profile. Click the field name. In the browser address bar, locate the filter-field-id parameter in the URL. The filter-field-id value is the field‑id . For example, for the custom field Cost Center, filter-field-id=cost-center , and the header format is x-cost-center .

    Note: You can also obtain the field ID from the XML API calls custom-fields or acl-field-list .

  • The user information in the CSV file must take login and password policies into consideration. For example, if an e‑mail address is used as the login name, the login and e‑mail values in the CSV file must be identical. Or, if there are password policies (certain length, format, special characters, and so on) these policies must also be applied in the CSV file.

Create new users

  1. Click the Administration tab at the top of the Connect Central window.
  2. Click Users And Groups and then click Import.
  3. Select Create New Users.
  4. Under the Select File To Import bar, browse to the CSV file you want to import.
  5. Click the Upload button.

    If any errors occur, the first ten errors are displayed in red text. (Errors on duplicate user login/email are not reported.) Make any necessary corrections and reimport the file; then repeat steps in this procedure.

Import users from a non-UTF-8 encoded CSV file

You can import users from a CSV file that isn’t UTF‑8 encoded. When importing a non-UTF‑8 encoded file, append the appropriate encoding parameter to the import URL.

  1. Click the Administration tab at the top of the Connect Central window.
  2. Click Users And Groups and then click Import.
  3. Check the URL in the browser address line. It looks like http://<Connect Server>/admin/administration/user/import.
  4. Click at the end of the URL in the browser address line and add “?encoding=<encode>” to the address. It looks like http://<Connect Server>/admin/administration/user/import?encoding=<encode>. Specific examples include the following:

    • http://<Connect Server>/admin/administration/user/import?encoding=sjis

    • http://<Connect Server>/admin/administration/user/import?encoding=euc_kr

  5. After modifying the URL address, click Enter.
  6. Select Create New Users.
  7. Under the Select File To Import bar, browse to the CSV file you want to import.
  8. Click the Upload button.

    If any errors occur, the first ten errors are displayed in red text. (Errors on duplicate user login/e‑mail are not reported.) Make any necessary corrections and reimport the file.

Import groups from a CSV file

Use the group import option to import groups into the Connect database. After you import the group CSV file, you can assign new users to the groups.

When you create the CSV file, ensure that it is in a format that Adobe Connect can use. The required column headers in the CSV file are name and description. The following is an example of a group CSV file that is adaptable for Connect: 

name, description 
group1, test1 
group2, test2
  1. Click the Administration tab at the top of the Connect Central window.
  2. Click Users And Groups.
  3. Click the Import link above the list.
  4. Under the Select Import Type bar, select the Create New Groups option.
  5. Under the Select File To Import bar, browse to the CSV file that you want to import.
  6. Click the Upload button.

    If any errors occur, the first ten errors are displayed in red text. Make any necessary corrections and reimport the file; then repeat steps 3‑6.

  7. If you assign users to custom groups, set library permissions for the groups. For more information, see Setting permissions for library files and folders .

Import users and add them to a group

Use this option to import new users and add them to a Built-in or previously created group. The Built-in group names appear in the menu for group selection as default groups. After you create a group manually, its name also appears in the menu for group selection. You can use the import option to assign large numbers of users to multiple groups.

You can select only one group for the users you import from one CSV file. Create a different CSV file for each set of users you want to add to a specific group. After you import these users, you can assign these users to additional groups, or assign the whole group to another group.

The following example shows the minimum user information required for the CSV file. You can add other information in the CSV file to prepopulate other user properties. The CSV file you create must include user information in the following format:

first-name,

last-name,

login,

email,

password

Mary,

Betts,

mbetts1@mycompany.com,

mbetts1@mycompany.com,

private1

Robert,

Blatt,

rblatt2@mycompany.com,

rblatt2@mycompany.com,

private1

Ron,

Bloom,

rbloom3@mycompany.com,

rbloom3@mycompany.com,

private1

Charles,

Bond,

cbond4,@mycompany.com,

cbond4@mycompany.com,

private1

Jennifer,

Cau,

jcau5@mycompany.com,

jcau5@mycompany.com,

private1

  1. Click the Administration tab at the top of the Connect Central window.
  2. Click Users And Groups.
  3. Click the Import link above the list of users and groups.
  4. Under the Select Import Type bar, select Create New Users And Add Them To A Group.
  5. Under the Select File To Import bar, browse to the CSV file that you want to import.
  6. Click the Upload button.

    Adobe Connect logs a message if groups in the CSV file exist in Adobe Connect.

  7. Add the new users to a group. For more information, see Add or remove group members .
  8. Set permissions for these users. For more information, see Setting permissions for library files and folders .

Add existing users to a group

  1. Click the Administration tab at the top of the Connect Central window.
  2. Click Users And Groups.
  3. Click the Import link above the list.
  4. Under Select Import Type, click Add existing users to a group.
  5. Select a group from the pop-up menu next to the Add existing users to a group option.
  6. Under the Select File To Import bar, browse to the CSV file that you want to import.
  7. Click the Upload button.

// Ethnio survey code removed