(PowerBuilder) 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

integer li_rc
oleobject loo_Sftp
string ls_Hostname
integer li_Port
integer li_Success
string ls_Handle
oleobject loo_DirListing
integer i
integer n
oleobject loo_SbFilename
integer li_CaseSensitive
integer li_BLocalDateTime
oleobject loo_FileObj
oleobject loo_Dt

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

loo_Sftp = create oleobject
// Use "Chilkat_9_5_0.SFtp" for versions of Chilkat < 10.0.0
li_rc = loo_Sftp.ConnectToNewObject("Chilkat.SFtp")
if li_rc < 0 then
    destroy loo_Sftp
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// Connect to the SSH server.  
ls_Hostname = "my-sftp-server.com"
li_Port = 22
li_Success = loo_Sftp.Connect(ls_Hostname,li_Port)
if li_Success <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// Authenticate with the SSH server. 
li_Success = loo_Sftp.AuthenticatePw("myLogin","myPassword")
if li_Success <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// After authenticating, the SFTP subsystem must be initialized:
li_Success = loo_Sftp.InitializeSftp()
if li_Success <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// Open a directory on the server...
// This example opens the "junk" directory located under the HOME directory of the SSH user account.
ls_Handle = loo_Sftp.OpenDir("junk")
if loo_Sftp.LastMethodSuccess <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// Download the directory listing:
loo_DirListing = loo_Sftp.ReadDir(ls_Handle)
if loo_Sftp.LastMethodSuccess <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// Close the directory handle
li_Success = loo_Sftp.CloseHandle(ls_Handle)
if li_Success <> 1 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// 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 = loo_DirListing.NumFilesAndDirs
loo_SbFilename = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbFilename.ConnectToNewObject("Chilkat.StringBuilder")

li_CaseSensitive = 0
li_BLocalDateTime = 0
do while i < n
    loo_FileObj = loo_DirListing.GetFileObject(i)
    Write-Debug loo_FileObj.Filename

    // Get the last-modified date/time
    loo_Dt = loo_FileObj.GetLastModifiedDt()

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

    // such as Wed, 18 Oct 2017 09:08:21 GMT
    Write-Debug "RFC822 format: " + loo_Dt.GetAsRfc822(li_BLocalDateTime)

    // such as 1990-12-31T23:59:60Z
    Write-Debug "Timestamp: " + loo_Dt.GetAsTimestamp(li_BLocalDateTime)

    // Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
    Write-Debug "RFC822 format: " + loo_Dt.GetAsIso8601("MM/DD/YYYY hh:mm:ss",li_BLocalDateTime)

    destroy loo_Dt
    destroy loo_FileObj

    i = i + 1
loop

destroy loo_DirListing

Write-Debug "Success."


destroy loo_Sftp
destroy loo_SbFilename