Field Mappings Tab for OnePager Express for Version 6.0

About the Project-View Properties form Field Mappings Tab

1) To compliment the Retroactive Column Mapping feature, we've changed the Other Columns tab on the Template Properties and added the a tab to the Project-View Properties forms. Previously, the Other Columns tab was only present on the Template Properties form. However, with the new Retroactive Column Mapping feature, it is appropriate for this tab to be present on the Project-View Properties form. For more information on the Retroactive Column Mapping feature, please consult the following link: Retroactive Column Mapping 0.4.1.5-60.

2) The name of the new tab is the Field Mappings tab. Since the Retroactive Column Mapping feature allows you to import all fields from Microsoft Excel source plans, the Field Mappings tab is a significantly simplified tab which focuses on those Microsoft Excel fields that customers tell us are the most frequent fields they wish to remap into other OnePager columns after a project view is created. For OnePager Express there are seven (7) Microsoft Excel fields as named in the Field Mappings tab list below:

(1) Percent-complete field

(2) Task-name field

(3) Start

(4) Finish

(5) Baseline start

(6) Baseline finish

(7) Deadline

3) The Field Mappings tab for the PVP is shown below:

File:X60-21 1 16-60-(1)-03012017.png X60-21_1_16-60-(1)-03012017.png</c

4) As in the Other Columns tab in previous versions, version 6.0 supports Field Splitting with the control on the Field Mappings tab in the Template form and Project-View Properties forms. Field Splitting can be performed on any source plan string type column with comma-separated components imported either before or after the project view is created.

5) Finally, we’ve added a group to the Field Mappings tab that shows the Microsoft Excel field currently being used for the Task/Milestone Identity feature. In the PVP form, the Task/Milestone Identity is ghosted but tells you which Microsoft Excel field is being used and specified in the Template Properties form to act as the Task ID field for OnePager Express UPDATE operations.

Basic Fields

1) There are three (3) Basic Fields in this group that are available to be remapped. You may use any Microsoft Excel field of the same type and these are revealed in the individual dropdown menus as shown in the example below:

<center>File:P60-21 1 16-60-(2)-03012017.png X60-21_1_16-60-(2)-03012017.png

2) Selecting a different Microsoft Excel field from the dropdown list tells OnePager to go back to the Microsoft Excel source plan, retrieve the data for that field, and use that data to populate the associated OnePager Express columns however they may be used in the project view. This reacquisition of Microsoft Excel source plan data is done immediately and the project view is updated accordingly regardless of the mode of operation (i.e., NEW, UPDATE or OPEN).

Data Fields

1) There are five (5) Date Fields in this group that are available to be remapped. You may use any Microsoft Excel date field that can be revealed in the individual dropdown menus as shown in the example below:

File:X60-21 1 16-60-(3)-03012017.png X60-21_1_16-60-(3)-03012017.png

2) As with the selections in the Basic Fields group, selecting a different Microsoft Excel field from the dropdown list tells OnePager to go back to the Microsoft Excel source plan, retrieve the data for that field, and use that data to populate the OnePager Express column however it may be used in the project view. This reacquisition of Microsoft Excel source plan data is done immediately and the project view is updated accordingly regardless of the mode of operation (i.e., UPDATE or OPEN).

Task/Milestone Identity

1) In the Project-View Properties form, this group is for your information. The group is ghosted but the Unique Id window shows the setting previously or currently set in the Template Properties form’s Field Mappings tab. As such, the window is for information purposes only and cannot be changed. The Task/Milestone Identity group is shown below:

File:X60-21 1 16-60-(4)-03012017.png X60-21_1_16-60-(4)-03012017.png

2) The Task/Milestone Identity group on this form provides a means for you to know the Microsoft Excel source plan field when a field other than the default Task ID field in Microsoft Excel is selected in the Template Properties form’s Field Mappings tab.

3) This feature is added to assist advanced OnePager Express users who create project views from multiple Microsoft Excel source plans or who find it necessary to copy portions of one Microsoft Excel source plan into another for updating project views. See the section in the article at this link: Advanced Tab for OnePager Express 21.1.14-60. This section provides guidance on using this feature to reset the Task ID field so that OnePager Express can properly perform project view update in the future.

Field Splitting

1) As with the group discussed previously, the Field Splitting group is ghosted but shows the Microsoft Excel field currently set in the Template Properties form as the field participating in field splitting. As such, the window is for information purposes only and cannot be changed. The Field Splitting group is shown below:

File:X60-21 1 16-60-(5)-03012017.png X60-21_1_16-60-(5)-03012017.png

2) The Field Splitting group in the Field Mappings tab of the OnePager Express PVP form works in the same way as it did in the Other Columns tab of previous versions. See the article at: Splitting and Parsing Columns-OnePager Express 24.5.1-60 for more information.

Related Links

Retroactive Column Mapping 0.4.1.5-60

Advanced Tab for OnePager Pro 21.1.14-60

Splitting and Parsing Columns-OnePager Pro 24.4.1-60

(21.1.16-60)