Multiple File Versions

Introduction

Multiple file versions allows DrawMGT users to upload a new file

Each uploaded file should have the following attributes:

• The upload file itself
• The file type (source, publish, etc.). The allowed file types are defined in the project configuration (in the database?)
• The date the file was uploaded
• The user that uploaded the file. (Need to decide if this should be displayed on the revision detail screen)
• A text note that us created by the user when the file is uploaded

Goals

• Keep all uploaded revision files, even if a file was deleted on the GUI
• Possibility for admins to restore deleted, overwritten files
• Using file types (publish, source, etc,) generally, to allow different number of file types, not hard-coded

Data Model

1. New table UploadFileTypeRef contains the upload file types, with a flag that the type can be uploaded

2. New table UploadFiles contains the

   • Reference to the object (Revisions, CommentNotes)

   • File type (PDF, DOC, etc.)
   • File size
   • Filename
   • File version (sequence number)
   • Deleted flag
   • Thumbnail file name

     Note that the table name UploadedFiles is already used in the vendor portal.

3. Table Revisions: all upload file informations will be removed

File Storage

• File could be stored in the same way as today, but the fie version appended (perhaps before the fileTypeId)

Code Areas to Change

1. Drawing Code Class
   • All functions returning file names, links, path, checking file names

2. Settings-DrawingCode.php

   • OPEN POINT: How to change file name definition?
3. Revision File Delete

   • Only the delete flag will be set in the UploadFiles record, neither the UploadFiles record nor the file will be deleted

4. Revision File Upload

   • New UploadFiles record created with the next file version number

   • OPEN POINT: Should we allow to upload a file also if there is already one uploaded?
5. Revision Delete
   • See Revision File Delete above
6. Validation
   • Work flow step can be completed only if specific type of upload file is uploaded
     • Type of upload file is from $_CFG
     • Type is defined in table WFStepTypeRef if the new work flow schema is used for revisions
7. Comment Note Attachment Delete
   • New function
8. Comment Note Attachment Upload
9. Thumbnail generation
   • Filenames created differently

10. Revisions, DrawingsRevisionsJoin dereference method

11. Drawings, Basket listsű
12. Submittal, Transmittal File Selection
    • Javascript to select file types

Migration