Skip to content
ProjectControls.com
Oracle Primavera - PM6

Filter by a list of numbers

In the Open Standard
Mi MoMember for 7 years 7 months
Created
11
4
0

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?

Save Follow Follow forum Report
Reply New topic

11 replies

Oldest first
  1. 0
    Santosh Bhat ·
    #1

    You could use a UDF as a flag

    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.
    Report
  2. 0
    Mi Mo ·
    #2

    Thanks for you comment.That

    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.

    Report
  3. 0
    Raymund de Laza ·
    #3

    What is Workorder?

    What is Workorder?

    Report
  4. 0
    Mike Testro ·
    #4

    Hi Mi Welcome to planning

    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

    Report
  5. 0
    Zoltan Palffy ·
    #5

    just make the filterwhere

    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

    Report
  6. 0
    Mi Mo ·
    #6

    Thanks for the comments. Here

    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.

    Report
  7. 0
    Santosh Bhat ·
    #7

    If you know how to drive XLS

    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.

    Report
  8. 0
    Raymund de Laza ·
    #8

    You need to assign an Activty

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

    Report
  9. 0
    Zita van Beusekom ·
    #9

    If you set these work orders

    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.

    Report
  10. 0
    Zoltan Palffy ·
    #10

    you are corret you can not

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

    Report
  11. 0
    Zoltan Palffy ·
    #11

    go to Enterprise and create a

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?