Hi,
I have read the CloverETL help file as well as browse a number of forum posts in relation to accessing remote files to no avail.
I am trying to access a remote spreadsheet file hosted on an FTP server belonging to another organisation through a proxy server managed by my organisation.
I can confirm that I can access the file through WinSCP configured with the FTP connection settings (username and password) and our proxy server authentication details (username and password).
The steps I take are:
Create a new SpreadsheetDataWriter and under the FileURL property, choose Remote files and select the Create/Edit URL icon
Under the Basic properties, fill in the Protocol (FTP), host, port number (21), Username, Password, Path (forward slash anf file name, as the file resides in the default connect directory)
Select the Validate button to confirm the URL is valid (confirmed)
Under Proxy properties, set the proxy type (proxy), proxy host, proxy port and proxy username and proxy password (the same as what was configured in WinSCP)
Select the Validate button to confirm the connection is valid (confirmed)
Select OK to the Edit URL Dialog
A Progress Information dialogue box appears with a message “Initializing browser data”
An Error box appears stating that the URL could not be reached with a reason Connection reset.
Close the URL Dialogue box by selecting OK
If I take off the file name and leave the forward slash on the URL, selecting the View button produces HTML code that lists the content of the root directory
If I add the file name (day_seed.xlsx) after the forward slash and hit the View button, I get the following HTML Code:
Forefront TMG: extended error message :
200 TYPE set to BINARY 227 Entering passive mode (125,7,110,35,19,145) 450 File opening error
I have tried using a different file and get the same results.
Any help would be much appreciated.