ftp_get
FTP get command; Virtuoso FTP client
integer ftp_get
(in server varchar,
in user varchar,
in pass varchar,
in remote_file_name varchar,
in local_file_name varchar,
[in is_pasv integer]);
Description
Virtuoso has FTP client functionality, that can be used inside Virtuoso/PL. This Virtuoso function mimics the FTP get command. As with any PL, this can be combined with Web Services and SOAP.
Parameters
server –
The remote server address or IP Address.
user –
The username for authentication at the FTP server.
pass –
The accompanying password for authentication at the FTP server.
remote_file_name –
Full path and file name to the file on the FTP server to be downloaded.
local_file_name –
The full path and file name of the local save point. This is relative to the server root directory. This directory must be included in DirsAllowed ACL list in the Virtuoso.INI file.
is_pasv –
Flag to specify whether to use passive mode. This can be one "1"
for passive mode, or zero "0" for active mode. One "1" is assumed by default.
Return Types
This function returns the size of the file written to the local file system.
Errors
This function will return any errors returned by the remote FTP server.
Examples
Retrieving a file from an FTP server
To get the file virtuoso30.tar.gz from the ftp server ftp.openlinksw.com, one can use:
select ftp_get ('ftp.openlinksw.com', 'user_name', 'password', 'virtuoso30.tar.gz', 'virtuoso30.tar.gz');
This will download the file which occurs on the root directory of the server, and save
it to the local server root directory.