Difference between revisions of "TEMPzz3"

From OnePager Documentation
Jump to: navigation, search
Line 1: Line 1:
==About Unlimited Field Mapping==
+
==Overview==
  
'''Unlimited Field Mapping''' ('''UFM'''), provided in OnePager Pro and Express versions 6.0 and later,  is a vastly more efficient way to bring additional '''source plan fields''' into a chart after you've created and '''edited''' it.  With '''UFM''', a chart has access to all '''source plan fields'''.  '''Field Mapping''' is defined as the '''use''' of a '''source plan field''' for a particular OnePager '''purpose'''.  There are more than 25 OnePager '''purposes''' from '''Baseline Finish Date''' to '''Unique task/milestone identifier'''.  With this feature, you can easily refer back to your '''source plan''' and access changed '''fields''' for your chart.  For example, you can populate a '''Text field''' in Microsoft Project and then use that '''Text field''' to present data in an '''Text Column''' after the chart was first created.
+
1) OnePager Pro is capable of '''importing''' separate '''source plans''' to create a '''multi-project''' chart from individual '''source plans'''.
  
Further, OnePager Pro gives you a more efficient way to change the '''field mapping''' for eight (8) of the most frequently used OnePager Pro '''presentation purposes'''.  For OnePager Express, there are seven (7) such '''presentation purposes''' because it omits display of '''critical path''' information.  All this is explained further below.
+
2) In the article at: [[Making Multi-Project Charts from MS Project Integrated Master Schedules for Version 7.1 | Making Multi-Project Charts from MS Project Integrated Master Schedules]], 8.1.1-71 the Microsoft Project '''Integrated Master Schedule''' feature is used to construct a '''multi-project source plan''' from which OnePager Pro ('''OPP''') created a '''multi-project''' chart.
  
==Using Unlimited Field Mapping – A Microsoft Project Example==
+
3) Suppose you want to build a '''multi-project''' chart without first creating a Microsoft Project '''Integrated Master Schedule''' ('''IMS'''). 
  
Suppose we use a '''source plan''' called BlueGrass Project Plan. If we look at the '''source plan field''' headings from this Microsoft Project '''source plan''' they would look like this:
+
4) To illustrate an approach to do this, we’ll use the OnePager Pro ('''OPP''') '''Add-in''' application following the steps described in the remainder of this article.
  
<center>[[File:P70-7_19_1-(1)-05122020.png]]</center>
+
==Setting Up Steps==
<!--<center>P70-7_19_1-(1)-05122020.png</center>-->
+
  
Along with the typical '''Task Name''', '''Duration''', '''Start date''' and '''Finish date''' '''fields''' and some others, there are two '''flag''' fields ('''Flag20 and Flag10''') and a text field ('''Text10''') which appears to be used to specify the task's estimated risk.  If we create a simple chart using the standard Single Project Gantt View – Detailed '''Template Properties''' form and '''Flag20''' to control the import, we get a chart that looks something like this:
+
===Settings for Microsoft Project===
  
<center>[[File:P70-7_19_1-(2)-05122020.png]]</center>
+
1) OnePager Pro ('''OPP''') uses the '''labels''' of the '''project-summary task''' to identify each project in a '''multi-project''' chart.  
<!--<center>P70-7_19_1-(2)-05122020.png</center>-->
+
  
To see where the '''Unlimited Field Mapping''' first comes into play, let’s look at the '''Chart Properties''' form’s '''Rows/Swimlanes''' tab and one of the dropdown lists that contain '''field''' names from the '''source plan'''. An example from the '''Rows/Swimlanes''' tab is shown here:
+
2) OnePager does not use the Microsoft Project '''source plan file name''' to identify projects.  
  
<center>[[File:P70-7_19_1-(3)-05122020.png]]</center>
+
3) If you want to display the '''project summary task''' at the top of a Microsoft Project file, go to the '''File''' tab on Microsoft Project’s ribbon tool bar.  
<!--<center>P70-7_19_1-(3)-05122020.png</center>-->
+
  
In the dropdown list above all the '''field names''' from the Microsoft Project '''source plan''' that were '''imported''' when the chart was created as shown '''ABOVE''' the '''dotted line'''.  The '''fields''' listed '''BELOW''' the '''dotted line''' are '''all available''' to OnePager with '''Unlimited Field Mapping'''.  For the sake of this example, let’s suppose that we want to use additional data from our Microsoft Project '''source plan''' shown above.  Our purpose in this example is to access the new data from Microsoft Project (e.g., '''Text10''' field) and use the data to populate an '''text column''' in the updated chart.  To accomplish this chart update, we need to tell OnePager Pro that we want to use the '''Text10''' field for the purpose of creating an '''Text Column'''.  This is done by accessing the '''Chart Properties''' form's '''Rows/Swimlanes''' tab, navigating to the '''Text Columns''' control group, checking the '''Left#1''' sub-tab's '''Display data from''' checkbox to '''ON''' Then, use the dropdown window to the right to select the '''Text10''' entry as shown here:
+
4)Then navigate to '''Options''' tab and once there, to the '''Advanced''' tab and check the checkbox '''ON''' that is shown below:
  
<center>[[File:P70-7_19_1-(4)-05122020.png]]</center>
+
<center>[[File:P70-8_2_1-70-(0)-08282019.png]]</center>
<!--<center>P70-7_19_1-(4)-05122020.png</center>-->
+
<!--<center>P70-8_2_1-70-(0)-08282019.png</center>-->
  
When you are finished establishing the controls for the '''Text Column''', click OK on the '''Chart Properties''' form.  OnePager Pro now accesses your Microsoft Project '''source plan''', '''imports''' the data in the '''Text10''' field, and re-configures the chart to look like this:
+
5) When you are using the '''Pull''' operation workflow to create a '''multi-project''' chart, the setting above on the Microsoft Project’s '''Project Options''' page must be set '''before''' the first designated Microsoft Project '''source plan''' is '''pulled in''' and must stay set for all subsequent '''source plan Pull''' operations.
  
<center>[[File:P70-7_19_1-(5)-05122020.png]]</center>
+
6) This is because, although Microsoft Project, as an application, does not appear on your screen anytime during the '''Pull''' operation, nevertheless, it is launched by '''OPP''' and operates on the designated files before '''OPP''' processes them.
<!--<center>P70-7_19_1-(5)-05122020.png</center>-->
+
  
You can '''edit''' the '''Text Column''' header by changing it from '''Text10''' to '''Risk Assessment''', perhaps.  The same methods applies when your '''source plan''' is Microsoft Excel and you are using OnePager Express.
+
7) The setting for Microsoft Project discussed above does not need to be switched '''ON''' when '''Push''' operational workflows are being used.
  
==The Template Properties Form’s Field Mappings Tab==
+
===Predatory Steps===
  
The '''Field Mappings''' tab in the '''Template Properties''' form has several purposes. Among these purposes is the selection of '''source plan fields''' that can be used later on with the chart, selection of '''fields''' for some '''presentation purposes''', and to identify an optional field for '''field splitting'''.  The '''Template Properties'''' form's '''Field Mappings''' tab, simplified the '''remapping''' using this tab for eight (8) OnePager Pro '''column''' purposes (seven (7) for OnePager Express), and supports the '''field splitting controls'''.  In addition, there are '''Task/Milestone Identity''' controls to assist with '''Unique ID''' issues discussed elsewhere in this Wiki.
+
8) Before proceeding with the construction of a OnePager Pro '''multi-project''' chart, the first step is to assure that the '''Template Properties''' form used is for '''Single Project Gantt Chart - Detailed'''.   
  
===OnePager Pro===
+
9) This is because OnePager Pro is going to '''import''' two or more '''source plans''' and use them to construct the desired chart.
  
The '''Field Mappings '''tab in the '''Template Properties''' form for OnePager Pro looks like this:
+
10) Further, since each Microsoft Project '''source plan''' contains its own '''UniqueID''' sequence and since these '''UniqueID''' values may be duplicates from one '''source plan''' to the next, we need to make OnePager Pro aware that it must '''safely combine tasks from different source plans'''.
  
<center>[[File:P70-7_19_1-(6)-05122020.png]]</center>
+
11) These steps are described below:
<!--<center>P70-7_19_1-(6)-05122020.png</center>-->
+
  
The eight dropdown lists shown in the upper part of the form above are '''common uses''' that our customers need most frequently, but there are other important '''presentation purposes''' on the '''Rows/Swimlanes''' tab and the '''Task Bars''' and '''Milestones''' tab's of the '''Chart Properties''' form.
+
===Modifying the OnePager Pro Template Properties Form for Creating Multi-Project Charts===
  
Each dropdown list contains the Microsoft Project '''source plan fields''' of data types appropriate for its purpose.  For example, the '''Critical-path''' '''purpose''' allows only '''Boolean''' and '''Numeric''' fields, whereas the dropdowns in the '''Date Fields''' group contain only '''date''' fields and the '''Percent-Complete''' purpose allows only numeric fields. The '''Field Splitting''' group in the '''Field Mappings '''tab of the OnePager Pro '''Template Properties''' form works in the same way as it did in previous versions of OnePager Pro.
+
12) Launch Microsoft Project and navigate to the '''Add-ins''' tab on the Microsoft Project ribbon tool bar.
  
For more information on '''Splitting and parsing columns''', please see the article at: [[Splitting and Parsing Columns for OnePager Pro for Version 7.0 | Splitting and Parsing Fields-OnePager Pro]] 24.4.1-70
+
13) Click the '''Template''' button which accesses the current '''Template Properties''' form.
  
The '''Unique Id''' control in the '''Task/Milestone Identity Mapping''' control group shows the Microsoft Project '''source plan field''' that OnePager Pro used when it first created the chart.  This feature is available to assist advanced OnePager Pro users for '''updating''' charts when they have copied one Microsoft Project '''source plan''' into another. The '''Task/Milestones Identity Mapping''' control group is also found on the '''Chart Properties''' form's '''Field Mappings''' tab, but it is '''disabled''' there because you cannot change the '''Unique Id''' after a chart is created.
+
14) Assure that the '''Template Properties''' form type is '''Single Project Gantt Chart - Detailed''' or a '''Template Properties''' form of your own that is '''equivalent''' as used in this example shown below:
  
===OnePager Express===
+
<center>[[File:P70-8_2_1-(1)-05132020.png]]</center>
 +
<!--<center>P70-8_2_1-(1)-05132020.png</center>-->
  
The '''Field Mappings '''tab in the '''Template Properties '''form for OnePager Express looks like this:
+
15) At the '''Advanced''' tab, check the '''Safely combine tasks from different files''' checkbox '''ON''' as shown above. 
  
<center>[[File:P70-7_19_1-(7)-05122020.png]]</center>
+
16) This setting allows you to '''import multiple''' standalone Microsoft Project '''source plans'''.  
<!--<center>P70-7_19_1-(7)-05122020.png</center>-->
+
  
The seven (7) dropdown lists shown in the upper part of the form above are the '''common uses''' that our customers need most frequently, but there are other important '''presentation purposes''' on the '''Rows/Swimlanes''' tab and the '''Task Bars''' and '''Milestones''' tabs of the '''Chart Properties''' form. The dropdown lists here contain '''field''' headings found on the active Microsoft Excel '''source plan''' when the '''Template Properties''' form is accessed. Each dropdown list has two components divided by a '''dotted line'''.  The '''fields''' above the '''dotted line''' are properly classified as to data type when the chart was created. The list of '''fields''' below the '''dotted line''' are those remaining '''source plan''' fields that can not be accurately classified. A typical dropdown list of '''source plan fields''' for the OnePager Express '''Field Mappings '''tab in the '''Template Properties''' form might look like this:
+
17) If you do not check this checkbox '''ON''', OnePager may confuse tasks from one Microsoft Project '''source plan''' with tasks from another when the tasks have the same '''UniqueID'''.
  
<center>[[File:P70-7_19_1-(8)-05122020.png]]</center>
+
===Making Adjustments to Rows and Swimlanes===
<!--<center>P70-7_19_1-(8)-05122020.png</center>-->
+
  
The '''Field Splitting''' control group in the '''Field Mappings''' tab of the OnePager Express '''Template Properties''' form works in the same way as it did in previous versions of OnePager Express.
+
18) With the '''Template Properties''' form used previously, go to the '''Template Properties''' form’s '''Rows/Swimlanes''' tab shown below.  
  
For more information on '''Splitting and parsing columns''', please see the article at: [[Splitting and Parsing Columns for OnePager Express for Version 7.0 | Splitting and Parsing Fields-OnePager Express]] 24.5.1-70 
+
19) Ensure that you are '''grouping''' and '''labeling''' the '''swimlane level''' by the '''Project Name'''.  
  
The '''Unique Id''' field in the '''Task/Milestone Identity Mapping''' control group shows the Microsoft Excel '''source plan''' field that OnePager Express uses when it first created the chart and then retains for all future updates.  The '''Task/Milestone Identity Mapping''' control group is also found on the '''Chart Properties''' form's '''Field Mappings''' tab, but it is '''disabled''' there because you cannot change the '''Unique Id''' after a chart is created. As a note, please take a look at the paragraph just above the '''Field Mappings''' control group title in the tab for both OnePager Pro and Express.  Whenever you make a change to the '''Task Name, Percent Complete, and Critical''' '''fields''' in the '''Template Properties''' form’s '''Field Mappings '''tab, OnePager updates the corresponding '''fields''' in the '''Gantt Bar Decorations''' control group of the '''Task Bars '''and '''Milestone '''tabs.
+
20) This step is optional, it is strongly recommended.
  
==The Chart Properties Form’s Field Mappings Tab==
+
<center>[[File:P70-8_2_1-(2)-05132020.png]]</center>
 +
<!--<center>P70-8_2_1-(2)-05132020.png</center>-->
  
Using '''Unlimited Field Mapping''' on the '''Chart Properties''' form, you can change '''Field Mappings''' after chart creation. The '''Chart Properties''' form’s '''Field Mappings''' tabs for OnePager Pro and Express mirror the '''Field Mappings''' tabs in their respective '''Template Properties''' forms.  As an example, suppose we change the '''Chart Properties''' form’s '''Field Mappings''' tab’s '''Finish''' dropdown to use the '''source plan’s''' '''Start''' field as shown below:
+
21) Now click the '''Save and use''' or '''Use''' button to make this '''Template Properties''' form the current '''Template Properties''' form to support creating a '''multi-project''' chart.
  
<center>[[File:P70-7_19_1-(9)-05122020.png]]</center>
+
22) Once you’ve '''saved''' the '''Template Properties''' form, the next series of steps below involve accessing the separate Microsoft Project '''source plans''' that we intend to use for our '''multi-project''' chart.
<!--<center>P70-7_19_1-(9)-05122020.png</center>-->
+
  
If the chart looks like this '''before''' the above change is made:
+
===Load the First Microsoft Project Source Plan===
  
<center>[[File:P70-7_19_1-(10)-05122020.png]]</center>
+
23) With Microsoft Project already launched, use the '''Files''' controls in Microsoft Project to load the first Microsoft Project '''source plan''' as shown here:
<!--<center>P70-7_19_1-(10)-05122020.png</center>-->
+
  
'''After''' the '''Finish''' dropdown window is changed to show the '''Start''' field, the chart looks like this:
+
<center>[[File:P70-8_2_1-(3)-05132020.png]]</center>
 +
<!--<center>P70-8_2_1-(3)-05132020.png</center>-->
  
<center>[[File:P70-7_19_1-(11)-05122020.png]]</center>
+
24) When you click the '''Open''' button on the form above, Microsoft Project loads the '''source plan''' in the normal manner.
<!--<center>P70-7_19_1-(11)-05122020.png</center>-->
+
  
Changing the usage of the '''Finish '''dropdown to read '''Start''' tells OnePager that the '''Start '''and '''Finish''' dates are the same and that the task bar should be represented as a milestone symbol as shown above.
+
25)  With the '''first source plan''' loaded, navigate to the Microsoft Project '''Add-ins''' tab and click the '''OnePager Pro''' button to launch OnePager and access the '''OnePager Start''' form.
  
==Related Links==
+
26) Now click the '''NEW''' button on the '''OnePager Start''' form to access the OnePager choices ('''OPC''') form as shown here: 
  
[[Basic Workflows for Version 7.1 (Portal) | Basic Workflows (Portal)]] 7.0.1-71
+
<center>[[File:P70-8_2_1-70-(4)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(4)-08282019.png</center>-->
  
[[Conditional Formatting for Version 7.1 (Portal) | Conditional Formatting (Portal)]] 11.0.1-71
+
27) In the illustration above, OnePager Pro already knows the '''name''' of the '''first source plan'''.
  
[[Using the OnePager "Data" Tab's "Selected file(s)" Button for Version 7.1 | Using the OnePager "Data" Tab's "Selected file(s)" Button]] 7.17.1-71
+
28) Complete the remainder of the fields in the '''OPC''' form such as the '''Title of New Chart''' and the '''Snapshot Date''' if applicable.
  
[[OnePager Express Import of Data from Microsoft Excel for Version 7.0 | OnePager Express Import of Data from Microsoft Excel]] 4.0.1.4-70
+
29) To add the remaining two (2) '''source plans''' used in this example, it is necessary to create a '''source package''' assuring that all three '''source plans''' are included.
  
[[Understanding Charts and Snapshots for OnePager Pro for Version 7.0 | Understanding Charts and Snapshots for OnePager Pro]] 4.0.1.1-70
+
30) To do this click on the '''Add/Remove''' button near the top of the '''OPC''' form.
  
[[Understanding Charts and Snapshots for OnePager Express for Version 7.0 | Understanding Charts and Snapshots for OnePager Express]] 4.0.1.2-70
+
31) This action accesses the '''Data source selection''' form where the '''first source plan''' is already present in the grid as shown below:
  
[[Advanced Tab for OnePager Pro for Version 7.0#Reset Unique Ids on Update | Advanced Tab for OnePager Pro-Reset Unique Ids on Update]] 21.13.1-70
+
<center>[[File:P70-8_2_1-70-(5)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(5)-08282019.png</center>-->
  
[[Splitting and Parsing Columns for OnePager Pro for Version 7.0 | Splitting and Parsing Fields-OnePager Pro]] 24.4.1-70
+
===Add the Second Microsoft Project Source Plan to the Source Packet===
 +
 
 +
32) Using the '''Data source selection''' form, click the '''Add''' button in the form which gives you the option to select a '''recently used source plan''' or to '''BROWSE...'''.
 +
 
 +
33) Select the '''BROWSE...''' option so that you can select the '''second source plan''' for the multi-project''' chart being created.
 +
 
 +
34) Click on the desired '''second source plan''' as shown below and click the '''Open''' button on the form.
 +
 
 +
<center>[[File:P70-8_2_1-(6)-05132020.png]]</center>
 +
<!--<center>P70-8_2_1-(6)-05132020.png</center>-->
 +
 
 +
35) This action '''adds''' the '''second source plan''' to the '''source packet''' as shown below in the '''Data source selection''' form after the operation is complete.
 +
 
 +
<center>[[File:P70-8_2_1-70-(7)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(7)-08282019.png</center>-->
 +
 
 +
===Add the Third Microsoft Project Source Plan to the Source Packet===
 +
 
 +
36) Repeat this exact same process to '''add''' the '''third source plan''' to the '''source packet'''.
 +
 
 +
37) At the completion of that step the '''Data source selection''' form looks like this:
 +
 
 +
<center>[[File:P70-8_2_1-70-(8)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(8)-08282019.png</center>-->
 +
 
 +
38) When the '''OK''' button on the '''Data source selection''' form is clicked, the '''OPC''' form is '''updated''' to show that three '''source plans''' are included in the '''source packet''' as shown below:
 +
 
 +
<center>[[File:P70-8_2_1-70-(9)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(9)-08282019.png</center>-->
 +
 
 +
===Create the Multi-Project Chart===
 +
 
 +
39) Now, go ahead and click the '''Create the new chart''' button on the '''OPC''' form and the resulting chart looks like this:
 +
 
 +
<center>[[File:P70-8_2_1-70-(10)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(10)-08282019.png</center>-->
 +
 
 +
==Updating Charts Created from Separate Microsoft Project Plans==
 +
 
 +
1) Eventually there is a need to '''update''' your '''multi-project''' chart by either '''adding''' a snapshot or '''replacing''' a snapshot with '''updated''' data. 
 +
 
 +
2) To perform either the '''add''' or the '''replace''' snapshot operation, the processes described in the article at: [[REPLACING a Snapshot via Pull Operation for Version 7.1 | REPLACING a Snapshot via Pull Operation]] 7.14.1-71
 +
 
 +
3) The key to '''updating multi-project''' charts is the proper management of the '''source packet'''. 
 +
 
 +
4) Recall that the '''source packet''' contains the file or files that are to be used to either create or '''update''' a chart. 
 +
 
 +
5) They are stored as '''file names''' and '''path names''' in the chart’s '''.TAM''' file and can be accessed from the OnePager '''Data''' ribbon tool bar tab’s '''Selected file(s)''' button as shown below:
 +
 
 +
<center>[[File:P70-8_2_1-70-(11)-08282019.png]]</center>
 +
<!--<center>P70-8_2_1-70-(11)-08282019.png</center>-->
 +
 
 +
6) Validating the contents of the '''source packet''' and assuring that these are the Microsoft Project '''source plans''' to '''update''' is an essential step before proceeding to perform a '''multi-project''' chart '''update'''.
 +
 
 +
==Related Links==
 +
 
 +
[[REPLACING a Snapshot via Pull Operation for Version 7.1 | REPLACING a Snapshot via Pull Operation]] 7.14.1-71
 +
 
 +
[[ADDING a Snapshot via Pull Operation for Version 7.1 | ADDING a Snapshot via Pull Operation]] 7.15.1-71
 +
 
 +
[[Custom Update (Replacing) of a Snapshot via Pull Operation for Version 7.1 | Custom Update (Replacing) of a Snapshot via Pull Operation]] 7.16.1-71
 +
 
 +
[[Using the OnePager "Data" Tab's "Selected file(s)" Button for Version 7.1 | Using the OnePager "Data" Tab's "Selected file(s)" Button]] 7.17.1-71
  
[[Splitting and Parsing Columns for OnePager Express for Version 7.0 | Splitting and Parsing Fields-OnePager Express]] 24.5.1-70
+
[[Making Multi-Project Charts from MS Project Integrated Master Schedules for Version 7.1 | Making Multi-Project Charts from MS Project Integrated Master Schedules]] 8.1.1-71
  
(7.19.1-71)
+
(8.2.1-71)
  
 
[[Category:Version 7.1]]
 
[[Category:Version 7.1]]
[[Category:Add-in]]
 
 
[[Category:Desktop]]
 
[[Category:Desktop]]
 
[[Category:Basic Workflows]]
 
[[Category:Basic Workflows]]
 +
[[Category:Multi-Project Formats]]
 +
[[Category:Templates]]
 
[[Category:Conditional Import Filters]]
 
[[Category:Conditional Import Filters]]
[[Category:Unlimited Field Mapping]]
+
[[Category:OnePager Choices Form]]
[[Category:Importing]]
+
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Editing the Chart]]
+
[[Category:Sharing Output]]
[[Category:OnePager - Tool Bar]]
+
[[Category:Microsoft Project]]
[[Category:Basic Workflows]]‏‎
+
[[Category:Snapshots]]
+
[[Category:Task/Milestone Editing]]
+
[[Category:Conditional Formatting]]
+
[[Category:Getting Started with Version 7.1‏‎]]
+
 
[[Category:OnePager Pro]]
 
[[Category:OnePager Pro]]
[[Category:OnePager Express]]
 

Revision as of 16:35, 1 March 2021

Overview

1) OnePager Pro is capable of importing separate source plans to create a multi-project chart from individual source plans.

2) In the article at: Making Multi-Project Charts from MS Project Integrated Master Schedules, 8.1.1-71 the Microsoft Project Integrated Master Schedule feature is used to construct a multi-project source plan from which OnePager Pro (OPP) created a multi-project chart.

3) Suppose you want to build a multi-project chart without first creating a Microsoft Project Integrated Master Schedule (IMS).

4) To illustrate an approach to do this, we’ll use the OnePager Pro (OPP) Add-in application following the steps described in the remainder of this article.

Setting Up Steps

Settings for Microsoft Project

1) OnePager Pro (OPP) uses the labels of the project-summary task to identify each project in a multi-project chart.

2) OnePager does not use the Microsoft Project source plan file name to identify projects.

3) If you want to display the project summary task at the top of a Microsoft Project file, go to the File tab on Microsoft Project’s ribbon tool bar.

4)Then navigate to Options tab and once there, to the Advanced tab and check the checkbox ON that is shown below:

P70-8 2 1-70-(0)-08282019.png

5) When you are using the Pull operation workflow to create a multi-project chart, the setting above on the Microsoft Project’s Project Options page must be set before the first designated Microsoft Project source plan is pulled in and must stay set for all subsequent source plan Pull operations.

6) This is because, although Microsoft Project, as an application, does not appear on your screen anytime during the Pull operation, nevertheless, it is launched by OPP and operates on the designated files before OPP processes them.

7) The setting for Microsoft Project discussed above does not need to be switched ON when Push operational workflows are being used.

Predatory Steps

8) Before proceeding with the construction of a OnePager Pro multi-project chart, the first step is to assure that the Template Properties form used is for Single Project Gantt Chart - Detailed.

9) This is because OnePager Pro is going to import two or more source plans and use them to construct the desired chart.

10) Further, since each Microsoft Project source plan contains its own UniqueID sequence and since these UniqueID values may be duplicates from one source plan to the next, we need to make OnePager Pro aware that it must safely combine tasks from different source plans.

11) These steps are described below:

Modifying the OnePager Pro Template Properties Form for Creating Multi-Project Charts

12) Launch Microsoft Project and navigate to the Add-ins tab on the Microsoft Project ribbon tool bar.

13) Click the Template button which accesses the current Template Properties form.

14) Assure that the Template Properties form type is Single Project Gantt Chart - Detailed or a Template Properties form of your own that is equivalent as used in this example shown below:

P70-8 2 1-(1)-05132020.png

15) At the Advanced tab, check the Safely combine tasks from different files checkbox ON as shown above.

16) This setting allows you to import multiple standalone Microsoft Project source plans.

17) If you do not check this checkbox ON, OnePager may confuse tasks from one Microsoft Project source plan with tasks from another when the tasks have the same UniqueID.

Making Adjustments to Rows and Swimlanes

18) With the Template Properties form used previously, go to the Template Properties form’s Rows/Swimlanes tab shown below.

19) Ensure that you are grouping and labeling the swimlane level by the Project Name.

20) This step is optional, it is strongly recommended.

P70-8 2 1-(2)-05132020.png

21) Now click the Save and use or Use button to make this Template Properties form the current Template Properties form to support creating a multi-project chart.

22) Once you’ve saved the Template Properties form, the next series of steps below involve accessing the separate Microsoft Project source plans that we intend to use for our multi-project chart.

Load the First Microsoft Project Source Plan

23) With Microsoft Project already launched, use the Files controls in Microsoft Project to load the first Microsoft Project source plan as shown here:

P70-8 2 1-(3)-05132020.png

24) When you click the Open button on the form above, Microsoft Project loads the source plan in the normal manner.

25) With the first source plan loaded, navigate to the Microsoft Project Add-ins tab and click the OnePager Pro button to launch OnePager and access the OnePager Start form.

26) Now click the NEW button on the OnePager Start form to access the OnePager choices (OPC) form as shown here:

P70-8 2 1-70-(4)-08282019.png

27) In the illustration above, OnePager Pro already knows the name of the first source plan.

28) Complete the remainder of the fields in the OPC form such as the Title of New Chart and the Snapshot Date if applicable.

29) To add the remaining two (2) source plans used in this example, it is necessary to create a source package assuring that all three source plans are included.

30) To do this click on the Add/Remove button near the top of the OPC form.

31) This action accesses the Data source selection form where the first source plan is already present in the grid as shown below:

P70-8 2 1-70-(5)-08282019.png

Add the Second Microsoft Project Source Plan to the Source Packet

32) Using the Data source selection form, click the Add button in the form which gives you the option to select a recently used source plan or to BROWSE....

33) Select the BROWSE... option so that you can select the second source plan for the multi-project chart being created.

34) Click on the desired second source plan as shown below and click the Open button on the form.

P70-8 2 1-(6)-05132020.png

35) This action adds the second source plan to the source packet as shown below in the Data source selection form after the operation is complete.

P70-8 2 1-70-(7)-08282019.png

Add the Third Microsoft Project Source Plan to the Source Packet

36) Repeat this exact same process to add the third source plan to the source packet.

37) At the completion of that step the Data source selection form looks like this:

P70-8 2 1-70-(8)-08282019.png

38) When the OK button on the Data source selection form is clicked, the OPC form is updated to show that three source plans are included in the source packet as shown below:

P70-8 2 1-70-(9)-08282019.png

Create the Multi-Project Chart

39) Now, go ahead and click the Create the new chart button on the OPC form and the resulting chart looks like this:

P70-8 2 1-70-(10)-08282019.png

Updating Charts Created from Separate Microsoft Project Plans

1) Eventually there is a need to update your multi-project chart by either adding a snapshot or replacing a snapshot with updated data.

2) To perform either the add or the replace snapshot operation, the processes described in the article at: REPLACING a Snapshot via Pull Operation 7.14.1-71

3) The key to updating multi-project charts is the proper management of the source packet.

4) Recall that the source packet contains the file or files that are to be used to either create or update a chart.

5) They are stored as file names and path names in the chart’s .TAM file and can be accessed from the OnePager Data ribbon tool bar tab’s Selected file(s) button as shown below:

P70-8 2 1-70-(11)-08282019.png

6) Validating the contents of the source packet and assuring that these are the Microsoft Project source plans to update is an essential step before proceeding to perform a multi-project chart update.

Related Links

REPLACING a Snapshot via Pull Operation 7.14.1-71

ADDING a Snapshot via Pull Operation 7.15.1-71

Custom Update (Replacing) of a Snapshot via Pull Operation 7.16.1-71

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

Making Multi-Project Charts from MS Project Integrated Master Schedules 8.1.1-71

(8.2.1-71)