Excel Integration - Testing Notes
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