Taking Advantage of FileList Variables

Looking for an example project to get you started?
1 post Page 1 of 1

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Fri Mar 14, 2014 4:46 pm
Last month, I showed you how to create a FileSet to SFTP a list of files based on certain selection criteria. This month, I’m going to show you how to take advantage of that FileSet by creating a FileList. You can review how we created the FileSet by clicking on the link: Using File Lists via SFTP

FileLists can be created several different ways:
1. As the result of the CreateFileList Task
2. As an Output Variable of a local file task (copy, move, rename, encrypt, etc)
3. As an Output Variable of a remote file transfer (ftp, sftp, ftps, etc)
4. As a Parameter passed into a Project from a Monitor

Once you have the FileList variable created, manipulation of the file(s) associated to that FileList becomes as easy as typing a Variable into a Prompt … no matter how many files there are!

Our previous example created a FileSet by executing the FTP|Put Task. (See Figure 1)
Figure1.JPG
Figure1.JPG (23.38 KiB) Viewed 21815 times
In today’s example, we will convert our FileSet into a FileList variable, and then use that variable to archive our files using the Copy task.

To convert this FileSet into a FileList variable, click on the “Send Files to Target” task and select the “Output Variables” tab. Type “locFiles” into the “Processed Source Files Variable”. This will give you a FileList variable that will contain just the files (on the source server) that match the selection criteria identified under the FileSet element. (See Figure 2)
Figure2.JPG
Figure2.JPG (30.14 KiB) Viewed 21815 times
Now, for example, it becomes easy to Archive the files you transferred with one command!In the project outline, add a new Copy task. Name the task “Archive Files,” and then place the FileList variable in the “Source Files Variable” field. (See Figure 3)
Figure3.JPG
Figure 3

Execute the project and review the joblog. You will see that the files are identified and moved (archived) as a group of files. (See Figure 4)
Figure4.JPG
Figure4.JPG (29.18 KiB) Viewed 21815 times
Feel free to contact Linoma Software with any questions or to inquire about our On-Site Professional Services or Training Programs.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
1 post Page 1 of 1