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.

...

(blue star) 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.

(blue star) 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.