I am currently working my way through various bulk loading options, as data input is a bit of a pain in Primavera.
Is there anything else that would help you day to day, WBS Creation is only really an issue at the start of the project, as after the majority is loaded at the Project Start it is only modifications from there which are probably easier in P6.
I also have working code for converting activity codes to WBS Codes, with the WBS Levels set by choosing the Activity Code Types to use for each WBS Level. This also handles Activity Codes with a structure defined - any sub codes are added as a Sub WBS Code.
The activity code to WBS also updates the WBS of the activities to match the new WBS Structure.
At present this updates the WBS Codes in the XER File during execution, but I think I may change this to allow the WBS Code Structure to be created on demand & only saved to the XER on request. Need to update this to allow the Origninal WBS to be saved to a User Defined Field in P6 so that it could be changed back via Global Change in P6 if required.
I am also working on converting the WBS Back to Activity Codes to allow for additional Group / Sort Options within Primavera without having to manually recreate the WBS Structure in the Activity Codes.
Regards,
Steven
Member for
15 years 9 months
Member for15 years9 months
Submitted by Johannes Vandenberg on Thu, 2017-11-23 12:10
Thank you for testing your development code that allows Import a WBS Structure from an Excel file into an XER File.
I have imported the file, and it looks excellent. The import is remarkable, and I am sure that many persons can make use off. This would be a great for importing WBS from ERP systems to Primavera P6.
Here is a part of the WBS in Exel
Prima-WBS-2.2.3Topsides Prima-WBS-2.2.3.1Structural Engineering and Drafting Prima-WBS-2.2.3.1.1Deck In - Service Analysis Prima-WBS-2.2.3.1.2Deck-Pre-Service Analysis Prima-WBS-2.2.3.1.3Deck Design Details Prima-WBS-2.2.3.1.4Deck Weight and Materials Take-Off Prima-WBS-2.2.3.1.5Deck AFC Drawings Prima-WBS-2.2.3.1.6Deck Detailed Engineering and Design Report
As loaded in Primavera P6
Prima WBS.2.3 Topsides
Prima WBS.2.3.1 Structural Engineering and Drafting
Prima WBS.2.3.1.1 Deck In - Service Analysis
Prima WBS.2.3.1.2 Deck-Pre-Service Analysis
Prima WBS.2.3.1.3 Deck Design Details
Prima WBS.2.3.1.4 Deck Weight and Materials Take-Off
Prima WBS.2.3.1.5 Deck AFC Drawings
Prima WBS.2.3.1.6 Deck Detailed Engineering and Design Report
Member for
8 years 1 monthJohannes,Thanks for that.I am
Johannes,
Thanks for that.
I am currently working my way through various bulk loading options, as data input is a bit of a pain in Primavera.
Is there anything else that would help you day to day, WBS Creation is only really an issue at the start of the project, as after the majority is loaded at the Project Start it is only modifications from there which are probably easier in P6.
I also have working code for converting activity codes to WBS Codes, with the WBS Levels set by choosing the Activity Code Types to use for each WBS Level. This also handles Activity Codes with a structure defined - any sub codes are added as a Sub WBS Code.
The activity code to WBS also updates the WBS of the activities to match the new WBS Structure.
At present this updates the WBS Codes in the XER File during execution, but I think I may change this to allow the WBS Code Structure to be created on demand & only saved to the XER on request. Need to update this to allow the Origninal WBS to be saved to a User Defined Field in P6 so that it could be changed back via Global Change in P6 if required.
I am also working on converting the WBS Back to Activity Codes to allow for additional Group / Sort Options within Primavera without having to manually recreate the WBS Structure in the Activity Codes.
Regards,
Steven
Member for
15 years 9 monthsHi StevenThank you for
Hi Steven
Thank you for testing your development code that allows Import a WBS Structure from an Excel file into an XER File.
I have imported the file, and it looks excellent. The import is remarkable, and I am sure that many persons can make use off. This would be a great for importing WBS from ERP systems to Primavera P6.
Here is a part of the WBS in Exel
Prima-WBS-2.2.3Topsides Prima-WBS-2.2.3.1Structural Engineering and Drafting Prima-WBS-2.2.3.1.1Deck In - Service Analysis Prima-WBS-2.2.3.1.2Deck-Pre-Service Analysis Prima-WBS-2.2.3.1.3Deck Design Details Prima-WBS-2.2.3.1.4Deck Weight and Materials Take-Off Prima-WBS-2.2.3.1.5Deck AFC Drawings Prima-WBS-2.2.3.1.6Deck Detailed Engineering and Design Report
As loaded in Primavera P6
Prima WBS.2.3 Topsides
Prima WBS.2.3.1 Structural Engineering and Drafting
Prima WBS.2.3.1.1 Deck In - Service Analysis
Prima WBS.2.3.1.2 Deck-Pre-Service Analysis
Prima WBS.2.3.1.3 Deck Design Details
Prima WBS.2.3.1.4 Deck Weight and Materials Take-Off
Prima WBS.2.3.1.5 Deck AFC Drawings
Prima WBS.2.3.1.6 Deck Detailed Engineering and Design Report
Regards Johannes