BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
jeffjy
Staff (Retired)

Importing an XML file into JMP

Hi guys,

 

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Reading XML file

try the addin.

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

Capture.PNGOutput 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.)

Craige
0 Kudos
4 REPLIES 4
jschroedl
Staff

Re: Reading XML file

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() ) )
               )
          )
     )
);
0 Kudos
ix_stats
Community Member

Re: Reading XML file

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>

    <UID>AA11</UID>

    <Ver>1.0</Ver>

    - <CD>

      <UID>AA11</UID>

      <Type>0</Type>

      - <DD>

        <UID>AA11</UID>

        <Type>1</Type>

        </DD>    

      </CD>

    </Info>

</Summary_Log>

0 Kudos
sfayer0
Community Trekker

Re: Reading XML file

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

0 Kudos

Re: Reading XML file

try the addin.

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

Capture.PNGOutput 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.)

Craige
0 Kudos