Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Export from P6.7 to MSP

No replies
Abraham Jeyachandran
User offline. Last seen 12 years 40 weeks ago. Offline
Joined: 8 Nov 2011
Posts: 2
Groups: None

We are using Primavera version P6 version 7. We exported project from Primavera to Microsoft project (MSP) - First export from Primavera to XML 2007 then import XML 2007 to Microsoft project.

After exporting we noticed ID in Microsoft project is different sequence. Following is the sample

 

 

Microsoft ID

Primavera Project ID

Activity Name

Duration

7  

J3201        

Activity A

0.5d    

13 

J3202         

Activity B

0.5d        

8  

J3203        

Activity C

0.5d      

16 

J3204         

Activity D

1.5d    

9  

J3205        

Activity E

2d     


Please note for second primavera ID (J3202), MSP populated ID is 13 and for third primavera ID (J3203), MSP populated ID is 8. (Instead that, for the second primavera ID, MSP ID should be 8 and for third primavera ID, MSP ID should be 9, if it is in the same sequence of activity ID).

Relationships and durations are exported correctly hence dates are correct but the order is different than the actual process.
 

With what information from Primavera exported file MSP ID is created?

Is there any other unique ID other than Activity ID is created in Primavera while adding the activity?  If yes may be based that MSP ID is created.

How to create the MSP ID in the same sequence as the Primavera Activity ID?


Regards

Abraham