AnsweredAssumed Answered

How can I import attachment to custom attribute on custom object

Question asked by msnizek on Aug 11, 2015
Latest reply on Aug 12, 2015 by navzjoshi00

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

Outcomes