Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

using XML to import a time-varying field

  • 1.  using XML to import a time-varying field

    Posted May 26, 2008 07:53 AM
    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