Clarity

Expand all | Collapse all

How to make the Allocation and ETC zeroes?

  • 1.  How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:04 AM
      |   view attached
    Hi Friends,

    I need to make the allocation and ETC of all the resources in a long list of Projects Null or Zeroes. I used [color=#f90202]prj_projects_alloc_act_etc_read.xml[color] file to xog in the ZERO % allocation but how can i do the same for the ETCs?

    Please see the attached screenshot.

    Thanks in advance,
    Georgy


  • 2.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:13 AM
    Why did you not use prj_projects_alloc_act_etc_read.xml to write zero ETC?

    Martti K.


  • 3.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:24 AM
    HI Marti,

    These are the tags i get for a resource in the particular xog file:

    <Resource availFrom="2011-03-07T08:00:00" availTo="2011-03-08T00:00:00" bookingStatus="15" defaultAllocation="0" isProjectManager="false"
    lastUpdatedBy="admin" lastUpdatedDate="2012-06-19T12:58:34" openForTimeEntry="true" projectRoleID="Process Developer" resourceID="xx37096">
    <AllocCurve/>
    <HardAllocCurve>
    <segment finish="2011-03-08T00:00:00" rate="0.0000" start="2011-03-07T08:00:00"/>
    </HardAllocCurve>
    <CustomInformation>
    <ColumnValue name="partition_code">xxxx</ColumnValue>
    </CustomInformation>
    <SkillAssocs/>
    </Resource>

    I used the defaultAllocation to make the allocation ZERO. Couldnt find anything on ETC here.

    Thanks,
    Georgy


  • 4.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:38 AM
    The ETC for a resource is held against the individual assignments (feasibly many many in a project for a single resource), so you'd have to be writing back to Clarity the all assignment details - the XML you have posted is just the allocation details.

    ...might just be easier to open the plan in OWB, create a view showing you the assignment ETCs and then paste in a load of zeros....


  • 5.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:41 AM
    Hi Dave,

    Thanks a lot...But i have to do this on 1000s of projects. So cant open the plans manually in OWB :sad

    Thats why i was thinking on the xog method.

    Thanks,
    Georgy


  • 6.  RE: How to make the Allocation and ETC zeroes?
    Best Answer

    Posted Jun 19, 2012 07:45 AM
    If you have
    <args name="include_estimates" value="true"/>

    you are expected to get also something like

    <Tasks><Task finish="2004-10-29T17:00:00" internalTaskID="5017721" key="false" lastUpdatedBy="sbutler" lastUpdatedDate="2004-11-10T18:01:12" milestone="false" name="Effort" orderID="1" outlineLevel="1" percComp="0" start="2004-10-04T08:00:00" status="1" summary="false" taskID="~rmw">

    <Assignments><TaskLabor actualWork="0" baselineWork="0" estPattern="3" finish="2004-10-29T17:00:00" lastUpdatedBy="sbutler" lastUpdatedDate="2004-11-10T17:42:38" remainingWork="2.777778" resourceID="PRJ_COVRG_Bricks" start="2004-10-04T08:00:00" unpostedActuals="0.138889">

    <EstCurve><Segment finish="2004-10-30T00:00:00" start="2004-10-04T00:00:00" sum="10000.0"/></EstCurve>

    <ActCurve/>

    </TaskLabor>

    Which does not reduce your pain.

    Martti K.


  • 7.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 07:59 AM
    Well then its XOG and as I said you need to be loading the assignment details ; you have started with a file that contains the assignment details but you seem to have removed that from your XML you posted above????

    Look at the <Assignments> section in that prj_projects_alloc_act_etc_write.xml example (like Martti suggests!) - "remainingWork" looks interesting to me.


  • 8.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 08:17 AM
    That might be related to the fact that in Clarity task ETC is editable opposed to OWB where it is not.
    That is in Task list if you have ETC displayed and you go edit mode you can set the ETC to zero in those hundreds of task in those thousands of projects.
    I should assume that the assigment ETC's will be zero after that as well.


    Martti K.


  • 9.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 08:32 AM
    Then again if you are happy setting the task ETC to zero you can create a portlet based on the task object.
    Because that is a system data provider you can enter to edit mode and if you increase the number of rows in the portlet to 50 you set manually the ETC to 50 at a time in the GUI.
    For me that certainly would beat manually editing the xml files.


    Martti K.


  • 10.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 08:43 AM
    @ Dave,

    Yes Dave....I checked up the Assignments section and found this:

    <Assignments>
    <TaskLabor actualWork="0" baselineWork="0" estPattern="3" finish="2011-03-07T17:00:00"
    lastUpdatedBy="admin" lastUpdatedDate="2012-01-12T19:57:06"
    remainingWork="0" resourceID="xx44945" roleID="Project Manager"
    start="2011-03-07T08:00:00" unpostedActuals="0">
    <CustomInformation>
    <ColumnValue name="partition_code">xxxx</ColumnValue>
    </CustomInformation>
    </TaskLabor>

    As you said, yes, the remainingWork had the ETCs from the Assignments subtab in a project....tried xogging in with ZERO values in remainingWork...but its not updating the ETCs to zero.


    @ Marti,

    Ya, now i am gonna try the portlet way...will keep you posted.

    Thanks all,
    Georgy


  • 11.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 09:57 AM
    Hi Marti,

    Yes....We made the portlet and its working fine...we can Zero the ETCs using the Edit Mode of the '50 row' Task Portlet and that is inturn making all the assignments ETCs to zeroes.

    Have to do this on 2000+ old projects whose finish date is already past. Hmmm...guess this will take some time:sad but it works! :happy

    Thanks a lot Dave and Marti,
    Georgy


  • 12.  RE: How to make the Allocation and ETC zeroes?

    Posted Jun 19, 2012 12:23 PM
    Youi've got to do what you've got to do. :grin:


    Martti K.