Allows users to remove users from M365 using CSV job upload.
Columns | Description | Supported Values |
Type | Specify if adding as a user | String : User |
FirstName | Enter the user first name | String |
LastName | Enter the user last name | String |
MiddleName | Enter the user middle name | String |
PrimaryEmail | The email address of the user | String. Needs to contain proper Email formatting, example: *****@***.com |
SecondaryEmail | Any secondary email. User defined | String. Needs to contain proper Email formatting, example: *****@***.com |
CreateInOffice365 | Add users to Office 365 | String, set to y = Action performed |
UserID | Add user ID to login | String. E.g. a.marcus - One of the required fields for user creation. |
DisplayName | Adds the full name (display name) of the user. | String. E.g. Alexey Marcus. - One of the required fields for user creation. |
Description | User Description | String |
mailNickname | Adds the email (nickname) of the user | String Typically same as username E.g. alexey.marcus - One of the required fields for user creation. Optional for Microsoft teams creation. |
IsExternal | Sets up external users/groups | Boolean. true or false. Is not case sensitive. |
Groups | Specify group name | String : gracy1089883 |
isDelete | Specify value for delete operation | Integer: 1 |
Create a CSV file using Text Editor
Open any text editor and enter the data, separating each value with a comma and each row with a new line, as shown in the illustration below:
Save the file with extension .csv
...
Samples
...
CSV
...
Description
| View file | ||
|---|---|---|
|
...
This CSV will recreate deleting and removing a user from User & Groups.
Create TSV file using Text Editor
Open any text editor and enter the data, separating each value with a tab and each row with a new line, as shown in the illustration below:
Save the file with extension .tsv
...
Create a CSV/TSV file using Excel
Open an Excel sheet and enter the data.
To save the spreadsheet as CSV, select File → Save As and select CSV (Comma delimited) as the type.
To save the spreadsheet as TSV, select File → Save As and select Text (Tab delimited) as the type.
Excel will display a dialog box indicating some Excel features may be lost in the format chosen. Click on Yes to continue to save the file in CSV/TSV format.
...
| Info |
|---|
Tip: A text editor like Notepad can suffice for creating and editing simple CSV files. However, if you are working with large data, using an application like Excel is preferable. |
Note: If you plan to set workspaces with no templates in the Workspace Wizard or CSV Import, you will need to setup a metadata field for NoTemplate in CAM.
This format would be:
...
Metadata name= NoTemplate
...
Type= boolean
...
Learn how to create your own CSV/TSV files with a Text Editor or Excel.