XML Importer Add-InThis 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
Example Data
Original XML
Title Text
Text1
Text2
Text3
Title Text 2
Text4
Text5
Text6
Resulting Data Table
| header.content.array._text | header.title._text | header.title2._text |
|---|
| Text1 | Title Text | Title Text 2 |
| Text2 | Title Text | Title Text 2 |
| Text3 | Title Text | Title Text 2 |
| Text4 | Title Text | Title Text 2 |
| Text5 | Title Text | Title Text 2 |
| Text6 | Title Text | Title 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.
Re: XML Importer Add-In<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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!
