Skip to content
ProjectControls.com
Oracle Primavera - PM6

Import form excell, WBS lost

In the Open Standard
Santhosh kumar NarayananMember for 20 years 2 months
Created
10
4
0

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

Save Follow Follow forum Report
Reply New topic

10 replies

Oldest first
  1. 0
    Anil Varghese ·
    #1

    Yes; I have exported to

    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

    Report
  2. 0
    Zoltan Palffy ·
    #2

    I am not sure how you did

    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 ? 

    Report
  3. 0
    Carlos Ruiz ·
    #3

    Hello!!!Anybody find a

    Hello!!!

    Anybody find a solution for this issue?

    Report
  4. 0
    Zoltan Palffy ·
    #4

    yeah the solution is to also

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

    Report
  5. 0
    Sandy Meza ·
    #5

    SAME ISSUE CONSIDER THAT the

    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?

    Report
  6. 0
    Zoltan Palffy ·
    #6

    3 possibilities

    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. 

     Report
  7. 0
    Baykan Yigit Sogut · 
    #7
    While exporting Activity
    While exporting Activity Sprea Sheet into Primavera, you shoudl always keep WBS Column as shown below.
     Report
  8. 0
    Zoltan Palffy · 
    #8
    yeah think I said that NEVER
    yeah think I said that NEVER change ANY column names that yo uhave exported 
     Report
  9. 0
    Alexandros Kroustis · 
    #9
    Did you exported from a
    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.
     Report
  10. 0
    Alexandros Kroustis · 
    #10
    Did you exported from a
    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.
     Report
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Log inJoin free
Existing members: your original username and password still work. Forgot password?