donkoller1319120

XOG to add new year chargeback Allocations records

Discussion created by donkoller1319120 on Mar 27, 2012
Latest reply on Apr 4, 2012 by Chris_Hackett
Hi,

I have created a XML for chargeback allocations from an Excel spreadsheet to added new year records. I used the glallocation.xsd for the XML format. The problem I have encountered is the XOG removes all existing percentages for the project and allocation code combination. I would appreciate your guidance. I am including the XML I have used to create the records.

<?xml version="1.0" encoding="UTF-8" ?>
- <!-- Chargeback Write XML for Clarity XOG Client - Created by Don Koller on 03/27/12
-->
- <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_glallocation.xsd">
<Header action="write" externalSource="NIKU" objectType="glallocation" version="12.0.5.5350" />
- <Allocations>
- <Allocation allocationCode="DEBIT00008" cbkSubtype="INVESTMENT" cbkType="DEBIT" chgRemtoOverhead="0" entityCode="LOL" investmentCode="PRJ-3360" pageLayoutCode="revmgr.invallocFrame" statusCode="ACTIVE">
- <Details>
- <Detail department="5300500.84840.110" glAccountMain="5300500" glAccountSub="84840.105">
- <percentage default="0.0" entityCode="LOL" finish="2013-12-31T00:00:00" fiscalPeriodType="ANNUALLY" isFiscal="true" start="2008-01-01T00:00:00" type="percentage">
<segment finish="2012-12-31T00:00:00" isDefaultSegment="false" rate="0.17" start="2012-01-01T00:00:00" />
</percentage>
- <CustomInformation>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
</CustomInformation>
</Detail>
- <Detail department="5300500.84840.110" glAccountMain="5300500" glAccountSub="84840.105">
- <percentage default="0.0" entityCode="LOL" finish="2013-12-31T00:00:00" fiscalPeriodType="ANNUALLY" isFiscal="true" start="2008-01-01T00:00:00" type="percentage">
<segment finish="2013-12-31T00:00:00" isDefaultSegment="false" rate="0.15" start="2013-01-01T00:00:00" />
</percentage>
- <CustomInformation>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
</CustomInformation>
</Detail>
- <Detail department="3300137.84840.110" glAccountMain="3300137" glAccountSub="84840.105">
- <percentage default="0.0" entityCode="LOL" finish="2013-12-31T00:00:00" isFiscal="false" start="2008-01-01T00:00:00" type="percentage">
<segment finish="2013-12-31T00:00:00" isDefaultSegment="false" rate="0.33" start="2013-01-01T00:00:00" />
</percentage>
- <CustomInformation>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
</CustomInformation>
</Detail>
</Details>
</Allocation>
- <Allocation allocationCode="overhead-LOL" cbkSubtype="OVERHEAD" cbkType="DEBIT" chgRemtoOverhead="1" entityCode="LOL" investmentCode="" pageLayoutCode="revmgr.invallocFrame" statusCode="ACTIVE">
- <Details>
- <Detail department="LOL" glAccountMain="9999999" glAccountSub="84840.105">
- <percentage default="0.0" entityCode="LOL" finish="2013-12-31T00:00:00" fiscalPeriodType="ANNUALLY" isFiscal="true" start="2013-01-01T00:00:00" type="percentage">
<segment finish="2013-12-31T00:00:00" isDefaultSegment="false" rate="1.0" start="2013-01-01T00:00:00" />
</percentage>
- <CustomInformation>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
</CustomInformation>
</Detail>
</Details>
</Allocation>
- <Allocation allocationCode="DEBIT00071" cbkSubtype="INVESTMENT" cbkType="DEBIT" chgRemtoOverhead="0" entityCode="LOL" investmentCode="PRJ-3587" pageLayoutCode="revmgr.invallocFrame" statusCode="ACTIVE">
- <Details>
- <Detail department="2300500.84840.110" glAccountMain="2300500" glAccountSub="84840.105">
- <percentage default="0.0" entityCode="LOL" finish="2013-12-31T00:00:00" isFiscal="true" start="2013-01-01T00:00:00" type="percentage">
<segment finish="2013-12-31T00:00:00" isDefaultSegment="false" rate="1.0" start="2013-01-01T00:00:00" />
</percentage>
- <CustomInformation>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
</CustomInformation>
</Detail>
</Details>
</Allocation>
</Allocations>
</NikuDataBus>

Thanks for your help.

Outcomes