Difference between revisions of "OnePager Express Import of Data from Microsoft Excel for Version 7.0"

From OnePager Documentation
Jump to: navigation, search
(About Importing Microsoft Excel Data to OnePager Express)
(Intelligent Changes Made to OnePager Express Current Templates)
Line 51: Line 51:
 
11) When the '''Create new Project View''' button is selected, OnePager uses your '''field''' assignments to create the chart.
 
11) When the '''Create new Project View''' button is selected, OnePager uses your '''field''' assignments to create the chart.
  
==Intelligent Changes Made to OnePager Express Current Templates==
+
==Intelligent Changes Made to OnePager Express Current Template Properties Forms==
  
1) '''OPX''' is shipped to you with a predefined set of '''Templates''' that are based upon the '''BlueGrass Project Plan Report - Express''' used in this Wiki for example purposes and available to you from the '''OPX''' tutorial.   
+
1) '''OPX''' is shipped to you with a predefined set of '''Template Properties''' forms that are based upon the '''BlueGrass Project Plan Report - Express''' used in this Wiki for example purposes and available to you from the '''OPX''' tutorial.   
  
2) This means that all '''field''' usage settings within these shipped '''Templates''' are based upon this Microsoft Excel '''source plan'''.
+
2) This means that all '''field''' usage settings within these shipped '''Template Properties''' forms are based upon this Microsoft Excel '''source plan'''.
  
3) Since the flexibility of Microsoft Excel needed to be considered in the design of '''OPX''', it was necessary to '''update''' the current '''Templates''' based upon '''your''' Microsoft Excel '''source plan'''.
+
3) Since the flexibility of Microsoft Excel needed to be considered in the design of '''OPX''', it was necessary to '''update''' the current '''Template Properties''' form based upon '''your''' Microsoft Excel '''source plan'''.
  
4) Accordingly, '''OPX''' uses the analysis techniques discussed above to modify the '''current Template'''.   
+
4) Accordingly, '''OPX''' uses the analysis techniques discussed above to modify the '''current Template Properties''' form.   
  
 
5) This is necessary because, unlike Microsoft Project, where the '''fields''' have predefined meanings, the Microsoft Excel '''source plan field''' assignments and meaning are totally determined by you.   
 
5) This is necessary because, unlike Microsoft Project, where the '''fields''' have predefined meanings, the Microsoft Excel '''source plan field''' assignments and meaning are totally determined by you.   
Line 71: Line 71:
 
:b) Clicking this button brings up the '''Template Properties''' form at the '''Rows and Swimlanes''' tab.   
 
:b) Clicking this button brings up the '''Template Properties''' form at the '''Rows and Swimlanes''' tab.   
  
:c) The settings found in the '''Row & Swimlanes''' tab are determined by the '''current Template''' and by the intelligent analysis described above.   
+
:c) The settings found in the '''Row & Swimlanes''' tab are determined by the '''current Template Properties''' form and by the intelligent analysis described above.   
  
:d) If your Microsoft Excel '''source plan''' contains a '''field heading''' that exists in the '''Template''', OnePager uses that '''fields'''.   
+
:d) If your Microsoft Excel '''source plan''' contains a '''field heading''' that exists in the '''Template Properties''' form, OnePager uses that '''fields'''.   
  
 
:e) Otherwise, it makes an intelligent recommendation from the '''field headings''' it discovers.   
 
:e) Otherwise, it makes an intelligent recommendation from the '''field headings''' it discovers.   
Line 94: Line 94:
 
14) You can change the rows and swimlane settings as well as settings in any of the other tabs.   
 
14) You can change the rows and swimlane settings as well as settings in any of the other tabs.   
  
15) When you are ready, click '''Save and use''' button to make these changes part of the '''current Template'''.
+
15) When you are ready, click '''Save and use''' button to make these changes part of the '''current Template Properties''' form.
  
 
16) In other tabs of the '''Template Properties''' form, '''OPX''' has adjusted settings in a similar way to be consistent with its intelligent engine’s analysis of the Microsoft Excel '''source plan field headers''' and data types.  
 
16) In other tabs of the '''Template Properties''' form, '''OPX''' has adjusted settings in a similar way to be consistent with its intelligent engine’s analysis of the Microsoft Excel '''source plan field headers''' and data types.  
Line 100: Line 100:
 
17) If '''OPX''' cannot find a '''field header''' name in the Microsoft Excel '''source plan''' that can be correlated with a specific '''OPX''' purpose, '''OPX''' makes as intelligent a guess as possible and you are then able to make any change necessary.
 
17) If '''OPX''' cannot find a '''field header''' name in the Microsoft Excel '''source plan''' that can be correlated with a specific '''OPX''' purpose, '''OPX''' makes as intelligent a guess as possible and you are then able to make any change necessary.
  
18) You are '''cautioned''' that all '''current Templates''' are altered when used in this way.   
+
18) You are '''cautioned''' that all '''current Template Properties''' forms are altered when used in this way.   
  
19) We recommends that unique '''Template''' names be subsequently given to such modified '''Templates''' for future reference and for sharing these modified '''Templates''' with others.
+
19) We recommend that unique '''Template Properties''' form names be subsequently given to such modified '''Template Properties''' form for future reference and for sharing these modified '''Template Properties''' form with others.
  
 
==Missing Fields, Field Headers, or Misspelled Field Headings==
 
==Missing Fields, Field Headers, or Misspelled Field Headings==

Revision as of 20:22, 8 December 2020

About Importing Microsoft Excel Data to OnePager Express

1) OnePager Express (OPX) imports data from your Microsoft Excel source plan and allows you to select which of the Microsoft Excel source plan fields to process and how they are to be processed through the OnePager choices (OPC) form.

2) Since Microsoft Excel is so flexible, OnePager is constructed with significant intelligence to determine how you want to represent the imported data.

3) This built in intelligence is applied in two ways:

a) OnePager scans all your Microsoft Excel source plan fields and looks for field headers that can be useful for the creation of a chart. Once this analysis is complete, OPX populates the second page of the OPC form with its findings as shown below:
X61-4 0 1 4-61-(1)-10252017.png
X61-4_0_1_4-61-(1)-10252017.png
(b) OPX recognizes information in the various Microsoft Excel source plan fields after finding and analyzing the field headers and after examining the type of data in each field.

4) OPX intelligently makes changes to the current Template Properties form's settings to reflect these findings and reports them to you in the OPC form shown above.

Data Import to OnePager Express

1) What follows is a discussion of how OnePager Express applies it’s built in intelligence functions for you.

2) Our goal here is to provide sufficient understanding of the process so you know what to expect from OnePager Express when various field heading names and data types are encountered by OnePager Express from your Microsoft Excel source plan.

3) There are four data types that OPX looks for when importing data from Microsoft Excel:

a) Dates
b) Numbers
c) Boolean (TRUE or FALSE)
d) Strings (A through Z, 0-9, special characters)

4) All data, regardless of data type, are imported from Microsoft Excel.

5) OPX begins this analysis from top-left to bottom-right.

6) OPX ignores merged cells in fields and merged cells in rows.

7) Once the field headers are located and the data types are analyzed, OPX associates these fields with specific usages in the OPC form as illustrated above.

8) Using the second page of the OPC form shown above, you can change the field usage by selecting another field to serve the function from the dropdown list provided.

9) The dropdown list is built from all the field headers that OPX found during its analysis pass.

10) An example of a dropdown list of field header names taken from a Microsoft Excel source plan is shown here:

X61-4 0 1 4-61-(2)-10252017.png
X61-4_0_1_4-61-(2)-10252017.png

11) When the Create new Project View button is selected, OnePager uses your field assignments to create the chart.

Intelligent Changes Made to OnePager Express Current Template Properties Forms

1) OPX is shipped to you with a predefined set of Template Properties forms that are based upon the BlueGrass Project Plan Report - Express used in this Wiki for example purposes and available to you from the OPX tutorial.

2) This means that all field usage settings within these shipped Template Properties forms are based upon this Microsoft Excel source plan.

3) Since the flexibility of Microsoft Excel needed to be considered in the design of OPX, it was necessary to update the current Template Properties form based upon your Microsoft Excel source plan.

4) Accordingly, OPX uses the analysis techniques discussed above to modify the current Template Properties form.

5) This is necessary because, unlike Microsoft Project, where the fields have predefined meanings, the Microsoft Excel source plan field assignments and meaning are totally determined by you.

6) OPX, therefore, makes intelligent recommendations on Microsoft Excel source plan field usage based on the findings of the intelligent engine.

7) You can change or override these findings as follows:

a) You can click the Edit current Template… button also on the second page of the OnePager choices (OPC) form shown above.
b) Clicking this button brings up the Template Properties form at the Rows and Swimlanes tab.
c) The settings found in the Row & Swimlanes tab are determined by the current Template Properties form and by the intelligent analysis described above.
d) If your Microsoft Excel source plan contains a field heading that exists in the Template Properties form, OnePager uses that fields.
e) Otherwise, it makes an intelligent recommendation from the field headings it discovers.

8) The figure below shows that several of the settings in the Template Properties form’s Rows & Swimlanes tab reflect the decisions that OnePager made concerning field usage. These settings are consistent with the selections displayed in the OPC form.

X70-4 0 1 4-70-(3)-09082020.png
X70-4_0_1_4-70-(3)-09082020.png

9) Note in the highlighted rectangles above, that OPC picked up the Task Name field for collecting tasks into rows.

10) To access the form for selecting text column names, click the Text Column Properties... button to access the Custom Text Column form as shown above.

11) The illustration above shows that the “Lemgth” field from the Microsoft Excel source plan is selected as the text column to appear in the chart.

12) The “Lemgth” field is indicated in the Template form's Rows/Swimlanes tab for ordering rows.

13) We purposely misspelled Length to illustrate that OPX has the intelligence to pick fields even though their headings are somewhat misspelled.

14) You can change the rows and swimlane settings as well as settings in any of the other tabs.

15) When you are ready, click Save and use button to make these changes part of the current Template Properties form.

16) In other tabs of the Template Properties form, OPX has adjusted settings in a similar way to be consistent with its intelligent engine’s analysis of the Microsoft Excel source plan field headers and data types.

17) If OPX cannot find a field header name in the Microsoft Excel source plan that can be correlated with a specific OPX purpose, OPX makes as intelligent a guess as possible and you are then able to make any change necessary.

18) You are cautioned that all current Template Properties forms are altered when used in this way.

19) We recommend that unique Template Properties form names be subsequently given to such modified Template Properties form for future reference and for sharing these modified Template Properties form with others.

Missing Fields, Field Headers, or Misspelled Field Headings

1) OPX also checks field headings when importing data in UPDATE mode.

2) If the field was used in previous snapshots for any purpose, OnePager checks to assure that the new import for the snapshot has those same fields.

3) When OPX cannot find the expected fields, one or more field heading names are missing or blank, the field heading is recognizably misspelled, or the data type is different from the previous snapshot, OPX provides a warning message as shown in the example below:

X52-4 4-(4)-06082015.png
X52-4_4-(4)-06082015.png

4) This can occur when you inadvertently attempt to update a chart from the incorrect Microsoft Excel source plan or the desired Microsoft Excel source plan was altered to the extent that OPX cannot find the fields needed to accomplish the UPDATE functions.

5) You are given two choices when the message above is displayed:

Select Yes

6) By selecting the Yes button, the import proceeds.

7) OnePager blanks some values that it cannot find.

8) Note: The results can be unexpected.

Select No

9) Selecting the No button tells OPX to stop the import process and return control to Microsoft Excel.

10) You can now correct the Microsoft Excel source plan or select another one and start the UPDATE process again.

Related Links

Basic Workflows (Portal) 7.0.1-70 specifically those articles provided for OPX.

Merging the Wrong Tasks into a Chart - OnePager Express 7.12.1-70

Data-Driven Task Links for OnePager Express 19.1.1.2-70

(4.0.1.4-70)