Difference between revisions of "Merging the Wrong Tasks into a Chart for Version 7.0 - OnePager Pro"

From OnePager Documentation
Jump to: navigation, search
(Related Links)
Line 1: Line 1:
 
==About Merging the Wrong Tasks into a Chart==
 
==About Merging the Wrong Tasks into a Chart==
  
1) OnePager Pro ('''OPP''') can consistently create snapshots from period to period with '''updated''' information from a Microsoft Project '''source plan'''.  
+
OnePager Pro ('''OPP''') can consistently create snapshots from period to period with '''updated''' information from a Microsoft Project '''source plan'''. The tasks and milestones that are '''imported''' to OnePager in '''UPDATE''' mode should be the same set of tasks and milestones with, perhaps, some '''added or removed''' as the project moves forward.  
 
+
2) The tasks and milestones that are '''imported''' to OnePager in '''UPDATE''' mode should be the same set of tasks and milestones with, perhaps, some '''added or removed''' as the project moves forward.  
+
  
 
===Microsoft Project's UniqueID Field===
 
===Microsoft Project's UniqueID Field===
  
3) OnePager Pro tracks tasks and milestones from snapshot to snapshot though the Microsoft Project '''UniqueID''' field in the '''source plan'''.   
+
OnePager Pro tracks tasks and milestones from snapshot to snapshot though the Microsoft Project '''UniqueID''' field in the '''source plan'''.  The '''UniqueID''' is created by Microsoft Project and is part of each '''.mpp file'''.  The '''UniqueID''' field and its associated values are:
 
+
4)The '''UniqueID''' is created by Microsoft Project and is part of each '''.mpp file'''.   
+
 
+
5) The '''UniqueID''' field and its associated values are:
+
 
+
:a) Displayable by Microsoft Project,
+
 
+
:b) Automatically '''imported''' by OnePager Pro with other task and milestone related data.
+
  
:c) Used by OnePager Pro to '''match''' tasks and milestones  from one snapshot with '''Updated''' '''source plan''' data '''imported''' to either '''replace''' the snapshot or to '''add''' a snapshot consistent with previous snapshots.  
+
:* Displayable by Microsoft Project,
 +
:* Automatically '''imported''' by OnePager Pro with other task and milestone related data.
 +
:* Used by OnePager Pro to '''match''' tasks and milestones  from one snapshot with '''Updated''' '''source plan''' data '''imported''' to either '''replace''' the snapshot or to '''add''' a snapshot consistent with previous snapshots.  
  
6) For more information pertaining to '''UniqueID''', their significance in Microsoft Project '''source plans''', and their role within OnePager Pro, please see the links at: [[Merging the Wrong Tasks into a Chart for Version 7.0 - OnePager Pro#OnePager Blog Posts | OnePager Blog Posts]] 7.11.1-70.
+
For more information pertaining to '''UniqueID''', their significance in Microsoft Project '''source plans''', and their role within OnePager Pro, please see the links at: [[Merging the Wrong Tasks into a Chart for Version 7.0 - OnePager Pro#OnePager Blog Posts | OnePager Blog Posts]] 7.11.1-70.
  
 
===Setting Your Warning Thresholds===
 
===Setting Your Warning Thresholds===
  
7) Sometimes you can make the mistake of accidentally '''updating''' a chart with tasks and milestones from the '''wrong''' Microsoft Project '''source plan'''.  
+
Sometimes you can make the mistake of accidentally '''updating''' a chart with tasks and milestones from the '''wrong''' Microsoft Project '''source plan'''.   Or with the '''wrong''' set of tasks and milestones from the right Microsoft Project '''source plan''' if you are making several charts from the same Microsoft Project '''source plan''' using several different '''Flag''' fields. When any of these situations arise, OnePager detects them by using the '''UniqueID''' field from the '''source plan''' to determine if '''additional''' tasks and milestones are being '''imported''' or if tasks and milestones are '''missing''' from the '''imported source plan''' supporting the '''update'''. '''Additional or missing''' tasks and milestones can cause the chart to suddenly appear '''messed up''' because it now displays many '''added new''' tasks and milestones that reside in many new '''rows and swimlanes'''.  Even the earlier snapshots are affected by these new '''rows and swimlanes'''. 
  
8) Or with the '''wrong''' set of tasks and milestones from the right Microsoft Project '''source plan''' if you are making several charts from the same Microsoft Project '''source plan''' using several different '''Flag''' fields.  
+
A similar '''messed up''' chart can result from '''missing''' tasks and milestones as well. When this happens, the best idea is to immediately press the '''Undo''' button above the OnePager ribbon.  This action immediately '''restores''' the chart to how it was before all the unfamiliar tasks and milestones were '''merged'''.  Or you can simply '''close''' the '''messed up''' chart without '''saving''' it.  When you '''reopen''' the chart, the erroneous '''update''' is gone.
  
9) When any of these situations arise, OnePager detects them by using the '''UniqueID''' field from the '''source plan''' to determine if '''additional''' tasks and milestones are being '''imported''' or if tasks and milestones are '''missing''' from the '''imported source plan''' supporting the '''update'''.
+
To avoid this problem in the first place, OnePager can '''warn''' you before the '''wrong''' tasks and milestones are '''incorporated''' into the chart. To receive this '''warning''', there is a checkbox in the '''Chart Properties''' form's '''Advanced''' tab that when checked '''ON''' assures that the '''Warning''' message shown below is displayed.  The '''Chart Properties''' form's '''Advanced''' tab with the '''Set warning thresholds''' form is shown here:
 
+
10) '''Additional or missing''' tasks and milestones can cause the chart to suddenly appear '''messed up''' because it now displays many '''added new''' tasks and milestones that reside in many new '''rows and swimlanes'''.
+
 
+
11) Even the earlier snapshots are affected by these new '''rows and swimlanes'''. 
+
 
+
12) A similar '''messed up''' chart can result from '''missing''' tasks and milestones as well.
+
 
+
13) When this happens, the best idea is to immediately press the '''Undo''' button above the OnePager ribbon. 
+
 
+
14) This action immediately '''restores''' the chart to how it was before all the unfamiliar tasks and milestones were '''merged'''. 
+
 
+
15) Or you can simply '''close''' the '''messed up''' chart without '''saving''' it. 
+
 
+
16) When you '''reopen''' the chart, the erroneous '''update''' is gone.
+
 
+
17) To avoid this problem in the first place, OnePager can '''warn''' you before the '''wrong''' tasks and milestones are '''incorporated''' into the chart.  
+
 
+
18) To receive this '''warning''', there is a checkbox in the '''Chart Properties''' form's '''Advanced''' tab that when checked '''ON''' assures that the '''Warning''' message shown below is displayed.   
+
 
+
19) The '''Chart Properties''' form's '''Advanced''' tab with the '''Set warning thresholds''' form is shown here:
+
  
 
<center>[[File:P70-7_11_1-(1)-05052020.png]]</center>
 
<center>[[File:P70-7_11_1-(1)-05052020.png]]</center>
 
<center>P70-7_11_1-(1)-05052020.png</center>
 
<center>P70-7_11_1-(1)-05052020.png</center>
  
20) The settings in the '''Set warning thresholds''' form are expressed in terms of percentage of '''extra tasks and milestones added''' and '''tasks and milestones that are missing'''.
+
The settings in the '''Set warning thresholds''' form are expressed in terms of percentage of '''extra tasks and milestones added''' and '''tasks and milestones that are missing'''.  If, during a '''merge''' operation these thresholds are exceeded, the '''warning message''' is displayed. You also have the option to set the '''warning thresholds''' in the '''Template Properties''' form's '''Advanced''' tab. The article links below provide more information on these topics:
 
+
21) If, during a '''merge''' operation these thresholds are exceeded, the '''warning message''' is displayed.
+
 
+
22) You also have the option to set the '''warning thresholds''' in the '''Template Properties''' form's '''Advanced''' tab.
+
 
+
23) The article links below provide more information on these topics:
+
  
 
<center>
 
<center>
Line 74: Line 40:
 
====Setting Warning Thresholds====
 
====Setting Warning Thresholds====
  
1) The '''Advanced''' tab of the '''Chart Properties''' form has a checkbox titled '''Warn of merging tasks''' as shown in the previous section.  This checkbox is accompanied by the '''Warning options''' button to the right.
+
The '''Advanced''' tab of the '''Chart Properties''' form has a checkbox titled '''Warn of merging tasks''' as shown in the previous section.  This checkbox is accompanied by the '''Warning options''' button to the right. When this checkbox is checked '''ON''', the button is active and when the '''Warning options''' button is clicked it accesses the '''Set warning thresholds''' form where you can set the '''percentage of extra and missing tasks''' necessary to provide you with the '''warning message''' discussed below.  
 
+
2) When this checkbox is checked '''ON''', the button is active and when the '''Warning options''' button is clicked it accesses the '''Set warning thresholds''' form where you can set the '''percentage of extra and missing tasks''' necessary to provide you with the '''warning message''' discussed below.  
+
  
 
<center>[[File:P70-7_11_1-70-(2)-08212019.png]]</center>
 
<center>[[File:P70-7_11_1-70-(2)-08212019.png]]</center>
 
<center>P70-7_11_1-70-(2)-08212019.png</center>
 
<center>P70-7_11_1-70-(2)-08212019.png</center>
  
3)  '''Extra tasks''' are tasks that are present in the '''imported''' '''source plan''' but are not present in the '''current chart'''.  
+
'''Extra tasks''' are tasks that are present in the '''imported''' '''source plan''' but are not present in the '''current chart'''.  '''Missing tasks''' are tasks that are present in the '''current chart''' but are not present in the '''imported''' '''source plan'''. Setting these percentages to 100% has the impact of turning the '''fixes and warnings off'''. Setting the percentages to 0% provides an assurance that '''any extra or missing tasks''' triggers the '''fixes and warnings''' feature.
 
+
4) '''Missing tasks''' are tasks that are present in the '''current chart''' but are not present in the '''imported''' '''source plan'''.
+
 
+
5) Setting these percentages to 100% has the impact of turning the '''fixes and warnings off'''.
+
 
+
6) Setting the percentages to 0% provides an assurance that '''any extra or missing tasks''' triggers the '''fixes and warnings''' feature.
+
  
 
====When Merging Tasks Exceed the Thresholds====
 
====When Merging Tasks Exceed the Thresholds====
  
7) When the '''Warn on merging tasks''' checkbox is checked '''ON''' and your workflow involves '''merging''' tasks, OnePager looks to see if '''extra tasks''' are being '''imported''' or if '''missing tasks''' are '''not being imported''' when '''updating''' a snapshot.
+
When the '''Warn on merging tasks''' checkbox is checked '''ON''' and your workflow involves '''merging''' tasks, OnePager looks to see if '''extra tasks''' are being '''imported''' or if '''missing tasks''' are '''not being imported''' when '''updating''' a snapshot. After making the calculation, OnePager shows a '''Warning''' form asking if you want to proceed with the '''update''', '''cancel the update''', or '''try to fix''' tasks that have been misidentified.
 
+
8) After making the calculation, OnePager shows a '''Warning''' form asking if you want to proceed with the '''update''', '''cancel the update''', or '''try to fix''' tasks that have been misidentified.
+
  
 
===Warning Message Form===
 
===Warning Message Form===
  
9) The '''Warning''' message also gives you access to the '''See Extra and Missing Tasks''' form, shown below, so you can actually see the '''extra''' and '''missing''' tasks and milestones and make a fix, if possible.   
+
The '''Warning''' message also gives you access to the '''See Extra and Missing Tasks''' form, shown below, so you can actually see the '''extra''' and '''missing''' tasks and milestones and make a fix, if possible.  OnePager is configured to issue the '''warning''' shown below if either of the thresholds in the '''Set warning thresholds''' form are exceeded.  In this example, the threshold is exceeded because either 100% of the '''imported''' tasks and milestones are '''extra''' or 100% of the existing tasks and milestoones are '''missing''':
 
+
10) OnePager is configured to issue the '''warning''' shown below if either of the thresholds in the '''Set warning thresholds''' form are exceeded.   
+
 
+
11) In this example, the threshold is exceeded because either 100% of the '''imported''' tasks and milestones are '''extra''' or 100% of the existing tasks and milestoones are '''missing''':
+
  
 
<center>[[File:P70-7_11_1-70-(3)-08212019.png]]</center>
 
<center>[[File:P70-7_11_1-70-(3)-08212019.png]]</center>
 
<center>P70-7_11_1-70-(3)-08212019.png</center>
 
<center>P70-7_11_1-70-(3)-08212019.png</center>
  
12) At this point you have three (3) options:
+
At this point you have three (3) options:
  
 
====Continue Import====
 
====Continue Import====
  
13)  Click the '''Continue import''' button to proceed with the '''import'''.   
+
Click the '''Continue import''' button to proceed with the '''import'''.  By doing so you are accepting the differences between the '''current chart''' and the '''imported''' data that are about to '''update''' the chart.  This can lead to both new '''rows''' with new tasks and milestones and '''empty rows''' in the snapshot.
 
+
14) By doing so you are accepting the differences between the '''current chart''' and the '''imported''' data that are about to '''update''' the chart.   
+
 
+
15) This can lead to both new '''rows''' with new tasks and milestones and '''empty rows''' in the snapshot.
+
  
 
====See and Fix It====
 
====See and Fix It====
  
16)  Click the '''See and fix it''' button to take a look at the specific '''extra and missing''' tasks and milestones before deciding to whether to continue or not.   
+
Click the '''See and fix it''' button to take a look at the specific '''extra and missing''' tasks and milestones before deciding to whether to continue or not.  You can sometimes also fix the issue if you notice that an '''extra''' task is actually a '''missing''' task in disguise.  In that case, you can tell OnePager to map a '''missing''' task to the '''extra''' task.  These actions are explained in the '''See Extra and Missing Tasks''' form discussed below.
 
+
17) You can sometimes also fix the issue if you notice that an '''extra''' task is actually a '''missing''' task in disguise.   
+
 
+
18) In that case, you can tell OnePager to map a '''missing''' task to the '''extra''' task.   
+
 
+
19) These actions are explained in the '''See Extra and Missing Tasks''' form discussed below.
+
  
 
====Cancel Import====
 
====Cancel Import====
  
20) As the final option, you can click the '''Cancel import''' button to '''close''' the '''OnePager message''' form above and stop the '''import''' process.
+
As the final option, you can click the '''Cancel import''' button to '''close''' the '''OnePager message''' form above and stop the '''import''' process.
  
 
===Continuing to Import Regardless of Extra or Missing Tasks===
 
===Continuing to Import Regardless of Extra or Missing Tasks===
  
21) Clicking the '''Continue import''' button tells OnePager to proceed with the '''import''' and disregard any differences between the set of '''current''' tasks in the chart and the '''set of selected''' tasks in the '''source plan''' being '''imported'''.   
+
Clicking the '''Continue import''' button tells OnePager to proceed with the '''import''' and disregard any differences between the set of '''current''' tasks in the chart and the '''set of selected''' tasks in the '''source plan''' being '''imported'''.  At the end of the '''import''' operation, you have an '''updated''' snapshot that was either '''added''' to the snapshot list or '''replaced'''.  You can expect to see some '''new rows''' containing the '''extra''' tasks or milestones and some '''empty rows''' corresponding to the '''missing''' tasks or milestones. The latter can be automatically '''hidden''' if you have chosen the option '''Hide newly-empty rows on import''' on the '''Advanced''' tab page of the '''Chart Properties''' form.  For more information on '''hiding empty rows''', please see section in  the article at: [[Advanced Tab for OnePager Pro for Version 7.0#Hiding Empty Rows | Hiding Empty Rows]] 21.13.1-70.
 
+
22) At the end of the '''import''' operation, you have an '''updated''' snapshot that was either '''added''' to the snapshot list or '''replaced'''.   
+
 
+
23) You can expect to see some '''new rows''' containing the '''extra''' tasks or milestones and some '''empty rows''' corresponding to the '''missing''' tasks or milestones.  
+
 
+
24) The latter can be automatically '''hidden''' if you have chosen the option '''Hide newly-empty rows on import''' on the '''Advanced''' tab page of the '''Chart Properties''' form.   
+
 
+
25) For more information on '''hiding empty rows''', please see section in  the article at: [[Advanced Tab for OnePager Pro for Version 7.0#Hiding Empty Rows | Hiding Empty Rows]] 21.13.1-70.
+
  
 
===Using the See Extra and Missing Tasks Form===
 
===Using the See Extra and Missing Tasks Form===
  
26)  Clicking the '''See and fix it''' button in the '''message form''' accesses the '''See Extra and Missing Tasks''' form that lists the '''extra''' and '''missing''' tasks in two grids as shown below.   
+
Clicking the '''See and fix it''' button in the '''message form''' accesses the '''See Extra and Missing Tasks''' form that lists the '''extra''' and '''missing''' tasks in two grids as shown below.  Usually a '''missing''' task is just an existing task in the chart that is not in the '''current import set''' because you decided you did not want to '''Flag''' it for '''import'''.  Likewise, an '''extra''' task is usually just a task in the '''import set''' that you did not '''Flag''' previously but now want to include in the '''updated''' chart.  In these cases, there’s nothing to worry about, and you can safely ignore the rest of the discussion below.   
 
+
27) Usually a '''missing''' task is just an existing task in the chart that is not in the '''current import set''' because you decided you did not want to '''Flag''' it for '''import'''.   
+
 
+
28) Likewise, an '''extra''' task is usually just a task in the '''import set''' that you did not '''Flag''' previously but now want to include in the '''updated''' chart.   
+
 
+
29) In these cases, there’s nothing to worry about, and you can safely ignore the rest of the discussion below.   
+
  
 
====Wrong Source Plan or Wrong Flag Field====
 
====Wrong Source Plan or Wrong Flag Field====
  
30) There’s also the case in which you have accidentally started an '''update''' using the wrong '''source plan''' or the wrong '''Flag''' field.   
+
There’s also the case in which you have accidentally started an '''update''' using the wrong '''source plan''' or the wrong '''Flag''' field.  To continue can give you a '''big, unpleasant surprise!''' There can be lots of tasks that lost all of their '''formatting'''.  If the '''See Extra and Missing Tasks''' form shows lots of '''extra''' and '''missing''' tasks that don’t seem to belong together in the same chart, you probably need to '''cancel''' the '''update''' so that you can go back and choose the correct tasks to perform the '''update''' correctly.
 
+
31) To continue can give you a '''big, unpleasant surprise!''' There can be lots of tasks that lost all of their '''formatting'''.   
+
 
+
32) If the '''See Extra and Missing Tasks''' form shows lots of '''extra''' and '''missing''' tasks that don’t seem to belong together in the same chart, you probably need to '''cancel''' the '''update''' so that you can go back and choose the correct tasks to perform the '''update''' correctly.
+
  
 
====Mapping Extra Tasks to Missing Tasks====
 
====Mapping Extra Tasks to Missing Tasks====
  
33) However, there are cases in which an '''extra''' task is actually a '''missing''' task that is misidentified because its '''ID''' has changed in the '''source plan''' between when the chart was '''first''' created and the '''current moment''' when '''source plan''' data are being used to make the '''update'''.
+
However, there are cases in which an '''extra''' task is actually a '''missing''' task that is misidentified because its '''ID''' has changed in the '''source plan''' between when the chart was '''first''' created and the '''current moment''' when '''source plan''' data are being used to make the '''update'''. When this happens, you are able to recognize the '''missing''' task that is really just the '''extra''' task with a different '''ID'''. In this situation, you almost always want the '''extra''' task to inherit all the properties of the '''missing''' task so that it retains the right formatting (i.e., '''color, shape, row assignment, and so on'''). You can do this by '''mapping''' these two tasks to each other.  If you see an '''extra''' task and then find a '''missing''' task that you recognize to be the same task but with a different '''ID''', use the '''Map''' button in the form below to '''map''' the '''extra''' task to its corresponding '''missing''' task.
 
+
34) When this happens, you are able to recognize the '''missing''' task that is really just the '''extra''' task with a different '''ID'''.
+
 
+
35) In this situation, you almost always want the '''extra''' task to inherit all the properties of the '''missing''' task so that it retains the right formatting (i.e., '''color, shape, row assignment, and so on''').
+
 
+
36) You can do this by '''mapping''' these two tasks to each other.   
+
 
+
37) If you see an '''extra''' task and then find a '''missing''' task that you recognize to be the same task but with a different '''ID''', use the '''Map''' button in the form below to '''map''' the '''extra''' task to its corresponding '''missing''' task.
+
  
 
<center>[[File:P70-7_11_1-70-(4-1)-08232019.png]]</center>
 
<center>[[File:P70-7_11_1-70-(4-1)-08232019.png]]</center>
 
<center>P70-7_11_1-70-(4-1)-08232019.png</center>
 
<center>P70-7_11_1-70-(4-1)-08232019.png</center>
  
38) The form above has two grids ('''Extra Tasks''' and '''Missing Tasks'''), each of which has four columns.   
+
The form above has two grids ('''Extra Tasks''' and '''Missing Tasks'''), each of which has four columns.  The left-most column contains the '''row cells''' for '''selecting a grid row'''.  The '''ID''' column contains the '''UniqueID''' for the '''extra''' or '''missing''' tasks.  The '''Task name''' column contains the task's '''name label'''.  The right-most column displays check marks for both members of a '''mapped pair'''.  When the '''vertical scroll bar''' is present in the form it means there are more entries in the grid than displayed in the form's '''Extra''' or '''Missing Tasks''' window. For convenience, clicking the '''column headers''' for the '''ID''' and '''Task name''' columns '''reverses''' the '''sort sequence''' for the column and it's associated grid rows. To '''map an extra''' task to the '''missing''' task that goes with it, follow these steps:
  
39) The left-most column contains the '''row cells''' for '''selecting a grid row'''.   
+
:1) Use your mouse to select one task from the''' Extra Tasks''' grid row by clicking the '''extra task’s''' selection cell.
 +
:2) Then go to the '''Missing Tasks''' grid row and click the selection cell of the '''missing''' task that goes with '''extra''' task.
 +
:3) Once two rows are selected, the '''Map''' button is '''enabled'''.  Click the '''Map''' button to '''map''' the two tasks to each other.   
  
40) The '''ID''' column contains the '''UniqueID''' for the '''extra''' or '''missing''' tasks.
+
Notice that check marks now appear in the '''Mapped''' column for both grid rows. Also notice that the name of the button changes from '''Map''' to '''Unmap''', indicating that you can change your mind and '''remove the mapping''' you just created. You can repeat the procedure above as many times as needed provided there are pairs of tasks available in the '''Extra Tasks''' grid rows and '''Missing Tasks''' grid rows.  After matching a pair and clicking the '''Map''' button, when you select the second task in the next pair notice that the button labeled '''Unmap''' is relabeled to '''Map''' thus '''enabling''' the '''mapping''' function once more. To review all your '''mappings''', select any '''mapped''' task in either grid.  Notice that it's '''paired task''' in the other grid is automatically selected and that the '''Unmap''' button is now '''enabled'''.  This lets you see what is '''mapped''' to what and to '''remove mappings''' that should not be there.
  
41)  The '''Task name''' column contains the task's '''name label'''.  
+
When you are satisfied with all the '''mappings''' between '''extra''' and '''missing''' tasks, associated '''missing''' tasks, click the '''Done''' button to confirm and go back to the '''Warning message''' form where the process started. When you finished this '''matching process''' and returned to the '''Warning message''' form, click one of the three buttons as described below:
  
42) The right-most column displays check marks for both members of a '''mapped pair'''.
+
:* Clicking the '''Continue import''' button tells OnePager to proceed with the remaining '''import''' process and use any '''matched missing and extra''' tasks or milestones to preserve formatting.
 
+
:* Clicking the '''Cancel import''' button stops the '''import''' process and returns you to where you started the '''update''' process (i.e. chart or '''Start form''').
43) When the '''vertical scroll bar''' is present in the form it means there are more entries in the grid than displayed in the form's '''Extra''' or '''Missing Tasks''' window.
+
:* Clicking the '''See and Fix It''' button takes you back to the '''See Extra and Missing Tasks''' form so that you can '''review, add, or remove mappings'''.
 
+
44) For convenience, clicking the '''column headers''' for the '''ID''' and '''Task name''' columns '''reverses''' the '''sort sequence''' for the column and it's associated grid rows.
+
 
+
45) To '''map an extra''' task to the '''missing''' task that goes with it, follow these steps:
+
 
+
:a) Use your mouse to select one task from the''' Extra Tasks''' grid row by clicking the '''extra task’s''' selection cell.
+
 
+
:b) Then go to the '''Missing Tasks''' grid row and click the selection cell of the '''missing''' task that goes with '''extra''' task.
+
 
+
:c) Once two rows are selected, the '''Map''' button is '''enabled'''.  Click the '''Map''' button to '''map''' the two tasks to each other. 
+
 
+
46) Notice that check marks now appear in the '''Mapped''' column for both grid rows.
+
 
+
47) Also notice that the name of the button changes from '''Map''' to '''Unmap''', indicating that you can change your mind and '''remove the mapping''' you just created.
+
 
+
48) You can repeat the procedure above as many times as needed provided there are pairs of tasks available in the '''Extra Tasks''' grid rows and '''Missing Tasks''' grid rows. 
+
 
+
49) After matching a pair and clicking the '''Map''' button, when you select the second task in the next pair notice that the button labeled '''Unmap''' is relabeled to '''Map''' thus '''enabling''' the '''mapping''' function once more.
+
 
+
50) To review all your '''mappings''', select any '''mapped''' task in either grid. 
+
 
+
51) Notice that it's '''paired task''' in the other grid is automatically selected and that the '''Unmap''' button is now '''enabled'''.
+
 
+
52) This lets you see what is '''mapped''' to what and to '''remove mappings''' that should not be there.
+
 
+
53) When you are satisfied with all the '''mappings''' between '''extra''' and '''missing''' tasks, associated '''missing''' tasks, click the '''Done''' button to confirm and go back to the '''Warning message''' form where the process started.
+
 
+
54) When you finished this '''matching process''' and returned to the '''Warning message''' form, click one of the three buttons as described below:
+
 
+
:a) Clicking the '''Continue import''' button tells OnePager to proceed with the remaining '''import''' process and use any '''matched missing and extra''' tasks or milestones to preserve formatting.
+
 
+
:b) Clicking the '''Cancel import''' button stops the '''import''' process and returns you to where you started the '''update''' process (i.e. chart or '''Start form''').
+
 
+
:c) Clicking the '''See and Fix It''' button takes you back to the '''See Extra and Missing Tasks''' form so that you can '''review, add, or remove mappings'''.
+
  
 
===Notes===
 
===Notes===
  
55) During any '''import and update''' operation, OnePager can find '''extra''' tasks and '''no missing''' tasks.   
+
During any '''import and update''' operation, OnePager can find '''extra''' tasks and '''no missing''' tasks.  Or it can find '''missing''' tasks and '''no extra''' tasks.  In these situations, the '''Warning message''' is still displayed and the option to click the '''See and fix it''' button is still available.  However, there is no way to '''fix''' anything because one of the grids in the '''See Extra and Missing Tasks''' form is empty.  When you view the '''See Extra and Missing Tasks''' form in such situations, it shows you the '''extra or missing''' tasks, but it does not instruct you to '''map''' anything.  In this case, the form is for informational purposes only.
 
+
56) Or it can find '''missing''' tasks and '''no extra''' tasks.   
+
 
+
57) In these situations, the '''Warning message''' is still displayed and the option to click the '''See and fix it''' button is still available.   
+
 
+
58) However, there is no way to '''fix''' anything because one of the grids in the '''See Extra and Missing Tasks''' form is empty.   
+
+
59) When you view the '''See Extra and Missing Tasks''' form in such situations, it shows you the '''extra or missing''' tasks, but it does not instruct you to '''map''' anything.   
+
 
+
60) In this case, the form is for informational purposes only.
+
  
 
<center>[[File:P70-7_11_1-70-(5-1)-08232019.png]]</center>
 
<center>[[File:P70-7_11_1-70-(5-1)-08232019.png]]</center>

Revision as of 21:04, 30 December 2020

About Merging the Wrong Tasks into a Chart

OnePager Pro (OPP) can consistently create snapshots from period to period with updated information from a Microsoft Project source plan. The tasks and milestones that are imported to OnePager in UPDATE mode should be the same set of tasks and milestones with, perhaps, some added or removed as the project moves forward.

Microsoft Project's UniqueID Field

OnePager Pro tracks tasks and milestones from snapshot to snapshot though the Microsoft Project UniqueID field in the source plan. The UniqueID is created by Microsoft Project and is part of each .mpp file. The UniqueID field and its associated values are:

  • Displayable by Microsoft Project,
  • Automatically imported by OnePager Pro with other task and milestone related data.
  • Used by OnePager Pro to match tasks and milestones from one snapshot with Updated source plan data imported to either replace the snapshot or to add a snapshot consistent with previous snapshots.

For more information pertaining to UniqueID, their significance in Microsoft Project source plans, and their role within OnePager Pro, please see the links at: OnePager Blog Posts 7.11.1-70.

Setting Your Warning Thresholds

Sometimes you can make the mistake of accidentally updating a chart with tasks and milestones from the wrong Microsoft Project source plan. Or with the wrong set of tasks and milestones from the right Microsoft Project source plan if you are making several charts from the same Microsoft Project source plan using several different Flag fields. When any of these situations arise, OnePager detects them by using the UniqueID field from the source plan to determine if additional tasks and milestones are being imported or if tasks and milestones are missing from the imported source plan supporting the update. Additional or missing tasks and milestones can cause the chart to suddenly appear messed up because it now displays many added new tasks and milestones that reside in many new rows and swimlanes. Even the earlier snapshots are affected by these new rows and swimlanes.

A similar messed up chart can result from missing tasks and milestones as well. When this happens, the best idea is to immediately press the Undo button above the OnePager ribbon. This action immediately restores the chart to how it was before all the unfamiliar tasks and milestones were merged. Or you can simply close the messed up chart without saving it. When you reopen the chart, the erroneous update is gone.

To avoid this problem in the first place, OnePager can warn you before the wrong tasks and milestones are incorporated into the chart. To receive this warning, there is a checkbox in the Chart Properties form's Advanced tab that when checked ON assures that the Warning message shown below is displayed. The Chart Properties form's Advanced tab with the Set warning thresholds form is shown here:

P70-7 11 1-(1)-05052020.png
P70-7_11_1-(1)-05052020.png

The settings in the Set warning thresholds form are expressed in terms of percentage of extra tasks and milestones added and tasks and milestones that are missing. If, during a merge operation these thresholds are exceeded, the warning message is displayed. You also have the option to set the warning thresholds in the Template Properties form's Advanced tab. The article links below provide more information on these topics:

Template Only Features-OnePager Pro-Advanced Template Tab 24.1.1-70
Advanced Tab for OnePager Pro-Warn Of Merging Tasks 21.13.1-70.

Warn of merging tasks

About Merging Tasks

Setting Warning Thresholds

The Advanced tab of the Chart Properties form has a checkbox titled Warn of merging tasks as shown in the previous section. This checkbox is accompanied by the Warning options button to the right. When this checkbox is checked ON, the button is active and when the Warning options button is clicked it accesses the Set warning thresholds form where you can set the percentage of extra and missing tasks necessary to provide you with the warning message discussed below.

P70-7 11 1-70-(2)-08212019.png
P70-7_11_1-70-(2)-08212019.png

Extra tasks are tasks that are present in the imported source plan but are not present in the current chart. Missing tasks are tasks that are present in the current chart but are not present in the imported source plan. Setting these percentages to 100% has the impact of turning the fixes and warnings off. Setting the percentages to 0% provides an assurance that any extra or missing tasks triggers the fixes and warnings feature.

When Merging Tasks Exceed the Thresholds

When the Warn on merging tasks checkbox is checked ON and your workflow involves merging tasks, OnePager looks to see if extra tasks are being imported or if missing tasks are not being imported when updating a snapshot. After making the calculation, OnePager shows a Warning form asking if you want to proceed with the update, cancel the update, or try to fix tasks that have been misidentified.

Warning Message Form

The Warning message also gives you access to the See Extra and Missing Tasks form, shown below, so you can actually see the extra and missing tasks and milestones and make a fix, if possible. OnePager is configured to issue the warning shown below if either of the thresholds in the Set warning thresholds form are exceeded. In this example, the threshold is exceeded because either 100% of the imported tasks and milestones are extra or 100% of the existing tasks and milestoones are missing:

P70-7 11 1-70-(3)-08212019.png
P70-7_11_1-70-(3)-08212019.png

At this point you have three (3) options:

Continue Import

Click the Continue import button to proceed with the import. By doing so you are accepting the differences between the current chart and the imported data that are about to update the chart. This can lead to both new rows with new tasks and milestones and empty rows in the snapshot.

See and Fix It

Click the See and fix it button to take a look at the specific extra and missing tasks and milestones before deciding to whether to continue or not. You can sometimes also fix the issue if you notice that an extra task is actually a missing task in disguise. In that case, you can tell OnePager to map a missing task to the extra task. These actions are explained in the See Extra and Missing Tasks form discussed below.

Cancel Import

As the final option, you can click the Cancel import button to close the OnePager message form above and stop the import process.

Continuing to Import Regardless of Extra or Missing Tasks

Clicking the Continue import button tells OnePager to proceed with the import and disregard any differences between the set of current tasks in the chart and the set of selected tasks in the source plan being imported. At the end of the import operation, you have an updated snapshot that was either added to the snapshot list or replaced. You can expect to see some new rows containing the extra tasks or milestones and some empty rows corresponding to the missing tasks or milestones. The latter can be automatically hidden if you have chosen the option Hide newly-empty rows on import on the Advanced tab page of the Chart Properties form. For more information on hiding empty rows, please see section in the article at: Hiding Empty Rows 21.13.1-70.

Using the See Extra and Missing Tasks Form

Clicking the See and fix it button in the message form accesses the See Extra and Missing Tasks form that lists the extra and missing tasks in two grids as shown below. Usually a missing task is just an existing task in the chart that is not in the current import set because you decided you did not want to Flag it for import. Likewise, an extra task is usually just a task in the import set that you did not Flag previously but now want to include in the updated chart. In these cases, there’s nothing to worry about, and you can safely ignore the rest of the discussion below.

Wrong Source Plan or Wrong Flag Field

There’s also the case in which you have accidentally started an update using the wrong source plan or the wrong Flag field. To continue can give you a big, unpleasant surprise! There can be lots of tasks that lost all of their formatting. If the See Extra and Missing Tasks form shows lots of extra and missing tasks that don’t seem to belong together in the same chart, you probably need to cancel the update so that you can go back and choose the correct tasks to perform the update correctly.

Mapping Extra Tasks to Missing Tasks

However, there are cases in which an extra task is actually a missing task that is misidentified because its ID has changed in the source plan between when the chart was first created and the current moment when source plan data are being used to make the update. When this happens, you are able to recognize the missing task that is really just the extra task with a different ID. In this situation, you almost always want the extra task to inherit all the properties of the missing task so that it retains the right formatting (i.e., color, shape, row assignment, and so on). You can do this by mapping these two tasks to each other. If you see an extra task and then find a missing task that you recognize to be the same task but with a different ID, use the Map button in the form below to map the extra task to its corresponding missing task.

P70-7 11 1-70-(4-1)-08232019.png
P70-7_11_1-70-(4-1)-08232019.png

The form above has two grids (Extra Tasks and Missing Tasks), each of which has four columns. The left-most column contains the row cells for selecting a grid row. The ID column contains the UniqueID for the extra or missing tasks. The Task name column contains the task's name label. The right-most column displays check marks for both members of a mapped pair. When the vertical scroll bar is present in the form it means there are more entries in the grid than displayed in the form's Extra or Missing Tasks window. For convenience, clicking the column headers for the ID and Task name columns reverses the sort sequence for the column and it's associated grid rows. To map an extra task to the missing task that goes with it, follow these steps:

1) Use your mouse to select one task from the Extra Tasks grid row by clicking the extra task’s selection cell.
2) Then go to the Missing Tasks grid row and click the selection cell of the missing task that goes with extra task.
3) Once two rows are selected, the Map button is enabled. Click the Map button to map the two tasks to each other.

Notice that check marks now appear in the Mapped column for both grid rows. Also notice that the name of the button changes from Map to Unmap, indicating that you can change your mind and remove the mapping you just created. You can repeat the procedure above as many times as needed provided there are pairs of tasks available in the Extra Tasks grid rows and Missing Tasks grid rows. After matching a pair and clicking the Map button, when you select the second task in the next pair notice that the button labeled Unmap is relabeled to Map thus enabling the mapping function once more. To review all your mappings, select any mapped task in either grid. Notice that it's paired task in the other grid is automatically selected and that the Unmap button is now enabled. This lets you see what is mapped to what and to remove mappings that should not be there.

When you are satisfied with all the mappings between extra and missing tasks, associated missing tasks, click the Done button to confirm and go back to the Warning message form where the process started. When you finished this matching process and returned to the Warning message form, click one of the three buttons as described below:

  • Clicking the Continue import button tells OnePager to proceed with the remaining import process and use any matched missing and extra tasks or milestones to preserve formatting.
  • Clicking the Cancel import button stops the import process and returns you to where you started the update process (i.e. chart or Start form).
  • Clicking the See and Fix It button takes you back to the See Extra and Missing Tasks form so that you can review, add, or remove mappings.

Notes

During any import and update operation, OnePager can find extra tasks and no missing tasks. Or it can find missing tasks and no extra tasks. In these situations, the Warning message is still displayed and the option to click the See and fix it button is still available. However, there is no way to fix anything because one of the grids in the See Extra and Missing Tasks form is empty. When you view the See Extra and Missing Tasks form in such situations, it shows you the extra or missing tasks, but it does not instruct you to map anything. In this case, the form is for informational purposes only.

P70-7 11 1-70-(5-1)-08232019.png
P70-7_11_1-70-(5-1)-08232019.png

Related Links

Basic Workflows (Portal) 7.0.1-70

Advanced Tab for OnePager Pro 21.13.1-70

Template Only Features-OnePager Pro 24.1.1-70

OnePager Blog Posts

What’s a Unique ID and Why Should I Care?

Unique IDs in Microsoft Project

Unique IDs in Project Online and Project Server

Unique IDs in Excel

(7.11.1-70)