Batch registration of user and group information

User information, group information, and user group affiliation information are registered by reading the information file (.csv).

Note that you must have system administrator privileges to use batch registration.

Import user and group information

1. Open the 'User Management' tab or 'Group Management' tab in "Manage" screen.
2. Click the 'Import' button.

Tip

The same button is available on both the 'User Management' tab and the 'Group Management' tab.

3. Configure import settings in the 'Import user group information' dialog.

[1] File name

Select the information file (.csv) to import.

Tip

Registration of items for which no file is selected will not be performed.

[2] Replacement (Initial Setting: Not checked)

It is registered after deleting the registered information.

Attention

• Deleted data cannot be recovered. When checking 'Replacement', make sure that the data can be deleted.
• Note the following points when registering user information.
  • You cannot create users exceeding the number of licensed users. The maximum number of users that can be created is limited by the number of 'Total users' of registered CELF license.

    Note that users who only use the Web apps (CELF BrowserAccess) and users who are temporarily suspended are not counted towards this limit.
  • For information on how to check the number of licensed users, please refer to Check the license.
  • If the user ID is duplicated in the data file to be imported, an error will occur.
  • If the user ID already registered is included in the data file to be imported, the information is updated with the contents of the data file.

    In particular, if you set a password for the registered user ID, the password is changed. Leave this field blank to use the current password.
  • Information about the logged-in user cannot be updated. An error occurs if the ID of the logged-in user is included in the data file to be imported.
  • Even if 'Replacement' is checked, the login user is not deleted.
  • Even if 'Replacement' is checked, the two-factor authentication information of logged-in users and users contained in the data file to be imported will not be deleted.

    Even after replacing the data, you can still perform two-factor authentication with the one-time password of the account registered on your smartphone.
  • Even if 'Replacement' is checked, In addition to user information, the following related information is also deleted:
    • User group affiliation information
• Note the following points when registering group information.

  • If the group ID is duplicated in the data file to be imported, an error will occur.

  • If the group ID already registered is included in the data file to be imported, the information is updated with the contents of the data file.
  • Even if 'Replacement' is checked, In addition to group information, the following related information is also deleted:
    • User group affiliation information, table authority information, database connection destination authority information, App editing permission information, application public group information

Hint

The information file to be imported can be created in Export user and group information or in the following format:

1. User information

• Header row: id,name, password, administrator?, app-developer?, db-admin?, celf-app-user?, web-app-user?, ai-user?, suspended?, private-developer?, two-fa-exclusion?

Field	Contents	Mandatory Field
id	User ID	○
name	User Name	○
password	Password	○(Only for new registration)
administrator?	System administrator: 1, others: 0
app-developer?	Application author: 1, others: 0
db-admin?	Database administrator: 1, others: 0
celf-app-user?	CELF App user: 1, others: 0
web-app-user?	Web apps user: 1, others: 0
ai-user?	AI user: 1, others: 0
suspended?	Lock the account: 1, others: 0
private-developer?	User who is only allowed for private publication(publish app to himself/herself): 1, others: 0
two-fa-exclusion?	User who exclude two-factor authentication 1, others 0

'password' can be omitted if the user ID is already registered.In the case of new registration or changing the password of a registered user, the password must be set along with the policy (structured character). Regarding the password policy, refer Register User, or Set Password Policy .

Also, note the following points.

• In order for you to enable private-developer?, administrator? or app-developer? needs to be 1. If administrator? or app-developer? is not 1, the value of private-developer? will be treated as 0.
• In order to enable two-fa-exclusion?, the system administrator must set the two-factor authentication settings to 'Available' or 'Forced use'.

2. Group information

• Header Row: id,name

Field	Contents	Mandatory Field
id	User ID	○
name	User Name	○

3. User group affiliation information

• Header Row: group-id,user-id

Field	Contents	Mandatory Field
group-id	Group ID	○
user-id	User ID	○

If you want to register multiple users in a group, enter multiple lines with the same group ID.

ex.)

group1,user1

group1,user2

group1,user3

An error will occur if a group ID or user ID that is not registered is specified.

4. Click 'Register' button.

Important

You need the system administrator authority to import user and group information.

Related keywords

account, user, group, affiliation, read, load, format, comma, separator, delimiter