Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Split Resources in the Chart)
 
(512 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Overview==
+
==Introduction==
  
In addition to '''defining row''' and '''text column''' properties in the '''Template''' and in the '''Chart Properties''' form, you can select a specific '''row''' or '''text column cell''' and individually '''edit''' its '''properties'''. To do this, use your mouse to select a '''row''' or a '''text column cell''' with a right-click to access the '''text column''' right-click '''context menu''' as shown below:
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
<center>[[File:P70-12_22_1-(1)-08142020.png]]</center>
+
==About Splitting and Parsing Fields==
<!--<center>P70-12_22_1-(1)-08142020.png</center>-->
+
  
In the illustration above, the '''Left#1 text column cell''' is right-clicked to select the '''row''' and the '''Left#1 text column cell''' and to access the '''text column''' right-click '''context menu'''.  Clicking the '''Properties …''' command accesses the '''Row/Column Properties''' form’s '''Row''' tab shown below:
+
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. 
  
<center>[[File:P70-12_22_1-(2)-08142020.png]]</center>
+
===Split Resource Names Example===
<!--<center>P70-12_22_1-(2)-08142020.png </center>-->
+
  
As an alternative, use the '''slow left-click selection''' method to select just the '''Left#1 text column cell''', right-click to access the '''text column''' right-click '''context menu''', and click the '''Properties …''' command where the '''Row/Column Properties''' form is accessed at the '''Cell''' tab as shown here:
+
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:
  
<center>[[File:P70-12_22_1-(3)-08142020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
<!--<center>P70-12_22_1-(3)-08142020.png </center>-->
+
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
Either method in the above two illustrations allows you to access either tab of the '''Row/Column Properties''' form.  The access methods described above in general terms for OnePager Pro applies to OnePager Express as well.  Any '''edits''' made to a '''row''' or a '''text column cell''' using the '''Row/Column Properties''' form’s controls makes the '''row''' and/or '''text column cell''' a '''maverick'''.
+
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:
  
In the '''Row/Column Properties''' form’s '''Row''' tab you can '''edit '''the '''border properties''' of the selected '''row''', '''edit '''the selected '''text column cell’s background color''' (as described later on), and use the '''Use Default Row Properties''' button to revert any '''maverick rows''' back to their '''default settings'''. '''Multiple rows''' and '''text column cells''' can be selected and '''edited''' using the controls in the '''Row/Column Properties''' form.
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
When selecting '''multiple rows''' or '''text column cells''', OnePager '''does allow''' selections in '''different text columns'''.  This is different from attempting to make '''multiple selections swimlanes''' or '''swimlane level cells''' in '''different swimlane levels'''. '''Multiple row''' and '''text column cell''' selections can be made using the '''CTL+Left-Click '''method to select any '''text column cell defined''' and '''showing''' in the chart. Attempting to use the '''SHIFT+Left-Click '''method to select '''a sequence of text column cells''' in '''different text columns''' is not supportedOnce you start a '''SHIFT+Left-Click''' selection in a '''text column''' you must continue the '''sequence''' of selections in that '''same text column'''.
+
OnePager, in this case, treats the '''entire string''' as an individual '''Assigned to''' valueTo 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.
  
This article describes the use of the '''Row/Column Properties''' form for the situations where '''one''' or '''multiple rows''' or '''text column cells''' are selected.
+
===Enabling Splitting===
  
The next section covers the various methods for selecting '''rows''' for '''editing'''.   
+
To use this feature requires turning '''ON''' the feature in the Asana '''Template Properties''' form you intend to use to make the chartThe 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:
  
If you are comfortable with these selection techniques, you can jump to the article sections at the link where the controls in the '''Row/Column Properties''' form’s tabs are discussed:  [[Editing Row Properties for Version 7.0#Editing Row Properties with the Row/Column Properties Form’s Row Tab | Editing Row Properties with the Row/Column Properties Form’s Row Tab]] <!--12.22.1-70-->
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
==Accessing Rows for Editing Rows and Text Column Cells==
+
When you click the '''Next>''' button at the bottom of the form, OnePager accesses the second page of the '''OnePager choices''' form shown below:
  
It may be necessary to '''edit''' the '''properties''' of a '''text column cell''' or set of '''text column cells''' for the purpose of highlighting them for your schedule discussion presentation.  This can be done by selecting the desired '''text column cell '''or''' cells''' using the appropriate mouse left-click and/or right-click combination selection methods to access the '''text column''' right-click '''context menu''' and its '''Properties …''' command shown here:
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
<center>[[File:P70-12_22_1-(4)-08142020.png]]</center>
+
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>P70-12_22_1-(4)-08142020.png </center>-->
+
  
This sub-section covers accessing the '''Row/Column Properties''' form using the available selection methods for '''rows '''and''' text column cells'''.
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
For more information on the '''selection methods available for rows and text column cells''', please see the article and sub-section at: [[About OnePager's Rows and Swimlanes#Selection Methods Available for Multiple Text Columns | Selection Methods Available for Multiple Text Columns]] <!--12.0.2-70-->
+
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.
  
===Accessing the Row/Column Properties Form – Single Row and Single Text Column Cell Selection===
+
===Split Resources in the Chart===
  
Clicking the '''Properties …''' command when a '''row''' is selected accesses the '''Row/Column Propertie'''s form at the '''Row''' tab 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:P70-12_22_1-(5)-08142020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
<!--<center>P70-12_22_1-(5)-08142020.png </center>-->
+
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
The '''editing '''controls available in the '''Row/Column Properties '''form’s '''Row '''tab are applied to all selected '''rows''' when the form’s '''OK '''button is clicked.
+
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'''.
  
====Accessing a Single Row====
+
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'''.
  
Using the above illustration as an example, the '''single row '''can be accessed as shown below:
+
==Splitting Resources and Task Links==
  
<center>[[File:P70-12_22_1-(6)-08142020.png]]</center>
+
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.
<!--<center>P70-12_22_1-(6)-08142020.png </center>-->
+
 
+
Once accessed, any '''edits''' applied to the '''Row''' may be applied to '''all text column cells defined''' and '''showing''' and the '''row''' portion extending into the '''graph'''.  For example, if the '''Left#1 text column cell''' is used to access the '''Row/Column Properties''' form, changing the '''Row Background Color''' applies to the '''Left#1''' and '''Left#2''' '''text column cells''' as these '''text column cells''' are in the same '''row '''from the form’s perspective.  The portion of the '''row''' in the '''graph area''' also takes on the selected '''row background color'''.
+
 
+
Making such an '''edit''' to change the '''Row Background Color''' to '''red''' changes the configuration of the chart to look like this:
+
 
+
<center>[[File:P70-12_22_1-(7)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(7)-08142020.png </center>-->
+
 
+
Regardless of which of the '''two text column cells''' is initially selected in the above illustration, the result shown above is the same.  This is because '''text columns''' are not organized into '''levels''' as are '''swimlanes''' but remain a component of the '''row'''.
+
 
+
====Accessing a Single Text Column Cell====
+
 
+
Clicking the '''Properties …''' command when a single '''text column cell''' is selected accesses the '''Row/Column Properties''' form at the '''Cell''' tab shown here:
+
 
+
<center>[[File:P70-12_22_1-(8)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(8)-08142020.png </center>-->
+
 
+
Use the '''slow left-click selection method''' to select an individual '''text column cell''' and follow the selection action with the method described above to access the '''Row/Column Properties '''form at the '''Cell''' tab as shown here:
+
 
+
<center>[[File:P70-12_22_1-(8A)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(8A)-08142020.png </center>-->
+
 
+
When a '''single text column cell''' is selected with the '''slow left-click method''' and the '''Row/Column Properties''' form is accessed at the '''Cell '''tab and the same '''edit''' as shown above is applied, only the '''Left#1 text column cell''' has its '''Cell Background Color''' changed to '''red''' as shown below:
+
 
+
<center>[[File:P70-12_22_1-(9)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(9)-08142020.png</center>-->
+
 
+
===Accessing the Row/Column Properties Form – Multiple Row and Text Column Cell Selection===
+
 
+
You can select '''multiple swimlanes''' or '''multiple swimlane level cells''' as long as they are at the same '''swimlane level'''.  However, no such restriction applies for selecting '''multiple text column cells''' in '''different text columns'''.  The '''CTL+Left-Click '''or '''SHIFT+Left-Click '''selection techniques can be used to select '''multiple rows''' or '''multiple text column cells''' for '''editing''' using the '''Row/Column Properties''' form’s '''Row '''or''' Cell''' tabs.
+
 
+
For more information on the '''selection methods available for selecting multiple rows or multiple text column cells''', please see the article and sub-section at: [[About OnePager's Rows and Swimlanes#Selection Methods Available for Multiple Text Columns | Selection Methods Available for Multiple Text Columns]] <!--12.0.2-70-->
+
 
+
====CTL+Left-Click Method Used to Select Multiple Individual Rows ====
+
 
+
'''Multiple rows''' can be '''edited '''with the '''Row/Column Properties''' form’s '''Row''' tab as demonstrated below using the access method previously described:
+
 
+
<center>[[File:P70-12_22_1-(10)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(10)-08142020.png</center>-->
+
 
+
'''Edits''' made in the '''Row/Column Properties''' form’s '''Row''' tab are applied to all selected '''rows'''.  Using the '''CTL+Left-Click '''is effective in selecting '''rows''' when done in either of the '''two text columns''' shown in the illustration above.
+
 
+
====SHIFT+Left-Click Method Used to Select Multiple Sequential Rows ====
+
 
+
Use '''SHIFT+Left-Click''' method to select a sequence of '''rows '''for '''editing''' with the '''Row/Column Properties''' form as shown here:
+
 
+
<center>[[File:P70-12_22_1-(11)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(11)-08142020.png</center>-->
+
 
+
'''Edits''' made in the '''Row/Column Properties''' form’s '''Row''' tab are applied to all selected '''rows'''.
+
 
+
====Using Slow Left-Click and CTL+Left-Click Methods to Select Multiple Individual Text Column Cells ====
+
 
+
Use the '''slow left-click''' method in conjunction with the '''CTL+Left-Click '''method to select '''individual text column cells''' in the '''same or different''' '''text column'''.  The method involves first getting the mouse device into the '''slow left-click mode''' and then using the '''CTL+Left-Click '''method to select the desired '''individual text column  cells''' as shown below:
+
 
+
<center>[[File:P70-12_22_1-(12)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(12)-08142020.png</center>-->
+
 
+
The illustration above purposely shows '''text column cells''' selected with the '''slow left-click''' method in both the '''Left#1''' and '''Left#2 text columns'''. Note that the '''text column number''' showing the '''Text Column''' control group '''heading''' of the above form indicates that the '''Left#1 Cell Properties''' are the '''primary focus''' of the form. This is because in the illustration above, the right-click used to access the '''text column''' right-click '''context menu''' is made in the '''last Left#1 text column cell'''. Although you can select '''text column cells''' in '''any text column defined''' and '''showing''' in the chart, the '''edits '''only apply to those '''text column cells''' in the '''text column number''' showing in the form.
+
 
+
Once the '''several individual text column cells''' are selected, as shown above, a right-click in the '''last Left#1 selected text column cell''' accesses the '''text column''' right-click '''context menu'''.  Clicking the '''Properties …''' command accesses the '''Row/Column Properties''' form’s '''Cell''' tab for the '''Left#1 Cell Properties''' where any '''edits''' that are made to the controls at the '''Cell''' tab apply to all selected '''individual Left#1 text column cells'''.
+
 
+
For example, we can change the '''Cell Background Color''' to '''red''' for the selected '''individual Left#1 text column cells''' by using the standard OnePager '''Color Chooser''' form as shown below:
+
 
+
<center>[[File:P70-12_22_1-(13)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(13)-08142020.png</center>-->
+
 
+
As specified, all selected '''rows''' have their '''text column cells edited''' such that their '''Cell Background Color''' is '''red'''.  After closing the '''Row/Column Properties''' form, the chart looks like this:
+
 
+
<center>[[File:P70-12_22_1-(13A)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(13A)-08142020.png</center>-->
+
 
+
====Using Slow Left-Click and SHIFT+Left-Click Methods to Select a Sequence of Text Column Cells ====
+
 
+
Use the '''slow left-click''' method in conjunction with the '''SHIFT+Left-Click '''method to access a '''sequence of text column cells''' in the '''same text column'''.  The method involves first getting the mouse device into the '''slow left-click mode''' and then using the '''SHIFT+Left-Click '''method to select the desired '''sequence of text column cells''' as shown below:
+
 
+
<center>[[File:P70-12_22_1-(14)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(14)-08142020.png</center>-->
+
 
+
Once the '''sequence of text column cells''' are selected, as shown above, a right-click in the '''last selected text column cell''' accesses the '''text column''' right-click '''context menu'''.  Clicking the '''Properties …''' command accesses the '''Row/Column Properties''' form’s '''Cell''' tab for the '''Left#1 Cell Properties''' where any '''edits''' that are made to the controls at the '''Cell''' tab apply to all selected '''individual Left#1 text column cells'''.
+
 
+
For this example, we can change the '''Cell Background Color''' to '''red''' for the selected '''sequence of Left#1 text column cells''' by using the standard OnePager '''Color Chooser''' form as shown below:
+
 
+
<center>[[File:P70-12_22_1-(15)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(15)-08142020.png</center>-->
+
 
+
==Editing Row Properties with the Row/Column Properties Form’s Row Tab==
+
 
+
The '''Row/Column Properties''' form’s '''Row''' tab is shown below:
+
 
+
<center>[[File:P70-12_22_1-(5)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(5)-08142020.png </center>-->
+
 
+
===Requirements for Editing Row Borders===
+
 
+
In order to '''edit row borders''' using the '''Row/Column Properties''' form’s '''Row''' tab, the '''Show Row Borders''' checkbox in the '''Row Formatting''' form, accessed from '''the Chart Properties''' or '''Template Properties '''form’s '''Rows/Swimlanes''' tab’s '''Rows''' control group must be checked '''ON''' as shown below: 
+
 
+
<center>[[File:P70-12_22_1-(15A)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(15A)-08172020.png</center>-->
+
 
+
If you intend to '''maverick''' some '''row borders''' but not '''all row borders''', '''row borders''' can be '''hidden '''by accessing the '''Row Formatting''' form as shown above, then accessing the standard OnePager '''Color Chooser''' form, and setting the '''color''' for '''row borders''' to '''No fill''' as shown here:
+
 
+
<center>[[File:P70-12_22_1-(15B)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(15B)-08172020.png</center>-->
+
 
+
When these actions are taken, the '''row borders''' in the chart are reconfigured to look like this:
+
 
+
<center>[[File:P70-12_22_1-(15C)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(15C)-08172020.png</center>-->
+
 
+
To further de-emphasize '''row borders''', you have the option of removing the '''row striping''' using the controls in the '''Chart Properties''' or '''Template Properties '''form’s '''Main''' tab’s '''Chart Background''' control group.  Additionally, if desired, you can '''remove all row borders''' from the chart which is the starting condition that is used below to demonstrate the '''mavericking of row borders''' using the '''Row/Column Properties''' form’s '''Row''' tab.
+
 
+
===Manually Editing Row Properties with the Row/Column Properties form’s Row Tab===
+
 
+
There are three control groups on this form for: 
+
 
+
:1) '''Border''',
+
 
+
:2) '''Row Background Color''',
+
 
+
:3) '''Use Default Row Properties''' button.
+
 
+
There are three sub-control groups in the '''Border '''control group shown at the top of this section.  You have control over the selected '''row’s Border type''', '''Top border''' and '''Bottom border colors''', the '''Line width '''of the '''top and bottom border lines''', and the '''Dash type''' for the '''top and bottom border lines'''.
+
 
+
====Border Types for Row Borders====
+
 
+
There are '''four border types''' available for use in the form.  For the selected '''row''' or '''rows''' there are options for turning '''ON''' both the '''top '''and''' bottom borders''', either the '''top '''or''' the bottom borders ON''', or neither '''top '''nor''' bottom border ON'''.  Any changes made to the '''global setting of row borders''' make the '''row''' or '''rows''' into a '''maverick'''.
+
 
+
====Mavericking Border Types for Row Borders - Example====
+
 
+
To provide an example, the sample '''BlueGrass Project Plan Report – Pro''' chart is modified '''globally''' to '''remove all row''' and '''swimlane borders''' as shown below:
+
 
+
<center>[[File:P70-12_23_1-(16)-08122020.png]]</center>
+
<!--<center>P70-12_23_1-(16)-08122020.png</center>-->
+
 
+
Recall that the '''Show row borders''' checkbox in the '''Row Formatting''' form referenced in the previous sub-section above, must be checked '''ON'''.
+
 
+
In the illustration that follows, we’ll '''maverick row borders''' as follows:
+
 
+
:* The '''row''' with the '''Create Working Plans''' task bar is updated so its '''bottom border''' is turned '''ON''' with '''line size 2.0''', '''Color Black''', '''Dash type – Dot'''.
+
:* The '''row''' with the '''Engineering Team 1 Development''' task bar is updated so its '''top border''' is turned '''ON''' with '''line size 3.0''', '''Color Red''', and '''Dash type – Dash-dot-dot'''.
+
:* The '''row''' with the '''Engineering Team 1 Rework''' is updated so that its '''top '''and''' bottom borders''' are turned '''ON''' with '''line size 3.5''', '''Color Blue''', and '''Dash type – Solid'''.
+
 
+
When these '''maverick''' changes are '''applied''' to the individual elements mentioned above using the '''Row/Column Properties''' form’s '''Row''' tab, the chart is modified to look like this:
+
 
+
<center>[[File:P70-12_22_1-(17)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(17)-08172020.png</center>-->
+
 
+
===Manually Editing Row Background Colors with the Row/Column Properties form’s Rows Tab===
+
 
+
The standard OnePager '''Color Chooser''' form is used the change the '''background color''' of the selected '''row''' or '''rows'''.  Recall that with '''text columns''' in the chart, changing the '''background color''' for a '''Left#1 text column cell''' propagates the '''color''' change to the '''Left#2''' '''text column cells''' (if present) and into the '''row''' itself as shown in the sequence below:
+
 
+
<center>[[File:P70-12_22_1-(18)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(18)-08172020.png</center>-->
+
 
+
When the '''OK''' button is clicked on the '''Row/Column Properties''' form, the configuration of the chart is changed to this:
+
 
+
<center>[[File:P70-12_22_1-(19)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(19)-08172020.png</center>-->
+
 
+
When the selected '''row''' is '''de-selected''', the chart looks like this:
+
 
+
<center>[[File:P70-12_22_1-(20)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(20)-08172020.png</center>-->
+
 
+
===Manually Editing Text Column’s Background Colors with the Row/Column Properties form’s Cell Tab===
+
 
+
Using the '''Row/Column Properties''' form’s '''Row''' tab’s '''Row Background Color''' control, changes the entire '''row''' to the '''new row background color'''.  If you want to select a '''Left#1 text column cell''' and change just the '''Left#1 text column cell’s background color''' you must access the '''Row/Column Properties''' form at the '''Cell''' tab.  This can be done by using the '''slow left-click''' selection method to just select the '''Left#1 text column cell''' or use a standard selection method on the '''Left#1 text column cell''' to access the '''Row/Column Properties''' form at the '''Row''' tab and simply click the '''Cell''' tab as shown below:
+
 
+
<center>[[File:P70-12_22_1-(21)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(21)-08172020.png</center>-->
+
 
+
When the '''OK''' button on the '''Row/Column Properties''' form is clicked and the '''Left#1 text column cell''' is '''de-selected''', the chart looks like this:
+
 
+
<center>[[File:P70-12_22_1-(22)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(22)-08172020.png</center>-->
+
 
+
The procedure for changing the '''properties''' of the chart portion of the '''swimlane''' (i.e., to the right of the '''text columns''') is explained in the '''Editing Swimlane Properties''' article at: [[Editing Swimlane Properties for Version 7.0 | Editing Swimlane Properties]] <!--12.23.1-70-->
+
 
+
===The Use Default Row Properties Button in the Row/Column Properties form’s Row Tab===
+
 
+
The purpose of the '''Use Default Row Properties''' button is to '''restore''' the selected '''row''' or '''row’s properties''' to the settings in the current '''Chart Properties''' form or '''Template Properties''' form.  This is done by first selecting the '''row''' or '''rows''' that you want to '''restore''', accessing the '''Row/Column Properties''' form at the '''Row tab''' and clicking the '''Use Default Row Properties''' button.
+
 
+
'''Note''' that the '''Use Default Row Properties''' button is '''enabled''' whenever a change is made to a '''row '''or''' row’s properties'''.  As an example, suppose we start with the chart configuration where we '''mavericked''' a '''row''' by giving it a '''background color''' of '''red''' as shown below:
+
 
+
<center>[[File:P70-12_22_1-(20)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(20)-08172020.png</center>-->
+
 
+
If we now select one of the '''row’s text column cells''' and access the '''Row/Column Properties''' form the chart shows the illustration below:
+
 
+
<center>[[File:P70-12_22_1-(23)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(23)-08172020.png</center>-->
+
 
+
When the '''Use Default Row Properties''' form is clicked and the form is '''closed''' by clicking the '''OK''' button, the chart’s configuration changes to that shown below:
+
 
+
<center>[[File:P70-12_22_1-(24)-08172020.png]]</center>
+
<!--<center>P70-12_22_1-(24)-08172020.png</center>-->
+
 
+
==Editing Text Column Cell Properties with the Row/Column Properties Form’s Cell Tab==
+
 
+
The '''Row/Column Properties''' form’s '''Cell''' tab looks like this:
+
 
+
<center>[[File:P70-12_22_1-(8)-08142020.png]]</center>
+
<!--<center>P70-12_22_1-(8)-08142020.png </center>-->
+
 
+
The '''properties''' that can be '''edited''' in this tab include:
+
 
+
:* The '''text''' within the selected '''text column cell''',
+
:* The '''text’s font properties''',
+
:* The '''horizontal '''and''' vertical alignment''' of the '''text''' within the '''text column cell '''or '''cells''',
+
:* The '''cell’s background color''',
+
:* And the '''rotation''' of the '''text column cell’s text'''.
+
 
+
Additionally, there is a '''Use Default Cell Properties''' button that can be used to '''restore''' any '''mavericked text column cell’s properties''' back to the '''global settings''' in the '''Chart Properties''' or '''Template Properties''' forms.  Several of these controls such as the '''Text''' window, the '''Font''' control dropdown that accesses the '''Font properties''' form, and the two sets of three '''Alignment '''buttons are standard within OnePager.  These controls perform the same '''editing functions''' as when used for '''editing''' the '''properties of text elements''' for graphic objects such as '''task bars/milestone symbols''', '''comment boxes''', '''time axis level cells''', and '''vertical curtains'''.
+
 
+
Extensive examples are not provided here for the above mentioned controls. 
+
 
+
Please reference the links in the '''related links '''section at: [[Editing Row Properties for Version 7.0#Related Links | Related Links]] <!--12.22.1-70-->
+
 
+
Rather, the remaining focus in this sub-section is on the '''Cell Background Color''' control, the '''Text Rotation''' control, and the '''Use Default Cell Properties''' button.
+
 
+
===Manually Editing Text Column Cell Background Colors with the Row/Column Properties form’s Cell Tab===
+
 
+
'''Manually editing''' a selected '''text column cell''' or '''cells''' for '''background color''' requires that the '''text column cell''' or '''cells '''be individually selected with one of the appropriate '''cell '''selection methods.  When the '''text column cell''' or '''cells''' are selected and the '''Row/Column Properties''' form’s '''Cell''' tab is accessed, then the standard OnePager '''Color Chooser''' form can be accessed by clicking on the '''Cell Background Color''' dropdown as shown below:
+
 
+
<center>[[File:P70-12_22_1-(25)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(25)-08182020.png</center>-->
+
 
+
When the '''OK''' button on the '''Row/Column Properties''' form is clicked, the three selected '''Left#1 text column cells''' are reconfigured as shown here:
+
 
+
<center>[[File:P70-12_22_1-(26)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(26)-08182020.png</center>-->
+
 
+
Recall that '''text column cell''' '''mavericking''' can only be done in the '''same text column''' so that selecting '''cells '''in '''different text columns '''to change their '''background colors''' for must be done on '''an individual text column''' basis.
+
 
+
===Manually Editing Text Column Cell’s Text Rotation with the Row/Column Properties form’s Cell Tab===
+
 
+
The '''Row/Column Properties''' form’s '''Cell''' tab’s '''Text Rotation''' control provides '''three different orientation''' of '''text''' contained within a selected '''text column cell''' or '''cells'''.  You have the option to '''rotate text column cell text horizontally''' (the typical '''default''' setting), '''rotate text column cell text 90 degrees clockwise''', and '''rotate text column cell text 270 degrees clockwise'''.  The dropdown list for the '''Text Rotation''' control in the '''Row/Column Properties''' form’s '''Cell''' tab looks like this:
+
 
+
<center>[[File:P70-12_22_1-(27)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(27)-08182020.png</center>-->
+
 
+
As an example, we can '''rotate the text''' '''90 degrees''' in the '''Left#1 text column cell '''in the '''row''' containing the '''Create Work Plans '''task bar''' '''to get the configuration of '''text''' within the '''cell''' shown below:
+
 
+
<center>[[File:P70-12_22_1-(28)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(28)-08182020.png</center>-->
+
 
+
In the illustration above, the '''height of the row''' is '''increased''' to show the '''rotated text''' as a single string.
+
 
+
'''Text column cell text rotation''' is sometimes useful in order to help decrease the '''width''' of a''' text column '''and allow more '''horizontal space''' for the chart itself.
+
 
+
===The Use Default Cell Properties Button in the Row/Column Properties form’s Cell Tab===
+
 
+
The purpose of the '''Use Default Cell Properties''' button is to '''restore''' the selected '''text column cell''' or '''cell’s properties''' to the settings in the current '''Chart Properties''' form or '''Template Properties''' form.  This is done by first selecting the '''text column cell''' or '''cells''' that you want to '''restore''', accessing the '''Row/Column Properties''' form at the '''Cell tab''', and clicking the '''Use Default Cell Properties''' button.  '''Note''' that the '''Use Default Cell Properties''' button is '''enabled''' whenever a change is made to a '''text column cell '''or''' cell’s properties''' at a '''cell level'''.
+
 
+
As an example, suppose we start with the chart configuration where we '''mavericked''' the '''Left#1 text column cell''' to have a '''background color''' of '''red''' as shown below:
+
 
+
<center>[[File:P70-12_22_1-(29)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(29)-08182020.png</center>-->
+
 
+
If we now select this '''Left#1 text column cell''' and access the '''Row/Column Properties''' form at the '''Cell '''tab, the chart shows the illustration below:
+
 
+
<center>[[File:P70-12_22_1-(30)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(30)-08182020.png</center>-->
+
 
+
When the '''Use Default Cell Properties''' form is clicked and the form is '''closed''' by clicking the '''OK''' button, the chart’s configuration changes to that shown below:
+
 
+
<center>[[File:P70-12_22_1-(31)-08182020.png]]</center>
+
<!--<center>P70-12_22_1-(31)-08182020.png</center>-->
+
  
 
==Related Links==
 
==Related Links==
  
[[Manual Editing Task/Milestone Shapes and Text Labels for Version 7.0 (Portal) | Manual Editing Task/Milestone Shapes and Text Labels (Portal)]] <!--9.0.1-70-->
+
{| class="wikitable"
 +
| [[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
 +
|-
 +
| [[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
 +
|}
  
[[Creating and Editing Rows and Swimlanes for Version 7.0 (Portal) | Creating and Editing Rows and Swimlanes (Portal)]] <!--12.0.1-70-->
+
(24.5.9-72)
  
[[About OnePager's Rows and Swimlanes | About OnePager's Rows and Swimlanes]] <!--12.0.2-70-->
+
[[Category:Version 7.2]]
 
+
[[Category:Editing the Chart]]
[[Collecting, Formatting, and Sorting Task/Milestones into Rows for Version 7.0 | Collecting, Formatting, and Sorting Task/Milestones into Rows]] <!--12.01.1-70-->
+
[[Category:Task/Milestone Editing]]
 
+
[[Category:Column Splitting]]
[[Creating, Formatting, and Sorting Swimlanes Levels for Version 7.0 | Creating, Formatting, and Sorting Swimlanes Levels]] <!--12.02.1-70-->
+
 
+
[[Creating and Formatting Text Columns for Version 7.0 | Creating and Formatting Text Columns]] <!--12.03.1-70-->
+
 
+
[[Row and Swimlane Borders for Version 7.0 | Row and Swimlane Borders]] <!--12.04.1-70-->
+
 
+
[[Editing Text Columns or Swimlane Labels for Version 7.0 | Editing Text Columns or Swimlane Labels]] <!--12.3.1-70-->
+
 
+
[[Manually Hiding and Unhiding Swimlane Levels for Version 7.0 | Manually Hiding and Unhiding Swimlane Levels]] <!--12.5.1-70-->
+
 
+
[[Resizing the Width of Text Columns and Swimlanes for Version 7.0 | Resizing the Width of Text Columns and Swimlanes]] <!--12.8.1-70-->
+
 
+
[[Resizing the Height of Rows for Version 7.0 | Resizing the Height of Rows]] <!--12.11.1-70-->
+
 
+
[[Hiding and Unhiding Rows and Swimlanes for Version 7.0 | Hiding and Unhiding Rows and Swimlanes]] <!--12.13.1-70-->
+
 
+
[[Adding a Row or Swimlane for Version 7.0 | Adding a Row or Swimlane]] <!--12.16.1-70-->
+
 
+
[[Adding a Row to a Swimlane for Version 7.0 | Adding a Row to a Swimlane]] <!--12.19.1-70-->
+
 
+
[[Making Each Row into a Swimlane for Version 7.0 | Making Each Row into a Swimlane]] <!--12.20.1-70-->
+
 
+
[[Merging Swimlanes for Version 7.0 | Merging Swimlanes]] <!--12.21.1-70-->
+
 
+
[[Editing Swimlane Properties for Version 7.0 | Editing Swimlane Properties]] <!--12.23.1-70-->
+
 
+
[[Zebra Striping for Rows and Swimlanes for OnePager Pro for Version 7.0 | Zebra Striping for Rows and Swimlanes for OnePager Pro]] <!--12.24.1-70-->
+
 
+
[[Zebra Striping for Rows and Swimlanes for OnePager Express for Version 7.0 | Zebra Striping for Rows and Swimlanes for OnePager Express]] <!--12.24.2-70-->
+
 
+
[[Editing with the Chart Properties form for Version 7.0 (Portal) | Editing with the Chart Properties form (Portal)]] <!--21.0.1-70-->
+
 
+
[[Managing Templates for Version 7.0 (Portal) | Managing Templates (Portal)]] <!--24.0.1-70-->
+
 
+
(12.22.1-70)
+
 
+
[[Category:Version 7.0]]
+
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Templates]]
+
[[Category:Task Links]]
 +
[[Category:Ribbon]]
 +
[[Category:Snapshots]]
 +
[[Category:Template Properties Form]]
 
[[Category:Chart Properties Form]]
 
[[Category:Chart Properties Form]]
[[Category:Editing the Chart]]
+
[[Category:Asana]]
[[Category:Rows and Swimlanes]]
+
[[Category:OnePager Bundle]]
[[Category:Multiple Swimlane Levels]]
+
[[Category:Labels]]
+
[[Category:Text Columns]]
+
[[Category:Snapshots]]
+
[[Category:Swimlane Stripes]]
+
[[Category:Mavericks]]
+
[[Category:OnePager Pro]]
+
[[Category:OnePager Express]]
+

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)