Differences between revisions 2 and 3

DrawMGT - V11.6

Contents

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

Features

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

Important New Features

Transmittals recipients are DreawMGT users and named baskets
Transmittals has all classification fields
Vendor portal

Other Changes

Database Model Changes

Database Model Changes Associated With New Features

Transmittals recipients are DrawMGT users and named baskets
- Table SubmittalRecipients changed
  - Field userId renamed to recipientId
Transmittals has all classification fields
- Classification fields added to table Submittals
  - projectPhaseId
  - workCategoryId
  - documentTypeId
  - categoryId
  - locationId
  - workTypeId
  - siteClassification1Id
  - siteClassification2Id
  - siteClassification3Id
  - siteClassification4Id
Vendor Portal
- New tables:
  - GroupClassification
  - UploadedFiles
  - UploadedFileTypeRef

Other Database Model Changes

Migration Notes

Transmittal email adresses should be converted to userId

Clean up duplicates:

delete from s1 using SubmittalRecipients as s1, SubmittalRecipients as s2
  where s1.submittalRecipientId < s2.submittalRecipientId
  and s1.submittalId = s2.submittalId and s1.destination = s2.destination;

Email addresses can not be converted (859 at IDP!!!):

select distinct replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' )i
  from SubmittalRecipients i
  where replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' ) i
        not in ( select email1 from Users )  order by 1;

The update:

update SubmittalRecipients, Users set recipientId = userId 
  where recipientId is null 
  and replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' ) = email1;

-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
-= DrawMGT - V11.5 =
+= DrawMGT - V11.6 =
-Line 6:
+Line 5:
-Line 10:
+Line 8:
-. 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
+. Transmittals recipients are DreawMGT users and named baskets

 1. Transmittals has all classification fields

 1. Vendor portal
-Line 19:
+Line 13:
+= Database Model Changes =

== Database Model Changes Associated With New Features ==

 1. Transmittals recipients are DrawMGT users and named baskets

  * Table '''!SubmittalRecipients''' changed

   * Field '''userId''' renamed to '''recipientId'''
-Line 20:
+Line 19:
-. 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

 1. New role: !FileUpload



= Database Model Changes =



== Database Model Changes Associated With New Features ==



 1. Generic object (Document/Revision/Comment) references, links
+. Transmittals has all classification fields

  * Classification fields added to table '''Submittals'''

   * projectPhaseId

   * workCategoryId

   * documentTypeId

   * categoryId

   * locationId

   * workTypeId

   * siteClassification1Id

   * siteClassification2Id

   * siteClassification3Id

   * siteClassification4Id

 1. Vendor Portal
-Line 35:
+Line 33:
-   * 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

  * Fields moved from table Drawings to table Revisions

   * 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
+   * '''!GroupClassification'''

   * '''!UploadedFiles'''

   * '''!UploadedFileTypeRef'''
-Line 72:
+Line 38:
-. All ...Flag fields got default value 0
-Line 76:
+Line 39:
-. Revision must be created in site specific migration for all Drawings without Revisions in 11.4.

 1. Site setting $_CFG[ 'MailFrom' ] is obsolete use

  * $_CFG[ 'MailFromName' ] - e.g. 'Projekt PSW Limmern DrawMGT'

  * $_CFG[ 'MailFromAddress' ] - e.g. 'drawmgt-pswlimmern@axpo.ch'

 1. Use $_CFG[ 'MailFromInitiator' ] = true if you want name of initiator user in "From:" field

 1. Use $_CFG[ 'MailReplyToInitiator' ] = true, if you want the email address of initiator user in "Replay to:" field
+. Transmittal email adresses should be converted to userId

  * Clean up duplicates:

 {{{

delete from s1 using SubmittalRecipients as s1, SubmittalRecipients as s2

  where s1.submittalRecipientId < s2.submittalRecipientId

  and s1.submittalId = s2.submittalId and s1.destination = s2.destination;

}}}

 * Email addresses can not be converted (859 at IDP!!!):

 {{{

select distinct replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' )i

  from SubmittalRecipients i

  where replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' ) i

        not in ( select email1 from Users )  order by 1;

}}}

  * The update:

 {{{

update SubmittalRecipients, Users set recipientId = userId 

  where recipientId is null 

  and replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' ) = email1;

}}}
-Line 85:
+Line 61:
-. 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