AnsweredAssumed Answered

Create a project using XOG

Question asked by PragyaT on Jul 3, 2013
Latest reply on Jul 4, 2013 by another_martink
HI All,

I am trying to create a project using XOG Script.

Project id attribute is auto incremented. So initially i didnot keep that parameter in XOG. See the below XOG Script. but it gave me error as: 'element "Project" is missing "projectID" attribute'

<?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.1.3.1361"/>
<Projects>
<Project name="TestP" status="0" progress="0" start="2013-07-03T08:00:00" finish="2013-12-31T08:00:00" financialStatus="H" billingType="S" billingCurrencyCode="USD"
laborExchageRateType="AVERAGE" materialExchageRateType="AVERAGE" equipmentExchageRateType="AVERAGE" expenseExchageRateType="AVERAGE" percentComplete="0" active="true"
managerResourceID="mlucas" description="N/A" trackMode="2" format="11" >
<CustomInformation>
<ColumnValue name="project_ident">DISC</ColumnValue>
<ColumnValue name="intake_date">2013-07-03</ColumnValue>
<ColumnValue name="ecl_status">9</ColumnValue>
<ColumnValue name="ecl_requestor">Lucas_Maureen</ColumnValue>
<ColumnValue name="client_sp">Abberton_Jim</ColumnValue>
<ColumnValue name="sponsor_ocio">6</ColumnValue>
<ColumnValue name="ns_srvc_line">architecture</ColumnValue>
<ColumnValue name="ns_icd10_app">true</ColumnValue>
<ColumnValue name="ns_priority">5</ColumnValue>
<ColumnValue name="ns_icd10_criticality">low</ColumnValue>
<ColumnValue name="ns_icd10_survey_comp">unknown</ColumnValue>
<ColumnValue name="ns_icd10_compliant">unknown</ColumnValue>
<ColumnValue name="ns_icd10_upgrade_req">unknown</ColumnValue>
<ColumnValue name="ns_icd10_ga_date">2013-07-01T00:00:00</ColumnValue>
<ColumnValue name="ns_icd10_cur_ver">1</ColumnValue>
<ColumnValue name="ns_icd10_comp_ver">2</ColumnValue>
<ColumnValue name="ns_icd10_comments">icd 10 comments</ColumnValue>
<ColumnValue name="ns_icd10_decisions">icd 10 decisions</ColumnValue>
<ColumnValue name="allsc_proj_srvcln">icd10</ColumnValue>
<ColumnValue name="ecl_portfolio">seal</ColumnValue>
<ColumnValue name="ns_application">
<Value>3M_HDM</Value>
<Value>4D_EP</Value>
<Value>N_A</Value>
</ColumnValue>
<ColumnValue name="ns_facility">
<Value>CCMC</Value>
<Value>EHIT</Value>
</ColumnValue>
<ColumnValue name="ns_portfolios">
<Value>AEHR</Value>
<Value>Physician_Practice</Value>
</ColumnValue>
</CustomInformation>
</Project>
</Projects>
<XOGOutput>
<Object type="project"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>




After that i tried with project id attribute as below: but now it gives me error as 'unexpected attribute "projectid"'


<?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.1.3.1361"/>
<Projects>
<Project projectid="123456" name="TestP" status="0" progress="0" start="2013-07-03T08:00:00" finish="2013-12-31T08:00:00" financialStatus="H" billingType="S" billingCurrencyCode="USD"
laborExchageRateType="AVERAGE" materialExchageRateType="AVERAGE" equipmentExchageRateType="AVERAGE" expenseExchageRateType="AVERAGE" percentComplete="0" active="true"
managerResourceID="mlucas" description="N/A" trackMode="2" format="11" >
<CustomInformation>
<ColumnValue name="project_ident">DISC</ColumnValue>
<ColumnValue name="intake_date">2013-07-03</ColumnValue>
<ColumnValue name="ecl_status">9</ColumnValue>
<ColumnValue name="ecl_requestor">Lucas_Maureen</ColumnValue>
<ColumnValue name="client_sp">Abberton_Jim</ColumnValue>
<ColumnValue name="sponsor_ocio">6</ColumnValue>
<ColumnValue name="ns_srvc_line">architecture</ColumnValue>
<ColumnValue name="ns_icd10_app">true</ColumnValue>
<ColumnValue name="ns_priority">5</ColumnValue>
<ColumnValue name="ns_icd10_criticality">low</ColumnValue>
<ColumnValue name="ns_icd10_survey_comp">unknown</ColumnValue>
<ColumnValue name="ns_icd10_compliant">unknown</ColumnValue>
<ColumnValue name="ns_icd10_upgrade_req">unknown</ColumnValue>
<ColumnValue name="ns_icd10_ga_date">2013-07-01T00:00:00</ColumnValue>
<ColumnValue name="ns_icd10_cur_ver">1</ColumnValue>
<ColumnValue name="ns_icd10_comp_ver">2</ColumnValue>
<ColumnValue name="ns_icd10_comments">icd 10 comments</ColumnValue>
<ColumnValue name="ns_icd10_decisions">icd 10 decisions</ColumnValue>
<ColumnValue name="allsc_proj_srvcln">icd10</ColumnValue>
<ColumnValue name="ecl_portfolio">seal</ColumnValue>
<ColumnValue name="ns_application">
<Value>3M_HDM</Value>
<Value>4D_EP</Value>
<Value>N_A</Value>
</ColumnValue>
<ColumnValue name="ns_facility">
<Value>CCMC</Value>
<Value>EHIT</Value>
</ColumnValue>
<ColumnValue name="ns_portfolios">
<Value>AEHR</Value>
<Value>Physician_Practice</Value>
</ColumnValue>
</CustomInformation>
</Project>
</Projects>
<XOGOutput>
<Object type="project"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>


Can any one help me to sort this out? how i can create a project using XOG?

Outcomes