Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Split Resources in the Chart)
 
(409 intermediate revisions by the same user not shown)
Line 1: Line 1:
=Getting Started with OnePager 360 (P371-3_0_3-71-04142021.docx)=
 
 
==Introduction==
 
==Introduction==
  
OnePager 360 is a new product that has the capability to create '''Gantt Charts''' from schedule '''source plans''' provided by Microsoft Project, Microsoft Project Server, Microsoft Project Online, Microsoft Excel, Smartsheet, or Oracle Primavera.  Essentially OnePager 360 combines the '''source plan''' import capabilities of OnePager Pro and OnePager Express and adds the capabilities to process '''source plans''' from Smartsheet and Primavera.
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
Like OnePager Pro and Express, OnePager 360 is employed either as an Add-in to Microsoft Project or Microsoft Excel.  OnePager 360 also has the capability to be launched as a '''Standalone''' application where it can import '''source plan''' files from the above mentioned schedule '''source plan '''file types.
+
==About Splitting and Parsing Fields==
  
Installing OnePager 360 on a computer is in place of OnePager Pro or Excel.  Once installed, OnePager 360 operates exactly like OnePager Pro for '''source plans''' presented from Microsoft Project, Microsoft Project Server, Microsoft Project Online, and Microsoft Excel in either the '''Add-in''' or '''Standalone '''editionOnePager 360 '''Standalone '''edition is used to access Smartsheet and Primavera '''source plans''' since there are no '''Add-in '''capabilities for these two '''source plan '''creation applications.
+
The OnePager '''column splitting''' feature allows you to '''duplicate task bars''' when a task in your Asana '''source plan''' is assigned to '''multiple resources''' (or anything else)Because assignments from Asana often are '''comma-delimited''', this feature enables OnePager to '''parse the comma-delimited list''' and '''create a unique task bar''' for each instance in the '''comma-separated''' list.
  
In most cases only OnePager 360 '''or''' OnePager Pro/Express can be installed in a single user account on a computer although OnePager 360 '''and''' OnePager Pro/Express can be installed in '''different''' user accounts on a single computer.
+
===Split Resource Names Example===
  
For more information on installing OnePager 360, please see the article at: [[Installing and Activating OnePager 360 for Version 7.1 (Portal) | Installing and Activating OnePager 360 (Portal)]] 2.0.3-71.
+
Say you want to use '''color-codes''' on task bars/milestone symbols based upon your Asana '''source plan’s Assigned to''' column as shown below:
  
==Using OnePager 360 Add-in with Microsoft Project and Microsoft Excel Source Plans==
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
OnePager 360 is typically installed as an '''Add-in '''to both Microsoft Project and Microsoft Excel and as a '''Standalone'''.  Accordingly, there is no difference in the initial or continued operations and capabilities of OnePager 360 with respect to '''source plans''' originating from Microsoft Project, Project Server, Project Online, or Excel.  The only difference you will see when using OnePager 360 instead of OnePager Pro, for example, is that the color of the forms are blue instead of red and the name of the product in the '''ADD-INS''' tab for Microsoft Project or Excel says OnePager 360 as illustrated with the Microsoft Project '''ADD-INS '''tool bar tabs shown below:
+
Some of the entries in the '''Assigned to''' column consist of multiple, '''comma-separated''' items and some tasks only used one '''resource'''.  Without the '''column splitting''' feature, a chart '''created''' from these data and assigned task bar/milestone symbol '''colors''' based upon the '''Assigned to''' column looks like this:
  
<center>[[File:P71-3_0_3-71-(1)-03312021.png]]</center>
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
<center>P71-3_0_3-71-(1)-03312021.png</center>
+
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
The '''ADD-INS''' tab for Microsoft Excel with OnePager 360 installed as an '''Add-in''' looks like this:
+
OnePager, in this case, treats the '''entire string''' as an individual '''Assigned to''' value.  To provide more flexibility in displaying task bars that have '''multiple resources''' assigned, OnePager supports the concept of a '''column splitting'''.  This feature recognizes '''comma-separated''' values in a '''designated column''' and '''creates a separate task bar''' for each of the '''comma-separated''' values.
  
<center>TBD-Error in OnePager 360 7.1.B</center>
+
===Enabling Splitting===
<center>P71-3_0_3-71-(2)-03312021.png</center>
+
  
This being the case, all the instructional material you will need to '''get started''' using OnePager 360 with Microsoft Project or Microsoft Excel source plans is contained in the two existing Wiki articles for OnePager Pro and OnePager Express at the links shown in the table below:
+
To use this feature requires turning '''ON''' the feature in the Asana '''Template Properties''' form you intend to use to make the chart.  The setting must be turned '''ON''' before the chart is created so launch OnePager Bundle from the '''desktop icon''', click the '''NEW''' button on the '''OnePager Bundle Start''' form to access the '''OnePager choices''' form, '''select''' your Asana '''source plan''', and type in the chart's '''title''' as shown here:
  
<center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
{| class="wikitable"
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
| [[Getting Started with OnePager Pro Version 7.1# Launching OnePager Pro Add-in for the First Time | Getting Started with OnePager Pro - Launching OnePager Pro Add-in for the First Time]] 3.0.1-71
+
|-
+
| [[Getting Started with OnePager Express Version 7.1# Launching OnePager Express Add-in for the First Time | Getting Started with OnePager Express - Launching OnePager Express Add-in for the First Time]] 3.0.2-71
+
|}
+
</center>
+
  
==Using OnePager 360 Stand Alone==
+
When you click the '''Next>''' button at the bottom of the form, OnePager accesses the second page of the '''OnePager choices''' form shown below:
  
===Launching OnePager 360 Standalone===
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
For OnePager 360 users the '''Standalone '''edition, OnePager 360 is accessed by clicking the '''OnePager 360 Icon''' on your desktop as shown below:
+
Clicking the '''Edit current template''' button accesses the current '''Template Properties''' form.  Navigate to the '''Field Mappings''' tab on the form, check the '''Enable splitting on:''' checkbox to '''ON''' and (in this example) select the '''Assigned To''' column from the dropdown list provided.  The results are shown here:
  
<center>[[File:P71-3_0_3-71-(3)-03312021.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
<center>P71-3_0_3-71-(3)-03312021.png</center>
+
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
Clicking the above '''Icon''' on your desktop launches OnePager 360 as indicated by a standard splash screen as shown below:
+
Click the '''Save and use''' button to complete the process and close the current '''Template Properties''' form returning you to the second page of the '''OnePager choices''' form show above.
  
<center>[[File:P71-3_0_3-71-(4)-04142021.png]]</center>
+
===Split Resources in the Chart===
<center>P71-3_0_3-71-(4)-04142021.png</center>
+
  
When the splash screen closes, the OnePager 360 '''Chart Editor''' is opened and the '''OnePager 360 Start '''form is placed in the middle of the editor as shown here:
+
Clicking the '''Create new chart''' button completes the process and creates the chart with the '''column splitting''' feature in use.  The chart with '''splitting''' looks like this:
  
<center>[[File:P71-3_0_3-71-(5)-04142021.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
<center>P71-3_0_3-71-(5)-04142021.png</center>
+
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
With the '''OnePager 360 Start''' form in view, you are now able to access the three available modes of operation for OnePager 360 ('''NEW''', '''UPDATE''', and '''OPEN''')In all three modes for OnePager 360 '''Standalone''' your '''source plan''' choices include Microsoft Project, Microsoft Project Server, Microsoft Project Online, Microsoft Excel, Smartsheet, and Oracle Primavera.
+
In the chart with '''column splitting''' shown above, there are now several more task bars in the '''Chart Editor''' than there were before.  The task bar for '''Plate Movement''' is now '''split into two (2) separate task bars''', one for each of the '''two resources assigned'''.  The task bar for '''Centrifugal Barrier''' is now '''split into three (3) separate task bars''', one for each of the '''three resources''' that were assigned to this task in the Asana '''source plan'''.  Each of the '''resources''' has a unique '''color''' assigned.  Each of the '''resources''' appears by itself in the '''Legend'''.  The '''Legend title''' shows the '''column name''' that is used for '''splitting the columns'''.
  
====Using OnePager 360 Standalone with Microsoft Project and Microsoft Excel====
+
With this feature, you can use '''column splitting''' just like any other column by using the dropdowns in the '''Template Properties''' form or '''Chart Properties''' form to assign '''colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes'''.
  
OnePager 360 '''Standalone''' when used to create charts from Microsoft Project, Project Server, Project Online, and Excel operates identically to OnePager Pro '''Standalone '''and OnePager Express''' Standalone'''.  This being the case, all the instructional material you will need to '''get started''' using OnePager 360 with Microsoft Project or Microsoft Excel source plans is contained in the two existing Wiki articles for OnePager Pro and OnePager Express at the links shown in the table below:
+
==Splitting Resources and Task Links==
 +
 
 +
When task bars with '''Data-Driven''' or manual '''Task Links''' are '''split''', the '''Task Links''' ('''Data-Driven''' and manual) are '''not shown'''.  Further, the '''Task Links''' that are now '''hidden''' and '''do not''' have entries in the '''Where are My Links?''' form.
 +
 
 +
==Related Links==
  
<center>
 
 
{| class="wikitable"
 
{| class="wikitable"
| [[Getting Started with OnePager Pro Version 7.1# Launching OnePager Pro Standalone for the First Time | Getting Started with OnePager Pro - Launching OnePager Pro Standalone for the First Time]] 3.0.1-71
+
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
 +
| [[Linking Task and Milestones Using Manual and Data-Driven Task Links for Version 7.2 | Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)]] 19.0.1-72
 
|-
 
|-
| [[Getting Started with OnePager Express Version 7.1# Launching OnePager Express Standalone for the First Time | Getting Started with OnePager Express - Launching OnePager Express Standalone for the First Time]] 3.0.2-71
+
| [[Editing with the Chart Properties form for Version 7.2 (Portal) | Editing with the Chart Properties form (Portal)]] 21.0.1-72
 +
| [[Template Only Features for OnePager Pro for Version 7.2 | Template Only Features for OnePager Pro]] 24.1.1-72
 +
|-
 +
| [[Template Only Features for OnePager Express for Version 7.2 | Template Only Features for OnePager Express]] 24.2.1-72
 +
| [[Template Only Features for Primavera P6 Source Plans in OnePager Version 7.2 | Template Only Features for Primavera P6 Source Plans in OnePager]] 24.2.2-72
 +
|-
 +
| [[Template Only Features for Smartsheet Source Plans in OnePager Version 7.2 | Template Only Features for Smartsheet Source Plans in OnePager]] 24.2.3-72
 +
| [[Splitting and Parsing Columns for OnePager Pro for Version 7.2 | Splitting and Parsing Fields for OnePager Pro]] 24.4.1-72
 +
|-
 +
| [[Splitting and Parsing Columns for OnePager Express for Version 7.2 | Splitting and Parsing Fields for OnePager Express]] 24.5.1-72
 +
| [[Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager]] 24.5.2-72
 +
|-
 +
| [[Splitting and Parsing Columns for Smartsheet Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Smartsheet Source Plans in OnePager]] 24.5.3-72
 +
| [[Splitting and Parsing Columns for Project for the Web Source Plans for Version 7.2 | Splitting and Parsing Columns for Project for the Web Source Plans]] 24.5.5-72
 +
|-
 +
| [[Splitting and Parsing Columns for Planisware Enterprise Source Plans for Version 7.2 | Splitting and Parsing Columns for Planisware Enterprise Source Plans]] 24.5.7-72
 +
| [[Splitting and Parsing Columns for Wrike in OnePager Version 7.2 | Splitting and Parsing Columns for Wrike in OnePager]] 24.5.11-72
 
|}
 
|}
</center>
 
  
====Using OnePager 360 Standalone with Smartsheet====
+
(24.5.9-72)
  
To use OnePager 360 '''Standalone''' with Smartsheet you are required to have access to the [http://www.smartsheet.com/ www.smartsheet.com] website, possess an account, and have Smartsheet '''source plans '''that can be '''imported''' to OnePager 360 '''Standalone'''.  With these requirements satisfied and the proper [http://www.smartsheet.com/ www.smartsheet.com] access credentials available, OnePager 360 '''Standalone''' can connect you to your Smartsheet account, access your selected Smartsheet '''source plan''' and create a '''NEW '''chart, '''UPDATE''', an existing chart, or '''OPEN''' an already created chart residing on your computer.
+
[[Category:Version 7.2]]
 
+
[[Category:Editing the Chart]]
The discussion on '''getting started with Smartsheet''' is continued in the article at: [[Using Smartsheet Source Plans with OnePager 360 Version 7.1 | Using Smartsheet Source Plans with OnePager 360]] 3.0.3.3-71.
+
[[Category:Task/Milestone Editing]]
 
+
[[Category:Column Splitting]]
====Using OnePager 360 Standalone with Primavera====
+
 
+
TBD
+
 
+
==Related Links==
+
 
+
[[Getting Started with OnePager Pro Version 7.1]] 3.0.1-71
+
 
+
[[Getting Started with OnePager Express Version 7.1]] 3.0.2-71
+
 
+
(3.0.3-71)
+
 
+
[[Category:Version 7.1]]
+
[[Category:Getting Started with Version 7.1]]
+
[[Category:Add-in]]
+
[[Category:Standalone]]
+
[[Category:Launching From Microsoft Project]]
+
[[Category:Launching From Microsoft Excel]]
+
[[Category:Smartsheet]]
+
[[Category:Primavera]]
+
 
+
 
+
[[Category:OnePager 360 Start Form]]
+
[[Category:OnePager Choices Form]]
+
[[Category:Snapshots]]
+
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Templates]]
 
[[Category:Editing the Chart]]
 
[[Category:Sharing Output]]
 
 
[[Category:Task Links]]
 
[[Category:Task Links]]
[[Category:Time Axis]]
+
[[Category:Ribbon]]
[[Category:Multiple Swimlane Levels]]
+
[[Category:Snapshots]]
[[Category:OnePager - Tool Bar]]
+
[[Category:Template Properties Form]]
[[Category:Help]]
+
[[Category:Chart Properties Form]]
[[Category:OnePager Pro]]
+
[[Category:Asana]]
[[Category:OnePager Express]]
+
[[Category:OnePager Bundle]]
[[Category:OnePager 360]]
+

Latest revision as of 20:52, 27 November 2023

Introduction

This article is focused on using the Column Splitting feature with OnePager Bundle Standalone and imported Asana source plans.

About Splitting and Parsing Fields

The OnePager column splitting feature allows you to duplicate task bars when a task in your Asana source plan is assigned to multiple resources (or anything else). Because assignments from Asana often are comma-delimited, this feature enables OnePager to parse the comma-delimited list and create a unique task bar for each instance in the comma-separated list.

Split Resource Names Example

Say you want to use color-codes on task bars/milestone symbols based upon your Asana source plan’s Assigned to column as shown below:

P72-24 5 3-72-(1)-11022023.png
P72-24_5_3-72-(1)-11022023.png

Some of the entries in the Assigned to column consist of multiple, comma-separated items and some tasks only used one resource. Without the column splitting feature, a chart created from these data and assigned task bar/milestone symbol colors based upon the Assigned to column looks like this:

P72-24 5 3-72-(5)-11272023.png
P72-24_5_3-72-(5)-11272023.png

OnePager, in this case, treats the entire string as an individual Assigned to value. To provide more flexibility in displaying task bars that have multiple resources assigned, OnePager supports the concept of a column splitting. This feature recognizes comma-separated values in a designated column and creates a separate task bar for each of the comma-separated values.

Enabling Splitting

To use this feature requires turning ON the feature in the Asana Template Properties form you intend to use to make the chart. The setting must be turned ON before the chart is created so launch OnePager Bundle from the desktop icon, click the NEW button on the OnePager Bundle Start form to access the OnePager choices form, select your Asana source plan, and type in the chart's title as shown here:

P72-24 5 3-72-(2A)-11022023.png
P72-24_5_3-72-(2A)-11022023.png

When you click the Next> button at the bottom of the form, OnePager accesses the second page of the OnePager choices form shown below:

P72-24 5 3-72-(2AA)-11022023.png
P72-24_5_3-72-(2AA)-11022023.png

Clicking the Edit current template button accesses the current Template Properties form. Navigate to the Field Mappings tab on the form, check the Enable splitting on: checkbox to ON and (in this example) select the Assigned To column from the dropdown list provided. The results are shown here:

P72-24 5 3-72-(2AAA)-11022023.png
P72-24_5_3-72-(2AAA)-11022023.png

Click the Save and use button to complete the process and close the current Template Properties form returning you to the second page of the OnePager choices form show above.

Split Resources in the Chart

Clicking the Create new chart button completes the process and creates the chart with the column splitting feature in use. The chart with splitting looks like this:

P72-24 5 3-72-(2)-11022023.png
P72-24_5_3-72-(2)-11022023.png

In the chart with column splitting shown above, there are now several more task bars in the Chart Editor than there were before. The task bar for Plate Movement is now split into two (2) separate task bars, one for each of the two resources assigned. The task bar for Centrifugal Barrier is now split into three (3) separate task bars, one for each of the three resources that were assigned to this task in the Asana source plan. Each of the resources has a unique color assigned. Each of the resources appears by itself in the Legend. The Legend title shows the column name that is used for splitting the columns.

With this feature, you can use column splitting just like any other column by using the dropdowns in the Template Properties form or Chart Properties form to assign colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes.

Splitting Resources and Task Links

When task bars with Data-Driven or manual Task Links are split, the Task Links (Data-Driven and manual) are not shown. Further, the Task Links that are now hidden and do not have entries in the Where are My Links? form.

Related Links

Templates versus Charts 4.0.1.3-72 Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal) 19.0.1-72
Editing with the Chart Properties form (Portal) 21.0.1-72 Template Only Features for OnePager Pro 24.1.1-72
Template Only Features for OnePager Express 24.2.1-72 Template Only Features for Primavera P6 Source Plans in OnePager 24.2.2-72
Template Only Features for Smartsheet Source Plans in OnePager 24.2.3-72 Splitting and Parsing Fields for OnePager Pro 24.4.1-72
Splitting and Parsing Fields for OnePager Express 24.5.1-72 Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager 24.5.2-72
Splitting and Parsing Columns for Smartsheet Source Plans in OnePager 24.5.3-72 Splitting and Parsing Columns for Project for the Web Source Plans 24.5.5-72
Splitting and Parsing Columns for Planisware Enterprise Source Plans 24.5.7-72 Splitting and Parsing Columns for Wrike in OnePager 24.5.11-72

(24.5.9-72)