cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
samir
Level IV

Import (open) data from websites

Hello,

I am trying to import data from a web page, but it fails although I use the exact syntax mentioned in the documentation.

Here is the code I use:

My_URL=https://www.jetairfly.com/fr/last-minute/charleroi/bejaia;

ObjectName = Open(My_URL, HTML Table(1));

Here is the error message I get:

Unable to read data from "https://www.jetairfly.com/fr/last-minute/charleroi/bejaia" in access or evaluation of 'Open' , Open( My_URL, HTML Table( 1 ) )

In the following script, error marked by /*###*/

ObjectName = Open/*###*/(My_URL, HTML Table( 1 ))

Could someone help ?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Import (open) data from websites

Internet Open support for HTTPS sites was added in JMP 12, so you won't be able to open this URL in JMP 11.

View solution in original post

4 REPLIES 4
ian_jmp
Staff

Re: Import (open) data from websites

I had JMP generate the scripts below for by (by using 'File > Internet Open' and copying the 'Source' script it puts in the table):

Open(

"https://www.jetairfly.com/fr/last-minute/charleroi/bejaia",

HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )

);

Open(

"https://www.jetairfly.com/fr/last-minute/charleroi/bejaia",

HTML Table( 2, Column Names( 1 ), Data Starts( 2 ) )

);


Please try these.

samir
Level IV

Re: Import (open) data from websites

No it does not work, does if for you ?

I get the same error.

Strange enough, when I used 'File > Internet Open', I got a different source code...

I am using JMP11, could this be the reason ?

ian_jmp
Staff

Re: Import (open) data from websites

I'm using JMP 12 (on a Mac) and, yes, it worked for me.

Re: Import (open) data from websites

Internet Open support for HTTPS sites was added in JMP 12, so you won't be able to open this URL in JMP 11.