Difference between revisions of "Combining bxp and Microsoft Project"

From All n One's bxp software Wixi

Jump to: navigation, search
Line 28: Line 28:
 
! Description
 
! Description
 
|-
 
|-
| Task fields || Task fields show task-related information and can be displayed in task views such as the Gantt Chart, Task Sheet, and Network Diagram views.
+
| '''Task fields''' || Task fields show task-related information and can be displayed in task views such as the Gantt Chart, Task Sheet, and Network Diagram views.
 
|-
 
|-
| Task-timephased fields || Task-timephased fields show information for each task as distributed over its duration. These fields can be displayed in the timephased part of the Task Usage view.
+
| '''Task-timephased fields''' || Task-timephased fields show information for each task as distributed over its duration. These fields can be displayed in the timephased part of the Task Usage view.
 
|-
 
|-
| Resource fields || Resource fields show information for each resource, including summarized information about all tasks assigned to each resource. They can be displayed in resource views such as the Resource Sheet and Resource Usage views.
+
| '''Resource fields''' || Resource fields show information for each resource, including summarized information about all tasks assigned to each resource. They can be displayed in resource views such as the Resource Sheet and Resource Usage views.
 
|-
 
|-
| Resource-timephased fields || Resource-timephased fields show information for each resource as distributed over the duration of resource availability on the project. These fields can be displayed in the timephased portion of the Resource Usage view.
+
| '''Resource-timephased fields''' || Resource-timephased fields show information for each resource as distributed over the duration of resource availability on the project. These fields can be displayed in the timephased portion of the Resource Usage view.
 
|-
 
|-
| Assignment fields || Assignment fields show information for each assignment. They can be displayed in the sheet portion of the Task Usage and Resource Usage views and at the bottom of the Task Form and Resource Form views. You can change the assignment field that appears at the bottom of the Task Form or Resource Form view by clicking in the area, clicking the Format tab, and then clicking a command.
+
| '''Assignment fields''' || Assignment fields show information for each assignment. They can be displayed in the sheet portion of the Task Usage and Resource Usage views and at the bottom of the Task Form and Resource Form views. You can change the assignment field that appears at the bottom of the Task Form or Resource Form view by clicking in the area, clicking the Format tab, and then clicking a command.
 
|-
 
|-
| Assignment-timephased fields || Assignment-timephased fields show information for each assignment as distributed over its duration. These fields can be displayed in the timephased portion of the Resource Usage and Task Usage views.
+
| '''Assignment-timephased fields''' || Assignment-timephased fields show information for each assignment as distributed over its duration. These fields can be displayed in the timephased portion of the Resource Usage and Task Usage views.
 
|-
 
|-
 
|}
 
|}

Revision as of 14:37, 8 July 2017

1 Overview

bxp has the power to be able to integrate and work with Microsoft Project structures. It is important therefore to understand the underlying data structures in Microsoft Project first.


Microsoft provide the following specification of their fields. https://support.office.com/en-us/article/Available-fields-reference-615a4563-1cc3-40f4-b66f-1b17e793a460


2 Structure

So the first data structure is the Project table. Where in Microsoft Project desktop versions the data is stored in a file, the Professional and Enterprise versions can be stored in a centralised database.

bxp is able to mirror the key fields of the server thus allowing direct mapping solutions. There are more fields in bxp than Project for a number of key communications and customisation reasons. Bxp_and_Microsoft_Project_-_Project_table_fields


A project in bxp has an Id which is used system wide rather than a name.


In Project there are then key elements that can be assigned to the project.

Type Description
Task fields Task fields show task-related information and can be displayed in task views such as the Gantt Chart, Task Sheet, and Network Diagram views.
Task-timephased fields Task-timephased fields show information for each task as distributed over its duration. These fields can be displayed in the timephased part of the Task Usage view.
Resource fields Resource fields show information for each resource, including summarized information about all tasks assigned to each resource. They can be displayed in resource views such as the Resource Sheet and Resource Usage views.
Resource-timephased fields Resource-timephased fields show information for each resource as distributed over the duration of resource availability on the project. These fields can be displayed in the timephased portion of the Resource Usage view.
Assignment fields Assignment fields show information for each assignment. They can be displayed in the sheet portion of the Task Usage and Resource Usage views and at the bottom of the Task Form and Resource Form views. You can change the assignment field that appears at the bottom of the Task Form or Resource Form view by clicking in the area, clicking the Format tab, and then clicking a command.
Assignment-timephased fields Assignment-timephased fields show information for each assignment as distributed over its duration. These fields can be displayed in the timephased portion of the Resource Usage and Task Usage views.