Excel File Size

[a_houston]

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.

[Support_Rick]

You can retrieve the file size by doing something like the following:

Code: Select all

<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>

The output from this would show:

Code: Select all

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

In this example, I'm passing the file location in as a parameter (MyFile). You could easily assign the file name within your project, or define it as a literal location.

For more information, please see the help text (Blue Question Mark within your GoAnywhere Director) and search for FileInfo.

[a_houston]

Ric,

Thanks for your response. I must be missing something though because I can't seem to get it to work. Here is a sample of what I am trying to do:

Code: Select all

		<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" />

The .zip file was generated in the projects workspace. The variable FileSize always seems to be set to Zero (0).

[Support_Rick]

Try this:

Code: Select all

<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>

Which generates this:

Code: Select all

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

If you're still having issues, please email us at [email protected] or call our Support Help line!