Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Sorting Code libraries

6 replies [Last post]
Sun, 2009-09-27 18:29
Carlos Arana
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
I’ve noticed the code libraries include a sort order field. I exported my P3 schedule to Power Project in order to learn PP. The contract view all stakeholders are used to, displays milestones at the top, under a "milestones" heading, then some excavation works then heavy civils and construction roads at the bottom, each under its own heading. I tried to sort them in the same way they were sorted in P3, but PP seems to sort them alphabetically. How can I override the alphabetical order of the code libraries to sort the sub headings in the way they were signed in the contract?
Top

Replies

Tue, 2009-09-29 16:28
#1
Carlos Arana
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Mike: thanks for teaching me your way of doing things.
I’m glad we both learned something new.

Best Regards.
Carlos A. Matus.
Top
Mon, 2009-09-28 13:08
#2
Mike Testro
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 14 Dec 2005
Posts: 4420
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Carlos

Thanks for teaching me something new.

I have never had to use that facility before.

Best regards

Mike Testro.
Top
Mon, 2009-09-28 12:33
#3
Carlos Arana
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Thanks for the replies Mike!

I found another way to make it:
tools > options... > view > sort code libraries.

The default is "by name", I choose "By sort order", then fill the sort order field in the library explorer. That gets me to the same sort order as P3’s

I could not get the view the way you suggested, maybe I did not explain clearly what I was trying to do.

Thanks for the help.

Regards.
Top
Mon, 2009-09-28 11:06
#4
Mike Testro
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 14 Dec 2005
Posts: 4420
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Carlos

You do not copy paste the code library - you copy paste the task descriptions.

Then add the line numbers from P3 and do a =vlookup on the Powerproject side.

You will find the User Field Manager under the Tools drop down.

Save the file first and make sure that you set the User Level under the Help Drop Down to Advanced.

Best regards

Mike Testro
Top
Mon, 2009-09-28 10:52
#5
Carlos Arana
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Thanks Mike.

This may sound stupid but I don’t seem to find how to copy/paste code library definitions from PP. While I investigate it, can you explain me how do I sort the grouping according to a field?

I’m trying to achieve the exact same sort order in PP that I use in Primavera. Why? Because thet will help me learn how to configure the views in any way that is needed. That will also show me the limits and differences between PP and P3.

I think I need to explain it better what i’m trying to achieve. The next image is the contractual view in P3:
http://www.flickr.com/photos/8317996@N03/3962193329/sizes/o/
in P3, Headings are grouped according to the activity code Value, descending.

This is the view I’m getting in Power Project:
http://www.flickr.com/photos/8317996@N03/3962194661/sizes/l/
Top
Mon, 2009-09-28 02:36
#6
Mike Testro
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 14 Dec 2005
Posts: 4420
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Carlos

One simple way would be to set up a spreadsheet

Copy and paste the P3 descriptions in column A and a list of numbers representing the line numbers of the P3 programme in Columnn B.

In column C copy paste your PowerProject descriptions and in column D do a =vlookup formula to align the P3 line number to PwerProjct descriptions.

In powerprojec set up a user field column and copy paste the line numbers into it.

Then sort ascending on the user field.

Save the view as P3 Sort.

Best regards

Mike Testro
Top