AnsweredAssumed Answered

export many data in one time related to many projects

Question asked by slima24 on Sep 4, 2013
i had successfully the output for one project using this gel script, but i have the out put just FOR ONE PROJECT , and i wanna have the out put for many projects at the same time can you please help me to find the solution


<gel:script xmlns:x="jelly:xml"

xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"

xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"

xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:xog="https://empower.capgemini.com/niku/xog">


<gel:parameter var="XOGusername" default="aelabida"/>

<gel:parameter var="XOGpassword" default="password"/>


<soap:invoke endpoint="http://claritypreprod.capgemini.com/niku/xog" var="result">



<soap:message>



<soap-env:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"






xmlns:xog="http://www.niku.com/xog">




<soap-env:Body>





<xog:Login xmlns="http://www.niku.com/xog">






<xog:Username>${XOGusername}</xog:Username>






<xog:Password>${XOGpassword}</xog:Password>





</xog:Login>








<NikuDataBus xmlns:xsi="_http://www.w3.org/2001/XMLSchema-instance" >
<Header version="6.0.11" action="read" objectType="project" externalSource="NIKU">
<!-- you change the order by simply swap 1 and 2 number in the name attribute -->
<args name="order_by_1" value="name"/>
<args name="order_by_2" value="projectID"/>
<args name="include_tasks" value="true"/>
<args name="include_dependencies" value="true"/>
<args name="include_subprojects" value="true"/>
<args name="include_resources" value="true"/>
<args name="include_baselines" value="true"/>
<args name="include_allocations" value="true"/>
<args name="include_estimates" value="true"/>
<args name="include_actuals" value="true"/>
<args name="include_custom" value="true"/>
</Header>
<Query>


<Filter name="projectID" criteria="EQUALS">FR-FR-100099134</Filter>
</Query>
</NikuDataBus>









</soap-env:Body>



</soap-env:Envelope>


</soap:message>

</soap:invoke>


<gel:out><gel:expr select="$result"/></gel:out>


<gel:serialize fileName="result1.xml" var="${result}"/>
</gel:script>

Outcomes