Differences between revisions 1 and 2
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
= DrawMGT - V11.4 = = DrawMGT - V11.5 =
Line 11: Line 11:
 1. Dual-Mirrored system (Internal/external, confidential/shared)
 1. Hierarchical classification trees
 1. Database versioning
 1. New, simplified User Roles 		 1. Generic object (Document/Revision/Comment) references, links
 1. Creating document and first revision in one step
 1. WorkFlow wizard (it was disabled in 11.4 through performance and some functional problems)
 1. Dynamic work flow names, step names, status names (see DynamicWorkFlowNames)
 1. Excel integration (see ExcelIntegration)
 1. Document serial code
Line 18: Line 20:
 1. Improved password security, password aging
 1. "Get next sequence number" on drawing/new.
 1. Workflow step "check" has status
 1. Workflow comments moved to Comments
 1. 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
 1. Restricted document viewer role (FRQ-1616)
 1. Restricted comment viewer role (FRQ-1616)
 1. Drawing Code parts linked with form elements
 1. Workflow wizard
 1. Security exception for comment subscriber
 1. DrawingCode or RevisionCode change can be allowed
 1. Automated request redirecting after login
 1. Mail filtering
 1. E-mail sending on rejected revisions
 		 1. Planned title, planned scale removed from Document
 1. User defined fields in Drawings/Revisions
 1. New workflow status: 'in process', 'rejected without comment'
 1. Update counter to avoid parallel update
 1. Timestamp of last system update as hover on the left bottom time item
 1. Generic revision date added
 1. Workflow step's planned start date and effort added
Line 41: Line 32:
 1. Dual-Mirrored system (Internal/external, confidential/shared)
  * Database triggers, created by '''genMeta.pl -b'''
  * Staging database, mirring table (...stg.MirrorRecords)

 1. Hierarchical classification trees
  * New fields in classification reference tables
   * sortOrder
   * parentId
   * searchOnlyFlag
   * displayClass
   * displayTextInput
   * displayTextDetail
   * displayTextList
   * displayHover

 1. Database versioning
  * Database triggers, created by '''genMeta.pl -b'''
  * versioning tables '''..._log'''

 1. Improved password security, password ageing
  * New field Users.passwordDate

 1. Test users
  * New field Users.testUserFlag

 1. Restricted document viewer role (FRQ-1616)
  * New fields
   * DocumentTypeRef.restrictedFlag
   * Drawings.restrictedFlag
   * RevisionTypeRef.restrictedFlag
   * Revisions.restrictedFlag
   * Users.restrictedFlag

 1. Restricted comment viewer role (FRQ-1616)
  * New fields
   * CommentTypeRef.restrictedFlag
   * Comments.restrictedFlag
   * CommentNoteTypeRef.restrictedFlag
   * CommentNotes.restrictedFlag
   * Users.restrictedFlag

 1. Company/Department
  * New field Users.companyId
  * Users.company = department 		 1. Generic object (Document/Revision/Comment) references, links
  * New tables:
   * ReferenceTypeRef
   * ObjectReferences
  * Removed tables:
   * DrawingReferences
   * CommentReferences
   * CommentRevisions
 1. Creating document and first revision in one step
   * Fields externalKey renamed to externalKeyDoc and externalKeyRev
 1. Dynamic work flow names, step names, status names (see DynamicWorkFlowNames)
  * New tables:
   * WorkFlowStepRef
   * DisplayWorkFlowStepListRef
   * ApprovalStatusListRef
   * DisplayWorkFlowStepRef
   * DisplayWorkFlowTypeRef
   * DisplayApprovalStatusRef
 1. Document serial code
  * New tables: SerialCodeTypeRef
 1. Planned title, planned scale removed from Document
  * Fields removed from table Drawings
   * plannedTitle0Id
   * plannedTitle0
   * plannedTitle1
   * plannedTitle2
   * plannedTitle3
   * plannedScale
   * author
   * abstract
 1. User defined fields in Drawings/Revisions
   * Field userDefinedFields added to Drawings and Revisions
 1. Workflow step's planned start date and effort added
  * Fields added to table Revisions
   * ...PlanStartDate
   * ...Effort
Line 88: Line 71:
 1. New field '''sortOrder''' on all reference tables
 1. Fields Revisions.startDate, Revisions.startResponsibleId removed
 1. Fields Comments.startDate, Comments.startPlanDate removed
 1. Field ContractRef.contractorCompanyId removed
 1. New table OldPasswords, intended to store old passwords to allow to disable re-using passwords (not used yet)
 1. Field ContractRef.siteCompanyId removed 		 1. All ...Flag fields got default value 0
Line 97: Line 75:
 1. Dual-Mirrored system (Internal/external, confidential/shared)
  * See [[SetupDualDrawMGTSystem|Setup Dual Draw MGTSystem]]

 1. Database versioning
  * '''$_CFG['DbVersioning']['Tables']''' contains the array of table names partticipating in database versioning

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

 1. "Get next sequence number" on drawing/new
  * Set 'getNext' and 'getNextPattern' for the appropriate drawing code type

 1. Workflow comments moved to Comments
  * No automatic migration until now

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

 1. Attachment name changed on DrawingCode or RevisionCode change
  * '''$_CFG[ 'DrawingAllowCodeUpdate' ]'''
  * '''$_CFG[ 'RenameFilesOnDCodeUpdate' ]'''
  * '''$_CFG[ 'RevisionAllowCodeUpdate' ]'''
  * '''$_CFG[ 'RenameFilesOnRCodeUpdate' ]'''

 1. Mail filtering
  $_CFG[ 'Security' ][ 'AllowedEmailAddresses' ] - an array of allowed email addresses as regular expressions 		 1. Revision must be created in site specific migration for all Drawings without Revisions in 11.4.
Line 127: Line 79:
 1. Dual-Mirrored system (Internal/external, confidential/shared)
  See [[DualSystemDesignNotes|Dual System Design Notes]]

 1. Hierarchical classification trees

 1. Database versioning
  Database versioning triggers are combined with mirroring triggers of a dual system

 1. 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'''.

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

 1. Workflow comments moved to Comments

 1. Test users

 1. Restricted document viewer role (FRQ-1616)

 1. Restricted comment viewer role (FRQ-1616)

 1. Drawing Code parts linked with form elements

 1. Workflow wizard

 1. Security exception for comment subsribers

 1. DrawingCode or RevisionCode change can be allowed

 1. Automated request redirecting after login

 1. Mail filtering

 1. E-mail sending on rejected revisions 		 1. Database default values are used at initializing business objects
 1. Do not copy DC fields to classification fields and v.v. if setClassifications is not set

DrawMGT - V11.5

Contents

  1. DrawMGT - V11.5
  2. Features
    1. Important New Features
    2. Other Changes
  3. Database Model Changes
    1. Database Model Changes Associated With New Features
    2. Other Database Model Changes
  4. Migration Notes
  5. Development Notes

Features

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

Important New Features

  1. Generic object (Document/Revision/Comment) references, links
  2. Creating document and first revision in one step

  3. WorkFlow wizard (it was disabled in 11.4 through performance and some functional problems)

  4. Dynamic work flow names, step names, status names (see DynamicWorkFlowNames)

  5. Excel integration (see ExcelIntegration)

  6. Document serial code

Other Changes

  1. Planned title, planned scale removed from Document
  2. User defined fields in Drawings/Revisions
  3. New workflow status: 'in process', 'rejected without comment'
  4. Update counter to avoid parallel update
  5. Timestamp of last system update as hover on the left bottom time item
  6. Generic revision date added
  7. Workflow step's planned start date and effort added

Database Model Changes

Database Model Changes Associated With New Features

  1. Generic object (Document/Revision/Comment) references, links
  2. Creating document and first revision in one step
    • Fields externalKey renamed to externalKeyDoc and externalKeyRev

  3. Dynamic work flow names, step names, status names (see DynamicWorkFlowNames)

  4. Document serial code
  5. Planned title, planned scale removed from Document
    • Fields removed from table Drawings
      • plannedTitle0Id
      • plannedTitle0
      • plannedTitle1
      • plannedTitle2
      • plannedTitle3
      • plannedScale
      • author
      • abstract
  6. User defined fields in Drawings/Revisions
    • Field userDefinedFields added to Drawings and Revisions
  7. Workflow step's planned start date and effort added

Other Database Model Changes

  1. All ...Flag fields got default value 0

Migration Notes

  1. Revision must be created in site specific migration for all Drawings without Revisions in 11.4.

Development Notes

  1. Database default values are used at initializing business objects
  2. Do not copy DC fields to classification fields and v.v. if setClassifications is not set

DrawMGT115 (last edited 2011-09-06 10:25:22 by 195)

Copyright 2008-2014, SoftXS GmbH, Switzerland