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).
Comments
0 comments
Please sign in to leave a comment.