order of files in filelist

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.

order of files in filelist

Postby monahanks » Tue Nov 05, 2013 1:52 pm

Hi, I have a GoAnywhere project that reads a folder and generates a Filelist variable. The files are named:
(folder path/)PPE 101913 - Week 37.xls and
(folder path/)PPE 102613 - Week 38.xls

When i generate the file list variable, it shows and processes the second (Week 38) file first. does the filelist function populate the list in reverse order (add files to top of stack), and if so is there a way to reverse that?
monahanks
 
Posts: 24
Joined: Wed Mar 30, 2011 10:19 am

Re: order of files in filelist

Postby Support_ChrisB » Tue Nov 05, 2013 3:17 pm

Hello MonahHanks,
The createFileList task uses your operating system to read files in your folder and populate the variable. GoAnywhere Director does not currently have methods that allow you to sort the fileList, but you can create a forLoop and iterate through your fileList in reverse order. The forLoop would replace your forEachLoop and iterate using an index variable.

1. In your createFileList task, populate the Number of Files Found Variable field. In my example, I called the variable "numFiles." If your directory contains 8 files, then this variable will be assigned the integer 8.

2. Create a forLoop. On the Basic tab, use the ${numFiles} variable as the Begin Index. Set the End Index to '1', and set the Step to '- 1.'

On the Advanced tab, set the Current Index Variable to 'index.' The current file variable would now be ${fileList[index]}.

This loop will begin on Index 8 (the number or files in the directory) and decrement by 1 each time it loops, and end on the first file.

Here is an example of a forLoop that gets a list of files, and then prints them out in reverse order:

Code: Select all
<project name="File_List_Reverse_Order" mainModule="Main" version="2.0">

   <module name="Main">

      <createWorkspace version="1.0" />


      <createFileList fileListVariable="fileList" numFilesFoundVariable="numFiles" version="1.0">
         <fileset dir="C:\TestLoop" recursive="true" />
      </createFileList>

      <forLoop beginIndex="${numFiles}" endIndex="1" step="-1" currentIndexVariable="index">

         <print version="1.0">
            <![CDATA[${fileList[index]}]]>
         </print>

      </forLoop>
   </module>

</project>


Please let me know if you have any further questions.
Support_ChrisB
 
Posts: 3
Joined: Fri Oct 25, 2013 9:58 am


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron