Organise the Data

Submitted by Gayantha Abeywardena on
Primavera Project Planner - P3

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Sun, 2008-03-23 14:17
Permalink

Save it as WK1 files.



Wk1 files can be opened in Excel 2003.



Cheers,



Raviraj

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Sun, 2008-03-23 09:17
Permalink

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

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Tue, 2008-03-18 08:13
Permalink

Excel 2007 doesn’t support WK1 extension. U need to use Excel 2003 for import / export.

Member for

20 years 3 months
Member for 20 years 4 months
Submitted by Charleston-Jos… on Tue, 2008-03-18 06:40
Permalink

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

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Tue, 2008-03-18 06:30
Permalink

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

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Tue, 2008-03-18 06:25
Permalink

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

Member for

20 years 3 months
Member for 20 years 4 months
Submitted by Charleston-Jos… on Tue, 2008-03-18 04:00
Permalink

Gaya,



The steps are found in P3 Manuals.



I think you got stuck in the path.



Your path should be limited only to P3OUT


Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Tue, 2008-03-18 03:11
Permalink

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

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Tue, 2008-03-18 02:03
Permalink

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

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Wed, 2008-03-12 06:39
Permalink

Or otherwise, you can can export them into excel and then change the activity description and import it back.



Cheers,



Ravi

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Wed, 2008-03-12 02:24
Permalink

Hi Alexandre,



Thanks a lot for the tip it helps me lot



cheers



GA

Member for

22 years 9 months
Member for 22 years 9 months
Submitted by Alexandre Faul… on Tue, 2008-03-11 12:58
Permalink

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

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Tue, 2008-03-11 07:19
Permalink



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

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by Gayantha Abeywardena on Thu, 2008-03-06 06:37
Permalink

Hi Wael,



Thankyou so much It’s helped me lot



Gayantha

Member for

17 years 8 months
Member for 17 years 8 months
Submitted by WAEL ELHAJJ on Thu, 2008-03-06 06:20
Permalink

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.