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