Post a reply

Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)


Topic review


Re: Certificate

dale@... wrote:

Would I post that specific string of characters, behind the -Certificate argument?

Yes. That's the fingerprint of your server's certificate.

I was able to get this 2nd issue resolved by wrapping the local path (which contains spaces) with quotes.

lcd "C:\Work\Client Folder\SendFiles"


Would I post that specific string of characters, behind the -Certificate argument?

I also noticed, in one of the links you provided, that the -explicit argument is only for use with FTPS protocol, and in this version of the code I'm working on simple FTP, although I will be switching to SFTP or FTPS once I get the simple FTP version working.

When I removed that argument from the code, it looks like I was able to connect, but received another error:

< 2019-04-18 10:48:19.320 Script: /UID/Downloads/Test
> 2019-04-18 10:48:19.320 Script: lcd C:\Work\ClientFolder\SendFiles
< 2019-04-18 10:48:19.506 Script: Too many parameters for command 'lcd'.
. 2019-04-18 10:48:19.507 Script: Failed
. 2019-04-18 10:48:19.507 Script: Exit code: 1
. 2019-04-18 10:48:19.515 Disconnected from server

Note: "ClientFolder" represents a folder that looks like: "\Client Name\2019-04 SFTP\" which does include a space in the first name

VBA (Access) file upload error: Unable to get local issuer certificate

I am attempting to run an upload of .txt files from a folder on my computer to my websits /downloads/test folder, via VBA

I have created a subroutine which builds my script and attempts to run it with the following commands:

Dim objShell as object
set objShell = CreateObject("WScript.Shell")

objShell.Run """" & ftpClientApp & """" & " /log=""" & logFile & """" & " /script=""" & scriptFile & """"

'all of that crap converts to:
"C:\Program Files (x86)\WinSCP\WinSCP.exe" /log="C:\Work\ClientFolder\ScriptOutput\WinSCP.log" /script="C:\Work\ClientFolder\ScriptOutput\rad90DD9.tmp"

and the script file looks like:
open ftp://UID:PWD@HostName/ -Explicit

# Change the remote directory
cd /Downloads/Test
# Change the local directory
lcd C:\Work\ClientFolder\SendFiles
# Upload all .txt files from the ftpLocalDir to ftpRemoteDir
put *.txt

But I'm getting an error during this process:
Summary: Unable to get local issuer certificate