Is it possible to batch process projects to update the status to approved?

Document ID : KB000097791
Last Modified Date : 11/06/2018
Show Technical Document Details
Question:
Is it possible to batch process closed projects to update the status to "approved"?
Environment:
PPM 15.1 and above - ALL VERSIONS
Answer:
The only way to "batch update" projects would be to XOG those projects out which have an "unapproved" status, and update the status, then XOG those projects back into PPM.  Unfortunately, there is no automated process or job available to do this in a batch fashion.

To do this using XOG, first, XOG out the project(s) which you want to update the status to "approved".  Then located the following line for each project:

<Project active="true" allowAssignedTasksOnly="0" approved="false" approvedForBilling="1" assgnPool="1" billingCurrencyCode="USD" billingType="S"
  budgetBreakEven="2018-04-01T00:00:00" budgetCostCapitalTotal="167200" budgetCostFinish="2018-07-01T00:00:00" budgetCostOperatingTotal="97200"
  budgetCostStart="2018-03-01T00:00:00" budgetNPV="635600" budgetPaybackPeriod="1" budgetROI="2.403933" budgetRevFinish="2018-07-01T00:00:00"
  budgetRevStart="2018-03-01T00:00:00" budgetRevTotal="900000" calculateFinancialMetrics="true" chargeCodeExtID="Management" closed="false"
  costType="OPERATING" currencyISOcode="USD"
  description="Surveillance and monitoring improvements to enhance fraud and security measures on the online system." entityCode="Corporate"
  equipmentCostSource="Financial Cost and Rate Matrix" equipmentExchageRateType="AVERAGE" equipmentRateSource="Financial Cost and Rate Matrix"
  evCalcMethod="0" evPeriodDefCode="MONTHLY" expenseCostSource="Financial Cost and Rate Matrix" expenseExchageRateType="AVERAGE"
  expenseRateSource="Financial Cost and Rate Matrix" financialProjectClass="INTERNAL" financialStatus="O" financialWipClass="CLASS1"
  finish="2018-06-16T17:00:00" flexibilityRisk="50" format="11" fundingRisk="50" goalCode="GROW_BUSINESS" humanInterfaceRisk="0"
  implementationRisk="0" initialInvestment="0" interdependenciesRisk="50" investmentDefinedReinvestmentRate="0"
  investmentDefinedTotalCostOfCapital="0" laborCostSource="Financial Cost and Rate Matrix" laborExchageRateType="AVERAGE"
  laborRateSource="Financial Cost and Rate Matrix" lastUpdatedBy="csk.admin" lastUpdatedDate="2018-02-23T12:47:31" managerResourceID="paulBerks"
  materialCostSource="Financial Cost and Rate Matrix" materialExchageRateType="AVERAGE" materialRateSource="Financial Cost and Rate Matrix"
  name="Automated Security Enhancements" objectivesRisk="0" openForTimeEntry="true" organizationalCultureRisk="50"
  pageLayoutCode="dashboardProjectStatusFrame" percentCalcMode="0" percentComplete="0" plannedBenFinish="2018-07-01T00:00:00"
  plannedBenStart="2018-03-01T00:00:00" plannedBenTotal="900000" plannedBreakEven="2018-04-01T00:00:00" plannedCostCapitalTotal="167200"
  plannedCostFinish="2018-07-01T00:00:00" plannedCostOperatingTotal="97200" plannedCostStart="2018-03-01T00:00:00" plannedNPV="635600"
  plannedPaybackPeriod="1" plannedROI="2.403933" priority="18" processCode="IT" progress="0" projectID="PR1016" requiredForScenarios="false"
  resourceAvailabilityRisk="50" setBudgetValuesEqualToPlannedValues="false" sponsorshipRisk="0" stageCode="CSK_INITIATION" start="2018-03-01T08:00:00"
  status="0" statusIndicator="1" supportabilityRisk="50" syncInvestmentAndBudgetDates="false" technicalRisk="0" template="false" trackMode="2"
  useSystemDefinedReinvestmentRate="true" useSystemDefinedTotalCostOfCapital="true">

Note the attribute:  status="0"

Update the attribute to:  status="1"

Save the XML file, and then XOG it back in.

The project will now have a status of "Approved"