FTP - confused by response

[jamesF852]

Hi,

I'm trying to schedule a regular FTP to get a file (file_i_need.csv) from one of my servers and put it on a local machine with a different name (file_i_want.csv).

Code: Select all

FTPGetFile>host,user,password,21,C:\Users\jforeman\Downloads\file_i_want.csv,\remotedirectory\file_i_need.csv,I

When I run it, the FTP status window opens, and closes a few seconds later, and nothing else appears to happen. Confused, I put

Msg>FTP_RESULT

and I see that FTP_RESULT is '-' which isn't very enlightening.

Any suggestions on what I'm doing wrong? The server in question only accepts secure connections - I think that's what I'm asking for in the script, but I've learned not to assume my own infallibility. This is also the first time I've tried using FTPGetFile or OpenSSL, so I'm not sure if I've successfully installed the OpenSSL component - can anyone tell me how I can check that? (OpenSSL shows up in my list of installed programs and I've already been through one reboot since installation, but I'm not sure if there's anything else that's required)

[Marcus Tettmar]

Your syntax is incorrect (unless you are using a very old version of Macro Scheduler). The correct syntax for version 11 upwards is:

FTPGetFile>host,user,password,21,C:\Users\jforeman\Downloads\file_i_want.csv,\remotedirectory,file_i_need.csv,I

Note the remote directory and remote file are separate parameters. Assuming your paths are correct this should give you more of a clue.

[jamesF852]

Thanks. I've tried parameterising the command, so now I have

FTPGetFile>ftphost,ftpuser,ftppass,21,localdirectory,remotedirectory,remotefile,I

but I still get the same FTP_RESULT; '-'

This is using Macro Scheduler 13.1.06

[Marcus Tettmar]

What kind of FTP server is it? Are all the parms correct? Are you able to share the login details with our helpdesk? If you can send in the details we can try from here and see what we get. Send a ticket at help.mjtnet.com