I have created some development code that allows me to Import a WBS Structure from an Excel file into an XER File directly & have been testing this with my own projects, along with some made up examples to try & test it out properly.
I am looking to find out if there is anyone who has any examples of Excel Files that they would want created into a WBS Structure, to save having to manually generate different test examples.
I can import in 2 different formats at present:
Format 1:
All WBS Codes contained within 2 Columns - Column 1 is the WBS Code Values, with a defined code separator between each code, Column 2 is the WBS Description - i.e.
| WBS Code | WBS Description |
| WBS1 | First WBS Level (Under Project Code) |
| WBS1.1 | First Child WBS of WBS1 - "." Used as Separator |
| WBS1.2 | Second Child WBS of WBS1 |
| WBS1.1.1 | First Child of WBS1.1 |
| WBS1.2.1 | Child WBS of WBS1.2 |
Format 2:
Separate Columns for each WBS Code Value Level (e.g. Excel List Tables):
| WBSL1 Code | WBSL1 Description | WBSL2 Code | WBSL2 Description | WBSL3 Code | WBSL3 Description | WBSL49 Code | WBSL49 Description |
L1 | Level 1 - Repeating | LA | Level A - Child of L1 | LB | Level B - Child of LA | LAW | Level AW - Child of WBS Level 48 |
| L1 | Level 1 - Repeating | LB1 | Level B1 - Child of Level L1 | ||||
| L2 | Level 2 - Child of Project - Repeating | LZZ | Child of L2 |
Primavera allows a maximum of 50 WBS Levels, depending on settings in the Admin - Admin Preferences - Data Limits settings.
Each WBS Code can have a Maximum of 20 Characters.
If anyone would like to try this out, I will run the Import & Test the XER Import into a test P6 database before sending the final XER File back.
I am currently working on converting Activity Codes into a WBS Structure as well, but have a few changes to be made before I could offer this for testing purposes. Once this is complete I would be looking to see if anyone would like to have this done whilst I test out the code.
All files will be tested by importing into a test database to make sure that there are no issues during import, however this is development code in a development environment so would please keep this in mind.
Regards,
Steven