Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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

Create a CSV file using Text Editor

  1. 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:

  2. Save the file with extension .csv

...

Create TSV file using Text Editor

  1. 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:

  2. Save the file with extension .tsv

...

Create a CSV/TSV file using Excel

  1. Open an Excel sheet and enter the data.

  2. To save the spreadsheet as CSV, select File → Save As and select CSV (Comma delimited) as the type.

  3. To save the spreadsheet as TSV, select File → Save As and select Text (Tab delimited) as the type.

  4. 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

...

userOrGroupId

Remove users or groups from Team Security using a CSV file.

String

For users:

userOrGroupId|false

For Groups:

userOrGroupId|true

Learn how to create your own CSV/TSV files with a Text Editor or Excel.