Is there a XOG gel script or DB table that I can update allocation by period in bulk by hours not percentage?
Example: I want to change allocations for the month of April from 130 to 120 hours.
Release : All Supported
Component : CA PPM RESOURCE MANAGEMENT
The one option would be to calculate the percentage value of the hours you want to use, then add that value to the XOG file. The XOG file (prj_projects_alloc_act_etc_read.xml) uses percentages versus hours.
A DB script would not be supported.
While it is not possible via XOG, it is possible through the Modern UI and REST.
Here is an example REST call.
However, it can be done via REST
https://servername/ppm/rest/v1/projects/5225591/teams/5515858
Request Method: PUT
{
"_type": "tsv",
"isFiscal": "false",
"dataType": "numeric",
"workEffortUnit": "hours",
"segmentList": {
"segments": [
{
"start": "2022-06-01T00:00:00",
"finish": "2022-06-30T00:00:00",
"value": "56"
}
]
}
}