DataFlex

SFTP Get File Date/Times in Different Formats

See more SFTP Examples

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

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoSftp
    String sHostname
    Integer iPort
    String sHandle
    Variant vDirListing
    Handle hoDirListing
    Variant vFileObj
    Handle hoFileObj
    Handle hoSbFilename
    Boolean iCaseSensitive
    Boolean iBLocalDateTime
    Handle hoDt
    Integer i
    Integer n
    String sTemp1
    Boolean bTemp1

    Move False To iSuccess

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

    Get Create (RefClass(cComChilkatSFtp)) To hoSftp
    If (Not(IsComObjectCreated(hoSftp))) Begin
        Send CreateComObject of hoSftp
    End

    // Connect to the SSH server.  
    Move "my-sftp-server.com" To sHostname
    Move 22 To iPort
    Get ComConnect Of hoSftp sHostname iPort To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Authenticate with the SSH server. 
    Get ComAuthenticatePw Of hoSftp "myLogin" "myPassword" To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // After authenticating, the SFTP subsystem must be initialized:
    Get ComInitializeSftp Of hoSftp To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Open a directory on the server...
    // This example opens the "junk" directory located under the HOME directory of the SSH user account.
    Get ComOpenDir Of hoSftp "junk" To sHandle
    Get ComLastMethodSuccess Of hoSftp To bTemp1
    If (bTemp1 = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Download the directory listing:

    Get Create (RefClass(cComChilkatSFtpDir)) To hoDirListing
    If (Not(IsComObjectCreated(hoDirListing))) Begin
        Send CreateComObject of hoDirListing
    End
    Get pvComObject of hoDirListing to vDirListing
    Get ComReadDirListing Of hoSftp sHandle vDirListing To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Close the directory handle
    Get ComCloseHandle Of hoSftp sHandle To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoSftp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // 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")
    Get Create (RefClass(cComChilkatSFtpFile)) To hoFileObj
    If (Not(IsComObjectCreated(hoFileObj))) Begin
        Send CreateComObject of hoFileObj
    End
    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbFilename
    If (Not(IsComObjectCreated(hoSbFilename))) Begin
        Send CreateComObject of hoSbFilename
    End
    Move False To iCaseSensitive
    Move False To iBLocalDateTime

    Get Create (RefClass(cComCkDateTime)) To hoDt
    If (Not(IsComObjectCreated(hoDt))) Begin
        Send CreateComObject of hoDt
    End
    Move 0 To i
    Get ComNumFilesAndDirs Of hoDirListing To n
    While (i < n)

        Get pvComObject of hoFileObj to vFileObj
        Get ComFileAt Of hoDirListing i vFileObj To iSuccess
        If (iSuccess = False) Begin
            Get ComLastErrorText Of hoDirListing To sTemp1
            Showln sTemp1
            Procedure_Return
        End

        Get ComFilename Of hoFileObj To sTemp1
        Showln sTemp1

        // Get the last-modified date/time
        Get ComLastModifiedTimeStr Of hoFileObj To sTemp1
        Get ComSetFromRfc822 Of hoDt sTemp1 To iSuccess

        // Get the date/time in other formats offered by the CkDateTime object.

        // such as Wed, 18 Oct 2017 09:08:21 GMT
        Get ComGetAsRfc822 Of hoDt iBLocalDateTime To sTemp1
        Showln "RFC822 format: " sTemp1

        // such as 1990-12-31T23:59:60Z
        Get ComGetAsTimestamp Of hoDt iBLocalDateTime To sTemp1
        Showln "Timestamp: " sTemp1

        // Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
        Get ComGetAsIso8601 Of hoDt "MM/DD/YYYY hh:mm:ss" iBLocalDateTime To sTemp1
        Showln "RFC822 format: " sTemp1

        Move (i + 1) To i
    Loop

    Showln "Success."


End_Procedure