(Excel) Delete Local Files that Do Not Exist on the FTP Server

Demonstrates how to get a list of local files in a directory tree that do not exist on the FTP server.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim ftp As Chilkat.Ftp2
Set ftp = Chilkat.NewFtp2

ftp.Hostname = "ftp.example.com"
ftp.Username = "login"
ftp.Password = "password"

ftp.KeepSessionLog = True

' Connect and login to the FTP server.

success = ftp.Connect()
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Set the current remote directory to the root of
' the remote tree to be compared.
success = ftp.ChangeRemoteDir("abc123")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Recursively descend the local directory tree
' and find the files that exist locally but not remotely.
' These are the files what would be uploaded via
' the SyncRemoteTree method call with mode = 1.
' (Mode 1 would upload all files that do not exist on the FTP server.)

' The actual uploading is avoided by setting the preview-only argument to True.

mode = 1

descendTree = True

previewOnly = True
success = ftp.SyncRemoteTree2("/temp/abc123",mode,descendTree,previewOnly)
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' The files what would've been uploaded are now available in the SyncPreview property,
' which contains a list of local file paths, one per line.
' A program can iterate over them like this:
Dim sa As Chilkat.StringArray
Set sa = Chilkat.NewStringArray
sa.LoadFromText ftp.SyncPreview

Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess


numFiles = sa.Count

i = 0

Do While (i < numFiles)
    localFilePath = sa.GetString(i)
    Debug.Print localFilePath

    ' An application can delete the file using Chilkat's file access object,
    ' or it can choose to use the native file API available in the programming language:
    success = fac.FileDelete(localFilePath)
    If (success <> True) Then
        Debug.Print "Failed to delete: "; localFilePath
    End If

    i = i + 1
Loop

success = ftp.Disconnect()