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 -- 
    (check lower right msg in Excel -- not critical now)
  - All (most?) menu items should clear display area when operation
    completes -- OK
    
  7. Fix checkDuplicates to check both the drawingCode and drawingId
  fields -- OK
    - Set cell note and highlighting when duplicates found -- OK    

  8. Review/improve cell note set/clear functions: isCellDifference and
  setCellDifferenceComment -- FAILED
    - Fix bug when comparing date fields -- FAILED
    - Do not set cell comments in key set area -- ?
    
    Note: Date fields should only have a comment after a 'Refresh
    Selected', if an update on the server side changed dates.
    
    If T0 Arbeits-BP (CS) is set, the calculated SOLL dates are not
    saved on the server -- FAILED
    
    If changed in web-interface and 'Refresh Selected' in Excel:
    - VA Erstellen: Soll, Ist, Wer
      - Ist -- OK
      - Wer -- OK
    - VA Stellungnahme
      - Ist -- OK
      - Wer -- OK
    - VA Bereinigung
      - Ist -- OK
      - Wer -- OK

    
  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 --
    test later
  - Disable plan date formulas when Vorabzug set to false -- test later

  5. TEST GA/Freigegeben menu:
  - Sets the RevC revisionTypeId -- FAILED
    (CA-CF select -> show; should give you RevC value)
    
  - Menu with two choices: freigegeben (13) and gut zur Ausführung (15)
    -- OK
  
  Comment: revisionTypeId changes in cell CE, when switching from
  'freigegeben' to 'gut zur Ausführung' and vice-versa, but changes
  are not saved on the server after 'Save Selected'.


  Validation
  ----------
  
  1. TEST Client-side field validation
  - Implement Ist field validation.-- OK
  - 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, Status)
    Ist -- OK
    Wer -- FAILED (is 'Abert Franz' should be 'Muster Hans')
    Status -- OK
  - update VA Bereinigung (Ist, Wer, Status) -- OK
  
  - update ZF Erstellen (Ist, Wer) -- OK
  - update ZF Prüfbericht (Ist, Wer, Status) -- OK
  - update ZF Freigabe (Ist, Wer, Status) -- OK
  
  - update GA Versand (Ist, Wer) -- OK
  - update GA erhalten von BL (Ist, Wer, Status) -- OK
  - update GA übergeben an UN (Ist, Wer, Status) -- OK
  
  
Save Selected
-------------

  - update document code -- OK
  - update title (with Umlauts) -- OK
  
  - update VA Erstellen Soll -- OK
  - update VA Stellungnahme Status -- OK
  - update VA Stellungnahme Dauer -- OK
  - update VA Stellungnahme Soll -- OK
  - update VA Bereinigung Status -- OK
  - update VA Bereinigung Dauer -- OK
  - update VA Bereinigung Soll -- OK
  
  - update ZF Erstellen Dauer -- OK
  - update ZF Erstellen Soll -- OK
  - update ZF Prüfbericht Status -- OK
  - update ZF Prüfbericht Dauer -- OK
  - update ZF Prüfbericht Soll -- OK
  - update ZF Freigabe Status -- OK
  - update ZF Freigabe Dauer -- OK
  - update ZF Freigabe Soll -- OK
  
  - update GA erhalten von BL Status -- OK
  - update GA erhalten von BL Dauer -- OK
  - update GA übergeben an UN Status -- OK
  - update GA übergeben an UN Dauer -- OK
  - update GA übergeben an UN Soll -- OK


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

  -- OK