nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import data from html page issue

j_bonnouvrier

Hi,

I am trying to import the data from the following website:

http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html

It is basically a record of meteorological data.

I am using the JSL command:

But it fails. Does someone have the solution?

Open("http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html");

Thanks and regards,

Jérôme

Accepted answers

All comments

txnelson

I attempted to interactively open the webpage using

File==>Internet Open

and got the following error message

This web page uses an unsupported character set: "iso-8859-15".

I would contact JMP directly about when such support might be available

MikeD_Anderson

Have you tried to use File > Internet Open...? In the dialog, you can then select to have the HTML open as data. You should get two data tables. Look at the "Source" table in the table script area for the one you want to see what the JSL looks like to get to it directly.

Best,

MikeD_Anderson

@txnelson, that's odd. I just did it through the GUI and it worked fine.

JSL for the first table:

Open(
	"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
	HTML Table( 1, Column Names( 0 ), Data Starts( 1 ) )
)

JSL for the second table:

Open(
	"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
	HTML Table( 2, Column Names( 1 ), Data Starts( 2 ) )
)

There do appear to be a lot of pictures in the data table.

MikeD_Anderson

@txnelson, that's odd. I just did it through the GUI and it worked fine.

JSL for the first table:

Open(
	"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
	HTML Table( 1, Column Names( 0 ), Data Starts( 1 ) )
)

JSL for the second table:

Open(
	"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
	HTML Table( 2, Column Names( 1 ), Data Starts( 2 ) )
)

There do appear to be a lot of pictures in the data table.

txnelson

Here is the log I get when I run your little piece of JSL to get to the first table

TEConverter - unrecognized charset in access or evaluation of 'Open' , Open/*###*/(
"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
HTML Table( 1, Column Names( 0 ), Data Starts( 1 ) ))

In the following script, error marked by /*###*/
Open/*###*/(
"http://www.infoclimat.fr/observations-meteo/archives/24/janvier/2017/grenoble-st-geoirs/07486.html",
HTML Table( 1, Column Names( 0 ), Data Starts( 1 ) ))

MikeD_Anderson

@txnelson - it appears to be a Mac vs Windows issue... Runs fine on my MacOS box, but I get the same error you get on my windows partition.

@j_bonnouvrier - you probably want to report this to tech support, like @txnelson indicated originally.