XML Metadata Extractor configuration problem

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

rmills

Hi, I've run through the wiki article on this, but can't seem to get it to run.  I've imported a number of XMLs with the following DOM:

<Recipe>
    <Title>Value1</Title>
    <Author>Value2</Author>
    <Instruction>Value3</Instruction>
    <… />
</Recipe>‍‍‍‍‍‍

And I want to take the Title, Author and Instruction values and insert them into the Title, Author and Description fields on a basic Alfresco document.

I've configured my extractor with a selector to target just the Recipe elements and children:

<bean
         id="extracter.xml.sample.selector.XPathSelector"
         class="org.alfresco.repo.content.selector.XPathContentWorkerSelector"
         init-method="init">
      <property name="workers">
         <map>
            <entry key="/my:test">
               <null />
            </entry>
            <entry key="/Recipe">
               <ref bean="extracter.xml.sample.AlfrescoModelMetadataExtracter" />
            </entry>
         </map>
      </property>
   </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And the mappings:

<bean id="extracter.xml.sample.AlfrescoModelMetadataExtracter"
         class="org.alfresco.repo.content.metadata.xml.XPathMetadataExtracter"
         parent="baseMetadataExtracter"
         init-method="init" >
      <property name="mappingProperties">
         <bean class="org.springframework.beans.factory.config.PropertiesFactoryBean">
            <property name="properties">
               <props>
                    <prop key="author">author</prop>
          <prop key="title">title</prop>
                <prop key="description">description</prop>
               </props>
            </property>
         </bean>-
      </property>
      <property name="xpathMappingProperties">
         <bean class="org.springframework.beans.factory.config.PropertiesFactoryBean">
            <property name="properties">
               <props>
                  <prop key="author">/Recipe/Author/text()</prop>
                  <prop key="title">/Recipe/Title/text()</prop>
                  <prop key="description">/Recipe/Instructions/text()</prop>
               </props>
            </property>
         </bean>
      </property>
   </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I'm not sure what I'm missing here.  It seems pretty straight forward and I've worked off of the example that Alfresco provided, which is the exact functionality (except for the actual mappings and XPath queries), so it shouldn't be that different right?  It was kind of unclear in the wiki how to "activate" these extractors other than dropping them in /classes/alfresco/extension and removing the ".sample" from the end of the filename.  Thanks.  Any help is much appreciated.  Thanks.

derek

Hi,

I am assuming that you took the .xml.sample file, dropped the .sample part and put it into the alfresco/extensions location.  The mechanism by which this is picked up is discussed here: http://wiki.alfresco.com/wiki/Repository_Configuration

Now, your configuration looks correct except for the mappings such as

<prop key="author">author</prop>

You'll notice that the sample uses cm:author, but you chose to use just author.  cm:author is equivalent (assuming you put in the missing namespace mapping as well) to {http://www.alfresco.org/model/content/1.0}author, while author is equivalent to {}author.  They are completely different properties.

Perform this query against your database, but you could use the Node Browser to dig down to the nodes as well:

select * from alf_node_properties where qname like '{}%';‍

and see whether there are any values there.

Regards