Excel Integration - To Do List

• Back

Milestones

• Deadline: Week of 18-Jul

  • Deliver a completed and tested version that can be used in production.

Immediate Items to Complete

1. JS Complete the following:

   • Implement Excel 2003 menu

   • Test the onChange handling for Vorabzug menu and RevC type fields.

     • Make sure the revision code and revision type are changed and set correctly

     • Make sure the Vorabzug fields are locked/unlocked when the flag is changed

     • Make sure the Vorabzug fields are cleared when flag not set and records saved

   • Test items marked TEST in the High and Medium priority lists

     • Make notes, in a text file in axpo-excel/notes, of what has been tested and the results
     • Report all (and fix is possible) all errors

   • Field locking: Implemented protected worksheets and individual cell locking/unclocking

     • See: the lockCell and unlockCell subroutines in modFunctions. These are called for he correct cells in the correct places. The goal is that they actually lock the cells, rather than just set/reset the cell' background color.

   • Inserting after selection point: New Document and Duplicate Selected

2. AH

   • Complete on change handling for Vorabzug menu and RevC type fields

   • Vorabzug flag implementation: clearing locked fields when no Vorabzug

   • Highlighting records after change/save/error

   • Progress messages

3. DD Testing: See items marked TEST

   • Client-side validation: Testing of Ist field validation

   • Functional testing
   • Performance and stress testing (operations many records)

4. (JS) Implement Bau reports. There are two reports:

   • Dokumentenlieferprogramm - mainly contains deadline fields: Tv, Tzf, Tf, Tgza, T0, T0,wv

   • Ressourcenplanung - mainly contains Wer fields and resource (user defined) fields

---

High-Priority Items

Internals

1. TEST Implement cell locking helper functions that make cells read-only/non-read-only

   • Design/plan for implementing cell locking in protected sheets

   • Implementation initial implementation that just sets field's background color to indicate that the field is locked.

2. TEST Fix handling/display of progress messages:

   • Convert display of Record count to Revision count in search

   • All (most?) menu items should clear display area when operation completes

3. Implement Excel 2003 menu
4. Implement handling when not logged in:
   • Implement routine to catch and report not being logged in
   • All menu items that access server should be able to respond to a non-logged in error

5. TEST Supress setting of cell comments when records initially read from server

6. TEST Make sure that no problems occurr when user changes worksheet names

7. Fix checkDuplicates to check both the drawingCode and drawingId fields

   • Set cell note and highlighting when duplicates found

8. Review/improve cell note set/clear functions: isCellDifference and setCellDifferenceComment

   • Fix bug when comparing date fields

   • Do not set cell comments in key set area

Search

1. CRITICAL (AH) Change New Worksheet checkbox to Clear Existing Sheet in Search and Test Cases

2. TEST that no problems when the Layout worksheet is hidden.

3. TEST that Refresh All and Refresh Selected update the record update counts in key set area

   • Search, then make update on the server, refresh the client and ensure that the update counts are correctly updated

4. TEST that search correctly merges new data with existing data

   • Make sure that if you re-arrange the order of documents in a worksheet, that search still operates correctly. E.g. check th t search is able to recognize existing documents in the worksheet and doesn't depend on the order of documents delivered by the s rver.

5. TEST Searching for more than selected the number of records

   • Ensure cancel/continue dialog functions correctly

6. Mark row as un-savable if revision sequence is incomplete?

7. Implement checking for duplicate worksheet names

   • Make sure that system doesn't crash if it tries to create a worksheet name that already exists

Edit

1. TEST (JS) that New Document inserts after selected row

   • Should append data after last selected cell, or last row if nothing selected

2. TEST (JS) Duplicate Row should duplicate after the last selected row

   • And should not have problems when blank rows are selected

3. CRITICAL (AH) Implement Vorabzug ja/nein flag

   • Clear/reset revisionNo and revisionCode

   • Lock and grey-out all Vorabzug fields if Vorabzug flag set to 0

   • Disable plan date formulas when Vorabzug set to false

   • See ExcelIntegrationRequirements#VorabzugFlag

4. CRITICAL (AH) Fix highlighting/de-highlighting of status column. Display colors:

   • Status colors:

     • gray - saved

     • yellow - changed

     • red - error

   • Events:
     • New record (set to yellow)
     • Re-started record (set to yellow). E.g. after restart revision sequence
     • Record changed locally (set to yellow)
     • Client-side error? (set to red)
     • Server-side error (set to red)
     • Record saved (set to white)

5. TEST GA/Freigegeben menu:

   • Sets the RevC revisionTypeId

   • Menu with two choices: freigegeben (13) and gut zur Ausführung (15)

   • See ExcelIntegrationRequirements#GA.2BAC8-FregegebenMenu

6. TEST Get Next Sequence Number

7. Should Restart Revision Sequence not be allowed when applied to an unsaved record? Probably not

Validation

1. TEST Client-side field validation

   • TEST Ist field validation.

   • Formulas generated from Perl script.

     • See axpo-integration/data/genValidation.pl

   • See Client-Side Validation

2. TEST Group menu change

3. Leave Wer and Status field validation for now

Save/Update

1. TEST Save handling of Vorabzug menu and GA/Freigegeben menus

   • Vorabzug flag

   • GA/Freigegeben menu

2. TEST Implement field locking after save. Fields:

   • Bereich menu

   • Vorabzug flag

   • GA/Freigegeben menu (RevC type) No, does not need to be locked after save

3. Generate client-side error on update/insert when drawing code not complete

4. Implement checking of record serial numbers on update

5. Save all/selected should set record update counts

   • Test that a second save results in state with correct record update counts

6. Duplicate row detection before:

   • search / test cases

   • save all / save selected

   • refresh all / refresh selected

Attributes

1. TEST Make sure Refresh Attributes still works

2. Get feedback from JS re: recent changes to m_attributeRowCount global variable

   • Make sure that handling of m_attributeRowCount global variable is OK

Report

1. TEST (JS) Bau and Ausrüstung reports

   • Based on simple macros
   • Formatting of date columns

   • Dokumentenlieferprogramm - mainly contains deadline fields: Tv, Tzf, Tf, Tgza, T0, T0,wv

   • Ressourcenplanung - mainly contains Wer fields and resource (user defined) fields

Final Cleanup

1. Re-hide hidden rows/columns in header worksheet
   • Ensure that non-implemented fields are locked/greyed-out
2. Setup field worksheet field locking
3. Hide internal worksheets
4. Set password on VBA code

Test

1. Setup Excel 2003/2007 test/development environment

2. TEST contract and group menu changes in planning list worksheet

   • Make sure group menu updates when contract changed
   • Make sure user id menus change when contract and group changed

---

Medium-Priority Items

1. Implement Ausrustung report

2. Implement Preufdauer menu and handling of Delta-4 field

3. Implement document links for Grundlagen documents. tech GL and WV GL fields.

4. Implement document links for Stellungnahmen and Pruefberichts documents. Stn-Nr and Pruef-Nr fields.

5. Implement document links for QA-Eklaerung documents

6. TEST Performance:

   • Measure performance with large data sets
   • Profile code to see what is being called for each document/revision

   • Review calls to DoEvents

   • Disable screen update during record list processing

   • Investigate to see if bubble sort is really needed. Debug prints?

7. In search form implement Gruppe menu with dependency on Bereich menu (design needed)

8. TEST search fields:

   • document code
   • title
   • revision date from/to
   • external reference number

9. Separate Refresh Attributes into:

   • Refresh Attributes

   • Refresh Users and Roles

10. Trap Excel-Quit and ask user if unsaved records should be saved (design needed)

11. Testing prior to release of test candidate to GMM
    • Test basic features
    • Test different contracts/groups
12. Implement named baskets (Design needed)
    • User can select a named basket download its contents
    • Make sure all calculate fields are readonly

13. Implement new columns to display record status and DrawMGT id values (design needed)

14. Design for record status fields

    • May not be needed if the above highlighting is implemented

---

Low-Priority Items

General

1. Reject revision (design needed)

2. Sub-revision processing (design needed)

3. Implement new Magic Row fields:

   • Protocol version
   • Client software version
   • Server software version

4. Shorten attribute lists (design needed)

   • Via server-side configuration?

Final Cleanup and Packaging

1. Get code signed with a Axpo certificate?
2. Assign password to code

Login/Logout

1. Implement login timeout
2. Implement code that reacts correctly to auto-logout. E.g. session-timeout
   • Implement a heartbeat function to prevent session timeout?
3. Check user roles and disallow login if certain roles not present
4. Login in a specific contract?

Search

1. Use case: Set next revision based on a document with unknown revision types

Internals and Refactoring

1. Named ranges
   • Automated management
   • Function for repair/reset of named ranges in case of corruption
   • Clone worksheet
   • Document named ranges and their boundaries

2. Make sure Consts are used for all field type names in the write-back header worksheets

3. Change iRow to lRow?

4. Document new validation columns in header structure
5. Document and revision (write) record structures

6. Improved worksheet lookup/access functions (getCellValue/Address)

7. Improved row selection for printing to worksheet
8. Refactor define names to improve clarity and remove near-aliases

9. Identify all magic constants and convert to Consts

10. Improve function naming:

    • Make function names more business oriented rather than technically descriptive

11. Review TODOs in code

Compatibility

1. Excel 2003 compatibility (menu)

Internationalization

1. Convert all user display text to Const strings
2. Translate all messages Consts into DE

3. Implement tag and lookup for form text (design needed)

Testing

1. Write a test-plan wiki page
2. Make sure ZK/TN/DD have suitable test environments
3. Check reading and updating of all fields
4. Stress/performance testing
   • Searching for long lists
   • Bad input data
5. Character sets: test with Umlauts
   • Test Umlauts in UTF-8 set to server
   • Test Umlauts in ISO-8859-1 set from server
6. Compatibility testing
7. Search tests
8. Display tests
9. List menu tests
   • Status menus
   • User menus
   • Flag menus
10. Editing tests
    • Delta date calculations
    • Drawing code menus
11. Insert tests
12. Update tests
13. Client-side validation tests
14. Menu item tests
    • Check for duplicates
    • Duplicate selected
15. Performance tests
16. HTTPS test
17. HTTP/HTTPS proxy test

Internal Documentation

1. List of modules
2. List of public subs/functions

3. List of gotchas

   • Blank cells in header regions, caused by use of Excel count2 function

4. Explanation of complex menu and look formulas)
5. Convert notes/DesignNotes into Wiki
6. Revision sequence
7. Named ranges
8. URLS for REST transactions
9. XML structures
   • Returned records
   • Insert/update records

User Documentation

1. Define outline/structure for user documentation
2. Setup wiki pages