Differences between revisions 2 and 3
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
Line 8: Line 7:
Line 12: Line 10:
  * '''Revisions''' with workflow steps assigned to me.
  * New/pending/repoened '''tasks''' assigned/delegated to me
   *
  * '''Revisions''' with workflow steps assigned to me.
  * New/pending/repoened '''tasks''' assigned/delegated to me
Line 17: Line 13:
 *
Line 18: Line 15:


Line 22: Line 16:
Line 24: Line 17:
Line 30: Line 22:
  * OK - After file upload
   * Next Action - New task
   * Comment types
  * OK - After file upload
  * Next Action - New task
  * Comment types
Line 36: Line 27:

* Display drawing component name in front of entry field in input form. Use a tag to display the name.
 * --(Display drawing component name in front of entry field in input form. Use a tag to display the name.)-- DONE 2009-11-13 V11.3
Line 52: Line 42:
   
Line 55: Line 44:
 * In Document Detail: When you press the New Comment button, it should copy the classification information from the document to the new task.
Line 56: Line 46:
 * In Document Detail: When you press the New Comment button, it should copy the classification information from the document to the new task.
 
Line 61: Line 49:
Line 63: Line 50:
  * Search for non-completed workflow steps assigned to X
  * Quick search for document workflow tasks assigned to me (or someone else). Like comment search.
  * Search for non-completed workflow steps assigned to X
  * Quick search for document workflow tasks assigned to me (or someone else). Like comment search.
Line 67: Line 54:
  * Implement a search code, to use instead of the ID value - How to make it efficient?
   * Allow non-active items in dropdown lists
  
  * Implement a search code, to use instead of the ID value - How to make it efficient?
  * Allow non-active items in dropdown lists
Line 71: Line 58:
Line 76: Line 62:
Line 78: Line 63:
Line 84: Line 68:
 * 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 );
Line 85: Line 77:
 * Implement field-level history messages. List before/after for each field that was changed. At least for:
   * Revisions
   * Tasks
update Comments set projectPhaseId = 8 where commentId = 10;
select * from history;
}}}
Line 92: Line 84:
Line 94: Line 85:
  * handle internal file names
  * handle matching of first 'x' characters of filename against drawing code
  * handle internal file names
  * handle matching of first 'x' characters of filename against drawing code

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

Translation Related

  • Fix getMessage so that an empty message default to the default language's message
  • Search for \t\t in Messages.txt, FieldNames.txt, TableNames.txt and add missing DE translations

  • Fix missing DE translations:
    • OK - After file upload
    • Next Action - New task
    • Comment types

Document Related

  • Display drawing component name in front of entry field in input form. Use a tag to display the name. DONE 2009-11-13 V11.3

  • Suppress display of '*' for non-required drawing code components
  • Allow changing of document codes, even if a revision file has been uploaded, provided the file uses an internal number.
  • Add button 'preview', which stays in the input form. Sets the drawing code derived fields, and leaves you in the input form.
  • 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.
  • Make entry of a comment required when a revision is rejected
  • Add approval status overrulled (for release/versand only?)
  • Allow different workflow types for each revision. Add workflowTypeId to Revisions. Drawings workFlowTypeId --> defaultWorkflowTypeId

Task Related

  • In Document Detail: When you press the New Comment button, it should copy the classification information from the document to the new task.
  • Allow entry/update of subscribers when entering a new task

Searching

  • Implement additional search fields for documents:

    • Search for non-completed workflow steps assigned to X
    • Quick search for document workflow tasks assigned to me (or someone else). Like comment search.
  • Idea: Simple for V11.x hierarchical reference data

    • Implement a search code, to use instead of the ID value - How to make it efficient?
    • Allow non-active items in dropdown lists

Email Related

  • Generate email when a new comment is created - Check if this is implemented, and how to configure it
  • Generate email when a new comment note is entered - Check if this is implemented, and how to configure it

Configuration Documentation

  • Document validation rule for checker != approver
  • Document for 'send mail: if required, always, never' works

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

WishList (last edited 2009-11-24 12:19:05 by softxs)

Copyright 2008-2014, SoftXS GmbH, Switzerland