Importing P3 File to P3e

Member for

14 years 4 months

I have calculated my budget quantiy in excel & then converted to DBF file.But when i am trying to import all in P3 format.Except budget qunatity all are getting imported.But my budget quantity values are not displaying in P3.

Member for

20 years

Hi Philip,



Thanks for the response.



Regards.



Marcio eduardo.

Member for

21 years

Hi Marcio,



The import/export route is actually the simplest route to follow. The way you do it is to export the right fields, and also some user fields, depending on the infor mation/data you want to import. If you want to bring in codes, insert these codes in an user defined text field, you have to ensure that these codes are already allocated in the activity codes (in P3 you could import non- allocated codes and P3 would crete the codes without descriptions, but in V5 this is not possible), once the aforegoing is done, it is simply a matter of global change.



A humerous incident occured today, where we copied the master schedule, to make a major revision, the schedule was copied, but then all kinds of anonymalies started occurring, such as some project names were duplicated, some were renumbered, and various other things. This required a lot of maintenance in minutes. Had to figure out how to re-number projects in a controlled manner, how to rename the EPS structure. We managed to do it in no time, but the problem was somebody, had to walk through the minefield every time, that was pushing the button to do mass edits. The point is after the event, I decided this was the stuff where nedals should be issued,for bravery for planners, maybe the xxxx medal for hitting the replace button, or the yyyy medal for hitting the global change button.



Regards,



Philip

Member for

20 years

Hi Philip,



There is an option to import/esport to and from Excel on the P5 mesnu, ok?



Isn’t it SDK module introduced on P5 menu??



Do i have to install SDK also when using P5??



Regards.

Member for

21 years

Hi Marcio,



You have to install the SDK module. and it is not part of the menu, however there is simpler ways than using SDK.

Member for

20 years

Hi Philip,



Thanks for your help and support to my last answer.



About Q4: Import / export to excel in P3e is not the same as in P5. U have to use SDK module. In P5 this module was introduced in the menu.



Kind regards.



Marcio Eduardo

Member for

21 years

Hi Akin,



I sort of skipped the P3e period, and am working in Primavera V5, but my bit of time spent in P3e, tells me it is simular to V5.



Q1 and 2, Marcio is quite correct, however, make sure you select the project activity codes, as this is where P3 stores them during export. A tip to make thing easier is to create a wbs based on your P3 codes, then sort by activity codes, and code your activities with WBS codes to match, after this you use the WBS which is easier.



Q3: I would suggest you export your baseline (Target) project to P3e and after sorting out the WBS in the same fashion as mentioned above, set a baseline on your Target project, and use this baseline in your updated project. If this sounds a bit unclear, contact me to give more details. the problem is that the two programs operate slightly different, but essentially the same.



Q4: I am not sure if I am a 100% correct, but in V5, this is very simple, you set up your report, and copy paste it into Excel. I suspect you can do the same in P3e.

Member for

20 years

Hi Akin,



1 - Just repeat your activity codes structure (P3) on group and sort (P3e).



2 - Answered on #1.



3 - Sorry, i’m not sure. But i think that P3e imports P3 baseline.



4 - Yes, u can do it using SDK module or creating a lay-out on Assignments with the columns u need, copying and pasting to Excel.



Regards.



Marcio Eduardo

Rio de Janeiro - Brazil