

If you are on a version of Relativity where Case Dynamics uses the Person and Organization objects (Relativity 10.1 or below) and are upgrading to a Relativity version where Case Dynamics is integrated with the Entity object (Relativity 10.2 or above), run the Case Dynamics Pre-Entity Integration Script. The script aims to detect possible upgrade conflicts, data truncation, and customization on the Person and Organization objects that may need to be re-created on the Entity object.
See these related pages:
The script return two sets of results:
The Workspace details and conflicts result tab contains this information:
Fields listed in the table have a higher character limit on Relativity 10.1 and below than they do in Relativity 10.2 and above. Relativity reduced the character limits to increase database performance. This means that in fields where data exceeds the new lower limits, there will be truncation unless measures are taken to store the additional information in another field.
Field name | Old character limit | New character limit |
---|---|---|
Organization - Office Location | Long text field type | 255 (Fixed-length text) |
Person - First Name | 222 | 125 |
Person - Full Name | 450 | 255 |
Person - Last Name | 222 | 125 |
Phone Number | Long text field type | 255 (Fixed-length text) |
Number of relationships for these pairs:
Fact – Organization
Fact – Person
Issue – Person
Organization – Outline
Organization – Person
Person – Interview Question
Person – Outline
Person - ReportSet
Note: This information may help you to better estimate your migration time.
Possible conflicts with existing data
Naming conflicts occur during upgrades when fields, views, and layouts that are being used by Case Dynamics are implemented in a workspace. For example, if you have a custom field called Key Entities, a naming conflict will result upon upgrade because the custom field name matches the name of one of the fields used by the Case Dynamics application. Relativity recommends renaming custom fields that conflict with the application.
Note: The script operates under the assumption that no other application which uses Entity is installed. If you see a conflict for “Entity,” it is very likely that you have another application that uses entities, such as Analytics, installed.
Object Types
Name conflicts for Object Types that are going to be created
Name changes/removal on existing Object Types which are going to be migrated
Fields
Name conflicts for Fields that are going to be created
Name changes/removal on existing Fields which are going to be migrated
Views
Name conflicts for Views that are going to be created
Name changes/removal on existing Views which are going to be migrated
Layouts
Name conflicts for Layouts that are going to be created
Name changes/removal on existing Layouts which are going to be migrated
Choices
Name conflicts for Choices that are going to be created
Name changes/removal on existing Choices which are going to be migrated
The Case Dynamics views, fields, and layouts are re-created on the Entity object upon upgrade, but custom work needs to be evaluated. The Result - Workspace Customizations tab displays the customization made on the Person and Organization objects that need to be migrated after the upgrade. For example, the data in custom fields needs to be exported and re-imported in the custom field that is now on the Entity object. See Step 2 - Export custom data and Step 3 - Upgrade Case Dynamics and import custom data.
Note: For security, the names of these customizations are not shown by default. However, you can adjust the script to display the friendly custom names. See Step 2 - Export custom data.
The script only filters on workspaces that have Case Dynamics installed. If you want to further target or limit your search, follow one of these tips:
Export the results to a .csv file.
To upgrade Case Dynamics, follow the steps in these sections:
To execute the script:
Download the Case Dynamics Pre-Entity Integration Script from the Relativity Community.
Note: You must have valid Relativity Community credentials in order to download any Community file linked to the documentation site. You'll need to enter those credentials on the Community login screen if you're not already logged in. If you're already logged in to the Community at the time you click a link, the file is automatically downloaded in the bottom left corner of your screen. If you get an error message stating "URL No Longer Exists" after clicking a Community link, it may be due to a single sign-on error related to the SAML Assertion Validator, and you should contact your IT department.
(Optional) Modify the script to show the friendly names of customizations made on the Person and Organization objects.
Note: If you don't want to modify the script, you can use the Case Dynamics Pre-Entity Integration Script _ Friendly Names from the Relativity Community. See Relativity Community.
Search the text for:
SELECT DISTINCT Workspace_Detail, Item_Detail FROM #_CUSTOM ORDER BY Workspace_Detail
Searching the text, will take you to this portion of the script:
Use SQL syntax to comment out the active line and to uncomment the following line. The script should now look like this:
(Optional) Modify the script to enable SQL syntax filtering of the results based on a list of specific workspaces.
Search for the first occurrence of "Interactive" in the text. Searching the text, will take you to this portion of the script:
Add a where clause that follows this sample SQL syntax:
WHERE [CaseID] in (Workspace Artifact ID, Workspace Artifact ID, Workspace Artifact ID)
Note: After running the modified script, you will be able to filter results on the list of Workspace Artifact IDs that pass in this WHERE clause.
The script generates two results:
If you have custom data from the Person and/or Organization objects, than you need to export that data before you upgrade.
Note: The instructions below illustrate how to export custom data on the Person object. The instructions for the Organization object are similar.
To export the custom fixed-length text field on the person object called "Custom Field on Person Object" and the custom view on the person object called "Custom View":
Map the following fields in the Data Source tab:
In the Destination Files tab, complete the following:
In the Export Location section, select an export location. In this example, the export will be stored on the desktop.
In the Metadata section, select the following:
Comma-separated (.csv)
Unicode (UTF – 8)
After exporting the custom data, you can upgrade Case Dynamics and set up customizations on the Entity object.
Note: All custom data needs to be exported by this step for both the Person and Organization objects.
To upgrade Case Dynamics and set up customization on the Entity object:
Note: The instructions below illustrate how to import custom data from the Person object. Example custom data includes a fixed-length text field called "Custom Field on Person Object" and a custom view called "Custom View." The instructions for the Organization object are similar.
Create the same custom field and view on the Entity object.
Import the custom Person object data you exported:
Why was this not helpful?
Check one that applies.
Thank you for your feedback.
Want to tell us more?
Great!