Search

User Guide

Creating an Import File Using a File Format

You can collectively register users by using an Excel file.

To prepare for batch user registration, download the appropriate Excel file from User Management on this site, and then enter the user information.

Important

  • Up to 150,000 users can be imported at once.

  • The maximum import file size is 30 MB.

  • The downloaded import file will not import correctly if you edit the first row (comment row) or second row (key information row).

1Click the Icon illustration(Menu button) - [Import (File created from format)].

2[Click here to download the import file format] to download the file.

In addition to the Excel file you downloaded in this procedure, you can also use an exported Excel file.

3Open the downloaded Excel file.

4Delete the sample data from the third row onwards and enter data fields for each user.

When you specify items that are not included in the Excel file, such as a PIN, manually add rows for items you want to specify, and then specify the key information in the second row and values for each user from the third row onwards.

Item

Key information name

Description

User ID

userId

Enter the user ID. (Required field)

Email Address

nextLoginMailAddress

Enter the user's email address.

Last Name

familyName

Enter the user's last name.

First Name

givenName

Enter the user's first name.

Department

department

Enter the name of the user's department.

Office Location

location

Enter the location of the user's office.

Group ID

groups.groupId

Enter the group ID.

To specify multiple groups to which the user belongs, add a column to the right for each group.

Multifunction Printers/Copiers - Device Account

onpremiseAccounts.id
(type=mfp_address_book,deviceType=RicohMfp)

To link with authentication information for the multifunction printers/copiers, enter the account ID of the multifunction printers/copiers.

Multifunction Printers/Copiers - IC Card 1 to 3

onpremiseAccounts.id
(type=card,deviceType=RicohMfp,index=1 ~ 3)

If you want to use the IC card when logging in to the multifunction printers/copiers, enter the ID here.

Multifunction Printers/Copiers - IC Card 1 to 3 - Description

onpremiseAccounts.description
(type=card,deviceType=RicohMfp,index=1 ~ 3)

Enter a description for the IC card.

Interactive Whiteboard - Device Account

onpremiseAccounts.id
(type=address_book,deviceType=RicohIwb)

To link with authentication information for RICOH Interactive Whiteboard, enter an account ID for RICOH Interactive Whiteboard.

Interactive Whiteboard - IC Card

onpremiseAccounts.id
(type=card,deviceType=RicohIwb)

If you want to use the IC card when logging in to Interactive Whiteboard, enter the ID here.

Operation

operation

  • Enter "Add" to add a user.

  • Enter "Edit" to edit the registered user information.

  • When the registered user ID and the Excel file user ID match, the entries in the Excel file other than the user ID will be overwritten.

  • Enter "Delete" to delete the registered user.

User Optional Information 1 to 15

extensionAttributes.extensionAttribute1
~ extensionAttributes.extensionAttribute15

Enter optional user information that can be specified by the administrator.

Note

  • For import, no item name can be changed.

  • For an item written into a format file, its initial name is used as-is, even if the item name is changed on this site.

PIN

userCode

Enter the PIN for a user.

  • The PIN is not included in the format, so if you want to configure it, manually add the key information and data you want to import.

  • To delete the PIN, enter "DEL".

  • If you do not want to update the PIN, enter "NC".

  • When you add a PIN column, be sure to enter the data. If you leave the key information name blank, an error occurs when you import the data.

Note

  • When any of the items in "Operation" is blank, "Add" takes place.

  • When "Operation" is "Add" or "Edit", the following items must be entered.

    • User ID

    • Email Address

    • Last Name

    • First Name

  • When "Operation" is "Delete", the following item must be entered.

    • User ID

  • For details about the number of characters and character types that are available for each item, see Specifiable Characters

5Save the Excel file after entering the user information.