Forum Sponsor:
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
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?
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.
you are corret you can not use within the range becasue it treats the code value as text
You need to assign an Activty Codes to Batches of Items to use for filtering.
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.
Thanks for the comments.
Here is the problem, in small version offcourse
These are "all" orders.
ORDER | KARWEI | SYSTEEM | Volgnr | Werkorder name |
100509410 | VER-0503 | 0120 | Zoutbanden Verv./Rep. verlichting. | |
200587836 | EVB-31043 | S19 | 0120 | Z4/Z6 PD-meting kabelverb. (B1/2) 42E_4Y |
200587835 | EVB-31042 | S19 | 0120 | Z3/Z5 PD-meting kabelverb. (A1/2) 42E_4Y |
200627429 | 841041 | S5 | T8413 Periodieke inspectie.[6Y] | |
200586331 | EVB-31004 | S19 | 0140 | TZ3 Onderhoud (huur)trafo door Fa. Joulz |
200587821 | EVB-31013 | S19 | 0120 | TM7 Onderhoud transformator 42E_4Y |
200587829 | EVB-31016 | S19 | 0120 | TM7 Mantelbeproeving kabelverbinding 4Y_ |
200587823 | EVB-31015 | S19 | 0110 | TM7 Func.test temp. beveiligingen 42E_4Y |
200614818 | 81160 | 0100 | Keuring hijs-/hefmiddelen MEB TA 2Y | |
200587811 | 842010 | S6 | 0100 | T8422 Periodieke Inspectie 4Y |
200587782 | 832003 | S6 | AT8361 Periodieke Inspectie 6Y | |
200587779 | 831002 | S5 | AT8351 Periodieke Inspectie 6Y | |
200587793 | 833001 | S7 | AT8334 periodieke inspectie 4Y | |
100480973 | 81469 | S2 | 0110 | AT8171 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.
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
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
What is Workorder?
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.
Replies