Synthesize: Missing Document Categories for Documents

-- Some documents are linked to categories that no longer exist.
-- Create dummy document categories based on these values.
INSERT INTO
  __M_Documents_Digital_Categories (
    Id,
    Final_ReferenceCode,
    Final_Subject
)
SELECT DISTINCT
    Final_DocumentCategory_Id,
    Final_DocumentCategory_Id, 
    Final_DocumentCategory_Id
FROM
    __M_Documents_Digital_Files
WHERE 1=1
    AND Final_DocumentCategory_Id != ''
    AND Final_DocumentCategory_Id NOT IN (SELECT Id FROM __M_Documents_Digital_Categories)

• Related Articles

• Synthesize Missing Matters for Documents

  Some systems only allow documents to be linked to matters. These scripts will allow you to restore data into these systems. When Matters No Longer Exist The following script with synthesize matters for document related to matters that no longer ...

• Synthesize Missing Practice Areas

  The following SQL script will create practice areas where they do not exist in the Matters table. --Synthesize missing practice areas from Matters INSERT INTO __M_Matters_PracticeAreas( Id, Final_Subject ) SELECT DISTINCT Final_PracticeArea_Id, ...

• Synthesize Missing Client Contacts for Matters

  This script below will create dummy contacts where the Matter is assigned to a contact that no longer exists. --Some of the Matters are linked to contacts that no longer exist. --This will create dummy contacts from the missing links. INSERT INTO ...

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

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