How to change WBS path in primavera P6?

Prathy,

The WBS path cannot be created using the excel import / export.

If you look at the column names in the excel export sheet, both WBS Name & WBS Path have the (*) symbol at the start, which indicates that they are not imported into Primavera from the excel sheet.

The WBS Code would have to be created in Primavera first, then you should be able to assign these WBS Codes to activities using the Excel Import - the full WBS Path would need to be assigned against the WBS Code column in the excel sheet.

The WBS Code field is the full path including the Project level WBS Code value.

If the WBS Code already exists in the Project you are importing into, then it should be able to be assigned using the "WBS Code" column (wbs_id) & not the "WBS Path" column (wbs_path).

You can use the "Fill Down" in Primavera to speed up the WBS Code assignment for the activities that are now imported against the Project WBS instead of using the Global Change.

Hope this helps.

Steven

not true if you use SDK you can create the WBS

Zoltan,

You are correct - you can use the SDK to create the WBS in excel, however not everyone is able to use the SDK to update the Primavera Database depending on their IT setup.

You can also create the WBS using the XER Parser (Guide on Plan Academy as to how to do this: https://www.planacademy.com/using-primaveras-xer-file-parser-import-wbs-from-excel-without-the-sdk/) if you cannot use the SDK.

From Prathy's post I have taken it that he is using the Primavera Spreadsheet Import / Export option to copy the update from one project to another, which does not allow for the creation of WBS Codes & will default to the Project WBS Code if the correct path does not exist.

Regards,

Steven

yes the parser is another option. you can assignn a wbs to an activity using excel once the wbs structure has been crested. After I have created the wbs structure I go to the wbs and select all of it and copy it into the spreadsheet the I am going to use to import activities and I make a drop down list in excel so I can assign the wbs value in excel it make t he process much easiler

WBS cannot be imported and can't be modified by Global change in P6 Professional.

We have developed a tool using Primavera API.

Please check these:

https://prmyazilim.com/en/solutions/prmtransfer

https://www.youtube.com/watch?v=QL4BpEBoryo

there are several ways to import a wbs

1. create a few wbs lines in p6 export as an xer then open the xer in a text editor and paste the wbs portion into excel and continue to build the wbs in excel then copy the excel portion of the wbs into the xer opened n the text editior, save the file, then import the xer into p6

2. create a few wbs lines in p6 export as an xer then use the excel parser and select load xerf ile and make the rest of the wbs in the parser using the Projwbs tab at the bottom. Then select create xer file  and import the xer file into p6.

3. Download ranga and use ranga (add on for excel) and select create wbs fill in the rest of the ubs and then select  Raw import and then select Export Raw xer file and then import this file into P6