Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Solr Data Import Handler & XML – nested entities

DZone's Guide to

Solr Data Import Handler & XML – nested entities

· Java Zone ·
Free Resource

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

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.

 

Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.

Topics:

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}