Thank you, Zoltan. I have sent a note to my Project Management Office colleagues, asking for their support to do the exporting/importing exercise of resources via Excel.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Fri, 2018-11-30 13:57
Byron as I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with the new settings.
The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Fri, 2018-11-30 13:56
Byron was I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with the new settings.
The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings.
Export all of the resources using the built-in export to XLS, just export all resources assigments. You will need to add "Budgeted Quantity (or "Planned" depending on the industry selected at software installation. Sigh.)
Then in the "Resource Assignments" window delete all resources.
Then import your spreadsheet.
Member for
9 years 7 months
Member for9 years7 months
Submitted by Bryon McConnell on Thu, 2018-11-29 15:47
Zoltan, I have tested one activity, and have found that deleting and then re-adding the resources indeed prevents the auto-compute of actuals. (I wonder if deleting and then re-creating the activities in which I put actual costs will solve the problem of erasure of Actual Materials costs.)
This begs the next question: I am fearful now that there is no good way to delete and then re-create the resources en masse. This particular project has 1204 resource assignments across 374 activities. Am I doomed to hours and hours of manual electronic labour?
Member for
9 years 7 months
Member for9 years7 months
Submitted by Bryon McConnell on Thu, 2018-11-29 15:41
also in the activity directory under the resources tab right click and add a column for auto comout actuals and make sure that the box is unchecked.
basically the rules that were in effect when you assigned the resource remain in effect. The other option is if you are sure that you have changed all of the settings is to delete the resource and add it again with the new settgin in effect.
I have had a client who did exactly your process for internal/external costing with projects of 10k+ activities with external timesheet system actual manhours unaffected.
If you XER a project that exhibits the bad behavoir into a fresh database, does that change things?
Member for
16 years 3 monthsthat should work
that should work
Member for
9 years 7 monthsThank you, Zoltan. I have
Thank you, Zoltan. I have sent a note to my Project Management Office colleagues, asking for their support to do the exporting/importing exercise of resources via Excel.
Member for
16 years 3 monthsByron as I mentoned the
Byron as I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with the new settings.
The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings.
Member for
16 years 3 monthsByron was I mentoned the
Byron was I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with the new settings.
The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings.
Member for
21 yearsBryon,Export all of the
Bryon,
Export all of the resources using the built-in export to XLS, just export all resources assigments. You will need to add "Budgeted Quantity (or "Planned" depending on the industry selected at software installation. Sigh.)
Then in the "Resource Assignments" window delete all resources.
Then import your spreadsheet.
Member for
9 years 7 monthsZoltan, I have tested one
Zoltan, I have tested one activity, and have found that deleting and then re-adding the resources indeed prevents the auto-compute of actuals. (I wonder if deleting and then re-creating the activities in which I put actual costs will solve the problem of erasure of Actual Materials costs.)
This begs the next question: I am fearful now that there is no good way to delete and then re-create the resources en masse. This particular project has 1204 resource assignments across 374 activities. Am I doomed to hours and hours of manual electronic labour?
Member for
9 years 7 monthsDavid, I'll ask our Project
David, I'll ask our Project Management Office if we can try out the idea of pushing the file to a fresh database.
Member for
16 years 3 monthsalso in the activity
also in the activity directory under the resources tab right click and add a column for auto comout actuals and make sure that the box is unchecked.
basically the rules that were in effect when you assigned the resource remain in effect. The other option is if you are sure that you have changed all of the settings is to delete the resource and add it again with the new settgin in effect.
Member for
21 yearsBryon,I can't replicate
Bryon,
I can't replicate this.
I have had a client who did exactly your process for internal/external costing with projects of 10k+ activities with external timesheet system actual manhours unaffected.
If you XER a project that exhibits the bad behavoir into a fresh database, does that change things?