Importing from MS to P3
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
I support what Clives mentioned.
Import MPP/MPX into P3 is painful job. Im not worry data loss since youll have more than the required just after the import. e.g Group headings will be an P3 activity rather WBS/Group heading.
My experience, the task is not easy and no shortcut.
We have written a program that uses RA and the MS Project objects to do this..email me and Ill send you a copy.
You need P3 and MS Project 2000/2002/2003 on the same PC.
[email protected]
Hi Joel,
there are several ways to do it.
1. save the mpp as mdb(access database),then make some queries or new table to filter out the info. you need,the format should meet the requirements for P3 to import (eg.field length,field order...),then save the query/new table as dbf file, then import to P3(you need to import several files for activity ID/description, relationship...)
2. you can write some micro in MSP using P3s RA engine to transfer data from MSP to P3.
3. you can try P3 batch, you also need to export MPP to excel or word... then format it.(I have a excel micro to generate batch file with right format)
4. try to find some ready-made software
BTW its better to specify in the contract what software to use. You also need to set up a system for scheduling (work procedure, code definition , update method....),it is very important for such a big project. (is it in Xinjiang?)
There is an article on my website under technical articles that outlines many of the options.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Joel,
Look like you dont have a choice other than using MPX2000 to convert the MPP file.
Regards.
Hi Joel
Sorry being a bit late reading your additional request.
Answer is already there by other colleague.
Regards
JMFrade
Joel,
Check in your MSP 98. When you click "save as" you can save the file as MPX format.
HTH.
Hi Jose,
3. Use MSP 98 open the file and save MPX format.
Where do you find the MPX format function once you have saved it in MSP 98? Is that a export attachment file?
Regards.
Hi joel
I suggest you to take a look in previous discussions, you might find a lot of stuff in there.
I personnaly do the following:
1. ENSURE THAT ALL PRED. and SUCC. are linked with the unit that you are going to use it in P3 (Days most often).
2. Save actual version of MS project in MSProject 98 type.
3. Use MSP 98 open the file and save MPX format.
4. Import MPX in P3.
Best regards
JMFrade
Thanks for the reply however your answer was:
Check in your MSP 98. When you click "save as" you can save the file as MPX format.
I am working on MSP2002 version I have saved it in MSP 98 but I cant find the MPX Format on the save as menu. The options I have is only MP98,Text,CSV,XML Format, and the usual Microsoft file. Is ther a alternative?
Thanks