Hi,
I am receiving a flat file with 6 rows.
Location, product, Movement Type, Date, Pieces,Cases
This is to be mapped to a standard proxy structure (ProductActivityNotification) such that
ProductActivity
--->Item (0..unbounded)
-
>Product
-
>Location
-
>SalesTimeSeries (0..1)
-
>Item (0..unbounded)
-
>ValidityPeriod (0..1)
-
>StartDateTime (0..1)
-
>EndDateTime (0..1)
-
>Quantity (0..1)
-
>ConsumptionTimeSeries (0..1)
-
>Item (0..unbounded)
-
>ValidityPeriod (0..1)
-
>StartDateTime (0..1)
-
>EndDateTime (0..1)
-
>Quantity (0..1)
-
>OnOrderTimeSeries (0..1)
-
>Item (0..unbounded)
-
>ValidityPeriod (0..1)
-
>StartDateTime (0..1)
-
>EndDateTime (0..1)
-
>Quantity (0..1)
Now the mapping conditions are:
Only one item (at the header level) is to be created for unique pair of Location, product and date.
Now if the Movement type is 03 then SalesTimeSeries is to be created, for 99 ConsumptionTimeSerries, 04 OnOrderTimeSeries
If the input is such that
A,B,0320081201,10,10
A,B,0320081202,19,10
A,B,0320081203,15,10
A,B,0420081201,10,10
here movement type precedes date.
Then output should be
<ProductActivity>
<item>
<location>A</location>
<product>B</product>
<SalesTimeSeries>
<item>
<ValidityPeriod>
<StartTime>20081201</StartTime>
<EndTime>20081201</EndTime>
</ValidityPeriod>
<Quantity>100</Quantity>
</item>
<item>
<ValidityPeriod>
<StartTime>20081202</StartTime>
<EndTime>20081202</EndTime>
</ValidityPeriod>
<Quantity>190</Quantity>
</item>
<item>
<ValidityPeriod>
<StartTime>20081203</StartTime>
<EndTime>20081203</EndTime>
</ValidityPeriod>
<Quantity>150</Quantity>
</item>
</SalesTimeSeries>
<ConsumptionTimeSeries>
<item>
<ValidityPeriod>
<StartTime>20081201</StartTime>
<EndTime>20081201</EndTime>
</ValidityPeriod>
<Quantity>100</Quantity>
</item>
</ConsumptionTimeSeries>
</item>
</ProductActivity>
Any idea how to go about this mapping?
Some mapping screen shots
regards,
Anirudh.
Edited by: Anirudh Vyas on Dec 2, 2008 12:03 PM