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.

3Open the downloaded Excel file.

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

Item

Description

User ID

Enter the user ID. (Required field)

Email Address

Enter the user's email address.

LastName

Enter the user's family name.

First Name

Enter the user's name.

Department

Enter the name of the user's department.

Office Location

Enter the location of the user's office.

Group ID

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

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

Multifunction Printers/Copiers - IC Card

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

Interactive Whiteboard - Device Account

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

Interactive Whiteboard - IC Card

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

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

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.

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

5Save the Excel file after entering the user information.