Difference between revisions of "Conditional Import for OnePager Pro Add-in for Version 6.0"
(→Overview) |
|||
Line 142: | Line 142: | ||
==Switching from Flag Fields to New Conditional Import Filters Rules== | ==Switching from Flag Fields to New Conditional Import Filters Rules== | ||
− | 11) When you click the '''NEW''' button, the '''OPC''' form will appear as shown below. The process for building a new project view with '''Conditional Import | + | 11) When you click the '''NEW''' button, the '''OPC''' form will appear as shown below. The process for building a new project view with '''Conditional Import Filters''' is the same with the exception that instead of using '''flag''' fields from your Microsoft Project '''source plan''' you will, instead, invoke the '''Conditional Import Rules''' form from the '''OPC''' form as shown below: |
<center>[[File:P60-7_18_1-60-(4BB)-03022017.png]]</center> | <center>[[File:P60-7_18_1-60-(4BB)-03022017.png]]</center> |
Revision as of 17:53, 11 May 2017
Contents
- 1 Overview
- 1.1 Adding a Filter Rule to the Conditional Import Rules Form
- 1.2 Editing an Existing Filter Rule in the Conditional Import Rules Form
- 1.3 Copying an Existing Filter Rule in the Conditional Import Rules Form
- 1.4 Deleting an Existing Filter Rule in the Conditional Import Rules Form
- 1.5 Switching from Flag Fields to New Conditional Import Filters Rules
- 1.6 Switching from Conditional Import Filters Rules to Flag Fields or Selecting all Tasks
- 1.7 Adding, Editing, Copying, and Deleting Conditional Import Filters Rules
- 2 A Simplified Workflow Example Using Conditional Import Filters Rules
- 3 An Advanced Workflow Example Using Conditional Import Filters Rules
- 4 Using Conditional Import Filters with Microsoft Project Integrated Master Schedules (IMS)
- 5 Using Conditional Import Filters with Multiple Separate Microsoft Project Source Plan Packages
- 6 Using Conditional Import Filters with Server Resident Microsoft Project Source Plan
- 7 Using Enterprise Custom Fields from Microsoft Project Source Plans in Conditional Import Filters Rules
- 8 Related Links
Overview
An overview article with examples is available at: Conditional Import Filters for OnePager . The article is recommended reading before you advance to this article or any other of the product specific articles in this series.
This article provides details on the use of the Conditional Import Filters feature for OnePager Pro (OPP) Add-in edition.
- (1) First, we’ll provide information on how to create Conditional Import Filters rules using the Conditional Import Rules form.
- (2) Then, we'll cover a couple of examples on how you might use the Condition Import Filters feature in your every day use of OnePager in preparation for your schedule presentations and discussions.
- (3) Finally, we’ll provide details on how Conditional Import Filters works with (a) Microsoft Project Integrated Master Schedules (IMS), (b) with Microsoft Project source plans consisting of several separate files, and (c) with server resident Microsoft Project source plans.
Adding a Filter Rule to the Conditional Import Rules Form
1) The Conditional Import Rules form resembles to the Conditional Formatting form in look and function. In this form you can add, copy, change, and delete Conditional Import Filters rules. The form is accessed from the OnePager choices (OPC) form as shown below:
![P60-7 18 1-60-(4BB)-03022017.png](/wiki/images/0/0e/P60-7_18_1-60-%284BB%29-03022017.png)
- a) The Conditional Import Rules form is shown in its initial blank state above. The rules entered become part of any project view subsequently created or updated and are saved with the project view. If you later, create or update a snapshot using a flag field, OPP will save the flag field and clear the Conditional Import Filters rules.
- b) Conditional Import Filter rules are typically entered when a project view is first created in the NEW workflow.
- c) After a project view is created, rules may be added later for the UPDATE workflow via the OnePager Choices form invoked either from the OnePager Start form or the Project View Editor (Custom Update… button. These workflows are described later in this article.
2) With the Custom Import Rules form visible and blank, click the Add Rule button to create a new empty row as shown below:
![P60-7 18 1 1-60-(1AA)-03032017.png](/wiki/images/3/38/P60-7_18_1_1-60-%281AA%29-03032017.png)
- a) There are five cells shown for the new rule row above. The first two cells are used as follows:
- i) The first two cells are used as selection cells.
- ii) The first left-most cell, when clicked, allows you to use the Copy Rule(s) or the Delete Rule(s) buttons.
- iii) The second cell from the left is a checkbox used to allow you to activate or deactivate the rule. If the checkbox is unchecked, OPP will not apply the rule when performing the import function.
- b) The Field cell of a row (third from the left) has a dropdown menu that allows you to select a Microsoft Project source plan field to use in creating the selected criterion. When the dropdown menu is selected, the Field cell will look something like this:
![P60-7 18 1 1-60-(2AA)-03032017.png](/wiki/images/3/38/P60-7_18_1_1-60-%282AA%29-03032017.png)
- c) When a Microsoft Project source plan field is selected, the name will be displayed in the Field cell of the new Custom Import Filters rule row.
- d) The look of the rest of the new Conditional Import Filters rule row depends on the type of the Microsoft Project source plan field selected. These types are discussed next.
3) Date and Numeric Fields – When Microsoft Project date or numeric types are selected in the Field cell of the rule row, the Operator field dropdown will provide the options shown below:
![P60-7 18 1 1-60-(3AA)-03032017.png](/wiki/images/5/52/P60-7_18_1_1-60-%283AA%29-03032017.png)
- a) These are the conventional six (6) logical operators used consistently in OPP for date and numeric types. They are the same Operators used in OPP for Conditional Formatting. See the article at Conditional Formatting Overview for OnePager Pro for complementary details on the use of these logical operators.
- b) When the logical statement evaluates to TRUE on the selected Field in a Microsoft Project source plan row, the row is imported. Otherwise it is skipped.
4) Text Fields – When Microsoft Project text fields are entered in the Field cell of the Conditional Import Filters rule row, the Operator field dropdown will provide the options shown below:
![P60-7 18 1 1-60-(4AA)-03032017.png](/wiki/images/2/29/P60-7_18_1_1-60-%284AA%29-03032017.png)
- a) These are the conventional four (4) logical operators used consistently in OPP for the text type. They are the same Operators used in OPP for Conditional Formatting. See the article at Conditional Formatting Overview for OnePager Pro for complementary details on the use of these logical operators.
- b) When the logical statement evaluates to TRUE on the selected Field in a Microsoft Project source plan row, the row is imported. Otherwise it is skipped.
5) Boolean Fields – When Microsoft Project Boolean types are entered in the Field cell of the Conditional Import Filters rule row, the Operator field dropdown will provide the options shown below:
![P60-7 18 1 1-60-(5AA)-03032017.png](/wiki/images/e/e5/P60-7_18_1_1-60-%285AA%29-03032017.png)
- a) These are the two (2) conventional Boolean logical operators used consistently in OPP for the Boolean type. They are the same Operators used in OPP for Conditional Formatting. See the article at Conditional Formatting with Boolean Fields for OnePager Pro for complementary details on the use of these logical operators.
- b) Boolean types are a special case as the operator and the value in OPP are combined into one cell of the Conditional Import Filters rule row - the Operator cell.
- c) When the selected Field is TRUE (or Yes) in a Microsoft Project source plan row, the row is imported. Otherwise it is skipped.
6) Flag1 Through Flag20 Fields – OPP treats Microsoft Project fields from Flag1 through Flag20 as Boolean types in the same way as described in the previous sub-section.
7) We want to emphasize the flexibility that Conditional Import Filters adds to the way you can import rows from your Microsoft Project source plan. You can formulate sets of Conditional Import Filters rules to controls imports using all available types of Microsoft Project fields and use operators that let you select ranges of values and more complicated combinations of criteria.
Editing an Existing Filter Rule in the Conditional Import Rules Form
8) Suppose you’ve composed several Conditional Import Filters rules in an open Conditional Import Rules form as shown below:
![P60-7 18 1-60-(5BB)-03022017.png](/wiki/images/5/5a/P60-7_18_1-60-%285BB%29-03022017.png)
- a) Now further suppose, after reviewing these two rules, that you realize that you may not be able to capture any tasks/milestones that happen to Start on 12/31/2015 because the current rule is based on the less than logical Operator.
- b) To make the change in the Operator cell, click on the cell’s contents which will highlight the cell in blue and reveals the dropdown menu button which you should click. When you do the Conditional Import Rules form should look like this:
![P60-7 18 1 1-60-(7AA)-03032017.png](/wiki/images/7/71/P60-7_18_1_1-60-%287AA%29-03032017.png)
c) To change the rule, click the desired Operator in the dropdown menu, in this case the less than or equal Operator, and it will be displayed in the Operator cell of the second rule as shown here:
![P60-7 18 1 1-60-(8AA)-03032017.png](/wiki/images/7/77/P60-7_18_1_1-60-%288AA%29-03032017.png)
- d) Any Field, Operator, or Value cell may be edited in this way. Additionally, the On cell may be toggled to control the Conditional Import Filters rule's participation in the import process. Finally, you may switch between the two radio buttons at the top of the form in order to change the relationship among the rules from OR to AND or vice versa.
- e) The edits described above may be made to the Conditional Import Rules form regardless of the OPC mode in which you are working (i.e., NEW and UPDATE). Also, you may bring up the Conditional Import Rules form from the OPC form as many times as needed to accomplish your presentation goal. OPP saves the content of the last edit you make to the Conditional Import Rules form.
- f) When satisfied with the structure of your import rules, click the OK button at the bottom of the form to return to the OPC form. Now you are ready to create a new project view.
Copying an Existing Filter Rule in the Conditional Import Rules Form
9) The Copy Rule(s) button is provided in the Conditional Import Rules form to facilitate the creation of additional rules.
- a) To copy an existing rule to create a new rule, first select the rule row from which you wish to copy as shown below:
![P60-7 18 1 1-60-(9AA)-03032017.png](/wiki/images/b/b4/P60-7_18_1_1-60-%289AA%29-03032017.png)
- b) Once the desired row is selected, clicking the Copy Rule(s) button will copy the contents of the rule selected as indicated by the highlighted left-most cell in the desired rule as shown below:
![P60-7 18 1 1-60-(10AA)-03032017.png](/wiki/images/e/ed/P60-7_18_1_1-60-%2810AA%29-03032017.png)
- c) At this point you may edit the copied row in the manner described previously. When you are finished, the new set of three rule rows may look like this:
![P60-7 18 1 1-60-(11AA)-03032017.png](/wiki/images/d/dc/P60-7_18_1_1-60-%2811AA%29-03032017.png)
- d) When satisfied with the structure of your import rules, click the OK button at the bottom of the form to return to the OPC form. Now you are ready to create a new project view.
Deleting an Existing Filter Rule in the Conditional Import Rules Form
10) There are times when a particular Conditional Import Filters rule will no longer serve your purpose. You can select the rule row to be deleted and click the Delete Rule(s) button.
- a) The process for deleting a rule parallels the process for copying a rule row in that the you must select the desired row to delete by clicking the left-most cell in that rule’s row.
- b) Once the selection is made, click the Delete Rule(s) button and OPP will first put up a warning message asking if you really want to delete the rule row as shown below:
![P60-7 18 1 1-60-(12)-09272016.png](/wiki/images/5/55/P60-7_18_1_1-60-%2812%29-09272016.png)
- c) If you select the No option, OPP will abandon the rule deletion operation and the warning message will disappear leaving the selected rule row still selected.
- d) If you select the Yes option, OPP will remove the warning message, delete the selected rule row, and leave the Conditional Import Rules form showing the remaining rule rows, if any.
- e) When satisfied with the structure of your import rules, click the OK button at the bottom of the form to return to the OPC form.
Switching from Flag Fields to New Conditional Import Filters Rules
11) When you click the NEW button, the OPC form will appear as shown below. The process for building a new project view with Conditional Import Filters is the same with the exception that instead of using flag fields from your Microsoft Project source plan you will, instead, invoke the Conditional Import Rules form from the OPC form as shown below:
![P60-7 18 1-60-(4BB)-03022017.png](/wiki/images/0/0e/P60-7_18_1-60-%284BB%29-03022017.png)
- a) In the illustration above, in the Task Selection section of the form, the Select task by custom filter radio button is clicked on. This action brings up the Conditional Import Rules form also shown above.
- b) At this point you may Add Rules to the form, Copy Rules, Delete Rules, or edit existing rules.
Switching from Conditional Import Filters Rules to Flag Fields or Selecting all Tasks
12) If you subsequently decide after composing one or more Conditional Import Filters rules and clicking OK on the Conditional Import Rules form that you want to use flag fields instead, you may revert back to either of the two other Task Selection options provided in the OPC form shown above.
- a) To do this, click either of the other two radio buttons to Select all tasks, or Select task with ‘Yes’ in field:
- b) When you click the Select all tasks button there is no further action you need to take on the OPC form.
- c) However, if you click the Select tasks with ‘Yes’ in field: you will need to select a field from your Microsoft Project source plan as shown below:
![P60-7 18 1 1-60-(13)-09272016.png](/wiki/images/1/19/P60-7_18_1_1-60-%2813%29-09272016.png)
- d) In these circumstances where you’ve switched from using Conditional Import Filters rules to either selecting all tasks, or selecting tasks using a flag field, OPP will discard any Conditional Import Filters rules associated with the project view.
Adding, Editing, Copying, and Deleting Conditional Import Filters Rules
13) Managing Conditional Import Filters rules was discussed in previous sub-sections in this article. Please follow the reference links provided below for details on adding, editing, copying, and deleting of Conditional Import Filters rules:
- a) Adding a new rule: Adding a Filter Rule to the Conditional Import Rules Form.
- b) Editing an existing rule: Editing an Existing Filter Rule in the Conditional Import Rules Form.
- c) Copying a rule: Copying an Existing Filter Rule in the Conditional Import Rules Form.
- d) Deleting a rule: Deleting an Existing Filter Rule in the Conditional Import Rules Form.
A Simplified Workflow Example Using Conditional Import Filters Rules
XXXX
XXXX
XXXX
An Advanced Workflow Example Using Conditional Import Filters Rules
YYY
YYY
YYY
Using Conditional Import Filters with Microsoft Project Integrated Master Schedules (IMS)
1) Integrated Master Schedules (IMS) in Microsoft Project are a common used and OPP handles these quite effectively.
2) As a refresher, please consult this article for information on how OPP builds graphs from Microsoft Project IMS source plans at: Making Multi-Project Graphs from MS Project Integrated Master Schedules .
3) Once a Microsoft Project IMS source plan is created, the selection of source plan rows for import to OPP is essentially the same as for single project Microsoft Project source plans. Using either flag fields or Conditional Import Filters rules are applied to the entire source plan and OPP will create a graph according to the current Template once the source plan rows are imported.
4) Accordingly, the instructions provided in this article for single Microsoft Project source plans with respect to the OPP modes of NEW, UPDATE, and OPEN apply to Microsoft Project IMS source plans.
Using Conditional Import Filters with Multiple Separate Microsoft Project Source Plan Packages
1) Separate Microsoft Project source plans that are grouped into packages for processing by OPP are treated as a single source plan entity from the perspective of import to OPP.
- a) When a flag field is used to control the import of rows from multiple, separate Microsoft Project source plans grouped by OPP into a package, that flag field is applied to every single multiple Microsoft Project source plan uniformly in the package.
- b) When Conditional Import Filters rules are being used to control the import of separate Microsoft Project source plans grouped by OPP into a package, the defined Conditional Import Rules form controls the import of rows from each of the separate Microsoft Project source plans in turn.
2) As a refresher please consult this article for information on how OPP builds graphs from multiple separate Microsoft Project source plans at: Making Multi-Project Graphs from Separate Microsoft Project Plans .
3) As with Microsoft Project IMS source plans, the instructions provided in this article for single Microsoft Project source plans with respect to the OPP modes of NEW, UPDATE, and OPEN apply to import from separate multiple Microsoft Project source plans.
Using Conditional Import Filters with Server Resident Microsoft Project Source Plan
1) When Microsoft Project source plans are accessed from servers in the “cloud” the source plans required are first down loaded into OPP before any defined flag field or Conditional Import Filters rules are applied. Therefore, import processing for server resident Microsoft Project source plans differs only from desktop computer resident source plan in their location.
2) Please consult this article for information on how OPP accesses server resident Microsoft Project source plans at: Creating Project Views from Server Resident Project Plans for OnePager Pro (Portal) .
3) As with Microsoft Project IMS source plans and separate multiple Microsoft Project source plans, the instructions provided in this article for single Microsoft Project source plans with respect to the OPP modes of NEW, UPDATE, and OPEN apply to import from server resident Microsoft Project source plans.
Using Enterprise Custom Fields from Microsoft Project Source Plans in Conditional Import Filters Rules
1) A complete discussion of Enterprise Custom Fields is provided in this article: Using Enterprise Custom Fields from Microsoft Project for OnePager Pro .
2) As discussed above in the previous sub-sections of this article, once a Microsoft Project source plans or packages are provided to OPP regardless of media (i.e., desktop or server resident), OPP can determine which source plan rows to import based on either the flag field you designate or the fields and logic you create in the Conditional Import Rules form. However, it is required that you must first assure that any set of Enterprise Custom Fields you wish to use (for any purpose in OPP) be first included as described in the article referenced in the previous paragraph.
3) Again, as discussed in the previous sub-sections, with respect to the OPP modes of NEW, UPDATE, and OPEN apply to import rules using Enterprise Custom Fields.
Related Links
Conditional Formatting (Portal)
Using the OnePager "Data" Tab's "Selected file(s)" Button
OnePager Express Import of Data from Microsoft Excel <4.4-60-->
Message to Assist with Setting Import Flags When No Data Are Imported
Understanding Project Views and Snapshots for OnePager Pro
(7.18.1.1-60)