iManage SPM Policy
Allows users to set the iManage SPM policy through CSV.
A Dot character (.) in your execution, is treated as a separator. Don’t use it unless you intend on separating entries.
A pipe | symbol is used to separate two values in a column. It cannot be used as a separator like for example, separating client and matter by doing client|matter is not supported.
ClientId and MatterId were limited to 20 characters in the SPM API. Your job will fail with Max Limit Increased Error.
Parameters
Columns | Description | Supported Values |
---|---|---|
synctag | Sets the SPM tag. | Required; String= SPM |
createinSPM | Sets whether to create in the SPM system. | Required; String. 1,0 |
Job | Job name that manages the policies | String Default = managepolicy |
Name/ DisplayName | Unique Name Identifier for Policy Name in CAM Note: If you want the client and matter in the name of the SPM policy, use clientId^ClientDescription | Required; String |
Description | Short description of Policy | String |
PolicyType | Set Policy type. The accepted values are - There are 4 Policy type
| String: Inclusion
|
ExternalSystemId | System ID of iManage which is configured in CAM external system Configuration | String This is unique policy id from external system. If it does not match with external system then CAM will create security policy with this unique id. |
CreatedDate | Date of Creation | DateTime |
UpdatedDate | Last updated date | DateTime |
IncludedUsers | Required; if PolicyType : Inclusion | String Users separated by pipe character "|"; userid or emailaddress|user For e.g.: alexey.marcus@prosperoware.com|User |
Sets which external control system to set. Multiple systems can be separated by a pipe symbol. | String SPM | Intapp Walls | |
ExcludedUsers | Required; if PolicyType : Exclusion | String Users separated by pipe character "|"; userid or emailaddress|user For e.g.: alexey.marcus@prosperoware.com|User |
Side1Users | List of user | String Users separated by pipe character "|"; userid or emailaddress|user For e.g.: alexey.marcus@prosperoware.com|User |
Side<n>Users
| List of user This field will be increased till <n> number specified in "Sides"Column. If Sides = 3, then add 3 columns and increment numbers like Side2Users, Side3Users. | String Users separated by pipe character "|"; userid or emailaddress|user For e.g.: alexey.marcus@prosperoware.com|User |
ClientMatters | This field will be referred to apply Inclusion OR Exclusion as set in PolicyType. It has List of Client Matter separated by pipe "|" | String Add Metadata E.g. Client.Matter -> Client1.Matter001|Client2.Matter002 Do not use pipe to separate client |matter. |
Side1ClientMatters | This field will be referred to apply Inclusionmultiside OR Competative as set in PolicyType. It has List of Client Matter separated by pipe "|" ; | String E.g. Client.Matter -> Client1.Matter001|Client2.Matter002 Do not use pipe to separate client |matter. |
Side<n>ClientMatters
| This field will be referred to apply Inclusionmultiside OR Competitive as set in PolicyType. Multiple client matters can be separated by a pipe |" ; This field will be increased till <n> number specified in "Sides"Column. If Sides = 3, then add 3 columns and increment numbers like Side2ClientMatters, Side3ClientMatters. | String E.g. Client.Matter -> Client1.Matter001|Client2.Matter002 Do not use pipe to separate client |matter. |
Sides | No of sides to be added; SideUsers will be incremented based on this numbers | Integer E.g. 3 |
system | Creating Ethical Walls Policy in CAM | String Set default = CAM |
matterproperties | This allows to attach the matter properties to be included for knowledge management or for maintaining in SPM an automatic collection for updates based on these properties. E.g. if a time and billing system uses a Practice field and this is also added within SPM, CAM can pull this field and add that field on a matter, e.g. one that is a Litigation matter. | String. Practice: Litigation Separate using #. |
clientproperties | This allows to attach the client properties to be included for knowledge management or for maintaining in SPM an automatic collection for updates based on these properties. E.g. if a time and billing system uses a Practice field and this is also added within SPM, CAM can pull this field and add that field on a client, e.g. one that is a Advisory matter. | String. Practice: Advisory Separate using #. |
Adding a Rule for SPM Custom Properties
To add a rule on a custom property listed above (matterproperties or clientproperties), follow the below to setup the column in the CSV:
The format is: 1:DeptCode#Litigation|2:DeptCode#LPM
1: Rule number for each rule
DeptCode : Custom Field for example department
Litigation or LPM : Value of the custom field to set the rule on
AND conditions would be like this, if you want one rule for both Litigation and LPM:
1:DeptCode#Litigation|1:DeptCode#LPM
OR conditions would look like the example in #1.
Sample SPM CSV’s and SQL’s
Use the table below to download a sample CSV or SQL for the type of policy. Edit it for your purposes.
Name | Description | Download |
---|---|---|
Competitive-Client-Matter | A competitive policy upload for a client-matter designation. |
|
Policy Sample (iManage and Intapp) |
| |
Competitive-Client | A competitive policy only for the client. |
|
Exclusion- Client-Matter | An exclusionary policy for a client-matter designation |
|
Exclusion-Client | An exclusionary policy for only the client. |
|
Inclusion-Client-Matter | An inclusionary policy for a client-matter designation |
|
Inclusion-Client | An inclusionary policy for only the client. | |
Inclusion Multisided-Client-Matter | An inclusionary policy for multiple client matters or multiple users for a client-matter designation |
|
Inclusion Multisided- Client | An inclusionary policy for multiple client matters or multiple users for only the client. |
|
UserCreation | User Creation in SPM with Special and Foreign Characters |
|
GroupCreation | Group Creation in SPM with Special and Foreign Characters |
|
CreateSPMPolicies | Allows to create SPM policies |
|
CustomPropertiesSPMPolicy | This allows the use of provisioning a matter using the SPM custom properties. This example sets a Practice of Litigation and Advisory in the matterproperties column. |
|
Learn how to create your own CSV/TSV files with a Text Editor or Excel.
Related Topics
Let's Connect📌
☎ +1 630.598.1100
☎ +44 20 3880 1550
📧 support@litera.com
💻 https://www.litera.com/support/
📝 Support is available:
4 am - 8 pm US Eastern
(9 am - 1 am GMT/BST
7 pm - 11 am AET) on normal business days (excluding holidays)
© 2024 Litera