Delete all ETC in all tasks in order

[matej256]

Hi all,

 

I'd like to ask a question. From our business I've received a request for deletion all ETC(on task level) in order.

It's the biggest order we have and there are cca 9500 resources assigned on tasks so manual deletion would have take a long time....

 

I've find out a query for which ETCs are shown ordered by task:

 

Select pras.prid, Pr.Prname "Resource", Inv.Name "Project_name",

Prt.Prname "Task_name", Round((Pras.Prestsum/28800),2)Etc

 

From prresource pr

Inner Join Prassignment Pras On pr.prid = pras.prresourceid

Inner Join Prtask Prt On Pras.Prtaskid = Prt.Prid

Inner Join Prteam Team On Pras.Team_Id = Team.Prid

Inner Join Inv_Investments Inv On Inv.Id = Team.Prprojectid

 

Where

Inv.Name Like 'Non-charge%'

Group By pras.prid, Pr.Prname, Inv.Name, Prt.Prname, Round((Pras.Prestsum/28800),2)

order by prt.prname

 

Results by SQL:

 

Results in Clarity:

 

I've tried to update one record (resource "Abdelkhalek, Dalia") as you could see - it's 0 value

and I was succesfull. My question is if this is enough to do and quite safe on Clarity level.

It means if e.g. table prj_blb_slices don't influence this deletion or somehow other tables.

 

 

Thanks a lot for your inputs!

 

 

Matej

[Deactivated User]

When you change the ETC in the GUI that will trigger recalculation of of the ETCCURVE slices.

If you do just and and do not change the field that triggers slice update I do not know what is going to happen.

 

If you can open that in OWB and save back into Clarity you just copy paste 0 ETC in a view where you have assingment ETC's displayed.

[matej256]

Hi Urmas, thanks for your response.

Trigger - Yes it is something what I meant...

 

OWB - I'm not aware about using this "feature" so I fear I can't do it in this way... 

 

Any other suggestions/recommendations guys? Many thanks!

 

Matej

[Deactivated User]

Just wondering again...

Would removing the resources from the task (unassigning) or removing the from the project team do what you need to do without doing anything more=

[matej256]

Hi,

 

I assume I can't simple un-assign resources from tasks becasue these tasks are for all our resources -

it means tasks such a Vacation, Meeting, Training and so on. If I would remove all resources,

no one could track time on these tasks...

[Deactivated User]

No luck there then.

[Anon Anon]

I would never dare to change ETC by direct SQL. There are too many internal processes involved in calculating it. My suggestion would be to xog out the project with it's tasks, then set the etc in the xog-xml file to zero and xog the tasks back again.

BUT there is a serious limitation to xog-updating tasks: The Task External ID MUST be filled and unique within the project. Otherwise xog will just add new copies of the tasks.

 

Or there may be a better way: in the project view, under estimation, there is a write enabled field called ETC. If you enter a figure there the value will be spread over all tasks proportionally to the current task ETC. This is a top-down estimation facility. Try to change the top-ETC to zero. It might do the trick.

 

JorgenR

[matej256]

Hi Jorgen,

 

Your last tip seemed to be very helpful, but after I've tried, it wasn't, unfortunately.

 

I set 0 ETC and set apply

Then order locked, but seemed with old ETC:

After unlocked ETC remained the same

 

 

Nevertheless, Thank you too!

[Deactivated User]

Sorry to say I must disagreee

First estimating to double the ETC. The preview displays how they will be.

 

The same thing when the ETC is set to zero.

 

 

Those projects did not have any actual. The next project has actuals

Using Top down estimating and setting ETC to zero did set the ETC to zero for all tasks.

 

Thank you Jørgen for pointing out Estimating.

[matej256]

Hi urmas,

 

Yes, in Friday it was as I described - no change for ETC values.

 

But now, in Monday, all ETC on 0 values, so everything is fine. Maybe Clarity needed some time...

Finally, thank you all for your quick support and tips! 

 

 

Matej