Rajani

GEL XOG-out update info and XOG in

Discussion created by Rajani on Oct 12, 2010
Latest reply on Jan 19, 2011 by SankhadeepDhar
Hi,

Requirement - When an idea is converted to project, the OBS needs to be tranferred from the idea to project. This is not automatically happening in our environment.

Approach - A process on project create (when it has originating idea field not null) invokes GEL script. In the GEL Script, I am getting the idea OBS and XOG out the project and update OBS info and XOG in.

I am interested in the highlighted parts only from the xml below. I am good with the OBS part.
How can I read the Project element without including sub-elements like Custom Information etc.

I tried the following but it gives me the whole project element <project ... to </project>

<gel:set asString="false" select="$prjresult/SOAP-ENV:Envelope/SOAP-ENV:Body/NikuDataBus/Projects/Project" var="prjtag"/>

Please let me know your suggestions.

Thank you,
Rajani
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="12.0.6.5471"/>
<Projects>
[color=#AAA8BD]<Project active="true" approved="false" approvedForBilling="1"
billExpenses="1" billingCurrencyCode="USD" billingType="S"
calculatePresentValueInfo="true" chargeCodeExtID="WT OPEX"
closed="false" currencyISOcode="USD" entityCode="MTS"
equipmentExchageRateType="AVERAGE"
expenseExchageRateType="AVERAGE" financialStatus="O"
finish="2010-06-30T17:00:00" forecastEqualsBudget="false"
format="11" laborExchageRateType="AVERAGE"
lastUpdatedBy="eb4jqp4"
lastUpdatedDate="2010-09-09T14:03:15"
managerResourceID="eut6tl5"
materialExchageRateType="AVERAGE" name="ACH Setup"
openForTimeEntry="true"
pageLayoutCode="dashboardProjectStoryboard"
percentCalcMode="0" percentComplete="0"
plannedCostFinish="2011-04-01T00:00:00"
plannedCostStart="2009-04-01T00:00:00"
plannedCostTotal="58368" plannedNPV="-58368" plannedROI="0"
priority="10" program="false" progress="1"
projectID="PR10703" requiredForScenarios="false"
start="2009-12-31T08:00:00" status="0"
syncInvestmentAndBudgetDates="true" template="false" trackMode="2">[color]
<Allocations/>
<scenarioDependencies/>
<InvestmentAssociations>
<Allocations/>
<Hierarchies/>
</InvestmentAssociations>
<CustomInformation>
<ColumnValue name="partition_code">Partition14</ColumnValue>
<ColumnValue name="obj_objective">Allow ability for customer to provide bank account number and Med Surg to pay invoices for customer by withdrawing funds</ColumnValue>
<ColumnValue name="mck_capapp">false</ColumnValue>
<ColumnValue name="mck_doc_loc">http://</ColumnValue>
<ColumnValue name="mck_saphrs">false</ColumnValue>
<ColumnValue name="cap_app_request">false</ColumnValue>
<ColumnValue name="sap_hrs_request">false</ColumnValue>
<ColumnValue name="fm_exists">false</ColumnValue>
<ColumnValue name="mts_sharepoint">http://</ColumnValue>
<ColumnValue name="mck_aprcap_currency">USD</ColumnValue>
<ColumnValue name="mck_adjcap_currency">USD</ColumnValue>
<ColumnValue name="mck_prod_name2">N/A</ColumnValue>
<ColumnValue name="mck_prod_rev2">N/A</ColumnValue>
<ColumnValue name="mck_rel_mat_name">N/A</ColumnValue>
<ColumnValue name="mck_skip_fin_app">false</ColumnValue>
</CustomInformation>
<General addedBy="eb4jqp4" addedDate="2010-04-28"/>
[color=#AAA8BD] <OBSAssocs completed="false">
<OBSAssoc id="MTS_Departments"
name="McKesson Corporation" unitPath="/Distribution Solutions/Med Surg/MMS Finance/MMS Accounts Receivable"/>
</OBSAssocs>[color]
<BurdeningAssocs>
<BurdeningAssoc transactionType="Labor"/>
<BurdeningAssoc transactionType="Material"/>
<BurdeningAssoc transactionType="Expenses"/>
<BurdeningAssoc transactionType="Equipment"/>
</BurdeningAssocs>
</Project>
</Projects>
<XOGOutput>
<Object type="project"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>

Outcomes