Skip to content
ProjectControls.com
Primavera Project Planner - P3

Organise the Data

In the Open Standard
Gayantha AbeywardenaMember for 18 years 7 months
Created
15
3
0
Hi Gentlmen,

I want to group my existing primavera program by Activity ID Type and Floor wise how can i do it
to make it clear
Activity Id Activity Description
A10LGF44 First Fix
A10FFF44 First Fix
A10LGF45 Second Fix
A10FFF45 Second fix


Above LGF for Lower Ground Floor and FFF for first floor I want to separte Floor wise and Acttivity wise I maen to sort LGF First fix and Second fix then FFF first fix and Second fix can any body send me the steps

GA
Save Follow Follow forum Report
Reply New topic

15 replies

Oldest first
  1. 0
    Wael Elhajj ·
    #1
    update each activity you want with the proper dicipline . you will use to code the activities by means or project area and then filter them up on your new codes. go to data>activity ID> and see what diciplines you have. then arrange to see the levels set to your project and then filter or organize up on that criteria.
    i hope i was useful ... but as far as i know that is the way to do it.
    Report
  2. 0
    Gayantha Abeywardena ·
    #2
    Hi Wael,

    Thankyou so much It’s helped me lot

    Gayantha
    Report
  3. 0
    Gayantha Abeywardena ·
    #3

    Hi gentleman,

    I want change the activity description repeated more than 100times in the programme each time it has a different ID but I want to change the Activity description in to new one which will be same for all places.....

    Please help me send me the steps

    GA
    Report
  4. 0
    Alexandre Faulx-Briole ·
    #4
    Hello,
    sort your data on activity description,
    key in the new activity description on the firts row,
    select all the rows down on this particular column,
    click Edit, Fill Cell
    sort your data back to the orignial order
    Alexandre
    Report
  5. 0
    Gayantha Abeywardena ·
    #5
    Hi Alexandre,

    Thanks a lot for the tip it helps me lot

    cheers

    GA
    Report
  6. 0
    A D ·
    #6
    Or otherwise, you can can export them into excel and then change the activity description and import it back.

    Cheers,

    Ravi
    Report
  7. 0
    Gayantha Abeywardena ·
    #7
    Dear Raviraj,

    I tried to export it in to excel but it didn’t work can you please send me the steps of doing it
    thanks

    Gayantha
    Report
  8. 0
    A D ·
    #8
    Go to Tools --> Project Utilities --> Export

    In the window there will be three tabs, Content, Format and selection.

    In selection,

    type in the activity decription for selection,

    Give path name for the file location in Format

    And Content list in CONTENT tab.

    Open this excel file and then edit whatever u want and save it.

    Go back to P3 and then go to Tools --> P.... U....--> Import and then just give the excel file location and say RUN.

    Remember, this doesn’t work in Excel 2007.

    Cheers,

    Ravi
    Report
  9. 0
    Charleston-Joseph Orbe ·
    #9
    Gaya,

    The steps are found in P3 Manuals.

    I think you got stuck in the path.

    Your path should be limited only to P3OUT

    Report
  10. 0
    A D ·
    #10
    I believe, the file can be saved anywhere and not limited to P3 out.

    Hav u tried saving anywhere else and u got problem???

    Cheers,

    Ravi
    Report
  11. 0
    Gayantha Abeywardena ·
    #11
    Dear All

    I am working in excel 2007 which version i have to use Primavera 5 or else I have to switch to excel 2003 Advice me...

    Gayantha
    Report
  12. 0
    Charleston-Joseph Orbe ·
    #12
    Now I know

    You are using P5 but the main thread is P3.

    Oooppppss????

    My idea refer to P3 and exporting to excel 2003.

    Previously, the path I used was outside P3OUT and it did not worked.

    so to make it safe and avoid unnecesary waste of time, I used the path to P3OUT for export and import
    Report
  13. 0
    A D ·
    #13
    Excel 2007 doesn’t support WK1 extension. U need to use Excel 2003 for import / export.
    Report
  14. 0
    Gayantha Abeywardena ·
    #14
    Hi RaviRaj,

    I have followed the above steps but when it comes to path selection it shows ASCI, DBASE Lotus no any EXCEL I have installed the ExcEl 2003 too..

    Gayantha
    Report
  15. 0
    A D ·
    #15
    Save it as WK1 files.

    Wk1 files can be opened in Excel 2003.

    Cheers,

    Raviraj
    Report

Log in or join to reply

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

Log inJoin free

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