Unable to update Project manager Field in Project and Resource Manager field in Resource through XOG.
All other attributes in the both the attributes are getting updated by XOG in version 14.3 Patch 9
Hope you did check the database column with help of a query -
select manager_id from inv_investments where code='FCPA1201935'
Would like to rule out the scenario that the project manager field name configured on the ppm screen isn't another custom field. Since the output does not have any error/warning the update to the manager field should have been done
How about sharing your code that you are trying?
For Project Manger field on PROJECT it is managerResourceID:
<Project name="XXXName" projectID="XXXCode" description="XXXDescription" managerResourceID="admin"
Try XOG'ing out an existing project using prj_projects_read.xml so that you can see real data from your environment and how you have set up your Resources to use the correct Resource ID.
Similar would apply for Resource Manager on Resource, use the rsm_resources_read or have a look at rsm_resources_write as examples.
Hi Supratik. Can you tell us the error that you're getting? If it's a "Lookup Value is Invalid" error - please check the Resource permissions on your xog user's account.
Actually its updating all the other fields including the OOTB fields but only the manager id is not getting updated.
But all other fields updated only leaving behind the ManagerID.
Offshore CA Clarity Team Lead – Telia Company,
CA Certified Technical Professional
Accenture Delivery Centre
Hi Supratik, Can you share the XOG xml you are using to update the fields? Will make it easier to figure out the issue.
And I am having all the access rights granted through group.
Since the XOG is updating all the other OOTB fields, sharing the input xml will help in further understanding of whats going on.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="188.8.131.528"/>
name="Test Project for Xog" projectID="FCPA1201935" managerResourceID="scl303" description="Common template for Prospect creation. Replace with project description">
Output I am getting is
<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Status elapsedTime="1.245 seconds" state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="1"/>
Is resource id 'scl303' present in system ?
...would expect that if the managerResourceID is not recognised then you would (should!) get a WARNING message in the response XML.
Definitely worth checking the ID though. (noting that it is the resource id that should be used, not the user id of course).
.. and active
Assuming that it is OOTB Manager field, are you able to update the same Manager from Clarity UI for that project(when logged in with the same XOG user account)? If so, once updated, you may XOG out the project and observe the attribute value to analyze further.
As others have mentioned, I would suggest XOGing OUT the project and verifying whether the manager matches what you see in Clarity or what you have XOGed in. You may be seeing custom field in the UI with a different ID than what you are trying to XOG in
Retrieving data ...