Conditional Import for OnePager Pro/Express Version 6.0

From OnePager Documentation
Revision as of 17:08, 7 April 2017 by Rfeingold (Talk | contribs) (Related Links:)

Jump to: navigation, search

About Conditional Import for OnePager

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 new Conditional Import capabilities. Here we overview some situations you may have encountered in the past with OnePager that can be facilitated better with Conditional Import.

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 field holds a desired value or range of values. In this case, using a flag field may not be flexible enough or may be too time consuming.

2) Suppose you 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 data to OnePager. With version 6.0 you can clearly specify, in a Conditional Import rule, defined before the import process begins, the conditions that meet any logical combination of criteria WITHOUT making modifications to the source plan. Here’s how it works:

a) We’ll use the BlueGrass Project 2J-303 Microsoft Project source plan as an example. Recall that the field headers look something like this:
P60-7 18 1-60-(1)-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-(3A)-12272016.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-(4BB)-03022017.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-(5BB)-03022017.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, this form will disappear and you will be back at the OPC form once more. Now. 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
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 fields 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 field, applies to only the current snapshot. Therefore, changing the Conditional Import rules for a down timeline snapshot may 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. 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 fields or be unable to change them. You would have to first import all rows 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 source plan. The example below will illustrate this:

a) Consider the Microsoft Project source plan just below which has no flag fields defined and happens to be Read-only:
P60-7 18 1-60-(7)-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-(9BB)-03022017.png
e) This simple Conditional Import rule gives you access to all the tasks associated with Phase II. So, 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

5) Since OPP was told to generate the legend using the Resource Names field 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.

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)‏‎