Exporting from P3 / P5 into Ms Project

Hi!


I don’t have MS Project right here, but I’ve done once an export from P3 to MSP. There’s a ligne similar to project overview (in Tools but not sure) where you can define the starting date for the project under MSP.

If you don’t find it by yourself, i’m pretty sure that the MSP help topic (hit "start date") can redirect you to the start date?

Good luck. and don’t be affraid, but you will surely have some missmatch comparing you MPS Schedule and you P3 schedule, as the algorythme is not the same.

To change project start date in MSP (any version): Project, Project Information, Start Date
Be careful that exchanging project plans between MS and Primavera apps will make you lose a lot of scheduling data, as both apps do not schedule the same way; for instance P3 "Project must finish by" will be converted as "Finish no later than" on the MSP schedule last task, P3 constraints will not convert correctly in MSP that lacks a lot of them, etc...
Alexandre

All,

It’s not the project start date specifically that is the problem, it is all the activities are having their start dates reset to the project start date.

It is the same for any export from P3 or P5.

Resources are also imported incorrectly ?

Kevin.

All,

Fixed the problem. I eventually exported out of P3 to a DBF file. Renamed that to an excel file (.xls); edited it and then saved it as a CSV (Comma separated file); one of the few file formats recognised by MS Project.

I then mapped the four fields I exported into MS Project. i.e Activity id, name and the early start and finish dates. Note : you need to map the ES/EF dates as actual start and finish dates in MS Project otherwise it resets the start date to the data date.

Confused..?

Best option would be to avoid MS Project all together !

Regards,

Kevin.

Kevin

it’s great that you’ve figured that out... converting a P3 file to MSP is quite a tedious task and does not guarranty a 100% accuracy, however converting a P3ec to MSP works just fine for me... just check again the exporting template...