Sorting of Activity IDs in P6

Change it to

DC01
DC02
DC03
.....
....
....
DC09
DC10
DC11


DC19
DC20

Hi Wael,

Try to remove or delete (Leave it blank) the Field Name in the Sort.

Regards,

Arnold

Dear Arnold,
Thank you for your very fast reply , you are a friend indeed. I tried to remove the field name in the sort that is found in the organize GUI yet it still persist...
it did not work. is there any other mean or tool to correct sorting or correct how P6 considers the activity ID?

Hi Wael,

You can try Rav’s suggestion.

You need to be specific in sorting. If you have linked the activities and do you think it is okey then you can try to change the Activity ID using global change.

In P6 v7, it is very easy to change the Act ID. If you need further assistance on how to create a parameter in global change, let us know.


Regards,

Arnold

Dear Rav and arnold,
I thought of Global Change as a solution for this problem yet the activity Ids are not uniform , ie: for substructure the form of the ID is different than the submitals of every single contractor activity ID ... along with the activity ID defines sectors of the projects, levels and partitions.
if this could be sorted out with Global Change please inform me of the parameters.
thank you alot for you time and help. hope i could be of any assistance in the future.

Hi Wael,

Try the following workaround:

1. Create a new UDF, say ActSort.
2. Select Data Type equal to "Text".
3. Create a new Global Change, say "Sorting Activity ID".
4. The Parameters:

Select Subject Area "Activities"
If:
Where:
Activity ID "starts with" or "contains" DC

Then:
ActSort " = " SubString(Activity ID,3,10)

When done, Go to Group and Sort, select Sort, Add

Field Name = user_text1
Sort Order = Ascending

Regards,

Arnold

Wael,

As Arnold has already said, just delete the ’Field Name’ and it will sort it correctly for you. I’m sure this should work for all versions of P6.

Walshy

Dear Neil and Arnold.
Neil I already tried out the first choice and it did not work out as i wanted it to ... it should have worked but it did not...
Arnold i figured out the mean to for fill my need, it is very close to what you said. I exported all activities to excel... from there i sorted them and gave a user denide integer asending value to all 12,000 activities. after every activity ID was sorted and had a sort value allocated accordingly. after i imported the spread sheet , i sorted the schedule with reference to the new user defined field and the result amazing...
problem solved, why didn’t i think of that earlier... :)
again I thank you alot for sharing very important and vital information with me. I would have never been able to do it with out your support.
by the way if you ever need anything from UAE please inform me, I will be more than glad to help anytime.

Wael,

I’d love to be best pals with an oil tycoon.....could you get me one of those please? ;) ha

Anyway glad you got your Activities sorted the way you want. You certainly need a global function for 12,000 of the little buggers!

Take care

Walshy

Dear Neil,
If you love to workin oil and gas , well i hate it... I lostthe sense of smell and the taste of women. thus... do you want to exchange jobs/location?
wael