My project has an error that I suspect is due to a variable being used incorrectly. I am trying to get output of files recursively in c:\temp. There are subfolders in there. Just want *.pdf. I want to put a list of the files in an email. Are there templates for this? My code below gives error "[8099 - Set Variable] An unexpected error occurred. Variable 'C:\TEMP\Chicken.pdf' is not a RowSet or an Array. Original expression: CurrFile[1]."
My code:
<project name="George" mainModule="Main" version="2.0" logLevel="verbose">

<module name="Main">

<createWorkspace version="1.0" />


<createFileList fileListVariable="data" version="1.0">
<fileset dir="C:\TEMP">
<wildcardFilter>
<include pattern="*.*" />
</wildcardFilter>
</fileset>
</createFileList>

<forEachLoop itemsVariable="${data}" currentItemVariable="CurrFile" disabled="false">

<setVariable name="myFile" value="${CurrFile[1]}" version="2.0" />


<print file="test.txt" append="true" version="1.0">
<![CDATA[${myFile}
]]>
</print>

</forEachLoop>

<sendEmail resourceId="fhcp" toList="gasdf@adsfa.com" keyLocation="KeyVault" version="2.0">
<from address="afdasf@noreply.com" keyLocation="KeyVault" />
<subject>
<![CDATA[test]]>
</subject>
<message>
<![CDATA[${data}]]>
</message>
</sendEmail>


<deleteWorkspace version="1.0" />

</module>

</project>

First, we will want to Create the File List



Then, Print the File List to a reachable location, we will use this text file in the next step. Make sure to set Append to false so that you only send the most recent files.



Finally, add the Send Email Task, hit Add to set the Message sub-task. With this method, you can set the File field to that text file that was just created. Add the rest of the information needed to send the email, and that's it!

Thank you Mark.

Is there a way to do a carriage return after each file name? I got the code working you suggested but the output does not do a new line after each file found, unless it is in another subdirectory. That is, if two files are found in same directory, it outputs it on same line.

My code:--------------------------------------------------------------------------------------------------------------
<project name="test" mainModule="Main" version="2.0" logLevel="verbose">

<module name="Main">

<createWorkspace version="1.0" disabled="false" />

<createFileList fileListVariable="data" version="1.0">
<fileset dir="C:\Program Files\Linoma Software\GoAnywhere\userdata\webdocs" recursive="true" includeItems="files">
<wildcardFilter>
<include pattern="*.*" />
</wildcardFilter>
</fileset>
</createFileList>

<print file="C:\Program Files\Linoma Software\GoAnywhere\output.txt" append="false" version="1.0">
<![CDATA[From the job run at 8 pm tonight, these files were showing uploaded. If the below is blank no files were found.

${data}
]]>
</print>

<forEachLoop itemsVariable="${data}" currentItemVariable="CurrFile" disabled="true">
<setVariable name="myFile" value="${CurrFile[1]}" version="2.0" />

<print file="C:\Program Files\Linoma Software\GoAnywhere\output.txt" append="false" version="1.0">
<![CDATA[${myFile}
]]>
</print>
</forEachLoop>

<sendEmail resourceId="fhcp" toList="xx@xx.com" keyLocation="KeyVault" version="2.0">
<from address="fhcp_go_anywhere@noreply.com" keyLocation="KeyVault" />
<subject>
<![CDATA[test]]>
</subject>
<message file="C:\Program Files\Linoma Software\GoAnywhere\output.txt" />
</sendEmail>
<deleteWorkspace version="1.0" disabled="false" />

</module>

</project>

Hi George,

For this, we will have to read that text file back in and turn it into a Rowset. We can use a For-Each Loop and Print task to add a carriage return/line feed to the list.

Below, we have the same file list as last time, but now with Recursive set to true.



Print out to that same text file with the same settings.



Read the Flat File (text file) we just created and set the Record Delimiter to LF.



On this step, we'll be Deleting the text file that we are going to Print to in the following task; this step just makes sure old data won't be present in our Email Message.



Now, we use a For-Each Loop to examine each row of our Rowset that was created by reading in the text file containing our File List.



And finally, we use another Print task with Append set to True in order to write out each row with a carriage return and line feed at the end of each line.





Now, we can use this text file as the Message for our Email task, and each file should receive it's own line regardless of the original folder it was in.