Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

Delivery channels

Once your Excel file has been generated, you can deliver it to other users using a variety of means. You can copy it to a network share, or email it, or upload it to a FTP server.

delivery_01  

Click on the Add
button to select the delivery channel you want, and enter the settings for that channel.

delivery_types  

 
Copy settings  
 
delivery_copy01  
 
Target folder
The folder where the file will be copied to.

Overwrite existing file(s)
Select this option if SQL Spreadsheets should overwrite any existing files of the same name.

User name
If you need to impersonate another user to gain access to the target folder, enter the user account here to impersonate.

Password
The password of the impersonated user account.

 
 
 
Email settings  
 
delivery_email01  
 
Send to
The recipients of the email.

If you need to mail the file to multiple recipients, separate each recipient's email by a semi-colon (;) e.g. dba1@yohz.com;dba2@yohz.com

 
 
 
FTP settings  
 
delivery_ftp01  
 
Target folder
The target folder on the FTP server to upload the file to. '/' represents the user's home directory.

Host name
The host name of the FTP server.

Port
The listening port of the FTP server.

Use passive mode
Select this option if SQL Spreadsheets should use passive mode in establishing connection to the FTP server.

Use SSL
Select this option to use SSL for the connection.

Login name
The login name to the FTP server.

Password
The login password to the FTP server.

Proxy settings
Options:

(no proxy)
SITE FTPServer
USER UserName@FTPServer
USER after logon
OPEN FTPServer
USER UserName@FTPServer (direct)
USER ProxyUserName@FTPServer
USER UserName@FTPServer ProxyUserName
USER UserName@ProxyUserName@FTPServer

Select (no proxy) if the FTP connection can be established directly. If SQL Spreadsheets needs to use a proxy to connect to the FTP server, select the appropriate option for the proxy server.

Proxy settings - Host name
The proxy host name.

Proxy settings - Port
The proxy listening port for the FTP service.

Proxy settings - Login name
The login name to the proxy server.

Proxy settings - Password
The password for the login name to the proxy server.