VBScript

SFTP Get File Date/Times in Different Formats

See more SFTP Examples

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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

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

set sftp = CreateObject("Chilkat.SFtp")

' Connect to the SSH server.  
hostname = "my-sftp-server.com"
port = 22
success = sftp.Connect(hostname,port)
If (success = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Authenticate with the SSH server. 
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Open a directory on the server...
' This example opens the "junk" directory located under the HOME directory of the SSH user account.
handle = sftp.OpenDir("junk")
If (sftp.LastMethodSuccess = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Download the directory listing:

set dirListing = CreateObject("Chilkat.SFtpDir")
success = sftp.ReadDirListing(handle,dirListing)
If (success = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Close the directory handle
success = sftp.CloseHandle(handle)
If (success = 0) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
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")
set fileObj = CreateObject("Chilkat.SFtpFile")
set sbFilename = CreateObject("Chilkat.StringBuilder")
caseSensitive = 0
bLocalDateTime = 0

set dt = CreateObject("Chilkat.CkDateTime")
i = 0
n = dirListing.NumFilesAndDirs
Do While i < n

    success = dirListing.FileAt(i,fileObj)
    If (success = 0) Then
        outFile.WriteLine(dirListing.LastErrorText)
        WScript.Quit
    End If

    outFile.WriteLine(fileObj.Filename)

    ' Get the last-modified date/time
    success = dt.SetFromRfc822(fileObj.LastModifiedTimeStr)

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

    ' such as Wed, 18 Oct 2017 09:08:21 GMT
    outFile.WriteLine("RFC822 format: " & dt.GetAsRfc822(bLocalDateTime))

    ' such as 1990-12-31T23:59:60Z
    outFile.WriteLine("Timestamp: " & dt.GetAsTimestamp(bLocalDateTime))

    ' Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
    outFile.WriteLine("RFC822 format: " & dt.GetAsIso8601("MM/DD/YYYY hh:mm:ss",bLocalDateTime))

    i = i + 1
Loop

outFile.WriteLine("Success.")

outFile.Close