I have a schedule imported from MS Project which is due to be replaced soon by one created and imported from P6. I'd like to be able to select two Tasks (one from the MS project schedule, and the second from the P6 schedule) and have the Directly assigned 3D Resources (assignment, appearance profile & 3D Path applied) copied across. I assume that this could be handled by a script but I'm only familiar with very basic scripting based on single task operations and I don't know where to start.
This would seem to be the most reliable way to semi-automatically handle the assignment transfer between tasks but I'm open to any suggestions on how to handle this?
I am currently on version 220.127.116.11 but looking to upgrade to a later version very soon.
Thanks in advance!
Please go through the following steps -
Hope this helps!
Thanks Arpit,This has given me many ideas on how to potentially carry this out.I replaced the OldTaskID resource value with the common new/old task values else the automatching doesn't work.
Is there any way to populate the Resource userfields (appearance profile, 3dpath etc) with the information held from the assignments of a single selected task? The method you have supplied pulls all the assignment data for every task it is assigned to which makes reassigning the correct appearance profiles tricky.
Many thanks for the help on this Arpit
You can add SELECTED in from of TASK, which will then ensure the script is only working for selected Tasks. Eg.
TASK(SELECTED).ASSIGNMENT SET_PROPERTY (STRING_PROPERTY("3D Path"), RESOURCE.UFV("3D Path"))
Typically, just doing multiple Resource Assignments using the provided method above works like a charm, but including Appearance Profile and 3D path starts getting trickier. But you have means of referencing that information at least and using some quick tabular filters, edits can be made in bulk.
Arpit,Thanks for replying. You've provided a script to set the properties of the selected task assignments, I was looking for the reverse.
The reason I am so hung up on doing this a Task at a time is because many of my Resources are assigned multiple times across the schedule using differing Appearance Profiles, I can pull multiple Appearance Profiles for a Resource but assigning the correct Profile for the correct Task I think may be impossible unless I can cross-reference them in a numbered array (well beyond my capabilities!).
These are the steps as I see it:1) Select the old Task & Select all the Resources currently assigned to it (manual operation)2) Script sets Resource UFV's applicable only to the currently selected Task (this is the script I'm after)3) Assign the Resources to the new Task in bulk using standard shortcut (manual operation)4) Script to assign correct Appearance Profiles, 3DPath & Alignment (already have these scripts)
Hope this is what you looking for - RESOURCE(SELECTED) ASSIGN_UF("Old Task IDs", STRING, CONCAT_COMMA(TASK(SELECTED).USER_ID))RESOURCE(SELECTED) ASSIGN_UF("Appearance Profile", STRING, TASK(SELECTED).ASSIGNMENT.STRING_PROPERTY("Appearance Profile"))