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.
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.
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.