ispa-consulting

using XML to import a time-varying field

Discussion created by ispa-consulting on May 26, 2008
Hello all,
I have created a time varying field on the resource object and i try now to use XML to update/populate this field with this XML file:


http://www.w3.org/2001/XMLSchema-instance " xsi:noNamespaceSchemaLocation="../xsd/nikuxog_resource.xsd">



externalId=" " resourceId="400007" resourceType="LABOR">





start="2008-04-29T00:00:00" type="value" unitConversion="hour">
isDefaultSegment="false" start="2008-04-29T00:00:00" value="20"/>






I'm under Clarity 8.1 FP03 (8.1.0.03.4373 )
When I execute the XOG, i have no error message but in fact noting happens: the period is created but nothing in the value field; worse, if the data exists before, the XML deletes the contains of the value field!
>>>It works if  you multiply the value by 3600.
Now the question is how this field is stored in the database?
Thx
  Message Edited by ispa-xonsulting on 05-27-2008 07:46 AM Message Edited by ispa-xonsulting on 05-28-2008 09:24 AM

Message Edited by ispa-xonsulting on 05-28-2008 09:25 AM

Outcomes