Import organization using Excel

1

Import organization using Excel

Use Excel to import organizations

On the console organization management page, click Import organization - Import from Excel button:

Click to download the Excel template, the Excel template structure is as follows:

The fields are explained as follows:

  • Nickname: User nickname, can be empty, does not have to be unique;

  • Username: User username, can be empty, must be unique;

  • Email: User email, can be empty, and mobile phone number must be filled in one, must be unique;

  • Email verification: Whether the user's email has been verified, fill in "Yes" or "No";

  • Mobile phone number: User's mobile phone number, can be empty, and email must be filled in one, must be unique;

  • Unionid: User's unionid, can be empty, must be unique;

  • Openid: User's openid, optional, must be unique;

  • Password: password in plain text format;

  • Company: company name, optional;

  • Gender: U for unknown, M for "male", W for "female";

  • Disabled: fill in "Yes" or "No";

  • Department: must be sorted in descending order of department, separated by '/', the first part will be used as the root node, such as Feifan Technology/R&D/Backend.

After modifying the template, upload it.

Back to list