PowerBuilder

SFTP Get File Date/Times in Different Formats

See more SFTP Examples

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

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

li_Success = 0

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

loo_Sftp = create oleobject
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 = 0 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 = 0 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 = 0 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 = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

// Download the directory listing:

loo_DirListing = create oleobject
li_rc = loo_DirListing.ConnectToNewObject("Chilkat.SFtpDir")

li_Success = loo_Sftp.ReadDirListing(ls_Handle,loo_DirListing)
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    destroy loo_DirListing
    return
end if

// Close the directory handle
li_Success = loo_Sftp.CloseHandle(ls_Handle)
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    destroy loo_DirListing
    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")
loo_FileObj = create oleobject
li_rc = loo_FileObj.ConnectToNewObject("Chilkat.SFtpFile")

loo_SbFilename = create oleobject
li_rc = loo_SbFilename.ConnectToNewObject("Chilkat.StringBuilder")

li_CaseSensitive = 0
li_BLocalDateTime = 0

loo_Dt = create oleobject
li_rc = loo_Dt.ConnectToNewObject("Chilkat.CkDateTime")

i = 0
n = loo_DirListing.NumFilesAndDirs
do while i < n

    li_Success = loo_DirListing.FileAt(i,loo_FileObj)
    if li_Success = 0 then
        Write-Debug loo_DirListing.LastErrorText
        destroy loo_Sftp
        destroy loo_DirListing
        destroy loo_FileObj
        destroy loo_SbFilename
        destroy loo_Dt
        return
    end if

    Write-Debug loo_FileObj.Filename

    // Get the last-modified date/time
    loo_Dt.SetFromRfc822(loo_FileObj.LastModifiedTimeStr)

    // Get the date/time in other formats 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)

    i = i + 1
loop

Write-Debug "Success."


destroy loo_Sftp
destroy loo_DirListing
destroy loo_FileObj
destroy loo_SbFilename
destroy loo_Dt