DrawMGT - V11.4
Contents
Features
Description of end-user features, that we can explain to customers or put in our public web site.
Important New Features
- Dual-Mirrored system (Internal/external, confidential/shared)
- Hierarchical classification trees
- Database versioning
- New, simplified User Roles
- New, filtered user profile list
Other Changes
- Improved password security, password aging
- "Get next sequence number" on drawing/new.
- Workflow step "check" has status
- Workflow comments moved to Comments
- 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
- Restricted document viewer role (FRQ-1616)
- Restricted comment viewer role (FRQ-1616)
- Drawing Code parts linked with form elements
- Workflow wizard
Security exception for comment subscriber
DrawingCode or RevisionCode change can be allowed
- Automated request redirecting after login
- Mail filtering
- E-mail sending on rejected revisions
Database Model Changes
Database Model Changes Associated With New Features
- Dual-Mirrored system (Internal/external, confidential/shared)
Database triggers, created by genMeta.pl -b
Staging database, mirroring table (...stg.MirrorRecords)
- Hierarchical classification trees
- New fields in classification reference tables
- sortOrder
- parentId
- searchOnlyFlag
- displayClass
- displayTextInput
- displayTextDetail
- displayTextList
- displayHover
- New fields in classification reference tables
- Database versioning
Database triggers, created by genMeta.pl -b
versioning tables ..._log
- Improved password security, password ageing
- New field Users.passwordDate
- Test users
- New field Users.testUserFlag
- Restricted document viewer role (FRQ-1616)
- New fields
DocumentTypeRef.restrictedFlag
- Drawings.restrictedFlag
RevisionTypeRef.restrictedFlag
- Revisions.restrictedFlag
- Users.restrictedFlag
- New fields
- Restricted comment viewer role (FRQ-1616)
- New fields
CommentTypeRef.restrictedFlag
- Comments.restrictedFlag
CommentNoteTypeRef.restrictedFlag
CommentNotes.restrictedFlag
- Users.restrictedFlag
- New fields
- Company/Department
- New field Users.companyId
- Users.company = department
Other Database Model Changes
New field sortOrder on all reference tables
- Fields Revisions.startDate, Revisions.startResponsibleId removed
- Fields Comments.startDate, Comments.startPlanDate removed
Field ContractRef.contractorCompanyId removed
New table OldPasswords, intended to store old passwords to allow to disable re-using passwords (not used yet)
Field ContractRef.siteCompanyId removed
Migration Notes
- Dual-Mirrored system (Internal/external, confidential/shared)
- Database versioning
$_CFG['DbVersioning']['Tables'] contains the array of table names partticipating in database versioning
- 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
- "Get next sequence number" on drawing/new
- Set 'getNext' and 'getNextPattern' for the appropriate drawing code type
- Workflow comments moved to Comments
- No generic automatic migration until now, but there is a site specific solution in cfg/linthal/site/data/migrate-db-linthal.sql in DrawMGT 11.4.
$_CFG[ 'CommentTypesSubscrAllow' ] - set it to an array of comment types, where security exception allowed, e.g.: array( CommentTypeRef_KOOR )
Attachment name changed on DrawingCode or RevisionCode change
$_CFG[ 'DrawingAllowCodeUpdate' ]
$_CFG[ 'RenameFilesOnDCodeUpdate' ]
$_CFG[ 'RevisionAllowCodeUpdate' ]
$_CFG[ 'RenameFilesOnRCodeUpdate' ]
- Mail filtering
$_CFG[ 'Security' ][ 'AllowedEmailAddresses' ] - an array of allowed email addresses as regular expressions
Development Notes
- Dual-Mirrored system (Internal/external, confidential/shared)
- Hierarchical classification trees
- Database versioning
- Database versioning triggers are combined with mirroring triggers of a dual system
- 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.
- 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.
- Workflow comments moved to Comments
- Test users
- Restricted document viewer role (FRQ-1616)
- Restricted comment viewer role (FRQ-1616)
- Drawing Code parts linked with form elements
- Workflow wizard
- Security exception for comment subscribers
See Security exception.
DrawingCode or RevisionCode change can be allowed
- Automated request redirecting after login
- Mail filtering
- E-mail sending on rejected revisions