Import data from the Internet, FTP sites, or other computers by selecting File > Internet Open. A file path can start with http, ftp, or file; a drive letter; or, the path to a network drive (relative or absolute).
Using Internet Open, you can import data and images from the Internet or a remote computer and save it as a data table, web page, or text. See Import Data from Google Sheets for more information about using Internet Open to import a Google spreadsheet.
Suppose that you want to import data (with images) from a table on a web page and save it as a data table. The specific web page lists countries by population.
1. Select File > Internet Open > Web Page and select the file.
2. Enter the following URL: https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population.
3. Keep Open As set to Data, and click OK.
JMP finds several tables on the specified page.
4. Click List of countries and territories by total population and click OK.
JMP opens a data table that contains the information from the web page table.
5. (Optional) To add the images to the data table, run the Load pictures script.
Notes:
• You can open a remote file as one of the following formats:
Data
Opens the file as a data table.
Web page
Opens the web page in the JMP browser (Windows) or the default browser (macOS).
From the File menu on Windows, you can then choose to save the file or import the data as a data table. Select this option to import data that is generated by web page scripts and server-side requests.
Text
Opens the file in the script editor. If you imported an HTML file, the HTML tags of a web page are displayed.
• When you open a file from an FTP server, an FTP login window appears. 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.
• JMP waits 60 seconds before stopping the import due to an error. You can change the Internet Time Out setting on the General preferences page.
• If the table that you are importing contains images, the images 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 that contains the images is added to the data table.
• Running the Source script in a data table enables you to re-import and refresh the data.