Combining bxp and Microsoft Project

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 and task-timephased 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 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 and resource-timephased 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 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 and assignment-timephased 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 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.