Data Import Handler & XML – nested entities

Data Import Handler is a very nice and powerful tool. The following entry is a description of the problem (and solutions) which I met recently.

Description of the problem

I had to index some list of products, it doesn’t matter what kind of products. However, the products can be combined into groups. In addition, every successive element in the group may have some data omitted – actually the data that were present in the previous documents that appeared in the group. Here is the example structure (irrelevant information was omitted for readability):

<products>
  <product>
    <id>1</id>
    <name>Product 1</name>
  </product>
  <product>
    <id>2</id>
    <name>Product 2</name>
  </product>
  <group>
    <product>
      <id>3</id>
      <name>Product 3 and 4</name>
    </product>
    <product>
      <id>4</id>
    </product>
  </group>
</products>

Solution

The solution is as always a definition of the “entity” element which looked as follows:

<entity processor="XPathEntityProcessor"
    forEach="/products/product | /products/group/product">
  <field column="id" xpath="//id" />
  <field column="name" xpath="//name" commonField="true" />
</entity>

Explanation

With this “forEach” design the processing will take place both for products that do not belong to the group, as well as those in groups. An important attribute if the “commonField” one. It informs DIH that if the record doesn’t have a field defined DIH should fetch the field from the previous record.

The above solution has some limitations, such as the first item in the group should have defined the field “name” and it is important to order the products, but in my case, those limitations corresponded exactly with the specifications of the provided import file.

3 thoughts on “Data Import Handler & XML – nested entities

  • 17 August 2013 at 11:41
    Permalink

    Hey nice post, How it appear after query search result. Becouse while i am fetching the records, i am getting result as :

    1

    product 1

    Reply
  • 17 August 2013 at 11:41
    Permalink

    Hey nice post, How it appear after query search result. Because while i am fetching the records, i am getting result as :

    1
    2

    product 1
    product 2

    Reply
  • 21 August 2013 at 16:08
    Permalink

    Could you please repeat the comment? I’m not sure what you are expecting to get from Solr.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *