AnsweredAssumed Answered

Transactions write_How to find the Task id

Question asked by himani.sharma on Mar 15, 2011
Latest reply on May 16, 2011 by vitor.sakaguti
Hi
I have an assignment where i have to insert transaction from an external system into clarity.I am going to use a staging table(create an object in clarity and use the table as the staging table) and write a gel script to read data from the table.The customer is using SQL system as a database.
I have thought of creating the gel script based on imp_transactions_write.xml file.
I checked the imp_transcations_read.xml
Xogged out a project

<?xml version="1.0" encoding="UTF-8" ?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="6.0.11" action="read" objectType="outboundTransaction" externalSource="NIKU" />
<Query>
<Filter name="projectID" criteria="EQUALS">PMO-00000103</Filter>
</Query>
</NikuDataBus>

Got the write:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_outboundTransaction.xsd">
<Header action="write" externalSource="NIKU"
objectType="outboundTransaction" version="12.0.6.5471"/>

<Transactions>
<Transaction chargeCode="Opex" chargeable="0"
inputTypeCode="standard" projectID="PMO-00000103"
projectName="pso-test 150910-3" resourceID="ST7740"
resourceName="Solvang, Smith" roleID="Advisor"
taskID="5001454" taskName="Project Management Plan"
transactionDate="2010-12-06" transactionID="5000080"
transactionType="L" units="4">
<CurrencyValue actualCostRate="1148"
actualCostRateCurrency="NOK" amountRemaining="0"
billRate="1148" billRateCurrency="NOK"
currencyType="NATURAL" standardCostRate="1148"
standardCostRateCurrency="NOK" totalAmount="4592" totalCost="4592"/>
<CurrencyValue actualCostRate="1148"
actualCostRateCurrency="NOK" amountRemaining="0"
billRate="1148" billRateCurrency="NOK"
currencyType="BILLING" standardCostRate="1148"
standardCostRateCurrency="NOK" totalAmount="4592" totalCost="4592"/>
<CurrencyValue actualCostRate="1148"
actualCostRateCurrency="NOK" amountRemaining="0"
billRate="1148" billRateCurrency="NOK"
currencyType="HOME" standardCostRate="1148"
standardCostRateCurrency="NOK" totalAmount="4592" totalCost="4592"/>
</Transaction>


</Transactions>
<XOGOutput>
<Object type="outboundTransaction"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="38" updatedRecords="0"/>
<Records/>
<DeprecationInformation>
<Severity>WARNING</Severity>
<Description>DEPRECATION MESSAGE</Description>
<Exception type="java.lang.Exception">The objectType 'outboundTransaction' has been deprecated. Please use the objectType

'transaction' instead.</Exception>
</DeprecationInformation>
</XOGOutput>
</NikuDataBus>


Here i see the taskID.How do i find the task ID.

The Client(customer) wants to use ProjectID as the key to transfer transactions.Is that enough.Dont i need the task Id too.
And is this a good approach.

Any suggestion


Regards
Himani

Outcomes