Bulk adding, changing, or deleting users from a file

Users can be bulk added, edited, deleted, and inactivated in Sansan by importing CSV files specifying information such as user names and permissions.


Point to be aware of

Adding users

  • When a user is successfully added, a notification will be sent to the user's main email or sub-email address on the first day of use, indicating that the account was created.


Changing user information

  • By importing user information, you can overwrite existing data. No judgment is made to the content of the overwrite. If a blank space is registered in new data the old data will simply be deleted.
  • The administrator will be notified by email when the change is completed, as will any user whose department and/or permissions have changed.


Deleting users

  • When a user is deleted, please be aware that the business cards, contacts, and tags held by that user will also be deleted.
  • When deleting is complete, a notification email will be sent to the system administrator. Deleted users will not be notified.


Inactivating a user

  • To inactivate a user, change the account status to "inactive" and import the user as described in the following.
  • See inactivating a user for more details.
  • When the user inactivation is completed, your system admin and the user will be notified by email.


Common points

  • To use these functions, you must have administrator clearance.
  • The time required for importing is approximately 10 minutes for every 100 entries. Depending on the number of users, this may take some time.
  • When 50 or more users are added at one time, the notification of completion email sent to the system administrator will have a list of these users attached to it.
  • If the import file contains doubles of either user IDs or email addresses, then the import cannot be done. Delete these double entries and try importing again.
  • If you are editing a CSV file in Excel, zeros input at the beginning of numbers will not go in. To import these types of numbers, put a single quotation mark (') at the beginning.(Example ['001])
  • If you already have more than 1000 users registered, it may take several hours for the import to finish.




1. Go to "Admin Settings" at the upper right, then click on "Add/Change User".


2. Click on "Import from File".


3. Download the special format (CSV file) to be used for this. In addition to this, you can also download your current user information and use it as a basis.


4. Create the CSV file.
(1) For adding users, put the users in a new line.
(2) For editing users, change the information you would like to edit.
(3) To delete, put a "1" in the Delete Flag for users to be deleted.
(4) If you change a user ID, add the new user ID to the New User ID column.
*The "New User ID" item is added to the CSV file in a new format, so download the CSV template again to use it. You can also add it to the end of the line of the CSV file you're already using.
(5) To temporarily inactivate a user, enter "inactive" in the account status field. To reactivate them, enter “active”.


5. Choose the file you made and edited.


6. Check the file contents.
The first few rows will be shown. Check for any issues with the file contents or the delimiter. If you do spot any problems, revise the file and re-upload it.

7. When you click on "Start Import", the import will start.


8. After the import is started, the status will become "Preparing for Import".




Q. Can I add users who are working in multiple departments.
A. Yes, you can. For multiple departments, separate them with a semi-colon.

Q. The status "Error found" came up. What should I do?
A. This means there is a mistake in the import file format or in the data entered. Please check the file again.

Q. I accidentally deleted a user. Can I bring him back?
A. Users deleted by reading in from a file cannot be returned to their former state.

Q. The sub email address was overwritten with a blank. Can I bring it back?
A. Users overwritten with blank spaces by reading in a file cannot be restored to their former state. Please edit the user information again. (Sub email addresses and SAML Name ID can be written over with blank spaces. )

Q. One of my colleagues who is seconded to another company uses Sansan. Can I add him with the same email address he uses there?
A. Email addresses being used under other contracts cannot be duplicated. Add the user using a different email address.

131 人中有 30 人觉得有帮助