(Visual FoxPro) SFTP Get File Date/Times in Different Formats

See more SFTP Examples

Demonstrates how to get remote file date/times in different formats.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loSftp
LOCAL lcHostname
LOCAL lnPort
LOCAL lnSuccess
LOCAL lcHandle
LOCAL loDirListing
LOCAL i
LOCAL n
LOCAL loSbFilename
LOCAL lnCaseSensitive
LOCAL lnBLocalDateTime
LOCAL loFileObj
LOCAL loDt

* This requires the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.SFtp')
loSftp = CreateObject('Chilkat.SFtp')

* Connect to the SSH server.  
lcHostname = "my-sftp-server.com"
lnPort = 22
lnSuccess = loSftp.Connect(lcHostname,lnPort)
IF (lnSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* Authenticate with the SSH server. 
lnSuccess = loSftp.AuthenticatePw("myLogin","myPassword")
IF (lnSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* After authenticating, the SFTP subsystem must be initialized:
lnSuccess = loSftp.InitializeSftp()
IF (lnSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* Open a directory on the server...
* This example opens the "junk" directory located under the HOME directory of the SSH user account.
lcHandle = loSftp.OpenDir("junk")
IF (loSftp.LastMethodSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* Download the directory listing:
loDirListing = loSftp.ReadDir(lcHandle)
IF (loSftp.LastMethodSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* Close the directory handle
lnSuccess = loSftp.CloseHandle(lcHandle)
IF (lnSuccess <> 1) THEN
    ? loSftp.LastErrorText
    RELEASE loSftp
    CANCEL
ENDIF

* Iterate over the files.
* Examine each filename and indicate those that match *FICHERO*.pdf
* (i.e. the filename contains the word "FICHERO" and ends in ".pdf")
i = 0
n = loDirListing.NumFilesAndDirs
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbFilename = CreateObject('Chilkat.StringBuilder')
lnCaseSensitive = 0
lnBLocalDateTime = 0
DO WHILE i < n
    loFileObj = loDirListing.GetFileObject(i)
    ? loFileObj.Filename

    * Get the last-modified date/time
    loDt = loFileObj.GetLastModifiedDt()

    * Get the date/time in any format offered by the CkDateTime object.

    * such as Wed, 18 Oct 2017 09:08:21 GMT
    ? "RFC822 format: " + loDt.GetAsRfc822(lnBLocalDateTime)

    * such as 1990-12-31T23:59:60Z
    ? "Timestamp: " + loDt.GetAsTimestamp(lnBLocalDateTime)

    * Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
    ? "RFC822 format: " + loDt.GetAsIso8601("MM/DD/YYYY hh:mm:ss",lnBLocalDateTime)

    RELEASE loDt
    RELEASE loFileObj

    i = i + 1
ENDDO

RELEASE loDirListing

? "Success."

RELEASE loSftp
RELEASE loSbFilename