...
Archive Team- User can archive M365 team using CSV job upload.
Restore archive Team - User can restore same archive team using CSV job upload.
Columns | Description | Supported Values |
|---|---|---|
Office365Group | Name of Office 365 Group | String- Team Name to archive/restore, is required. |
Job | Set the Job name | String - To Archive : archive team To Restore : restore team |
CreateInOffice365 | To apply in Office 365 | Set to 1 |
NonUniqueIdJob | Specify any random value in case don't want to add client/matter or unique columns | String |
userOrGroupId | Remove users or groups from Team Security using a CSV file. | String For users: userOrGroupId|false For Groups: userOrGroupId|true |
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
...
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.