Hi cderendinger,
If you have a specific file you need to grab, you'll drill down to the wildcard filtering portion of the fileset. To do this, click NEXT from the FILESET element and Add a Wildcard Filter, then NEXT and Include Files. In your case, you'll be filtering for *.xlsx. Be sure to define an output variable in the processed source files variable field under the Output Variables tab of the Get Files sub-task.
After the Get Files sub-task, add a Delete Files sub-task to the FTP task and specify the output variable that you created earlier in the Input Files Variable field.
Here is a sample project XML that suits your requirements:
Code: Select all<project name="FTP Get ALL" mainModule="Main" version="2.0">
<module name="Main">
<ftp resourceId="My PC" version="1.0">
<get label="getFile" destinationDir="C:\test\FTP Test\" whenFileExists="overwrite" processedSourceFilesVariable="getFile">
<fileset dir="/upload/">
<wildcardFilter>
<include pattern="*.xlsx" />
</wildcardFilter>
</fileset>
</get>
<delete label="Delete getFile" inputFilesVariable="${getFile}" />
</ftp>
</module>
</project>
In this example, we're getting all files that end with the extension .xlsx in directory /upload/ on the FTP server. Then after the Get sub-task, we're deleting the file(s) that were downloaded from the remote FTP server, before disconnecting from the source server.
Thanks,
Chris