Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Filter by a list of numbers

11 replies [Last post]
Mi Mo
User offline. Last seen 4 years 44 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

Hi everyone,

 

I haven't been able to find other posts about this, since I don't know how to call it what I am searching for..

The thing is this:
In my Primavera P6 I have different workorders. In Excel I have a nice list of 120 workorders that I want to change.

Now, I want to export exactly those workorders. Is there a way to copy and past that list in the filter of Primavera?

 

The only way I know how to get them is to filter one by one every workorder number.

Should be an easier way right?

Replies

Zoltan Palffy
User offline. Last seen 3 days 12 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

go to Enterprise and create a UDF user defined field call it new work order and make that data type an integer

then go to tools and run a global 

any 

where work order  equals 100509410 then new work order equals 100509410

or

where work order  equals 200587836 then new work order equals 200587836

and so on 

now you will be able to filter group and sort by this udf new work order

If you set these work orders as "user text""or üser number", then I will suggest to create Activity Code that could organize how you wanted it and then by using GLOBAL CHANGE to assign this code to certain activity as to the range you want (or manually, from activiy layout, do not group your activities, but set a column for ORDERS, and then "soort it", and then assigned the code and then fill-up the rest as to the code) and then you can create the filter with "little parameters". :-), I used to do that for procurement activities specially if they are bulk materials that has different (or batches) deliveries.

Zoltan Palffy
User offline. Last seen 3 days 12 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you are corret you can not use within the range becasue it treats the code value as text

Raymund de Laza
User offline. Last seen 27 weeks 6 days ago. Offline
Joined: 22 Nov 2009
Posts: 762

You need to assign an Activty Codes to Batches of Items to use for filtering.

Santosh Bhat
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 15 Apr 2005
Posts: 381

If you know how to drive XLS exports, the export the list of activities including the UDF I mentioned in my earlier field. Use VLookups to match up the order numbers, and place a flag against those that match, then import this list back into P6. Then all you need to do is to filter against the flag UDF.

Mi Mo
User offline. Last seen 4 years 44 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

Thanks for the comments.

 

Here is the problem, in small version offcourse

 

These are "all" orders.

ORDERKARWEISYSTEEMVolgnrWerkorder name
100509410VER-0503 0120Zoutbanden Verv./Rep. verlichting.
200587836EVB-31043S190120Z4/Z6 PD-meting kabelverb. (B1/2) 42E_4Y
200587835EVB-31042S190120Z3/Z5 PD-meting kabelverb. (A1/2) 42E_4Y
200627429841041S5 T8413 Periodieke inspectie.[6Y]
200586331EVB-31004S190140TZ3 Onderhoud (huur)trafo door Fa. Joulz
200587821EVB-31013S190120TM7 Onderhoud transformator 42E_4Y
200587829EVB-31016S190120TM7 Mantelbeproeving kabelverbinding 4Y_
200587823EVB-31015S190110TM7 Func.test temp. beveiligingen 42E_4Y
20061481881160 0100Keuring hijs-/hefmiddelen MEB TA 2Y
200587811842010S60100T8422 Periodieke Inspectie 4Y
200587782832003S6 AT8361 Periodieke Inspectie 6Y
200587779831002S5 AT8351 Periodieke Inspectie 6Y
200587793833001S7 AT8334 periodieke inspectie 4Y
10048097381469S20110AT8171 Bodem-inspectie Plasticon

 

I want to filter out: 100509410, 200587779 and 200587821.

There is not a certain range.. I can only tell

Where - Workorder - equals - 100509410

Where - Workorder - equals - 200587779

Where - Workorder - equals - 200587821

For 3 numbers it is doable.. But not for the amount I need.

Zoltan Palffy
User offline. Last seen 3 days 12 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

just make the filter

where work order is in the range 01 120

if you do not have the leading zero as Mike stated above then

where work order is in the range (low range ) 1 (high range) 120

the other option is 

where work order is not equal to (then leave this next part blank)

then you can go to group and sort and Group by work order

Mike Testro
User offline. Last seen 1 week 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418

Hi Mi Welcome to planning planet.

With any numerical list make sure that you use a leading zero format: Nr 1 is '0001 ect.

This is because when you transfer the data to P6 it is not in numeric form but text so that when sorted nr 9 will appear after nr 10.

Best regards

Mike Testro

Raymund de Laza
User offline. Last seen 27 weeks 6 days ago. Offline
Joined: 22 Nov 2009
Posts: 762

What is Workorder?

Mi Mo
User offline. Last seen 4 years 44 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

Thanks for you comment.

That would be a plan B, but this way I still have to go manually tru every line that has that workorder.

I would like to copy that list from excel and paste it somewhere in a filter.

Santosh Bhat
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 15 Apr 2005
Posts: 381
You could use a UDF as a flag field to identify those activities from your list. Then run a filter that only selects the activities that containe flag value.