DrawMGT - V11.4

Features

Important New Features

1. Dual-Mirrored system (Internal/external, confidential/shared)
2. Hierarchical classification trees
3. Database versioning
4. New, simplified User Roles

Other Changes

1. Improved password security, password ageing
2. Workflow comments moved to Comments
3. Test users
   • Don't appear in any drop down menus (workflow, subscribers, etc.)
   • Exclude from user lists, unless admin mode (and a 'include test users' checkbox)
   • Never send email to test users
4. Restricted document viewer role (FRQ-1616)
5. Restricted comment viewer role (FRQ-1616)
6. Drawing Code parts linked with form elements
7. Workflow wizard
8. Security exception for comment subsribers

9. DrawingCode or RevisionCode change can be allowed

10. Automated request redirecting after login
11. Mail filtering
12. E-mail sending on rejected revisions

Database Model Changes

== Database Model Changes Associated With New Features

1. Dual-Mirrored system (Internal/external, confidential/shared)

   • Database triggers, created by genMeta.pl -b

   • Staging database, mirring table (...stg.MirrorRecords)

2. Hierarchical classification trees
   • New fields in classification reference tables
     • sortOrder
     • parentId
     • searchOnlyFlag
     • displayClass
     • displayTextInput
     • displayTextDetail
     • displayTextList
     • displayHover
3. Database versioning

   • Database triggers, created by genMeta.pl -b

   • versioning tables ..._log

4. Improved password security, password ageing
   • New field Users.passwordDate
5. Test users
   • New field Users.testUserFlag
6. Restricted document viewer role (FRQ-1616)
   • New fields

     • DocumentTypeRef.restrictedFlag

     • Drawings.restrictedFlag

     • RevisionTypeRef.restrictedFlag

     • Revisions.restrictedFlag
     • Users.restrictedFlag
7. Restricted comment viewer role (FRQ-1616)
   • New fields

     • CommentTypeRef.restrictedFlag

     • Comments.restrictedFlag

     • CommentNoteTypeRef.restrictedFlag

     • CommentNotes.restrictedFlag

     • Users.restrictedFlag

Other Database Model Changes

1. New field sortOrder on all reference tables

2. Fields Revisions.startDate, Revisions.startResponsibleId removed
3. Fields Comments.startDate, Comments.startPlanDate removed

4. Field ContractRef.contractorCompanyId removed

5. New table OldPasswords, intended to store old passwords to allow to disable re-using passwords (not used yet)

6. Field ContractRef.siteCompanyId removed

Migration Notes

1. Dual-Mirrored system (Internal/external, confidential/shared)

   • See Setup Dual Draw MGTSystem

2. Database versioning

   • $_CFG['DbVersioning']['Tables'] contains the array of table names partticipating in database versioning

3. Improved password security, password ageing

   • $_CFG['SecurityCheck']['PasswordWithLoginName' ] - cut-off date for encrypting with login name. Set it to migration date in SiteSettings.php

   • $_CFG['SecurityCheck']['PasswordChangePeriod'] - password aging period, set to 90 days in Settings.php

4. Workflow comments moved to Comments
   • No automatic migration until now
5. Security exception

   • $_CFG[ 'CommentTypesSubscrAllow' ] - set it to an array of comment types, where security exception allowed, e.g.: array( CommentTypeRef_KOOR )

6. Attachment name changed on DrawingCode or RevisionCode change

   • $_CFG[ 'DrawingAllowCodeUpdate' ]

   • $_CFG[ 'RenameFilesOnDCodeUpdate' ]

   • $_CFG[ 'RevisionAllowCodeUpdate' ]

   • $_CFG[ 'RenameFilesOnRCodeUpdate' ]

7. Mail filtering

   • $_CFG[ 'Security' ][ 'AllowedEmailAddresses' ] - an array of allowed email addresses as regular expressions

Development Notes

1. Dual-Mirrored system (Internal/external, confidential/shared)

   • See Dual System Design Notes

2. Hierarchical classification trees
3. Database versioning
   • Database versioning triggers are combined with mirroring triggers of a dual system
4. New, simplified User Roles

   • See NewRoleXRef.xls in SXS-T-000001 for cross reference list between old and new roles. The script ./app/schema/migrate/bin/generateUserRolesMigration.pl creates migration script from NewRoleXRef.xls.

5. Improved password security, password ageing
   • As of 11.4 the user name and the raw password are encrypted together. Use the new enryption methon on password check if ct-off date is greather or equal to password date.
6. Workflow comments moved to Comments
7. Test users
8. Restricted document viewer role (FRQ-1616)
9. Restricted comment viewer role (FRQ-1616)
10. Drawing Code parts linked with form elements
11. Workflow wizard
12. Security exception for comment subsribers

13. DrawingCode or RevisionCode change can be allowed

14. Automated request redirecting after login
15. Mail filtering
16. E-mail sending on rejected revisions