(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.
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
Printer-friendly version
Send to friend
yeah think I said that NEVER change ANY column names that yo uhave exported
While exporting Activity Sprea Sheet into Primavera, you shoudl always keep WBS Column as shown below.
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.
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?
yeah the solution is to also export the wbs in the 1st place. JUst group and sort again
Hello!!!
Anybody find a solution for this issue?
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 ?
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
Email: PPadmin@planningplanet.com
Replies