Subscribe Bookmark RSS Feed
matthewwolfe

Staff

Joined:

Aug 3, 2015

XML Importer Add-In

This add-in provides an interface for importing XML files to JMP Data Tables. To use the add-in, select Add-ins > Import XML. From the launch window, you can browse for the XML file you wish to import by pressing the Select File button. Once a file is selected, you will have the option to remove the file by pressing the Remove File button and then searching for another file. Pressing OK will initiate the importing process.

Figure 1.1 Launch Window

9469_launch-window.png

Example Data

Original XML


<header>


  <title>Title Text</title>


  <content>


    <array>Text1</array>


    <array>Text2</array>


    <array>Text3</array>


  </content>


  <title2>Title Text 2</title2>


  <content>


    <array>Text4</array>


    <array>Text5</array>


    <array>Text6</array>


  </content>


</header>




Resulting Data Table

header.content.array._textheader.title._textheader.title2._text
Text1Title TextTitle Text 2
Text2Title TextTitle Text 2
Text3Title TextTitle Text 2
Text4Title TextTitle Text 2
Text5Title TextTitle Text 2
Text6Title TextTitle Text 2

Note that tags that are not at the most nested depth get repeated and in some instances the order of tags at a given depth are not preserved. It becomes alphabetical in JMP.

Comments
alan_dunham

Installation and use went seamlessly. For an example XML file to practice with, there are examples at http://www.w3schools.com/xml/plant_catalog.xml .  The add-in went directly to the web site and delivered a JMP datafile to my JMP browser.   This was a great addition. Thanks!

Article Labels
Article Tags
Contributors