= Master ToDo List = <> ---- = Customer Projects = == Coya == 1. --(Download new documents from Geraud's web site)-- '''AH - DONE 2010.03.09''' 1. Review and write up notes for document renumbering. See emails from 2010.02.10 & 2010.02.28 1. Migrate to new server? == HMS == 1. Clarify requirements with Harald and Ines. == Ilulissat == 1. Waiting for initial ideas for classification. Expected by end March 2010. == IDP == 1. Get price for Skyrr hosting * Reply from David at Skyrr (2010-03-09 10:36): 34.300 without VAT ISK. Monthly. 1. Write backup and security statement for Jon 1. Get authorization for releasing backups/documents to RioTinto from Jon 1. Proposal for implementing: Transmission save/update 1. Proposal for implementing: Distribution Matrix * Discuss functionality AH/TN * Possible solution: New comment type called ''distribution list''. 1. '''AH''' - Investigate bug: ''TR-422-173''. List of documents in transmission is displayed incorrectly (it is incomplete). 1. Request for feature: Fort users and user lists by first name. 1. Improvement to display of roles: Display all role names, including those with no roles assigned 1. Improvement to drawing code entry: convert lower case text to upper case text 1. '''SOON''' - Implement new approval status: ''in progress'', which works exactly like open. 1. Improved document search: * Search by worklows status and dates 1. Feature request: System should operate in GMT if possible 1. Document the maximum size of file upload 1. '''TN''' - Setup WebDAV area for document uploading * Migrate IDP to ymir server first? 1. Feature request: Ability to lookup history of transmittals of individual documents 1. Idea for feature: Implement flag in refdata tables that mean ''no more new items with this classification'' * would allow you to reture a classification field, but keep old data that was classified using it. 1. '''Done?''' - Write wiki page describing mappings from DrawMGT field names to IDP field names 1. '''AH''' - Create a TN wiki user on IDP Wiki. 1. Idea for feature: implement ability to rename metadata column names 1. Fix the display order (in the drop down list) of the project phases == KEJV == * ''Project complete'' == Lagarfoss == * ''Project complete'' == Linthal == 1. '''AH - NOW''' - Test automatic sequence number assignment. 1. Schedule meeting with Gmür, re: requirements capture for processes 1. Complete priority 1 items on Koeerkturlist 1. Meeting with Gmür/Wohlkinger, re: billing for recent updates and further work 1. Schedule user training 1. Translate validation messages 1. Improve DE language documentation == MET == 1. Upload claims correspondence -- Waiting for instructions 1. Upload 2010-Q1 documents? 1. Upload Mary McGrath documents? 1. Switchover MET system from lu.softxs.ch to softxs.hu * Setup automated mirroring from lu.softxs.ch * DNS updates? * HTTP redirect on lu.softxs.ch * Automated backups to lu.softxs.ch and sz.softxs.ch 1. Implement multiple classification == MRE == Goal of establishing a baseline of the work done so far: 1. Complete uploading of metadata and files from DVDs 1. Andrew to prepare metadata and documents of the documents for upload * These are document C&B and their partners produced for the bid 1. Have discussion of how to build on the work performed so far: * Rapid deployment of the next bid system * Or implement a bid system capable of having one bid per contract 1. Visit C&B in Paris to give presentation of DrawMGT and work with Andrew == NDD == 1. See if there are any configuration changes/expansions based on Colenco using DrawMGT system 1. Setup project Wiki == Sisimiut == == Pöyry == 1. Create a document archive for Jean-Pierre Gisiger 1. Write proposal for bid system for Robert Bartlett == Verkis == 1. Write proposal for KEJV archive system * Get price for archive system hosting at Skyrr * Reply from David at Skyrr (2010-03-09 10:36): 34.300 without VAT ISK monthly, plus 4 hours work to setup (4*15.120 = 60.480) ---- = Internal Projects = == DrawMGT Development == 1. Implement document file upload via WevDAV 1. Implement copy user and copy user roles 1. Implement user role update for all contracts (in a single form) 1. Implement integration of logins for DrawMGT and Wiki 1. Design/concept for file versioning 1. Design concept for DB record versioning 1. Implement DCAR & RCAR workflows 1. Implement configuration option allowing designer to be same as checker 1. Implement virus scanning of documents stored in system (ClamAV?) == CH Servers == 1. --(Implement routing for multiple-incoming IP address)-- '''- AH - Done 2010.03.09''' 1. '''AH NOW''' - Implement master/slave DNS servers * lu.softxs.ch -- softxs.ch * hu.softxs.ch -- softxs.hu * jkaelin.ch 1. '''AH NOW''' - Find hosting/housing provider in LU area 1. '''AH NOW''' - Find source for 1-HU dual-disk server. Specs: * 1.8+ GHz, 2GB+ memory, 1/1.5 TB dual SATA disks 1. Consider getting ''official'' SSL certificate: * For softxs.hu - for Budapest server * For softxs.ch domain - for lu server and new external server 1. Update jkaelin.ch backup server - need more disk space == HU Servers == 1. Get domain name doftxs.hu -- currently waiting 1. Setup automated backups from all production sites 1. Implement configuration for outgoing email ---- = Old Notes (Probably Obsolete) = == General Items == 1. --('''TN/AH - NOW''' Order business cards for Tibor and Martin Pike.)-- 1. --('''AH''' Find and send layout PDF to Tibor)-- 1. --('''AH - NOW''' AH to get information for Martin Pike business cards)-- 1. --('''TN - NOW''' Select a printing company)-- 1. --(Tibor to bring cards to CH)-- 1. '''AH - SOON''' Order PC & Excel books for Edina 1. '''AH - NOW''' Review Coya document coding scheme sent by Geraud 1. Meeting planned for Tue, 2009-11-17 1. --('''AH - NOW''' Clarify MWSt. for Tibor invoice with accountant)-- - DONE AH 2009.11.17 1. --(!SmartForm can bill up to 75,000 CHF/year (in 2010, up to 100,000 CHF) without having to pay MWSt.)-- 1. Bonasati can bill an unlimited amount and SoftXS has to pay MWSt, but gets the amount credited back 1. '''WAIT''' Implement Wiki for NDD project 1. '''WAIT''' Implement integration DrawMGT and Wiki software (single login to DrawMGT & Wiki) == General DrawMGT Development Tasks == 1. --('''WAIT''' Update V11.3 data model (drawmgt.PDM) to match current schema)-- 1. --(New Revisions workflow fields)-- 1. --(Revision workflowTypeId and layoutTypeId)-- 1. New publish to project/contract field (Drawings/Comments.privacyLevelId) 1. '''TN - NOW''' Migrate recent V11.3 updates into CVS leading edge 1. Copy classification on new task ('''NO''' re-implement in 12.0) 1. --(New workflows)-- 1. --('''AH - NOW''' System reference data list)-- - DONE AH 2009.11.16 in V11.3/V12.0 1. --(Manager can change workflow type and layout type)-- 1. SiteCLassification ('''NO''') 1. Identify any high-priority bugs/updates: 1. V11.3 - Mainly NOK requests (see below) 1. V12.0 - Anything required by Martin Smith 1. '''WAIT''' Update V12.0 data model (drawmgt.PDM) to match current schema 1. '''WAIT''' Declare V12.1 branch for multi-classification ('''priority?''') 1. '''TN - SOON''' Determine priority (Martin Smith) 1. Document proposed design and data model changes 1. '''AH - SOON''' Complete DrawMGT user documentation wiki * Add all images * Improve internal linking * Divide into shorter pages? * Update for latest DrawMGT version (which version?) * Add DE translations of Chapters 5 & 6 == MET ToDo Items == 1. Finialize file and metadata transfer procedures and formats with Martin Smith 1. --('''TN - NOW''' Document metadata file format in Wiki)-- 1. --('''AH/TN - NOW''' ..and make sure Martin Smith agrees!)-- 1. --('''AH - NOW''' to email & phone Martin to explain importance of file format definition and procedures)-- 1. Determine and document next activities we perform for Martin Smith 1. What are next items for Martin Smith: 1. Upload more documents? 1. Import documents directly for Mary McGraw's team? 1. Priority for multi-classification (V12.1)? 1. Should document results in a wiki page (probably in wiki.softxs.ch/intern) 1. --('''TN - SOON''' Setup hosting of Budapest server (TN))-- 1. --(Select provider)-- 1. --(trategy for partitions: encrypted/non-encrypted)-- 1. --(Non-encrypted for primary file systems and DrawMGT live system(s). E.g. you can reboot without worrying about key)-- 1. --(Encrypted for backup partitions. Will need to enter key by hand to have automatic backups run)-- 1. Access for Edina/Martin for file transfer 1. '''WAIT''' Set classification fields automatically from drawing code, in version V12.1 1. '''TN - NOW''' Wiki documentation 1. --(Final metadata file format with Martin)-- 1. --(New user check list for Edina (in HU))-- 1. How to upload document file for Kati (in HU) == NOK ToDo Items == The '''items''' refer to Martin Gmür's spreadsheet. 1. Items to clarify with Martin Gmür: 1. Item 4.2: Probably can be closed. Fixed by having a single layout for documents. 1. --('''TN - NOW''' New layout: Displays Author in document layout header, but no date field)-- - DONE TN 2009-11-17 V12.0 1. '''AH - NOW''' Item 11.3: Unclear: '''Schaltfläche mit Prozessschritten unbennen''' (translation related) 1. Software updates: 1. --('''TN - NOW''' New document: Drawing code entry (the vertical list of input fields): Display drawing code component names (via tags) to left of select lists. Use a tag to display the component name (item 2.7, easy))-- - DONE TN 2009-11-17 V12.0 1. --('''AH - NOW''' New document: Custom template to hide display of layout type and document type input (item 2.1))-- - DONE AH 2009.11.17 V11.3 * Uses style attribute on table row (TR) tags to suppress the display. e.g. ` ... ` 1. --(('''WAIT''' New document: Automatically determine next sequence number, given the rest of the document code (item 2.9, '''difficult'''))-- - DONE TN 1. --('''TN - NOW''' New document: '''Set classification fields''' button, works like '''Preview''' but stays in input form (item 2.13))-- - DONE TN 2009-11-23 V11.3 1. --('''AH - NOW''' New document: Custom input template that highlights classification fields that are part of the drawing code)-- - DONE AH 2009-11-17 V11.3 1. --('''TN - NOW''' )----(New document: Suppress display of '*' for optional document code components )-- - DONE 1. --(will probably have to implement a new drawing code keyword '''optional''' that is used to set non-required for the component field.)-- - DONE TN 2009-11-17 V12.0 (existing keyword '''required''' is used) 1. --('''TN - NOW''' New document: Drawing code config for part (Teil), make alpha numeric, instead of numeric. (item 2.12))-- - DONE 1. Change field type of sheet number to alpha-numeric? 1. --('''TN - NOW''' Revision file upload: (item 2.12))-- - DONE TN 2009-11-24 V11.3 1. --(Display expected file basename in initial screen)-- DONE 1. --(Add checkbox that enables automatic renaming of uploaded file to conform to naming convention.)-- DONE 1. --('''WAIT''' New comment: Add ability to add/remove subscribers when the comment is created)-- DONE 1. '''WAIT''' Generate an email when a revision is rejected (how? to whom?) 1. '''TN - NOW''' ('''AH to make a specification in Wiki''') Implement additional document search fields: 1. '''Quick Search''' - Lists revisions assigned user '''X''' where workflow steps not completed 1. Dates for planned workflow steps 1. Initials for workflow steps 1. '''TN - NOW''' Implement '''my document workflow todo'''. E.g. list of revisions where I have to perform a workflow step 1. Only revisions assigned to me (or user '''X''') 1. Ordered by plan date 1. Includes only revisions where the completed date is not set 1. Software updates that require a data model change: 1. --('''DB model update now''')-- - DONE AH 2009.11.23 1. '''WAIT''' Implement new public/private field: 3-state flag to make public to contract or to system (item 3.13) 1. Implemented as field '''privacyLevelId''' (in Drawings and Comments), replaces existing unused field '''privateFlag'''. 1. Potential implementation issues: 1. Could have performance implications 1. Could make it difficult to know when to display '''[view]''' links 1. Changed '''Drawings.privateFlag''' --> '''privacyLevelId''' 1. Changed '''Comments.privateFlag''' --> '''privacyLevelId''' 1. Added table '''PrivacyLevelRef''' referenced by the pricacyLevelId fields 1. --('''TN - NOW''' Allow different workflow types for each revision.)-- DONE 1. --(Changed '''Drawings.workFlowTypeId''' --> '''defaultWorkflowTypeId''')-- 1. --(Changed '''Drawings.layoutTypeId''' --> '''defaultLayoutTypeId''')-- 1. --(Added '''Revisions.workFlowTypeId''')-- 1. --(Added '''Revisions.layoutTypeId''')-- 1. --('''TN - NOW''' Change sheetNo to an alphanumeric field)-- - DONE 1. --(Changed '''Drawings.sheetNo INTEGER --> CHAR(16)'''))- 1. '''WAIT''' Implement record versioning, to allow a field level audit trail 1. '''WAIT''' Implement file versioning, to allow overwritten upload files to be recovered 1. Will have consequences to storage and backup 1. Older versions may only be available from backup 1. --('''AH - SOON''' Reference data and drawing code configuration (waiting for response from Axpo, expected 2009-11-19))-- 1. Expected new task types: 1. '''Ablehnung''' - To document why a revision was rejected 1. Expected new revision types: 1. '''Vorabzug''' 1. Temporarily delete '''top-level''' classification records (e.g. records with code X00 or X0). This is being done because searching for, for example, Objekt '''100 - Fremdanlagen''' will not include the '1XX' Objekten. Classification fields affected: 1. Kontakt 1. Objekt 1. Dokumenttyp 1. Add new approval status: Approved (Over-ruled) 1. Allows Release/Transmission of a revision that has been rejected. 1. The over-rule applies to the previous workstep 1. '''WHO?''' Change revision numbering from 'v00' either: (Requires input from Axpo/GMM) 1. A, B, C, ... followed by 1, 2, 3, ... 1. 1, 2, 3, ... followed by A, B, C, ... 1. --('''TN - NOW''' Site settings:)-- 1. --(Documents: Set all classification fields that are mapped from the drawing code to required)-- 1. --('''AH - SOON''' Complete translation of reference data:)-- 1. Comment types 1. Roles 1. '''AH - NOW''' Configuration Documentation 1. Document validation rule for checker != approver 1. Document for 'send mail: if required, always, never' works 1. Generate email when a new comment is created - Check if this is implemented, and document how to configure it 1. Generate email when a new comment note is entered - Check if this is implemented, and document how to configure it 1. Translation 1. '''AH - SOON''' Main menu: Rename '''Submittal''' (in DE) as '''Versand''' 1. What names to use in EN version? 1. '''AH - NOW''' Input fields names in task search 1. '''TN - NOW''' Fix Session::getMessage so that an empty message default to the default language's message 1. '''AH - NOW''' Search for \t\t in Messages.txt, FieldNames.txt, TableNames.txt and add missing DE translations 1. '''AH - NOW''' Fix missing DE translations: * OK - After file upload * Next Action - New task 1. '''WAIT''' Classification attributes: 1. Fachgebiet is dependent on Fachgebiet. Solve with V12.x. (item 3.3) --- '''Fachbereich''' 1. --('''TN NOW''' Deployment: Goal is DrawMGT deployment by end Nov (excluding Wiki))-- 1. --(Prepare configuration on lu.softxs.ch for ssh tunnel)-- Not required. We get access via RSA public key 1. Negotiate procedure with Axpo Unix specialist (Jörg Leppin) for getting access 1. --(Send RSA 1024 bit key and IP numbers to Jörg Leppin)-- - DONE AH 2009.11.23 1. Create honir user axpo 1. Test ssh login from honir 1. Ensure all required tools available 1. MySQL 1. PHP - including MySQL access 1. Apache - including support for PHP5 1. htmldoc 1. Perl and PHP extensions 1. Outgoing email configuration 1. Apache configuration 1. php.ini configuration 1. For Apache 1. For PHP called from command line (may be a different php.ini file!) 1. Test DrawMGT installation == Rennes Metro Ligne B (MRE) ToDo Items == Goal is to get a basic system running in early december. Andrew Bourget is the contact person. 1. Wait for definitive go ahead from Andrew Bourget on Wednesday 2009.11.25 1. Setup generic application 1. --(Get DNS entry for mre.softxs.ch)-- - DONE AH 2009.11.23 1. --(Setup virtual host)-- - DONE AH 2009.11.24 1. --(Setup user mre)-- - DONE AH 2009.11.24 1. Install basic v11.3 system 1. '''NOW - WHO?''' Prepare configuration spreadsheets 1. Classification attributes 1. Users 1. User roles 1. Decide/design drawing code and revision code == Open Points == 1. How to display Revision List in Document detail if Revisions have different work flow types.