| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| '''Version''' 1, 2011-03-24 (AH) |
'''Version''' 2, 2011-05-20 (AH) '''Ref''' Prj-E-6-01-610-221-00_0004-Anl-v02 |
| Line 11: | Line 12: |
|
= Status of the Excel Integration = == Recently Completed Features == 1. The three Excel files have been reduced to a single file 1. ''Search Document'' -- The performance have been slightly improved 1. ''Create New Document'' -- Implemented (see the warning below) 1. ''Get Next Sequence Number'' -- Implemented 1. ''Check for Duplicates'' -- Now highlights the left-most cell and creates a cell comment indicating which rows are duplicates 1. Menu items that access the server now check for duplicates before the server access is performed. 1. The hidden worksheets are now hidden, and the system starts with a blank worksheet == Limitations of the Excel VBA Code == The following features are not completely implemented and/or not well-tested: 1. There is a new comlumn ''Status/DrawMGT-Nr.'', which contains the DrawMGT's internal document id (which is blank for new docume ts). This field has the background color set based on the document status (which is new and not completely tested) as follows: * '''Grey''' = OK * '''Ping''' = Error, typically a duplicate document * '''Yellow''' = Warning, typically ''not saved'' or ''cell changed'' 1. Cells with a light-orange color are meant to be read-only, this is a temporary solution to avoid slowing the developement effor . Protecting worksheets is a time consuming exercise. Currently the following fields are set to read-only: * Calculated field, typically ''Soll'' date fields * ''Bereich'' and ''Vorabzug ja/nein''. When the Vorabzug ja/nein menu is changed then all the Vorabzug fields will be locked/u locked. This code is not well-tested, and also does not set the revision code correctly. 1. There is a bug with ''Create New Document'', when you create a new document, you '''must select a cell in row 17 or below'''. O herwise it will be impossible to save the document. 1. The validation of the ''Ist'' date sequence is implemented, but not extensively tested, there may be bugs. 1. Re-loading data, using ''Search Documents'' into an existing list is not extensively tested and we have seen at least one bug. == Columns Not Implemented == The following worksheet columns are not implemented (and have a dark grey background): 1. The ''Q-Eklaerung'' column 1. Links to ''Grundlagen'' documents 1. The ''Format'' column 1. The ''Vorabzug ja/nein'' column - Currently has a bug where the revision codes are not reset currectly 1. The ''Stn-Nr'' column 1. The ''Art'' (''Pruefungsart'') column 1. The ''Pruef-Nr'' column = Operation = == Startup == 1. Open the Excel file '''LinthalDrawmgt-Planning-1.xlsm''' 1. Click on the ''DrawMGT'' menu. == Menu Items == 1. Server 1. '''Login''' - Login into the DrawMGT server 1. '''Logout''' - Logout from server 1. Save 1. '''Save Selected''' - Save all rows to server (see below) 1. '''Save All''' - Save selected rows to server (see below) 1. Search 1. '''Search Documents''' - Displays a search form. See below for details 1. '''Refresh Selected''' - Refresh selected rows (local data) with latest data from server (see below) 1. '''Refresh All''' - Refresh all rows (local data) with latest data from server (see below) 1. Edit 1. '''Create New Document''' - Create a new document at the selected row (make sure it is at or below row 18!) 1. '''Duplicated Selected''' - Duplicate the selected rows 1. '''Get Next Sequence''' - Get the sequence Lauf-Nr. for the selected rows 1. '''Restart Revision Sequence''' - Assign the text set of revision codes to the selected rows 1. '''Check for Duplicates''' - Check for duplicate documents. Checks the DrawMGT-Nr. and the Documentindex 1. '''Refresh Attributes''' - Functions correctly, but is very slow (it downloads many thousands of records!) 1. '''Test''' 1. '''Test Cases''' - Displays a list of regression test cases (''do not use'') Operations on all and selected rows: * '''All Rows''' - Operation works on all rows in the spreadsheet * '''All Rows''' - Operation works on rows where any cell in the row is selected. The selection does not need to be contiguous. For both cases the header rows and empty rows are ignored. E.g. if you select cells in the header or empty rows nothing bad happens. == Login == 1. Select menu item: '''DrawMGT --> Login''' 1. Enter DrawMGT user name and password 1. A confirmation dialog is presented if the login is successful == Search for and Display Data == 1. Select menu item: '''DrawMGT --> Search Documents''' 1. A search dialog is displayed: Enter the following search criterion: 1. '''Rapport''' - Select '''Bau''' 1. '''Bereich''' - Select '''LA2''' 1. '''Kontakt''' - Select '''213''' 1. '''Laufnummer''' - Select '''1000 --> 1020''', or select a smaller range (2002 -> 2006) if you want quicker results. Note that the search and display of data is slow, and that a number of hidden rows and columns are displayed during the processing p riod. This is because the Excel screen updating (e.g. recalculation) is enabled during the data processing. This was done to assist he testing and development process. After the search processing completes, the hidden cells and rows are hidden, and a list of approximately 15 documents is displayed. The header contains sections for the document and its ''vorabzug, zur Freigabe'' and ''gut zur Ausfuerhung'' revisions. Features: 1. The date calculation, based on the T0 and delta values is implemented. You should change T0 and the delta values, not the ''Soll ' dates 1. Automatic creation of the ''Drawing Code'', based on classification menu settings and the ''Laufnummer'' and ''Teil'' is impleme ted 1. Status menus are implemented 1. Title, scale and other text fields are implemented == Updating Data and Saving It to Server == You can change data for documents and revisions. === Scenarios === 1. Change the value of the '''T0''' field and observe that the ''Soll'' dates change. 1. Change the value of the ''Delta'' fields and observer that preceding ''Soll'' dates change. 1. Set the ''Ist'' date for the ''Vorabzug Erstellen'' 1. Set the ''Ist'' date and ''Status'' (to non-''Offen'') for the ''Vorabzug Stellungnahme'' 1. You can also change the ''Wer'' columns. Note that the user list is displayed based on the user roles in the server 1. Change the values in the ''Resourcenplannung'' and ''Verteiler''. Notes: 1. The ''Resourcenplannung'' ''von'' and ''bis'' dates are calculated base on the ''T0'' value and should not be changed manual y. 1. The ''gut zur Ausfuerhung'' revision fields: ''Verteiler-Ext'' and ''Verteiler-Ablage'' are not saved correctly (a bug) To '''save''' data there are two choices: 1. Select the menu item '''Save All'''. All rows will be saved 1. Select cells in rows that should be saved and press the menu item '''Save Selected''' === Restrictions === Given the limited test data observe the following restrictions: 1. The ''Bereich'' for a document that has already been saved 1. Do not change ''Ver'' (revision code) 1. You can copy entire rows of data and the check for duplicats flag them. It will not be possible to save copied rows, unless: * No DrawMGT-Nr. is assigned to the rows (in Col R) * You must change the documet codes to avoid duplicates == Refresh Data == If data is changed on the server, then it is possible to ''refresh'' rows in the planning spreadsheet, so that they are updated with the latest server data. To '''reshresh''' data there are two choices: 1. Select the menu item '''Refresh All'''. All rows will be refreshed 1. Select cells in rows that should be refreshed and press the menu item '''Refresh Selected''' When data is refreshed, all document and revision data for the row is downloaded and displayed in the corresponding Excel cells. If ifferences occur, then the cell contains the server (new) value and a cell note is appended to the cell with the original (old) spre dsheet value. = Demo Script = 1. '''DrawMGT Display''' 1. Change to Bereiche '''LA2''' 1. DrawMGT menu: '''Dokumente --> Suchen''' * ''Bereich'' - '''Aktueller Bereich''' * ''Kontakt'' - '''213''' * ''Laufnummer'' - '''1000 --> 1020''' 1. Select document '''LA2-E-6-03-351-213-10_0003-v__''' * Display workflow detail for revision '''V__''', the ''Vorabzug'' 1. '''Excel Download''' 1. Menu item: '''Search Documents''' * ''Rapport'' - Select '''Bau''' * ''Bereich'' - Select '''LA2''' * ''Kontakt'' - Select '''213''' * ''Laufnummer'' - Select '''1002 --> 1005''' 1. '''Excel Update''' 1. Find row (probably row 15) for '''LA2-E-6-03-351-213-10_0003''' 1. Update ''T0'' and ''Delta'' value: * Column CO(341): ''T0'': Change date to three days earlier * Column AS(28): ''Delta7'': Change from 28 to 25 1. Complete workflow steps ''Vorabzug Erstellen'' and ''Stellungnahme'' * Column AQ(29): ''Erstellen Ist'': Set date one month ago * Column AR(29): ''Erstellen Wer'': Change user * Column AV(33): ''Stellungnahme Ist'': Set today's date * Column AW(34): ''Stellungnahme Wer'': Change user * Column AX(35): ''Stellungnahme Status'': ''keine Bermerkungen'' 1. Update ''Resourcenplannung'' and ''Verteiler'' fields * Column CQ(49): ''Planner CAD'': Change from 25 to 28 * Column CS(51): ''Planner PL'': Change from 6 to 7 1. '''Excel Save''' 1. Select a cell in the row containing '''LA2-E-6-03-351-213-10_0003''' 1. Menu item: '''Save Selected''' 1. '''DrawMGT Re-Display''' 1. Refresh web screen for revision '''LA2-E-6-03-351-213-10_0003-v__''' 1. Verify changes from Excel displayed 1. '''DrawMGT Update''' 1. In web screen for '''LA2-E-6-03-351-213-10_0003-v__''' 1. Button '''Aendern''' * Change ''Stellunnahme Dauer'' (Delta7): from 25 to 29 * Save 1. '''Excel Refresh''' 1. Select a cell in the row containing '''LA2-E-6-03-351-213-10_0003''' 1. Menu item: '''Refresh Selected''' 1. Verify ''Delta7'' changed to 29 and that the old value in the cell note is 25 |
|
| Line 57: | Line 277: |
|
= Limitations of the Excel VBA Code = The following columns are not implemented: 1. The ''Contract'' menu - The menu is implemented and changes will cause user lists in the the ''Wer'' menus to change, but this is not extensively tested, and due to the ''Gruppe'' menu not being complete, could lead to data that causes validation errors on the server. 1. The ''Gruppe'' columne - The menu is not implemented 1. Links to ''Grundlagen'' documents 1. The ''Format'' column 1. The ''Vorabzug ja/nein'' column 1. The ''Stn-Nr'' column 1. The ''Art'' (''Pruefungsart'') column 1. The ''Pruef-Nr'' column 1. The ''Q-Eklaerung'' column 1. The ''Verteiler Ext'' and ''Ablage/Archiv'' columns associated with ''gut zur Ausfuerhung'' revision The following features are not completely implemented and/or tested: 1. Client side cross-field validation of workflow steps. E.g. there is no checking when you make a workflow step update to make sure that the preceding and subsequent workflow steps have are compatible with the change. 1. The server-side ''revision date'' is not set, this is because of a ''race condition'', which can occur and cause server-side validation error. The problem is that if you change multiple revision dates for the same document, the sequence of saving records (server-side) leads to validation errors when the first revision is saved, but the second revision (before being saved) is out of sequence. 1. The record update count (record serial number) field processing is implemented but not completely tested, it is not recommended to do simultaneous updates on the server and client. Do a refresh in Excel if you update records on the server. = Basic Operation = This section describe operations that can be performed for the demo: == Startup == The following three files should be installed in the same directory: 1. '''LinthalDrawMGT-Template-1.xlsm''' - An example planning workbook 1. '''LinthalDrawMGT-Menu-1.xlsm''' - Lightweight Excel ''AddIn'' that installs the DrawMGT Excel Ribbon (menu) 1. '''LinthalDrawMGT-Template-1.xlsm''' - An Excel VBA ''AddIn'' that contains the library code that implements the Excel Interface Procedure 1. Open the '''Template''' file: 1. Watch in the lower message area in the Excel screen (at the bottom) and verify that Excel opens the '''Menu''' and '''Lib''' files. 1. Excel will display an example document list and a number of ''hidden'' worksheets (these worksheets will not be displayed in the production version). 1. Verify there is a new ''Ribbon'' (menu) called '''DrawMGT''' next to the Start menu. == Menu Items == 1. Server 1. '''Login''' - Login into the DrawMGT server 1. '''Logout''' - Logout from server 1. '''Set Server''' - ''not enabled for demo'' 1. Data 1. '''Search Documents''' - Displays a search form. See below for details 1. '''Refresh Attributes''' - ''not enabled for for demo'' 1. Edit 1. '''Get Next Sequence''' - ''not enabled for demo'' 1. '''Refresh Selected''' - Refresh selected rows (local data) with latest data from server (see below) 1. '''Refresh All''' - Refresh all rows (local data) with latest data from server (see below) 1. '''Duplicated Selected''' - ''not enabled for demo'' 1. '''Check for Duplicates''' - ''not enabled for demo'' 1. Save 1. '''Save Selected''' - Save all rows to server (see below) 1. '''Save All''' - Save selected rows to server (see below) 1. '''Test''' 1. '''Test Cases''' - Displays a list of regression test cases (''do not use'') Operations on all and selected rows: * '''All Rows''' - Operation works on all rows in the spreadsheet * '''All Rows''' - Operation works on rows where any cell in the row is selected. The selection does not need to be contiguous. For both cases the header rows and empty rows are ignored. E.g. if you select cells in the header or empty rows nothing bad happens. == Login == 1. Select menu item: '''DrawMGT --> Login''' 1. Enter DrawMGT user name and password 1. A confirmation dialog is presented if the login is successful == Search for and Display Data == 1. Select menu item: '''DrawMGT --> Search Documents''' 1. A search dialog is displayed: Enter the following search criterion: 1. '''Rapport''' - Select '''Bau''' 1. '''Bereich''' - Select '''LA2''' 1. '''Kontakt''' - Select '''213''' 1. '''Laufnummer''' - Select '''1000 --> 1020''', or select a smaller range (2002 -> 2006) if you want quicker results. Note that the search and display of data is slow, and that a number of hidden rows and columns are displayed during the processing period. This is because the Excel screen updating (e.g. recalculation) is enabled during the data processing. This was done to assist the testing and development process. After the search processing completes, the hidden cells and rows are hidden, and a list of approximately 15 documents is displayed. The header contains sections for the document and its ''vorabzug, zur Freigabe'' and ''gut zur Ausfuerhung'' revisions. Features: 1. The date calculation, based on the T0 and delta values is implemented. You should change T0 and the delta values, not the ''Soll'' dates 1. Automatic creation of the ''Drawing Code'', based on classification menu settings and the ''Laufnummer'' and ''Teil'' is implemented 1. Status menus are implemented 1. Title, scale and other text fields are implemented == Updating Data and Saving It to Server == You can change data for documents and revisions. === Scenarios === 1. Change the value of the '''T0''' field and observe that the ''Soll'' dates change. 1. Change the value of the ''Delta'' fields and observer that preceding ''Soll'' dates change. 1. Set the ''Ist'' date for the ''Vorabzug Erstellen'' 1. Set the ''Ist'' date and ''Status'' (to non-''Offen'') for the ''Vorabzug Stellungnahme'' 1. You can also change the ''Wer'' columns. Note that the user list is displayed based on the user roles in the server 1. Change the values in the ''Resourcenplannung'' and ''Verteiler''. Notes: 1. The ''Resourcenplannung'' ''von'' and ''bis'' dates are calculated base on the ''T0'' value and should not be changed manually. 1. The ''gut zur Ausfuerhung'' revision fields: ''Verteiler-Ext'' and ''Verteiler-Ablage'' are not saved correctly (a bug) To '''save''' data there are two choices: 1. Select the menu item '''Save All'''. All rows will be saved 1. Select cells in rows that should be saved and press the menu item '''Save Selected''' === Restrictions === Given the limited test data observe the following restrictions: 1. ''Document code'', you can demonstrate the document classification menus, and that the document code is automatically updated basedon the menu setings and ''Laufnummer'' and ''Teil'', but don't save the document if the code is changed (this has not been extensively tested). 1. The ''Bereich'' or ''Gruppe'' - These menus are not completely implemented 1. Do not change ''Ver'' (revision code) 1. Do not copy and paste rows of data == Refresh Data == If data is changed on the server, then it is possible to ''refresh'' rows in the planning spreadsheet, so that they are updated with the latest server data. To '''reshresh''' data there are two choices: 1. Select the menu item '''Refresh All'''. All rows will be refreshed 1. Select cells in rows that should be refreshed and press the menu item '''Refresh Selected''' When data is refreshed, all document and revision data for the row is downloaded and displayed in the corresponding Excel cells. If differences occur, then the cell contains the server (new) value and a cell note is appended to the cell with the original (old) spreadsheet value. Limitation: The difference checking has bugs for dates (due to the different date formats) and cell comments are often created when the date has not changed. = Demo Script = 1. '''DrawMGT Display''' 1. Change to Bereiche '''LA2''' 1. DrawMGT menu: '''Dokumente --> Suchen''' * ''Bereich'' - '''Aktueller Bereich''' * ''Kontakt'' - '''213''' * ''Laufnummer'' - '''1000 --> 1020''' 1. Select document '''LA2-E-6-03-351-213-10_0003-v__''' * Display workflow detail for revision '''V__''', the ''Vorabzug'' 1. '''Excel Download''' 1. Menu item: '''Search Documents''' * ''Rapport'' - Select '''Bau''' * ''Bereich'' - Select '''LA2''' * ''Kontakt'' - Select '''213''' * ''Laufnummer'' - Select '''1002 --> 1005''' 1. '''Excel Update''' 1. Find row (probably row 15) for '''LA2-E-6-03-351-213-10_0003''' 1. Update ''T0'' and ''Delta'' value: * Column CO(341): ''T0'': Change date to three days earlier * Column AS(28): ''Delta7'': Change from 28 to 25 1. Complete workflow steps ''Vorabzug Erstellen'' and ''Stellungnahme'' * Column AQ(29): ''Erstellen Ist'': Set date one month ago * Column AR(29): ''Erstellen Wer'': Change user * Column AV(33): ''Stellungnahme Ist'': Set today's date * Column AW(34): ''Stellungnahme Wer'': Change user * Column AX(35): ''Stellungnahme Status'': ''keine Bermerkungen'' 1. Update ''Resourcenplannung'' and ''Verteiler'' fields * Column CQ(49): ''Planner CAD'': Change from 25 to 28 * Column CS(51): ''Planner PL'': Change from 6 to 7 1. '''Excel Save''' 1. Select a cell in the row containing '''LA2-E-6-03-351-213-10_0003''' 1. Menu item: '''Save Selected''' 1. '''DrawMGT Re-Display''' 1. Refresh web screen for revision '''LA2-E-6-03-351-213-10_0003-v__''' 1. Verify changes from Excel displayed 1. '''DrawMGT Update''' 1. In web screen for '''LA2-E-6-03-351-213-10_0003-v__''' 1. Button '''Aendern''' * Change ''Stellunnahme Dauer'' (Delta7): from 25 to 29 * Save 1. '''Excel Refresh''' 1. Select a cell in the row containing '''LA2-E-6-03-351-213-10_0003''' 1. Menu item: '''Refresh Selected''' 1. Verify ''Delta7'' changed to 29 and that the old value in the cell note is 25 |
Excel Integration - Axpo Demo Notes
Version 2, 2011-05-20 (AH) Ref Prj-E-6-01-610-221-00_0004-Anl-v02
Contents
Systems
http://linthal.softxs.ch/beta -- Combined Beta system
http://linthal.softxs.ch/dev/linthal115dev - Development system
Status of the Excel Integration
Recently Completed Features
- The three Excel files have been reduced to a single file
Search Document -- The performance have been slightly improved
Create New Document -- Implemented (see the warning below)
Get Next Sequence Number -- Implemented
Check for Duplicates -- Now highlights the left-most cell and creates a cell comment indicating which rows are duplicates
- Menu items that access the server now check for duplicates before the server access is performed.
- The hidden worksheets are now hidden, and the system starts with a blank worksheet
Limitations of the Excel VBA Code
The following features are not completely implemented and/or not well-tested:
There is a new comlumn Status/DrawMGT-Nr., which contains the DrawMGT's internal document id (which is blank for new docume ts). This field has the background color set based on the document status (which is new and not completely tested) as follows:
Grey = OK
Ping = Error, typically a duplicate document
Yellow = Warning, typically not saved or cell changed
- Cells with a light-orange color are meant to be read-only, this is a temporary solution to avoid slowing the developement effor . Protecting worksheets is a time consuming exercise. Currently the following fields are set to read-only:
Calculated field, typically Soll date fields
Bereich and Vorabzug ja/nein. When the Vorabzug ja/nein menu is changed then all the Vorabzug fields will be locked/u locked. This code is not well-tested, and also does not set the revision code correctly.
There is a bug with Create New Document, when you create a new document, you must select a cell in row 17 or below. O herwise it will be impossible to save the document.
The validation of the Ist date sequence is implemented, but not extensively tested, there may be bugs.
Re-loading data, using Search Documents into an existing list is not extensively tested and we have seen at least one bug.
Columns Not Implemented
The following worksheet columns are not implemented (and have a dark grey background):
The Q-Eklaerung column
Links to Grundlagen documents
The Format column
The Vorabzug ja/nein column - Currently has a bug where the revision codes are not reset currectly
The Stn-Nr column
The Art (Pruefungsart) column
The Pruef-Nr column
Operation
Startup
Open the Excel file LinthalDrawmgt-Planning-1.xlsm
Click on the DrawMGT menu.
Menu Items
- Server
Login - Login into the DrawMGT server
Logout - Logout from server
- Save
Save Selected - Save all rows to server (see below)
Save All - Save selected rows to server (see below)
- Search
Search Documents - Displays a search form. See below for details
Refresh Selected - Refresh selected rows (local data) with latest data from server (see below)
Refresh All - Refresh all rows (local data) with latest data from server (see below)
- Edit
Create New Document - Create a new document at the selected row (make sure it is at or below row 18!)
Duplicated Selected - Duplicate the selected rows
Get Next Sequence - Get the sequence Lauf-Nr. for the selected rows
Restart Revision Sequence - Assign the text set of revision codes to the selected rows
Check for Duplicates - Check for duplicate documents. Checks the DrawMGT-Nr. and the Documentindex
Refresh Attributes - Functions correctly, but is very slow (it downloads many thousands of records!)
Test
Test Cases - Displays a list of regression test cases (do not use)
Operations on all and selected rows:
All Rows - Operation works on all rows in the spreadsheet
All Rows - Operation works on rows where any cell in the row is selected. The selection does not need to be contiguous.
For both cases the header rows and empty rows are ignored. E.g. if you select cells in the header or empty rows nothing bad happens.
Login
Select menu item: DrawMGT --> Login
- Enter DrawMGT user name and password
- A confirmation dialog is presented if the login is successful
Search for and Display Data
Select menu item: DrawMGT --> Search Documents
- A search dialog is displayed: Enter the following search criterion:
Rapport - Select Bau
Bereich - Select LA2
Kontakt - Select 213
Laufnummer - Select 1000 --> 1020, or select a smaller range (2002 -> 2006) if you want quicker results.
Note that the search and display of data is slow, and that a number of hidden rows and columns are displayed during the processing p riod. This is because the Excel screen updating (e.g. recalculation) is enabled during the data processing. This was done to assist he testing and development process.
After the search processing completes, the hidden cells and rows are hidden, and a list of approximately 15 documents is displayed.
The header contains sections for the document and its vorabzug, zur Freigabe and gut zur Ausfuerhung revisions.
Features:
The date calculation, based on the T0 and delta values is implemented. You should change T0 and the delta values, not the Soll ' dates
Automatic creation of the Drawing Code, based on classification menu settings and the Laufnummer and Teil is impleme ted
- Status menus are implemented
- Title, scale and other text fields are implemented
Updating Data and Saving It to Server
You can change data for documents and revisions.
Scenarios
Change the value of the T0 field and observe that the Soll dates change.
Change the value of the Delta fields and observer that preceding Soll dates change.
Set the Ist date for the Vorabzug Erstellen
Set the Ist date and Status (to non-Offen) for the Vorabzug Stellungnahme
You can also change the
Change the values in the Resourcenplannung and Verteiler. Notes: The
Resourcenplannung von and bis dates are calculated base on the T0 value and should not be changed manual y.
The gut zur Ausfuerhung revision fields: Verteiler-Ext and Verteiler-Ablage are not saved correctly (a bug)
To save data there are two choices:
Select the menu item Save All. All rows will be saved
Select cells in rows that should be saved and press the menu item Save Selected
Restrictions
Given the limited test data observe the following restrictions:
The Bereich for a document that has already been saved
Do not change Ver (revision code)
- You can copy entire rows of data and the check for duplicats flag them. It will not be possible to save copied rows, unless:
- No DrawMGT-Nr. is assigned to the rows (in Col R)
- You must change the documet codes to avoid duplicates
Refresh Data
If data is changed on the server, then it is possible to refresh rows in the planning spreadsheet, so that they are updated with the latest server data. To reshresh data there are two choices: Select the menu item Refresh All. All rows will be refreshed Select cells in rows that should be refreshed and press the menu item Refresh Selected When data is refreshed, all document and revision data for the row is downloaded and displayed in the corresponding Excel cells. If ifferences occur, then the cell contains the server (new) value and a cell note is appended to the cell with the original (old) spre dsheet value.
DrawMGT Display Change to Bereiche LA2 DrawMGT menu: Dokumente --> Suchen Select document LA2-E-6-03-351-213-10_0003-v Display workflow detail for revision V, the Excel Download Menu item: Search Documents Excel Update Find row (probably row 15) for LA2-E-6-03-351-213-10_0003 Update Column CO(341): Column AS(28): Complete workflow steps Column AQ(29): Column AR(29): Column AV(33): Column AW(34): Column AX(35): Update Column CQ(49): Column CS(51): Excel Save Select a cell in the row containing LA2-E-6-03-351-213-10_0003 Menu item: Save Selected DrawMGT Re-Display Refresh web screen for revision LA2-E-6-03-351-213-10_0003-v DrawMGT Update In web screen for LA2-E-6-03-351-213-10_0003-v Button Aendern Change Excel Refresh Select a cell in the row containing LA2-E-6-03-351-213-10_0003 Menu item: Refresh Selected Verify
Fifteen LA2 documents have been entered into the The document codes for the test data are: Note that each document is a copy of an existing document aby adding 1000 to the LA2-E-6-03-351-213-10_1002 copied from LA2-E-6-03-351-213-10_0002 You can view the documents with the following search: Change to DrawMGT menu: Dokumente --> Suchen Note that this displays all revisions associated with these documents: Revision Code Description v_B GA gut zur Ausfuehrung v_A ZF zur Freigabe v__ VA Vorabzug When you display the revision detail, a new bock is shown which contains the
The Excel code has been tested on different versions of Windows and Excel. The only know limitation is that the VBA code does not yet work with Excel 2003.
Not tested
Demo Script
Bereich - Aktueller Bereich
T0: Change date to three days earlier
Erstellen Ist: Set date one month ago
Planner CAD: Change from 25 to 28 Test Data
Bereiche LA2
Compatibility Testing Notes
Excel Versions Tested
Excel 2007 and Excel 2010 Windows Versions and Languages Tested
Windows 7, German and English