Difference between revisions of "Combining bxp and Microsoft Project"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) (→Tasks) |
||
| Line 55: | Line 55: | ||
| − | In bxp tasks are stored in a standard form structure with the use of the Project Header structure applied. | + | In bxp tasks are stored in a standard form structure with the use of the Project Header structure applied. [[Form_Project_Header]] |
Revision as of 16:18, 8 July 2017
1 Overview
bxp has the power to be able to integrate and work with Microsoft Project(MS Project) structures. It is important therefore to understand the underlying data structures in MS 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
2.1 Projects
So the first data structure is the Project table. Where in MS 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.
2.2 MS Project elements
In MS Project there are then key elements that can be created and 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. |
2.3 Tasks
In bxp tasks are stored in a standard form structure with the use of the Project Header structure applied. Form_Project_Header
The project header structure field is not a perfect match for all the fields available in MS Project.
Missing fields can be created by bxp automatically to provide a perfect mapping on the creation of a new project / project form. What_is_a_Project_form
