topic Importing an XML file into JMP in Discussions

Importing an XML file into JMP

jeffjy — Tue, 13 Feb 2018 21:45:49 GMT

Hi guys,

Any one try to use JMP to work with XML file before? Can JMP import XML file?

Re: Reading XML file

jschroedl — Thu, 08 Sep 2011 13:21:12 GMT

JMP has functions for loading and parsing XML.

If you have the XML as text strings, use ParseXML

ex =
"<table name='fromxml'><col name='x'>[1 2 3]</col><col name='y'>[11 22 33]</col></table>";
Parse XML( ex,
     On Element(
          "table",
          Start Tag(
               New Table( XML Attr( "name" ) )
          )
     ),
     On Element(
          "col",
          End Tag(
               New Column( XML Attr( "name" ),
                    Set Values( Parse( XML Text() ) )
               )
          )
     )
);

From a file:

Parse XML( LoadTextFile("c:\temp\test.xml"),
          "table",
     On Element(
          Start Tag(
               New Table( XML Attr( "name" ) )
          )
     ),
     On Element(
          "col",
          End Tag(
               New Column( XML Attr( "name" ),
                    Set Values( Parse( XML Text() ) )
               )
          )
     )
);

Re: Reading XML file

ix_stats — Tue, 30 Apr 2013 11:58:34 GMT

Hi Jschroedl,

I have an XML file with contents as shown below. I was trying to create a JMP table from it.

How do i write the jsl so that I can pick up the value in the 'Type' field in folder "CD" which would be '0' and not pick up the '1' from the "DD" folder (also with a 'Type' field but is within "CD")?

Thanks.

XML contents:

- <Summary_Log>

- <Info>

- <CD>

- <DD>

</DD>

</CD>

</Info>

</Summary_Log>

Re: Reading XML file

sfayer0 — Tue, 12 Sep 2017 17:12:35 GMT

Having the same problem. The documentation does not go into much details on this.

Re: Reading XML file

Craige_Hales — Tue, 12 Sep 2017 19:19:14 GMT

try the addin.

https://community.jmp.com/t5/JMP-Add-Ins/XML-Importer-Add-In/ta-p/22723

Output from XML addin

The column names are the fully qualified path through the XML document.

(The addin source JSL is there too. View->add-ins->open the folder and see the JSL.)

Re: Reading XML file

Craige_Hales — Tue, 10 Dec 2019 20:54:29 GMT

Anyone landing here for JMP 15 and beyond: there is built-in support for reading XML and JSON data that includes a GUI-based wizard. (JMP 14 has non-GUI support for JSON as well).

The wizard looks similar for both XML and JSON files