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.
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.
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.
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.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
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.
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.
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.
Dont wait your Project manager chasing U....Cheers
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...
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
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