Copy a Custom Field into a Core Field

Copy a Custom Field into a Core Field

Some systems don't have certain core fields and clients often create a custom field that they use instead.  The following script will let you copy values from a custom field named 'Opened' into __M_Matters.Final_Date_Opened .  You can adjust this template as you see fit.

  1. --In our Source system, Matter's don't have an Opened date
  2. --But our client created a custom field named 'Opened'.
  3. --We are going to copy that value into the Matter's Final_Date_Opened
  4. UPDATE
  5.     __M_Matters
  6. SET
  7.     Final_Date_Opened = V2.Final_Value
  8. FROM
  9.     __M_CustomField_Definitions V1,
  10.     __M_CustomField_Values V2,
  11.     __M_Matters V3
  12. WHERE 1=1
  13.     AND V1.Final_Subject = 'Opened'
  14.     AND V1.Final_Parent_Type = '__M_Matters'
  15.     AND V2.Final_CustomFieldDefinition_Id = V1.Id
  16.     AND V2.Final_Parent_Type = V1.Final_Parent_Type
  17.     AND V3.Id = V2.Final_Parent_Id

    • Related Articles

    • Copy Calendar Entry Dates into Custom Field Values

      Some systems let you create custom fields that reference a Calendar Entry. When moving custom fields into a system that does not support this, an easy workaround would be to turn these custom fields into DateTime custom fields by copying in the start ...

    • Create a "Legacy Matter Number" Custom Field

      Some firms rely heavily on Matter Numbers to search for a specific matter. Sometimes when they migrate to a new system it can't replicate the automatic numbering system from their old system so they want to renumber all their matters to a new scheme ...

    • Copy User and Contact Picklists from __M_CustomField_Definitions to __M_Matters_Participating_Entities

      Some systems do not support custom fields that are User/Contact Picklist but they do support participants. Use this script to copy custom field values/definitions into the Matter Participants table. --We need to copy some records from custom fields ...

    • Convert a Custom Field into a Practice Area

      --The system we are coming from does not have practice areas --however, the client has created a picklist custom field that mimics this. --We are going to convert this custom field into a practice area. --First, populate the practice areas table with ...

    • Create an "Employer" Contact from a Custom Field.

      In some systems, contacts do not have an Employer relation and only have a text field that represents the employer. This script will help when moving firms into platforms that allow an actual contact to be specified for the employer. --Create Company ...