Skip to content

exporting to excel

Sunil KumarMember for 21 years
Created
5
1
0
i am a beginner in p3 .. can anybody pls briefly explain how to export activity ids, activity desc,ES EF,OD RD to EXCEL....

thanx

sunil

5 replies

Oldest first
  1. 0
    Steven Oliver ·
    Easiest way is to Cut & Paste
  2. 0
    David Andreotti ·
    Sunil;

    Run the export utility in P3. It will take you through the process.

    Dave
  3. 0
    Sen Moc ·
    In P3, select Tools/Project Utilities/Export. Then if you don’t want to use the existing export definition file, CLICK MODIFY.

    In the Content Tab, select Export/Contents of List. Then choose the items you want to export such as, Act ID, Act Description, ES, EF, etc……..

    In the Format Output Tab, Input filename and select file type. Note: the default file location is P3win/P3Out.

    In the Selection Tab, provide selection criteria or leave it blank if you want to select all activities.

    Finally, Click Run.

    Then, in MS Excel open the exported file. Note: the default file location is P3win/P3Out.

    Good luck and More Power!
  4. 0
    Hannes de Bruyne ·
    Better use a wk1-File to export (can be extended for reimport)
  5. 0
    Andrew Tan ·
    Hi,
    If you want to know what to export, use WK1 for export and edit accordingly. Try importing after that.
    I will not recommend exporting and importing unless you have a lot of data to amend fast.
    I have a excel utility that will extract data like export/import function.

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?