file properties
Posted: Wed Oct 26, 2016 8:01 am
Is it possible to use a file list and write the contents of that list to an excel spreadsheet? Specifically they want the file name and last date modified in the spreadsheet as 2 columns.
<<project name="Test_email" mainModule="Main" version="2.0" logLevel="verbose">
<module name="Main">
<createWorkspace version="1.0" />
<createFileList label="create e-mail list" fileListVariable="filelist" numFilesFoundVariable="filecnt" version="1.0" disabled="false">
<fileset dir="<path to>/Eligibility/test2" />
</createFileList>
<forEachLoop itemsVariable="${filelist}" currentItemVariable="currentfile" disabled="false">
<print file="<path to>/test/filelist.csv" append="true" version="1.0" disabled="false">
<![CDATA[${currentfile:name} ${system.carriageReturn}]]>
</print>
</forEachLoop>
<sendEmail resourceId="mail.wonderboxtech.com" toList="[email protected]" version="2.0" disabled="false">
<from address="Scion_Dental" />
<message file="<path to>/Eligibility/test/filelist.csv">
<![CDATA[The following files were sent today:
]]>
</message>
<subject>
<![CDATA[files sent today ]]>
</subject>
</sendEmail>
<delete file="<path to>/Eligibility/test/filelist.csv" version="1.0" disabled="false" />
<deleteWorkspace version="1.0" />
</module>
</project>