Copy and paste

N
Niek Zonneveld 👤 Member for 21 years 3 months

Hi Bill,



I’ve tried to find previous discussions on the subject but haven’t come across any.



Furthermore the MSP import capability is dramatically improved since 4.x so a ’new’ discussion won’t hurt I believe.



I use the MSP import feature on a daily basis and in my opinion there is no reason use Excel as an intermediate program. As soon as you understand where things can go wrong (summary task assignments, summary task relations, duplicate ID’s, etc.) and correct these errors before the import, it works flawlessly. A set of simple filters in MSP can be used to check for these errors.



Cheers,



Niek.

N
Niek Zonneveld 👤 Member for 21 years 3 months

Hi Katerina,



There are a few things you should check before you can successfully import MSP2003 schedules. If P3e hits an error it can’t resolve it terminates the import process without telling you; However if you go to the error log you can find the reason why.



The most common problem is duplicate resource names in MSP2003. During import into P3e you can select (in the template) if you want the MSP resource name or the initials as the unique identifier in P3e. MSP creates initials by just using the first character of the resource name, so Katerina and Kate will both be "k" in MPS. When you import this MSP schedule in P3e it will hit the "k" twice and terminate the import. What you need to do to resolve this is manually create unique resource ID’s (i.e. initials) in MSP before you import.



Hope this helps,



Niek.

J
Joao Ribeiro 👤 Member for 23 years 2 months

P3e/c should do it, possibly with some errors. Check the impor template in P3e/c and also close MS Project before starting to import. Hope it does the trick.

K
katerina Pasakopoulou 👤 Member for 20 years 11 months

dear planners..



Unfortunately i have MsProject 2003..

also i tried to transfer the activities from excel to PM.what is your opinion for this??



thanks anyway...

R
Raja Izat Raja Ibrahim 👤 Member for 21 years

dear katerina,

may i know which version MS Porject u use? As Far I know only MSP 98 *.mpx can transfer your activities to p3 included with link, other wise U have to make a P3 template in *.Wk1 and Export the data from MSP in *WK1 ...then copy and paste from MSP *.WK1 to P3 *.WK1.

Only style I know...Maybe u can try first or wait others expert opinion.

regards

N
Nazim Shaikh 👤 Member for 21 years 1 month

you should have microsoft project 98 to do this export & import to p3 any higher version then this of microsoft dont have this facility. Bye

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts