Clarity

  • Private Community
 View Only

  • 1.  How can I import attachment to custom attribute on custom object

    Posted Aug 11, 2015 04:04 AM

    Hello,

     

    our customer would like to import a lot of documents to custom attributes in Clarity. I tried some XOG write files, but without any success.

     

    Here is what I tried:

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
  <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="14.2.0.237"/>
  <customObjectInstances objectCode="min_res_activity">
    <instance instanceCode="00000039" objectCode="my_custom_object" parentInstanceCode="prj_report" parentObjectCode="project">
      <CustomInformation>
        <ColumnValue name="name">Task 2.3</ColumnValue>
        <ColumnValue name="code">00000039</ColumnValue>
        <ColumnValue name="odf_parent_id">5003000</ColumnValue>
        <ColumnValue name="odf_cncrt_parent_id">5003000</ColumnValue>
        <ColumnValue name="c_ra_deliv_attch_9">
          <Documents>
            <Parent documentLocation="/opt/ppm/logs/files/Files/013/005">
              <Document name="test_1.docx">
                <Version id="1" versionNumber="1"/>
              </Document>
            </Parent>
          </Documents>
        </ColumnValue>
      </CustomInformation>
    </instance>
  </customObjectInstances>
  <XOGOutput>
    <Object type="customObjectInstance"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records/>
  </XOGOutput>
</NikuDataBus>

     

    the documentLocation is absolut path on the server.

     

    I run the message above on Clarity application server, but I always get following error:

     <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="customObjectInstance"/>
  <Status elapsedTime="0.238 seconds" state="SUCCESS"/>
  <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="min_res_activity">00000039</column>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>com.niku.dms.util.DMSException: Could not locate directory in file store.</Description>
      </ErrorInformation>
    </Record>
  </Records>
</XOGOutput>

     

    Please have you got any advice how can I import absolutely new file to Clarity?

     

    Thanks in advance,

    Martin



  • 2.  Re: How can I import attachment to custom attribute on custom object

    Posted Aug 12, 2015 03:54 AM

    Check if this helps -

     

    Xog In Documents to the Project Object

    https://communities.ca.com/message/241801615#241801615

     

    NJ