Versions Compared

Old Version 15

changes.mady.by.user René Ponce Carrillo (Deactivated)

Saved on

compared with

New Version 16

changes.mady.by.user René Ponce Carrillo (Deactivated)

Saved on

Key

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

Allows users to create or update a matter through a CSV file.

Columns

Description

Supported Values

ClientId

Enter the client ID. Required paramter.

String

MatterId

Enter the matter ID. Required paramter.

String

ClientName

Enter the client name. Required paramter.

String

MatterName

Enter the matter name. Required paramter.

String

RefileDocsAndFolders

Set to update Metadata to Docs and Folder also. Required paramter.

Number 1| 0.

1=Update Metadata to Docs and Folders

RefileFolders

Refiles just the folder with a metadata update. Required paramter.

Number 1| 0.

1=Update Metadata to Folders

createinimanage

CreateInImanage

Updates the workspace in iManage

Number 1| 0.

1= Update in imanage

Note: This is a required parameter if working with iManage.

CreateInNetDocs

Updates the workspace in iManage

Number 1| 0.

1= Update in imanage

Workspace

Note: This is a required parameter if working with NetDocuments.

Workspacename

Enter the name of the workspace. Required parameter.

String

Security

This column assigns user/group access level.

 E.g. bob.bradely@demofirm.com|true#23/12/2019*Admin$false

Info

Note: Dates are based on your system setting found here: Admin->Settings.

 

 Group: Partners|true#11/3/2021*Editor$true

  •  If multiple entries are included in this column, separate each entry by a comma and save the file as tab delimited. CAM will recognise a tab-delimited file when uploading as a CSV file in the Jobs tab.

String.

The format for the security column:

[useremail]  |  {allow or deny=true or false]  #  [expiration date]  *  [role]  $  [isGroup=true or false]

 

CAM also supports the following parameter setting for the matter/user/group security:

@MatterTeam@/@userid@/@groupid@

Template

Enter the name of the template to be used. Optional parameter.

String

Server

Enter the server name. Required when working with iManage.

String

copysecurity

Updates the security. Optional parameter

Number 1| 0.

1= Copy the security

Sample CSVs

File

Description

View file
nameCreate Workspace.csv

Create a workspace in iManage

View file
nameimanageRefile.csv

Update a matter in iManage with Refiling Documents and Folders and copying security.

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.

...