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
Member for
23 years 11 months
Member for23 years11 months
Submitted by Nihat Yildirim on Tue, 2022-05-03 14:56
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
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.
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
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Mon, 2017-10-16 15:04
The WBS path cannot be createdusing 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.
Member for
16 years 3 monthsthere are several ways to
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
Member for
23 years 11 monthsWBS cannot be imported and
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
Member for
16 years 3 monthsyes the parser is another
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
Member for
8 years 1 monthZoltan,You are correct - you
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
Member for
16 years 3 monthsnot true if you use SDK you
not true if you use SDK you can create the WBS
Member for
8 years 1 monthPrathy,The WBS path cannot be
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