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.

Microsoft Project conversion to P3 expectations

17 replies [Last post]
Thu, 2003-10-16 03:25
Alphons Bruns
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 24 Jan 2002
Posts: 23
Groups: Petro-Chem / Oil & Gas
Dear PP people,

I would like to hear what kind of problems can occur when a planning is converted from MPP ->MPX -> to P3.

At the moment I am assigned to a firm that wants to put all the MP98 and MP2000 projects into P3 (and later maybe even into P3e) . How to convert I know, but what to expect from the results afterwards, and the work to be done to make the schedules trustfull working.

Suggestions and experience is very welcome on this subject.
Top

Replies

Mon, 2007-04-30 03:30
#1
Jorge Taguinod
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Durgesh,

1. Activity Durations: You may want to do a global change to divide all durations by 8 to convert from hourly durations to days. Or you may want to export Act ID and OD to excel, divide all ODs by 8, and import back into P3.

2. MS Project uses sub-activities to handle WBS. Primavera handles it differently. Since you’re moving to P3, you have to decide if you’re going to use Activity Coding and/or WBS. In any case, you may delete these topic activities from MSP. But you’ll have to create a project structure (Act Coding or WBS) to categorize your detailed activities.

This is what I meant by "doing some work" when converting from MSP to P3. It’s never a straighforward thing. One time I converted a small schedule from MSP to P3 and it took me a loooong time. I should have just done it in P3 from scratch instead of importing the schedule.

Goodluck.

Jorge
Top
Wed, 2007-04-25 07:10
#2
DURGESH NARAYAN M...
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 8 Apr 2007
Posts: 9
Groups: None
hi all!

i just converted msp programme in to mpx to convert in p3,
the problem i am facing is that, earlier the duration of the activities were in days & now they have automatically converted in hours in mpx programme which i want to be in days.
2nd problem is thatwhn i am conVerting mpx programme in p3, the main task is coming as TOPIC & NOT AS HAMMOK.HOW TO CHANGE IT AS HAMMOK ACTIVITY TYPE.

IF ANY BODY CAN HELP IN THAT.

THNX & REGARDS

DURGESH MISHRA

SIEMENS-ETA CONSORTIUM

Top
Wed, 2007-04-25 07:09
#3
DURGESH NARAYAN M...
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 8 Apr 2007
Posts: 9
Groups: None
hi all!

i just converted msp programme in to mpx to convert in p3,
the problem i am facing is that, earlier the duration of the activities were in days & now they have automatically converted in hours in mpx programme which i want to be in days.
2nd problem is thatwhn i am conerting mpx programme in p3, the main task is coming as TOPIC & NOT AS HAMMOK.

IF ANY BODY CAN HELP IN THAT.

THNX & REGARDS

DURGESH MISHRA

SIEMENS-ETA CONSORTIUM

Top
Mon, 2007-04-16 01:15
#4
Jorge Taguinod
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Hi Alphons,

I didn’t know that. I use Batch File to do it. Thank you very much for the information. This should make things much easier.

Do you have the utility? Or can you tell me where to get it?

Cheers,

Jorge
Top
Mon, 2007-04-16 01:06
#5
Alphons Bruns
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 24 Jan 2002
Posts: 23
Groups: Petro-Chem / Oil & Gas
Hello Jorge, There are two import utilities, You make use of activity.xls. There is also dictionary.xls. With this tool you can indeed fill WBS and also Resources, Custom data items,Cost account information. Regards.
Top
Sun, 2007-04-15 20:28
#6
Jorge Taguinod
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
P3’s import facility can only be used to import activity data. You can’t use this facility to modify dictionaries (e.g. WBS structure). To do this, you will need to either input it manually in P3 or use Batch Processing.

Please refer to the documentation included in your software for this.

Note: It’s quite difficult to use WBS in P3, but it’s a breeze in MSP and P3e. This is the reason you’re having quite a hard time importing from MSP. The technical process is easy. It’s the rework that’s a pain. Consider using P3e.

Jorge
Top
Tue, 2007-04-10 07:54
#7
Paul Harris
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
If I remember correctly P3 imports the WBS codes but not descriptions.

On the Primavera webs site Solution ID: 200252492644 supplies an Excel spreadsheet that can be used import the WBS codes and descriptions from MSP to P3.

You should be able to copy & paste the MSP WBS codes and summary task descriptions from MSP to the Excel Spreadsheet and then upload them to P3.

I have not specifically done this operation myself, but I often import Activity Code and Activity ID descriptions. If I had many WBS descriptions to upload, then this would be my approach.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Top
Sun, 2007-04-08 15:04
#8
Alphons Bruns
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 24 Jan 2002
Posts: 23
Groups: Petro-Chem / Oil & Gas
You can fill a text field in MSP with the value of your WBS before you convert, and during conversion it can be made an Activity code. After that you can make the WBS equal to the Activity code you created with a global change.

Regards Alphons
Top
Sun, 2007-04-08 04:34
#9
DURGESH NARAYAN M...
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 8 Apr 2007
Posts: 9
Groups: None
THNX!!

I CONVERTED MSP IN TO P3 BUT THE PROBLEM NOW I AM FACING IS THAT P3 IS NOT TAKING MSP’S WBS DIRECTLY...
ANY SOLUTION ...PLZ.

THNANK YOU.
Top
Mon, 2004-01-26 11:18
#10
Bernard Ertl
User offline. Last seen 9 years 19 weeks ago. Offline
Joined: 20 Nov 2002
Posts: 757
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)
You can also try:
  • saving your MSP2000 project in MSP98 format and use MSP98 to generate an .MPX
  • the free MPX2000 applet from Sciforma Corp.
  • the (commercial) MPX Translator plug-in from Bluewater Project Management Services, LLC
I would suggest you contact Primavera directly with any licensing issues you may be experiencing with their software.

Bernard Ertl
InterPlan Systems Inc. - Project Management Software, Project Planning Software

Top
Mon, 2004-01-26 07:50
#11
Gussein Mamedov
User offline. Last seen 20 years 13 weeks ago. Offline
Joined: 26 Jan 2004
Posts: 4
Groups: Petro-Chem / Oil & Gas
Dear All!
Please, kindly do me favor pls. I have tried all the instructions from you on this site. Thanks a lot. But since I tried to download this MPPtoMPX.exe from Primavera site, I can not register my P3 software, because its said my software is old in version, although my software is licensed officially ordered from Primavera itself by my company. Pls. kindly suggest how to solve the problem with convertion of MS Project 2000 files to P3. It is extremely important for me. May someone can forward me MPPtoMPX.exe utility already downloaded or there is another clue? My e-mail address guseinm@hotmail.com , corporate GMamedov@mqs.az
Top
Fri, 2004-01-23 23:34
#12
MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
I still suggest to re-do the import, then use some tools, like ClaimsDigger, PrimaPlan Project Investigator, etc to compare the 2 projects to list the differences. Then input those difference to the new one. I assume the difference are major your previous effort.
Top
Fri, 2004-01-23 10:51
#13
Clive Hibberd
User offline. Last seen 11 years 6 weeks ago. Offline
Joined: 15 Dec 2003
Posts: 5
Groups: None
Topic activities in P3

Can anyone help? I have converted a MS Project 2000 programme to P3 but forgot to outdent all the activities before converting. The result is that now I keep getting Topic activities showing in P3 but can’t change them. If I create new tasks to replace the topic activities, and then delete the topic activities, P3 then changes the activity above from a task to a topic activity. Does anyone have a fix for this? Unfortunately I can’t re-do the import conversion because I have made many changes to the programme since.
Top
Mon, 2003-11-24 12:04
#14
Dave Rodwell
User offline. Last seen 19 years 40 weeks ago. Offline
Joined: 27 Jun 2002
Posts: 5
Groups: None
I have tackled this conversion many times. It is not too bad to do, just make a cup of coffe, get comfortaable and allow sufficient time without interruption.
Top
Mon, 2003-11-24 11:32
#15
Jorge Taguinod
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Uh oh!

This is going to be difficult especially of you want to be organized about it. One of your major problem would be activity coding, expecially if you need to convert multiple MSP schedules into a P3 project group.

I anticipate that you would have problems with most if not all the items under the Data Menu.

Too long to expound here.

Jorge
Top
Thu, 2003-10-16 04:46
#16
Paul Harris
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
There is a technical paper on my web site www.eh.com.au on converting P3/STW to and from MSP.

Regards

Paul E Harris
Director
Eastwood Harris Pty Ltd
Top