Conditional Import for OnePager Pro/Express Version 6.0

From OnePager Documentation
Revision as of 14:42, 11 November 2016 by Rfeingold (Talk | contribs) (Created page with "===About Conditional Import for OnePager (PE60-0_4_1_1-11112016)=== In '''OPP''' and '''OPX''' version 6.0, the capability for you to control the '''import''' of rows from yo...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

About Conditional Import for OnePager (PE60-0_4_1_1-11112016)

In OPP and OPX version 6.0, the capability for you to control the import of rows from your source plan is made even more flexible with the addition of new Conditional Import capabilities. Here we discuss some situations you may have encountered in the past with OnePager that can be facilitated better with Conditional Import.

This article assumes that you are going to use the OPP version 6.0 Add-in application to access your Microsoft Project source plan and from there to launch OPP. There is a parallel article available at Conditional Import for OnePager Pro Desktop 7.18.1.2-60 which shows the how Conditional Import is used for the OPP version 6.0 Desktop application.

When a Flag Field Isn’t Sufficient

1) There are occasions where you would like to import a source plan row but only when the contents of a specified column holds a desired value or range of values for that row. In this case, using a flag field may not be flexible enough or may be too time consuming to use.

2) Suppose you might want to include source plan rows where task/milestone Start dates are greater than a specified date. Prior to OnePager version 6.0 you would have to manually locate and modify the flag cell contents for those rows meeting the desired condition before importing. With version 6.0 you can clearly specify, in a Conditional Import rule, defined before the import process begins, the conditions that meets any logical combination of criteria WITHOUT making modifications to the source plan. Here’s how it might work:

a) We’ll use the BlueGrass Project 2J-303 Microsoft Project source plan as an example. Recall that the column headers look something like this:
P60-7 18 1-60-(1)-09242016.png
P60-7_18_1-60-(1)-09242016.png
b) For this example you only want to import tasks/milestones that have a Start date greater than 10/11/2015 but less than 12/31/2015. You can do that by first launching Microsoft Project with the source plan loaded as shown above. Next, launch OPP version 6.0 from the Microsoft Project tool bar as you normally do and click the NEW button option. When this is done the following OnePager Choices form appears:
P60-7 18 1-60-(2)-09242016.png
P60-7_18_1-60-(2)-09242016.png
c) The OnePager choices (OPC) form above has an additional radio button in the Task Selection group, Select tasks by custom filter and a new button called Edit filter…. Before clicking the Select tasks by customer filter button, update the project view name and snapshot date such that the OPC form looks like this:
P60-7 18 1-60-(3)-09242016.png
P60-7_18_1-60-(3)-09242016.png
d) Now, click the Select tasks by custom filter button. When you do, a blank Custom Import Rules form will appear as show below:
P60-7 18 1-60-(4)-09242016.png
P60-7_18_1-60-(4)-09242016.png
e) You can now compose the two rules needed to import rows that have Start dates greater than 10/11/2015 but less than 12/31/2015. When you do this, the Conditional Import Rules form will look like this:
P60-7 18 1-60-(5)-09242016.png
P60-7_18_1-60-(5)-09242016.png
f) Note that the All of the following rules are true radio button is selected so that the two rules are essentially an AND operation. When you click OK on the form, it will disappear and you will be back at the OPC form once more. At this point. click the Create new project view button and OPP will create the project view that looks like this:
P60-7 18 1-60-(6)-09242016.png
P60-7_18_1-60-(6)-09242016.png
g) In the project view above, there are tasks that extend beyond 12/31/2015 but there are no tasks that Start on or after 12/31/2015. Similarly, there are no tasks that Start before 10/11/2015.
h) When the project view is saved, the Conditional Import rules are saved as well and will be used to control the import for subsequent snapshots. Further, in either this snapshot or subsequent ones, the Conditional Import rules can be edited (i.e., changed, added, or deleted). When such changes are made to the Conditional Import rules, the current new snapshot or the snapshot being replaced will be configured by the active set of Conditional Import rules. Finally, you can always revert to using flag columns or select All tasks for import.
i) An important thing to remember is that the Conditional Import rules, like the use of a single flag column, applies to only the current snapshot. Therefore, changing the Conditional Import rules for a down timeline snapshot will NOT change the look for all previous snapshots unless further Conditional Import rules changes are specifically made for these snapshots via the REPLACE snapshot procedure.

3) Conditional Import is a powerful new capability that allows you to better control the content of your project views. Conditional Import also makes project views more useful in project schedule analysis presentations/discussions that usually accompany project management. As such, OnePager becomes not only a presentation tool but an addition to your suite of project schedule analysis tools.

When Microsoft Project Source Plans are Read-Only

4) Occasions may also arise where you are not able to modify a Microsoft Project source plan. For instance, with a read-only file you might be unable to add the required import control flag columns or be unable to change them. You would have to first import them all and manually edit out or hide the unwanted row tasks/milestones after the project view is created. Again, version 6.0 allows you to specify import conditions that meet your needs, say, only the rows which correspond to a particular project Phase for which there are data already available in the plan’s source file. The example below will illustrate this:

a) Consider the Microsoft Project source plan just below which has no flag field columns defined and happens to be Read-only:
P60-7 18 1-60-(7)-09242016.png
P60-7_18_1-60-(7)-09242016.png
b) For the sake of this example, we will assume that Flag1 through Flag20 are not defined and have no data in the rows even if these columns are hidden in Microsoft Project. You need, again for illustration, something to control the import of rows. We’ll use the Phase column from the source plan which happens to be the Microsoft Project Text30 column.
c) Following the same sequences as in the previous example, we’ll launch OPP from the Microsoft Project tool bar, select the NEW option from the OnePager Start form, and make project view name and snapshot date modifications to the OPC form as shown below:
P60-7 18 1-60-(8)-09242016.png
P60-7_18_1-60-(8)-09242016.png
d) In the Microsoft Project source plan there are a total of six (6) possible Phase names. In this example, we’ll use Conditional Import to just build a project view showing Phase II task and milestones by creating a Conditional Import rule that looks like this:
P60-7 18 1-60-(9)-09242016.png
P60-7_18_1-60-(9)-09242016.png
e) This simple Conditional Import rule gives you access to all the tasks associated with Phase II. So now click the OK button on the above form and then click the Create project view button on the OPC form to create the project view as shown below:
P60-7 18 1-60-(10)-09242016.png
P60-7_18_1-60-(10)-09242016.png

5) Since OPP was told to generate the legend using the Resource Names column from the Microsoft Project source plan, you see that only one phase name is displayed. Team 2 is shown in the legend as the only resource name participating in Phase II of the project. Using Conditional Import first overcomes any difficulty dealing with a Read-only file and, second, allows you to focus on the second phase of the project to see the details in the plan. In this case the resources assigned. Again, Conditional Import becomes an analysis aid as well as a presentation aid.

Analysis Using an Existing Project View

6) There are also occasions where you may want to go back AFTER a project view is created and update the project view to look at rows controlled by another flag column. You may also want to build project views to do some analysis on the project schedule. This is easily done AFTER the project view was created by looking at other logical relationship within the Microsoft Project source plan data.

Changing the Flag Field AFTER the Project View is Created

7) Making changes to the flag field column after a project view is created is quite easy using the controls from the OnePager Project View Editor’s Data tab.

a) First, launch Microsoft Project with the original source plan and click the OnePager button on the Microsoft Project tool bar. Then, click the UPDATE button on the OnePager Start form. This will load the project view into the OPP’s Project View Editor (PVE).
b) With the PVE running, go to the Data tab and click the Custom Update button which brings up the OPC form shown in the illustration below.
c) In this form, make sure the Select tasks with ‘Yes’ in column button is on, click the dropdown menu, and select the alternate flag field column as shown below:
P60-7 18 1-60-(11)-09242016.png
P60-7_18_1-60-(11)-09242016.png
d) In the above project view, which was created originally using Custom Import rules, you are changing the import control back to a defined flag column, specifically, Flag10. When you do this and REPLACE the snapshot you get the following updated project view:

*********Doing the above described action doesn’t presently work either from OPEN or UPDATE (12)**********

e) This example illustrates how you can revert from using Conditional Import rules to the more conventional use of flag columns to control import.

Changing Custom Import Rules AFTER the Project View is Created

8) As was mentioned earlier, before version 6.0, handling import condition change situations meant totally starting over by going back to the OnePager Start form and selecting a different flag column. Version 6.0 lets you change the import conditions from the PVE by using the Data tab’s Custom Update button to access your Conditional Import rules and edit them. Here’s how changing Conditional Import rules can be done AFTER the project view is created:

a) Consider the previous example where you wanted to create a project view consisting of tasks/milestones with Start dates later than 10/11/2015 and earlier than 12/31/2015. Suppose you have that project view in the PVE and you want to import additional tasks/milestones for display that have Finish dates less than 4/1/2016.
b) You can do this by first bringing up the project view from Microsoft Project by launching OnePager and clicking the UPDATE button in the OnePager Start form. This brings up the PVE displaying the project view with the two Start date Conditional Import Rules defined previously.
c) Next, go to the Data tab, click the Custom Update button bringing up the OPC form created in a previous example.
d) Then, click the Edit Filters… button to bring up the Conditional Import Rules form which displays the two rules. You can now modify the Conditional Import rules by Adding a new rule as shown below:
P60-7 18 1-60-(13)-09242016.png
P60-7_18_1-60-(13)-09242016.png
                                                  • The Add Rule button didn’t work. Used the Copy Button to copy the second rule then edited it to make above screenshot. *******************
e) Now, click OK on the Conditional Import Rules form to return to the OPC form where you should click the REPLACE existing snapshot with date button and use the dropdown calendar to select a replacement snapshot date as shown below:
P60-7 18 1-60-(14)-09242016.png
P60-7_18_1-60-(14)-09242016.png
f) Then, click the Replace dates button on the OPC form and the following project view will appear:
P60-7 18 1-60-(16)-09242016.png
P60-7_18_1-60-(16)-09242016.png

Using the three rules shown CI Rule form above gives what I think is an erroneous result above. I conclude that using the Copy Rule and editing that rule does not produce the desired results. A previous attempt using the Copy Rule and editing that rule to be Finish>4/1/2016 gave a two row project view. The project view should have all the tasks shown in P60-7_18_1-60-(6)-09242016.png plus additional task/milestones that have Finish dates less 4/1/2016. The only difference between this 3 rule project view and the previous 2 rule project view is show in the red rectangle above.

                                    • It may be that the combination of rules and the actual date in the .mpp file has conspired to give this result. I will investigate.**************

Related Links:

Basic Workflows (Portal)

Conditional Formatting (Portal)

Using the OnePager "Data" Tab's "Selected file(s)" Button

OnePager Express Import of Data from Microsoft Excel

Message to Assist with Setting Import Flags When No Data Are Imported

Understanding Project Views and Snapshots for OnePager Pro

Understanding Project Views and Snapshots for OnePager Express

(0.4.1.1-60)‏‎