BookmarkSubscribeSubscribe to RSS Feed
gridge

Community Trekker

Joined:

May 25, 2017

Internet open from a table with multiple query (drop-down search)

Hello,

 

I am trying to import data from this website: http://www.naturalheritage.state.pa.us/Species.aspx into JMP but would only like the Plant data for all of PA. When I try internet open I only get a table with the data from the first category in the drop-down search (Reptiles & Amphibians). Is there a way to get the plant data table?Picture1.png

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz

Super User

Joined:

Jun 23, 2011

Solution

Re: Internet open from a table with multiple query (drop-down search)

Poor man's solution: select all of the data in the Plants table on the website.  Had to start the selection from the bottom, selecting in an upward direction until all table cells were highlighted.  Couldn't get the column headers swiping down.  Hit CTRL-C.  Open a new JMP table and click on Edit > Paste With Column Names.

 

Plants.png

5 REPLIES
briancorcoran

Joined:

Jun 23, 2011

Re: Internet open from a table with multiple query (drop-down search)

Are you using File->Internet Open and specifying "Data" as the type in the drop down, not Web Page?  It should present a dialog with three tables.  If you import them, you should have one with plants (the images do not import).

 

Brian Corcoran

JMP Development

 

Capture.PNGPlant Table

briancorcoran

Joined:

Jun 23, 2011

Re: Internet open from a table with multiple query (drop-down search)

I should have also mentioned that if you run the "Load pictures..." table script the thumbnails will be imported.

gridge

Community Trekker

Joined:

May 25, 2017

Re: Internet open from a table with multiple query (drop-down search)

Hi Brian,

Look at your table though, it just has the reptiles and amphibians. The plant list should at least have a couple hundred entries.

briancorcoran

Joined:

Jun 23, 2011

Re: Internet open from a table with multiple query (drop-down search)

Sorry about that.  I should have examined the results closer.  The plant table is a dynamic table that is populated after specifying a dropdown item.  Since it does not have a dedicated, static link, it probably will not be possible to obtain from this site at least.

 

Brian

pmroz

Super User

Joined:

Jun 23, 2011

Solution

Re: Internet open from a table with multiple query (drop-down search)

Poor man's solution: select all of the data in the Plants table on the website.  Had to start the selection from the bottom, selecting in an upward direction until all table cells were highlighted.  Couldn't get the column headers swiping down.  Hit CTRL-C.  Open a new JMP table and click on Edit > Paste With Column Names.

 

Plants.png