Using JMP • Import Your Data • Import Remote Files and Web Pages
Previous
 • 
Next
Import Remote Files and Web Pages
You import data from Internet sites, intranet sites, FTP sites, or other computers by selecting File > Internet Open. The file paths begin with the Uniform Resource Locators (URLs) http, ftp, or file; a drive letter; or the path to a network drive (relative or absolute).
You also use this feature to import a Web page on a local or network drive as a data table. Once the data table is created, there is a script called Source that you can run to re-import and refresh the data. If you open a web page by selecting File > Open, the page opens in a browser, not as a data table.
SAS stored process reports open in an HTML view. From that view, you can import the file as a data table.
JMP inserts the location of the original data as a note in the data table. For example, the path Z:\example.html is included as a note when you import example.html from the Z drive.
To open a remote file
1.
Select File > Internet Open. The window shown in Internet Open Window appears.
Internet Open Window
2.
Enter the URL.
3.
Click the list under Open As, and select the option that specifies how you would like JMP to display the imported data:
Data Imports the file as a data table.
Web page Opens the web page in a browser. (Select this option to import data generated by web page scripts and server-side requests.)
Text Opens the file in a JMP Script window. In an HTML file, the HTML tags of a .html file are displayed.
4.
Click OK.
One of the following occurs:
‒
The file opens as you specified.
‒
If you imported a web page as data, a window appears that lists all tables on the page. Select the table or tables that you want to open, and then click OK. Each table opens in a new data table.
‒
If you imported a web page as a web page, select File > Import Data as Data Table in the browser. Select the table or tables that you want to open, and then click OK. Each table opens in a new data table.
‒
If the file is on an FTP server, the window in FTP Login Window appears.
FTP Login Window
5.
For an anonymous account, click OK. For an authenticated login, enter your user ID and password. The file then opens as you specified.
Note: Some anonymous FTP servers require a user ID. If the data table does not open, try typing either ‘ftp’ or ‘anonymous’ in the User ID text box. Leave the Password text box empty and click OK.
By default, SAS stored processes open reports in an HTML view.
To open a SAS stored process report as a data table
1.
In the HTML view, select File > Import Table as Data Table.
A window appears that lists the tables found in the web page.
2.
Select the table or tables that you want to import.
3.
Click OK.
Each table is opened as a new data table.
See Run Stored Processes for more information about stored process reports.
Tip: If the table you are importing contains images, they are first imported as text. To display the images in your data table, run the automatically generated table script named Load Pictures. A new expression column containing the images is created.