Excel Integration - Testing Notes

• Back

Test against ...

• requirements given in DrawMGT-AxpoExcelIntegration-15.pdf (Chapter 2)

• client-side implementation in DrawMGT-AxpoExcelIntegration-15.pdf (Chapter 4)

• use cases given in DrawMGT-AxpoExcelIntegration-15.pdf (Appendix A)

• Test notes at ExcelIntegrationToDoList#Testing

All tests against DrawMGT-AxpoExcelIntegration-15.pdf are performed with ExcelIntegrationAxpoDemoNotes in mind!

Every tested feature is protocolled below.

High-Priority Items
-------------------

  Internals
  ---------
  1. CRITICAL Implement cell locking helper functions that make cells
  read-only/non-read-only
  - Implementation initial implementation that just sets field's
    background color to indicate that the field is locked. -- OK
    
  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 -- ?
    
  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
  ------
  
  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
  ----
  
  3. CRITICAL (AH) Implement Vorabzug ja/nein flag
  - Lock and grey-out all Vorabzug fields if Vorabzug flag set to 0 -- ?
  - Disable plan date formulas when Vorabzug set to false -- ?

  5. TEST GA/Freigegeben menu:
  - Sets the RevC revisionTypeId -- ?
  - Menu with two choices: freigegeben (13) and gut zur Ausführung (15)
    -- ?

  Validation
  ----------
  
  1. TEST Client-side field validation
  - Implement Ist field validation.-- ?
  - Formulas generated from Perl script. -- ?
    - See axpo-integration/data/genValidation.pl -- ?
    
    
  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
  ----------
  
  2. Get feedback from JS re: recent changes to m_attributeRowCount
  global variable -- ?
  - Make sure that handling of m_attributeRowCount global variable is OK
    -- ?

Medium-Priority Items
---------------------

  6. TEST Performance:
  - Disable screen update during record list processing -- ?
  - Investigate to see if bubble sort is really needed. Debug prints? --
    ?

  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 -- ?

  
Excel Start-Up
--------------

- User can start Excel with an empty planning spreadsheet or a workbook
  containing already-defined document and revision metadata -- OK
  
- To access metadata in the DrawMGT server, the user must login, using a
  custom Excel menu item, using their normal DrawMGT login name and
  password. -- OK

- After logging in, spreadsheet data can be downloaded and saved in the
  DrawMGT server -- OK
  
- If the user does not login, he is still able to work off-line, e.g.
  perform operations that do not require access to the DrawMGT server
  -- OK


Create New Document
-------------------

  - click menu ribbon 'Create New Document', cells are filled with
    template data -- OK
    
  AMENDMENTS:
  - Dokumenttitel 2 should be 'Titel-2'
  - it should not be possible to enter chars in Lauf-/ Teil-nummer cells
  - when an R* cell is selected, the save returns error messages ?

  
Refresh Selected
----------------

  After change in web-interface
  
  - update document code  -- OK
  - update title -- FAILED
  - update VA Erstellen (Ist,Wer) -- OK
  - update VA Stellungnahme (Ist, Wer)
    Ist -- OK
    Wer -- FAILED (is 'Abert Franz' should be 'Muster Hans')
  - update VA Bereinigung (Ist, Wer) -- OK
  
  Web-Interface Bug -- FAILED
  -----------------  
  After a publish file was added to VA, the button to add one to ZF or
  FR is missing, and the workflow process cannot be continued for these
  versions (v2-3).

  
Save Selected
-------------

  - update document code -- OK
  - update title (with Umlauts)-- OK


Check for Duplicates
--------------------

  -- OK