Excel File Size
Posted: Fri Jan 11, 2013 11:09 am
I have a project that creates an Excel file which is then zipped. Is there a way to retrieve the size of the zipped file? The file is created in the project's workspace only.
<project name="FileInfo Test" mainModule="Main" version="2.0" logLevel="silent" threadSafe="true">
<module name="Main">
<print label="Display File Size" version="1.0">
<![CDATA[
===================================================
File Name: ${ MyFile }
File Size: ${ FileInfo( MyFile ):size }
===================================================
]]>
</print>
</module>
<variable name="MyFile" value="" />
</project>
01/11/2013 09:28:25 INFO Overriding variable 'MyFile' with value 'C:\Temp\MyZipFile.zip'
01/11/2013 09:28:25 INFO
===================================================
File Name: C:\Temp\MyZipFile.zip
File Size: 21045
===================================================
01/11/2013 09:28:25 INFO End Date and Time: 01/11/2013 09:28:25
<setVariable label="Set File Name" name="MyFile" value="BatchEstimatedCartonizing${userid}${jobnbr}.zip" version="2.0" />
<setVariable label="Set File Size" name="FileSize" value="${ FileInfo( MyFile ):size}" version="2.0" />
<project name="FileInfo Test" mainModule="Main" version="2.0">
<module name="Main">
<createWorkspace version="1.0" />
<setVariable label="Init MyZipFile" name="MyZipFile" value="${system.job.workspace}/Pics.zip" version="2.0" />
<zip label="Zip my Files" outputFile="${ MyZipFile }" whenFileExists="overwrite" version="1.0">
<fileset dir="C:\Temp">
<wildcardFilter>
<include pattern="*.jpg" />
</wildcardFilter>
</fileset>
</zip>
<print label="Display File Size" version="1.0">
<![CDATA[===================================================
File Name: ${ MyZipFile }
File Size: ${ FileInfo( MyZipFile ):size }
===================================================
]]>
</print>
<deleteWorkspace version="1.0" />
</module>
</project>
01/11/2013 10:58:22 INFO Start Date and Time: 01/11/2013 10:58:22
01/11/2013 10:58:22 INFO Job Number: 1357908022166
01/11/2013 10:58:22 INFO Project Name: /Projects/FileInfo Test
01/11/2013 10:58:22 INFO Submitted By: RElliott
01/11/2013 10:58:22 INFO GoAnywhere Director 4.2.0 running on Windows 7 6.1 (amd64)
01/11/2013 10:58:22 INFO ===================================================
File Name: C:\Program Files\Linoma Software\GoAnywhere\userdata\workspace\1357908022166/Pics.zip
File Size: 1819758
===================================================
01/11/2013 10:58:22 INFO End Date and Time: 01/11/2013 10:58:22