DrawMGT - V11.6

Features

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

Important New Features

1. Transmittals recipients are DreawMGT users and named baskets
2. Transmittals has all classification fields
3. Vendor portal

Other Changes

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

2. Transmittals has all classification fields

   • Classification fields added to table Submittals

     • projectPhaseId
     • workCategoryId
     • documentTypeId
     • categoryId
     • locationId
     • workTypeId
     • siteClassification1Id
     • siteClassification2Id
     • siteClassification3Id
     • siteClassification4Id
3. Vendor Portal
   • New tables:

     • GroupClassification

     • UploadedFiles

     • UploadedFileTypeRef

Other Database Model Changes

Migration Notes

1. Recipient Types added, use site specific migration if translation is needed

   INSERT INTO RecipientTypeRef VALUES (4,'TO_BASKET','To_Basket',null,'To_Basket',null);
   INSERT INTO RecipientTypeRef VALUES (5,'CC_BASKET','CC_Basket',null,'CC_Basket',null);
   INSERT INTO RecipientTypeRef VALUES (6,'BCC_BASKET','BCC_Basket',null,'BCC_Basket',null);

2. 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 ), '>', '' )
     from SubmittalRecipients
     where replace ( substr( destination, instr( destination, '<' ) + 1 ), '>', '' )
           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;

3. Add vendor contract if necessary in site migration script (IDP example)

   insert into ContractRef values ( 1, 0, 'Vendor', 'Vendor Portal', null, 'Vendor', null, null );

4. Remove vendor role if not used in site migration script

   DELETE FROM Roles WHERE roleId = 27;

Development Notes