Ive tried to find previous discussions on the subject but havent come across any.
Furthermore the MSP import capability is dramatically improved since 4.x so a new discussion wont 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 IDs, 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.
Member for
20 years 7 months
Member for20 years7 months
Submitted by Niek Zonneveld on Wed, 2005-08-10 05:36
There are a few things you should check before you can successfully import MSP2003 schedules. If P3e hits an error it cant 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 IDs (i.e. initials) in MSP before you import.
Hope this helps,
Niek.
Member for
22 years 7 months
Member for22 years7 months
Submitted by Joao Ribeiro on Wed, 2005-08-03 08:41
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.
Member for
20 years 5 months
Member for20 years5 months
Submitted by Raja Izat Raja… on Wed, 2005-08-03 06:00
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
Member for
20 years 6 months
Member for20 years6 months
Submitted by Nazim Shaikh on Wed, 2005-08-03 05:02
Member for
20 years 7 monthsRE: Copy and paste
Hi Bill,
Ive tried to find previous discussions on the subject but havent come across any.
Furthermore the MSP import capability is dramatically improved since 4.x so a new discussion wont 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 IDs, 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.
Member for
20 years 7 monthsRE: Copy and paste
Hi Katerina,
There are a few things you should check before you can successfully import MSP2003 schedules. If P3e hits an error it cant 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 IDs (i.e. initials) in MSP before you import.
Hope this helps,
Niek.
Member for
22 years 7 monthsRE: Copy and paste
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.
Member for
20 years 5 monthsRE: Copy and paste
Dont wait your Project manager chasing U....Cheers
Member for
20 years 3 monthsRE: Copy and paste
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...
Member for
20 years 5 monthsRE: Copy and paste
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
Member for
20 years 6 monthsRE: Copy and paste
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