cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
XML Importer Add-In
matthewwolfe
Staff (Retired)

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

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!