Custom Update (Replacing) of a Snapshot via Pull Operation for OnePager Live Beta 2 (MS Excel Source)

From OnePager Documentation
Jump to: navigation, search

Overview

7.16.2-OPL2 from 7.16.2-60 7/21/2017

The purpose of these articles is to acquaint you with the new pull features of OnePager Pro (OPP) and Express (OPX). There are eight (8) articles in this series, four (4) providing examples of the pull feature for OPP and four (4) for OPX. Please see the links at the end of this article to access other articles in the series.

What is a Pull Operation?

A pull operation starts in the Project View Editor (PVE). That is, you already have OnePager running and decide to update the open project view or (rarely) create a new project view. In contrast, a push operation begins in the OnePager Express Start from which you make a new project view or update an existing project view.

We added the pull operation because we found that our users were often creating a project view, finding something in the source plan that they needed to change, going back to the source plan, making the change, and then re-launching OnePager to update the project view.

The pull update lets you open a project view and update it repeatedly as you edit its source plan. After each set of changes to the source plan, you can quickly see the effect on the screen by using OnePager’s new Data tab to pull the source plan changes into the project view.

The example below will illustrate a pull operation when replacing a snapshot using the Custom Update… button.

Example

1) The Custom Update… feature provides you more flexibility when doing a snapshot replacement. Instead of automatically updating the snapshot in view by pulling in the updated Microsoft Excel source plan, OnePager presents you with the standard OnePager choices (OPC) form from which you may either confirm settings (See: REPLACING a Snapshot via Pull Operation for MS Excel Source 7.14.2-OPL2) or change snapshot settings as needed.

2) For this example, let’s suppose you have a Microsoft Excel source plan for which you have already created a snapshot for a particular date, say, 12/1/2015. However, on 12/3/2015 you receive updated information that updates your plan accordingly. You now want to update the project view’s snapshot for 12/1/2015 to reflect the new information. This example is performed for you in article REPLACING a Snapshot via Pull Operation for MS Excel Source 7.14.2-OPL2 so we won’t repeat it here.

3) In this case, you want to create a project view for 12/1/2015 that includes all tasks from the Microsoft Excel source file as a way of checking the entire project plan. Upon your review you may or may not want to save the results as a Custom Update…

4) Since the Microsoft Excel source plan was updated and now reflects the latest information for 12/3/2015 we just need to use the pull operation to bring in the updated Microsoft Excel source plan data and replace the snapshot.

Launching OnePager Express from the Desktop Icon

5) First, update the Microsoft Excel source plan with the updated data you want to replace in the snapshot.

6) Launch OPX from the desktop and when the OnePager Express Start form appears, click the OPEN button which, in our example, will provide a dropdown menu with the name of the project view you wish to update by replacement. In this case it’s BlueGrass 2J-303-PMO-X as shown below:

X60-7 14 2-50-(1)-02022017.png

7) The OPX desktop application will bring the selected project view up in the Project View Editor (PVE) window. This is the project view and snapshot we want to replace. To proceed with the replacement click the Data tab on the ribbon. The PVE will look like this:

X60-7 14 2-60-(1A)-02022017.png

Use the Microsoft Excel Source Plan to Do a Custom Update

8) To perform the Custom Update… replacement, click the Custom Update… button on the Data tab as shown below:

X60-7 16 2-60-(1A1)-02032017.png

9) Taking this action will bring up the OPC form as shown above. Note that the OPC form is set up to use the Show It1 field for task selection, to do a replacement of the snapshot taken at 12/2/2015, and to replace only dates. For this example, we want to change the Task Selection control to Select all tasks. When you make these changes the OPC form will look like this:

X60-7 16 2-53-(2)-09202016.png

10) When you click the Next> button, the second page of the OPC form will appear as shown below. You may confirm field mapping settings or make changes to field mapping settings. Using the Custom Update… button opens up a great range of flexibility when making snapshot replacements or adds.

X60-3 0 3-60-(15AA)-03072017.png

11) For project view with multiple snapshots it is important to make sure that you have selected the correct snapshot to display in the PVE window before clicking the Custom Update… button. OnePager knows which snapshot is being displayed and will replace the visible snapshot with data from the parent Microsoft Excel source plan. Navigating between snapshots in a multiple snapshot project view can be done prior to the above action by using the View tab on the ribbon as shown here:

X60-7 16 2-60-(3A)-02032017.png

12) The replaced snapshot for the Custom Update… settings given above will be a project view BlueGrass 2J-303-PMO-X for 12/2/2015 is shown below in this 3 page print preview:

X53-7 16 2-53-(4)-12082015.png

13) Since we are using the OPX desktop application for this example, it was not necessary to launch Microsoft Excel first. As long as you’ve properly prepared your Microsoft Excel source plan just launching OPX from the desktop icon is basically all that is necessary to utilize the new pull operation for snapshot replacement.

Preparing a Second Project View for a Custom Update

14) There are two ways of updating the second project view from the same Microsoft Excel source plan:

(1) After saving the first project view, close the OPX desktop application and repeat the above process by opening the second project view and then using Show It2 to select the tasks.
(2) Remain in the current OPX desktop application window and update the second project view from there.

15) Since the methodology for preparing a second project view is demonstrated in other articles of this series we will dispense with the demonstration.

Compare Results, Edit, Copy to PowerPoint

16) Once you are satisfied with your project views you may save them, copy them into Microsoft PowerPoint presentations, or share time in other ways.

17) The pull operation using the Custom Update… feature is an easy, fast, and flexible way to create multiple project views.

Related Links

Creating a NEW Project View via Pull Operation for MS Project Source 7.13.1-OPL2

Creating a NEW Project View via Pull Operation for MS Excel Source 7.13.2-OPL2

REPLACING a Snapshot via Pull Operation for MS Project Source 7.14.1-OPL2

REPLACING a Snapshot via Pull Operation for MS Excel Source 7.14.2-OPL2

ADDING a Snapshot via Pull Operation for MS Project Source 7.15.1-OPL2

ADDING a Snapshot via Pull Operation for MS Excel Source 7.15.2-OPL2

Custom Update (Replacing) of a Snapshot via Pull Operation for MS PRoject Source 7.16.1-OPL2

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

(7.16.2-OPL2)