Versions Compared

Key

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

...

Allows users to perform following operations CSV -

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

...

📌 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

  • Value= 1 if you want to set no template. 0 if you want a template set.or Restore

    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.