3.3.3.1 Specifying URLs

In addition to file paths on the computer, you can also specify remote URLs: Web (HTTP) and FTP (File Transfer Protocol) URLs to import the XML from.

HTTP (Web) URLs

Specify a HTTP URL by copying it from the Web Browser, for example.

http://www.weather.gov/data/current_obs/KBUR.xml

If access to the file requires a user name and password, you can specify it in the following format. Please note that this works only when using HTTP based authentication (Basic or Digest). It does NOT work with HTTP Form-based authentication (where you enter the user name and password into a Web form to gain access).

http://user@password:www.example.com/path/to/file.xml

FTP URLs

In addition to HTTP URLs (used in web browsing), you can also add FTP URLs from which the XML is to be imported.

Type an FTP URL as follows. Note that this example uses anonymous FTP to fetch the XML file.

ftp://ftp.example.com/path/to/file.xml

Need to use a user name and password to retrieve the file? Specify the URL in the following format.

ftp://user@password:ftp.example.com/path/to/file.xml

If the FTP server needs a port to be specified, use the following format:

ftp://user@password:ftp.example.com:port/path/to/file.xml

Argon DataViz

Create Pivot Tables and Pivot Charts from Large Datasets.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.