Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Import form excell, WBS lost

10 replies [Last post]
Santhosh kumar Na...
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 66

I have exported to excelll the activity details such as ID, Name, dates, % Complete etc. But once you import those updated data back to P6 file it losing the entire group and sort.

WBS dictonary remains unchanged but group and sort does not work. Is any body is having the same problem.

Regards

Santhosh

Replies

Alexandros Kroustis
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 29 Dec 2006
Posts: 6
Groups: None
Did you exported from a project and trying to import to another copy of the same project (or renamed the id of that project)? If yes you need to replace the old project id with the new in your excel. For example, if the id of the project you exported is "proj1" and you are trying to import to a project with id "proj2" you need to replace "proj1" with "proj2" in your excel, save it and then import. If you take a look wbs starts with project id.
Alexandros Kroustis
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 29 Dec 2006
Posts: 6
Groups: None
Did you exported from a project and trying to import to another copy of the same project (or renamed the id of that project)? If yes you need to replace the old project id with the new in your excel. For example, if the id of the project you exported is "proj1" and you are trying to import to a project with id "proj2" you need to replace "proj1" with "proj2" in your excel, save it and then import. If you take a look wbs starts with project id.
Zoltan Palffy
User offline. Last seen 2 hours 28 min ago. Offline
Joined: 13 Jul 2009
Posts: 2404
Groups: None

yeah think I said that NEVER change ANY column names that yo uhave exported 

Baykan Yigit Sogut
User offline. Last seen 1 week 9 hours ago. Offline
Joined: 18 Jul 2019
Posts: 3
Groups: None

While exporting Activity Sprea Sheet into Primavera, you shoudl always keep WBS Column as shown below.

6940
capture.jpg

Zoltan Palffy
User offline. Last seen 2 hours 28 min ago. Offline
Joined: 13 Jul 2009
Posts: 2404
Groups: None

3 possibilities here 

possibility #1 you removed the wbs_id column

If the WBS Code (wbs_id) column is removed from the Excel spreadsheet entirely the activities will be moved to the root WBS which is the higest level of the wbs

Possibility #2 If there are spaces at the end of the WBS code in Primavera, Excel then truncates the spaces and then Primavera cannot recognize the WBS code as an existing code. So Primavera assigns those Activities to the highest level WBS code.


In order to fix this from Project Management, browse to Project, then WBS   and then remove any spaces that are at the end of the WBS code.

For a simple way to process this, select any WBS Code, then go to 

Edit, Replace:

"Find what:" hit the spacebar once to show a blank space.

Leave "Replace with:" empty to remove all the spaces.

Click "Replace All".

Possibility #3 f you export a column that will compile a list, and this list has a column of more than 100 characters then the characters after the 100th character are cut off

these are the only way that I can see this happening. 

      
Sandy Meza
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 10 Jul 2019
Posts: 2
Groups: None

SAME ISSUE CONSIDER THAT the excel file comes with the WBS asign by default, and even though I lose the Wbs asign to each activity, any help please?

Zoltan Palffy
User offline. Last seen 2 hours 28 min ago. Offline
Joined: 13 Jul 2009
Posts: 2404
Groups: None

yeah the solution is to also export the wbs in the 1st place. JUst group and sort again

Carlos Ruiz
User offline. Last seen 1 year 23 weeks ago. Offline
Joined: 20 Mar 2015
Posts: 2
Groups: None

Hello!!!

Anybody find a solution for this issue?

Zoltan Palffy
User offline. Last seen 2 hours 28 min ago. Offline
Joined: 13 Jul 2009
Posts: 2404
Groups: None

I am not sure how you did this because you CAN NOT export any information to excel without also exporting the wbs code.

are you saying that the wbs is no longer assigned to the activities but the activity structure is intact ? 

Anil Varghese
User offline. Last seen 18 weeks 6 hours ago. Offline
Joined: 18 Mar 2014
Posts: 7
Groups: None

Yes; I have exported to excelll the activity details such as ID, Name, dates, % Complete etc. But once you import those updated data back to P6 file it losing the entire group and sort.

WBS level of activities gone!! Please help