DrawMGT - V11.4

Features

Description of end-user features, that we can explain to customers or put in our public web site.

Important New Features

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

Other Changes

1. Improved password security, password aging
2. "Get next sequence number" on drawing/new.
3. Workflow step "check" has status
4. Workflow comments moved to Comments
5. 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
6. Restricted document viewer role (FRQ-1616)
7. Restricted comment viewer role (FRQ-1616)
8. Drawing Code parts linked with form elements
9. Workflow wizard

10. Security exception for comment subscriber

11. DrawingCode or RevisionCode change can be allowed

12. Automated request redirecting after login
13. Mail filtering
14. 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, mirroring 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
8. Company/Department
   • New field Users.companyId
   • Users.company = department

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. "Get next sequence number" on drawing/new
   • Set 'getNext' and 'getNextPattern' for the appropriate drawing code type
5. Workflow comments moved to Comments
   • No automatic migration until now

6. Security exception

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

7. Attachment name changed on DrawingCode or RevisionCode change

   • $_CFG[ 'DrawingAllowCodeUpdate' ]

   • $_CFG[ 'RenameFilesOnDCodeUpdate' ]

   • $_CFG[ 'RevisionAllowCodeUpdate' ]

   • $_CFG[ 'RenameFilesOnRCodeUpdate' ]

8. 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 subscribers

    • See Security exception.

13. DrawingCode or RevisionCode change can be allowed

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