How to Use Advanced XPath Settings

Goal

An XML file with the following structure needs to be imported and later analyzed in Datameer.

<?xml version='1.0' encoding='Cp1252' ?>
<CONTENT>
 <RECORD>
  <COLUMN NAME="USERID">
   <![CDATA[12345]]>
  </COLUMN>
  <COLUMN NAME="USERNAME">
   <![CDATA[Datameer]]>
  </COLUMN>
  <COLUMN NAME="USERADDRESS">
   <![CDATA[street1:Grosse Ulrichstrasse 7-9,city:Halle (Saale),zip:06110,state:SA,country:DE,type:WORK]]>
  </COLUMN>
  <COLUMN NAME="CREATIONDATE">
   <![CDATA[1253664000000]]>
  </COLUMN>
  <COLUMN NAME="TITLE">
   <![CDATA[Title]]>
  </COLUMN>
  <COLUMN NAME="CONTENT">
   <![CDATA[<body><p>Content in HTML</p></body>]]>
  </COLUMN>
 </RECORD>
</CONTENT>

Following the knowledge base article How to Parse XML File Format the question came up, what might be the most efficient setup for importing and later processing.

Learn

During the XML Import Job setup, provide the value RECORD for the XML Record Tag Name

To have each sub-record in a separate column use as XPath

//COLUMN[@NAME='USERID']/text()
//COLUMN[@NAME='USERNAME']/text()
//COLUMN[@NAME='USERADDRESS']/text()
//COLUMN[@NAME='CREATIONDATE']/text()
//COLUMN[@NAME='TITLE']/text()
//COLUMN[@NAME='CONTENT']/text()

Further Information

Check out the documentation on Importing XML Files and Using XPath, XML Path Language (XPath) and character data (CDATA).

Articles in this section

Comments