Skip to content

conversions to P3

Dennis WalkerMember for 22 years 5 months
Created
8
3
0
could anyone please explain how i can import an excel spredsheet into P3 the spreadsheet is created from MS Project
thanks for your help

8 replies

Oldest first
  1. 0
    Marc Borburgh ·
    First off ... there are a lot of topics in the forum about this that explain the ways to import. But hey ... try this:

    1) Make an export to .wk1 from P3 with all the fields you will be filling from your MS Project Spreadsheet. In selection, select one (1) activity.

    2) Open the .wk1 file in Excell and delete the exported row

    3) Open the other spreadsheet too.

    4) Copy/Paste the data (not the column names) from the Projects Spreadsheet into the P3 Spreadsheet in the appropriate columns

    5) Save the .wk1 as a .wk1 file

    6) Import the newly populated P3 spreadsheet into you planning

    This should do the trick.
    Last note ... always wise to backup your project prior to importing.

    Hope this helps.
  2. 0
    Dayanidhi Dhandapany ·
    As a small suggestion, while if you want to import a big file of having more than 2000 lines, it is better to use .dbf as a file format, so that the import will be clean and perfect.
  3. 0
    Paul Harris ·
    Dennis

    There is a technical article about converting from MSP to P3 on my web site.

    Paul E Harris
    Eastwood Harris Pty Ltd, Melbourne, Australia
    Planning and Scheduling Book Publishers, Training & Consulting
    www.eh.com.au
  4. 0
    Mk Tse ·
    If the MsProject is version 2000 or above, the file is in MPP format, then you need a MPP to MPX convertor for the changes. P3 default CD provide MPX to P3 function only.
    MPP to MPX convertor is available on Primavera Knowledgebase.
  5. 0
    Karo, Kerry Ugen ·
    Good day,

    Please can anyone tell me how possible for one to convrt from Microsoft project 2000 to P3, i can convert from Microsoft project 98 to P3, but with MP 98 icant.

    can anyone help, please advice

    kerry
  6. 0
    Dayanidhi Dhandapany ·
    Hello Karo,

    what i understand from your question is you are able to convert MSP 98 to P3, but you can’t do it with MSP 2000 file then save MSP2000 file into lower version i.e, MSP 98 version file, then you can convert this file into P3.

    or else you have to download the utility(MPP to MPX) converter file from primavera knowledge base to do the conversion of MSP 2000 file format directly into MPX file, then go to tools from p3, click MPX conversion utility, then select the MPX file to convert it into P3 files.

    refer this link for further details

    Regards

    Daya
  7. 0
    Vishwas Bindiganavale ·
    Hi,

    I’m facing the same probs here. I have created a Project in MS Projects 2003. I cannot convert it using MPX-to-P3 conversion utility. Also, even if this happens partially, I loose all resouces, cash-flow, etc.

    Any help would be appreciated.
  8. 0
    Mk Tse ·
    As we have stated in previous posts, if the Project file is in .MPP (Project 2000 or later version), you need a MPP to MPX convertor to prepare a .MPX from .MPP

    Once you have the .MPX, P3 will ’take’ the file by MPX to P3 conversion utility.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?