Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

P3 SCHEDULE TO MSP

11 replies [Last post]
Sat, 2005-06-18 04:41
X Planner
User offline. Last seen 9 years 17 weeks ago. Offline
Joined: 17 Jun 2002
Posts: 78
Groups: None
GUYS,

ANY POSSIBLE WAY TO CONVERT A 7K ACTIVITIES PROJECT FROM P3 INTO MSP PRESERVING THE SAME LAYOUT )CONSIDERING THE ASSIGNED CODES IN P3 AS A WBS IN MSP... ???

ACTUALLY I SUCCEDED TO CONVERT THE SCHEDULE DATA BUT THERE WERE NO WBS OR CODES IN THE LAYOUT AND THE DATA WAS NOT SORTED AS IN P3 WHICH WILL MAKE IT VERY HARD TO REBUILD A WBS SYSTEM FROM SCRATCH....


ANY IDEAS??????

THANX IN ADVANCE
Top

Replies

Thu, 2005-07-28 07:47
#1
Hannes de Bruyne
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
HI,

I brought up a new idea for transferring data -> no MPX (too poor), no ODBC (too complicated) just by using RA!.

Have a look at the Primavera P3 Forum.
Top
Tue, 2005-06-21 04:39
#2
X Planner
User offline. Last seen 9 years 17 weeks ago. Offline
Joined: 17 Jun 2002
Posts: 78
Groups: None
IT did help

thanx for Ramil and Jaco and all the contributers

it worked that way ...

i wonder how should i know that the text fields contains all my coding data :))

Thanx again
Top
Mon, 2005-06-20 10:47
#3
Ramil Rivera
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 13 Jun 2002
Posts: 5
Groups: Petro-Chem / Oil & Gas
Just an add’l. note: After creating code structure in MSP based on your P3 code structure. You’ll need to assign the codes to each activity in your schedule. Open a Gantt Entry View w/ Task Name column and insert all your custom fields, e.g. Text1, Text2, Outline Code, etc. Then assign the corresponding codes to your activities in order to see the effect of your code structure.

You will find the shortcut keys "Ctrl" + "D" helpful when assigning your code values to your activities.

Just hope this will help.

Regards,
Ramil
Top
Mon, 2005-06-20 01:54
#4
Jaco Stadler
User offline. Last seen 18 years 33 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Good Day

Try This.

Use MPX Conversion (P3 to MPX)

Open up in MP

Go Project - Group By - More Groups - New - Field Name Select - Text 1 (Your P3 Codes go into MS project text Fields)

Once you have Organised Changed the Code to your P3 Code Description (Type & Copy Works)

Now you should have the same Layout as in P3.

But as to the Data I dont Know what got Lost
Top
Sun, 2005-06-19 13:35
#5
Philip Jonker
User offline. Last seen 16 years 27 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
This is not impossible to do, however, excel probable is the best bet. The thinh to do is to create an numerical code within P3 prior to convertin to MPX, then create the fields in MSP, export from P3, and then copy the msp file to excel. If you then sort by the numericl code, you can copy paste the P3 codes to the MSP copy.Thereafter fix the problem wit sorts.
Top
Sun, 2005-06-19 02:50
#6
X Planner
User offline. Last seen 9 years 17 weeks ago. Offline
Joined: 17 Jun 2002
Posts: 78
Groups: None
Guys,
i tried something thought that it might convert p3 codes to wbs in msp which was the p3e for construction but there was no luck...
i got the same unorganized list of activities without any structure..
Top
Sun, 2005-06-19 02:29
#7
Ramil Rivera
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 13 Jun 2002
Posts: 5
Groups: Petro-Chem / Oil & Gas
Hi,

I’m not quite familiar yet with Access but I guess it would help to export your P3 data first to spreadsheet or Excel format then convert it into MSAccess. It might do the trick.

Pardon me, I’m still learning a little more related ’tricks’ of our trade, like Access, VBA/programming.

Ramil
Top
Sun, 2005-06-19 02:09
#8
X Planner
User offline. Last seen 9 years 17 weeks ago. Offline
Joined: 17 Jun 2002
Posts: 78
Groups: None
Thanx Ramil & Jaco

Can u Expand alittle bit on linking the p3 with access and then msp....??
Top
Sun, 2005-06-19 01:41
#9
Ramil Rivera
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 13 Jun 2002
Posts: 5
Groups: Petro-Chem / Oil & Gas
Hi Planner Planner,

Try using Custom Fields or Custom Outline Codes. These will be the equivalent of Project Codes and Activity Codes or Custom Data Items in P3. Please note that it was made available starting w/ MSProject 2000 to the latest version. MSP 98 doesn’t have these functionalities.

You can either export your coding structure first in P3 to Excel or other spreadsheet file (compatible with MSP) to map your codes in P3* *(Starting w/ MSP2000, MS stopped supporting MPX formatted files). You can then import it into MSP or while in MSP, you can create your project and activity code structure (the same way you assign in P3) by clicking Tools menu > Customize option > Fields, then when you’re in Customize Fields (Custom Field tab) - under Field list (make sure you use appropriate items Task or Resource) in this case make sure "Task" is selected, in the the Type box choose Text then create all your codes (type in your Values and Description - one note though, make sure your you assigned Ordinal numbers or letters in the Description column to help you in sorting the codes in order when Grouping or Sorting) same as what you have in P3. You may also want to try using Custom Outline Codes, say if you want unique Activity ID assigned to each tasks in the schedule make sure you define also your codes first as what you have in P3 then use the Formula option in Customize Fields window to assign Text1 field as your new Activity ID column or field. Your formula can be something like: Text1=[Outline Code1]+[Outline Code2]+[Outline Code3].

That’s all for now. Hope this helps.

For other cool tips on MSProject, check out the articles of Mr. Mike Glen at Techtrax at http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearc...

Rivera
Top
Sat, 2005-06-18 23:50
#10
Jaco Stadler
User offline. Last seen 18 years 33 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
MSP has Outline Codes. Use These as the Codes in P3. As to being successfull. I Doub’t it you will lose something / or Stuff Something. Maybe (I Have never done this myself) and easy way is to link p3 to Access & Access to MSP.

Cheers Good Luck.

Remember once you have done this succesful to tell us how you have done it. (I would start of by trying it if I was you and see what Happens)
Top
Sat, 2005-06-18 13:12
#11
Philip Jonker
User offline. Last seen 16 years 27 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
There is no way, due to the fact that P3 has a coding structure, and MSP has no structure, but it is not impossible if you have an open mind.
Top