• WishList

DrawMGT Wish List

• Requests and Ideas for new DrawMGT Features

Major Features

• Generic reports
• Dashboard that displays:

  • Revisions with workflow steps assigned to me.

  • New/pending/repoened tasks assigned/delegated to me

Minor Bugs

General

Document Related

1. Allow changing of document codes, even if a revision file has been uploaded, provided the file uses an internal number.
2. Add a comment field for each workflow field that has an approval status. This is to allow entry of a comment for approved with comments.
3. Make entry of a comment required when a revision is rejected
4. Add approval status over-rulled (for release/versand only?)

Task Related

1. In Document Detail: When you press the New Comment button, it should copy the classification information from the document to the new task. DONE 2009-11-13 V11.3

2. Allow entry/update of subscribers when entering a new task

History Related

• Implement field-level history messages. List before/after for each field that was changed. At least for:
  • Revisions
  • Tasks
  Could be solved generally by database trigger. Apache-PHP connects-disconnects from the database at every request. Therefore the userId should be saved to a small table with the database session id (@@pseudo_thread_id for MySQL) as key at every action, to allow the trigger to determine the user. Small example for using triggers:

• create table history ( date date, time time, session_id int, old int, new int );
  create trigger tr_upd_comments after update on Comments for each row
    insert into history values( now(), now(), @@pseudo_thread_id, old.projectPhaseId, new.projectPhaseId );
  
  update Comments set projectPhaseId = 8 where commentId = 10;
  select * from history;

• Implement file versioning for uploaded files (add a version number field to the internal file names?)

Back-End Tools

• Update app/etc/uploadFile.pl to:
  • handle internal file names
  • handle matching of first 'x' characters of filename against drawing code