Create Notes from Matter Descriptions

--Transform Matter Descriptions to Matter Notes
INSERT INTO
    __M_Common_Notes
    (Id, Final_Parent_Id, Final_Parent_Type, Final_Subject, Final_Description)
SELECT
    CONCAT('TRANSFORM --- ', V1.Id),
    V1.Id,
    '__M_Matters',
    V1.Final_Subject,
    V1.Final_Description
FROM
    __M_Matters V1
WHERE 1=1
    AND V1.Final_Description != ''

• Related Articles

• Linearize Notes

  Some systems support note comments(notes-on-notes). On systems like this, you might see notes organized as follows: |-Matter ABC.001 +-Note 1 (2021-01-01) +-Note 2 (2021-01-02) +-Note 2A (2021-01-04) +-Note 2B (2021-01-05) +-Note 2C (2021-01-06) ...

• 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 ...

• Create Contact Categories from Matter Participants

  --The following script will create Contact Categories from the roles --that Contacts are linked to on Matters and then assign the contacts to those categories. GO INSERT INTO __M_Contacts_Categories ( Id, Final_Subject ) SELECT DISTINCT ...

• Split Big Notes

  Some destinations have a max character count for notes. The script below will split notes that exceed that length into multiple notes. The subject of the note will be {original subject} (Part X of Y) and the description will be the first X number of ...

• Document Register: Moving digital documents into a Document Register Matter

  /* This script is a template that will help you move library documents (document register / safe custody records) into a general 'Document Register' matter. You should consider this a TEMPLATE that you may want to tweak and adjust for each client's ...