Can't Extract Zipped CSV File

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

jlee1

Posts: 12
Joined: Mon Jun 22, 2015 12:41 pm

Post by jlee1 » Tue Jul 07, 2015 10:51 am
Hello,

I have a job that prints data to a csv file (writing to csv failed so this was my work around). I successfully print the file and I can download and open it from the local workspace and it looks perfect. Next, I zip the file, which zips successfully. When I try to open the csv from the zip I get an error that says "Windows cannot complete the extraction. The destination file could not be created."

If I download the file and zip it myself, I have no problems. Is there a bug with the zip program for zipping printed files? Or comma delimited files?
Attachments
director error.png
Here is a picture of the error

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Tue Jul 07, 2015 12:32 pm
JLee,

Can you post a copy of the Project XML and JobLog so we can review what is happening?
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

jlee1

Posts: 12
Joined: Mon Jun 22, 2015 12:41 pm

Post by jlee1 » Tue Jul 07, 2015 1:47 pm
Sure thing! It is a large project but the problem we are having is towards the bottom. We print 3 columns to a CSV, move it to a folder, zip it with a few other files, and copy it to a different server. After I print the CSV file I can download and open it and it looks great, but after zipping it, it no longer works.
Code: Select all
<project name="SuddenLink CUSTOM BATCH EXPORT" mainModule="Main" version="2.0" logLevel="verbose">

	<module name="Main" onError="setVariable:mainError=1">

		<createFileList label="Create Zip fileList" fileListVariable="allzipFiles" numFilesFoundVariable="zipCount" version="1.0">
			<fileset dir="${inDir}">
				<wildcardFilter>
					<include pattern="*.zip" />
				</wildcardFilter>
			</fileset>
		</createFileList>

		<forEachLoop label="For Each zip File Loop" itemsVariable="${allzipFiles}" currentItemVariable="eachzipFile">

			<createWorkspace label="Create Local Workspace" version="1.0" onError="abort" />


			<mkdir label="Make In Directory" dir="In" version="1.0" />


			<copy label="Copy Data Extract to Local" sourceFilesVariable="${eachzipFile}" destDir="In" whenFileExists="overwrite" processedSourceFilesVariable="inZippedFile" destinationFilesVariable="zippedDataExtract" version="1.0" />


			<unzip label="Unzip Data Extract File" outputDir="Unzipped" outputFilesVariable="UnzippedFiles" version="1.0">
				<fileset dir="In">
					<wildcardFilter>
						<include pattern="*.zip" />
					</wildcardFilter>
				</fileset>
			</unzip>


			<readCSV label="Read Process Documents CSV" outputRowSetVariable="CSVRowset" fieldDelimiter="comma" textQualifier="double quotes" processedInputFilesVariable="ReadCSVFiles" version="1.0">
				<fileset dir="Unzipped" recursive="false">
					<wildcardFilter>
						<include pattern="*.csv" />
					</wildcardFilter>
				</fileset>
			</readCSV>


			<createFileList fileListVariable="pdfList" version="1.0">
				<fileset dir="Unzipped">
					<wildcardFilter>
						<include pattern="*.pdf" caseSensitive="false" />
					</wildcardFilter>
				</fileset>
			</createFileList>


			<modifyRowSet label="Modify Rowset" inputRowSetVariable="${CSVRowset}" outputRowSetVariable="NewCSVRowset" existingColumns="true" startAtRow="1" version="1.0" disabled="false">
				<modifyColumn index="17" value="${If(CSVRowset[3] == "DIN", CSVRowset[17], Concat(CSVRowset[3],".pdf"))}" />
			</modifyRowSet>


			<print label="Print ReadCSV Files" file="notes.txt" version="1.0" disabled="true">
				<![CDATA[Here are the read csv files: Read CSV Files:

${ReadCSVFiles}

CSVRowset
${CSVRowset}]]>
			</print>


			<writeCSV inputRowSetVariable="${NewCSVRowset}" outputFile="Unzipped/New.csv" whenFileExists="overwrite" fieldDelimiter="comma" textQualifier="double quotes" version="1.0" />


			<move sourceFile="Unzipped/New.csv" destFile="${ReadCSVFiles}" whenFileExists="overwrite" version="1.0" />


			<rename label="Rename All PDFs" inputFilesVariable="${pdfList}" whenFileExists="error" searchPattern="Invoice_" patternType="regex" replaceWith="${system.emptyString}" outputFilesVariable="Rename1" version="1.0" />


			<rename inputFilesVariable="${Rename1}" whenFileExists="error" searchPattern="_.*" patternType="regex" replaceWith=".pdf" version="1.0" />


			<modifyRowSet inputRowSetVariable="${NewCSVRowset}" outputRowSetVariable="invAmounts" startAtRow="2" version="1.0" />

			<forEachLoop label="Loop Through CSV Names" itemsVariable="${ReadCSVFiles}" currentItemVariable="thisFile">

				<print label="Print Filename" version="1.0">
					<![CDATA[${thisfile:name}]]>
				</print>


				<setVariable label="Set Filename Variable" name="fileName" value="${thisfile:name}" version="2.0" />

			</forEachLoop>

			<sql label="XML Translation" resourceId="DCP-NT9" version="1.0">
				<query label="Insert Data into Temp Table" inputRowSetVariable="${invAmounts}">
					<statement>TRUNCATE	TABLE master.dbo.fileSummary

INSERT INTO fileSummary (invTotal)
VALUES (?)


  </statement>
					<param index="1" type="VARCHAR" mapFrom="6" />
				</query>
			</sql>


			<sql label="Select Rows and Invoice Total" resourceId="DCP-NT9" version="1.0">
				<query label="select it" outputVariable="totalControl" whenNoDataFound="setVariable:nodata=true">
					<statement>SELECT COUNT(*) Cnt, SUM(cast(InvTotal as money)) InvTotal
FROM fileSummary
</statement>
				</query>
			</sql>


			<print label="Write the Control File" file="Unzipped/control.txt" version="1.0">
				<![CDATA[${thisFile:name}, ${totalControl[2]}, ${totalControl[1]}]]>
			</print>


			<rename inputFile="Unzipped/control.txt" newName="control.csv" version="1.0" />


			<zip label="Zip renamed" outputFile="Testzip.zip" outputFileVariable="NewZipped" version="1.0">
				<fileset dir="Unzipped" />
			</zip>


			<copy label="Copy New Zipped File to Out Folder" sourceFile="${NewZipped}" destFile="${Replace(String(inZippedFile), inDir, outDir)}" whenFileExists="overwrite" version="1.0" />


			<deleteWorkspace label="Delete Local Workspace" version="1.0" disabled="true" />

		</forEachLoop>
	</module>

	<variable name="inDir" value="resource:smb://testclientprocessing/SC/P2P/DataExtract" />
	<variable name="outDir" value="resource:smb://testclientprocessing/SC/P2P/Matching/Out" />

	<module name="BackupAndDelete" description="Copy to Backup and Delete Processing Files">

		<copy label="Copy Data Extract to Backup" sourceFilesVariable="${eachzipFile}" destDir="resource:smb://prodclientbackup/SC/P2P/DataExtract" whenFileExists="overwrite" version="1.0" onError="setVariable:backupError=1" />

		<if label="If no errors occur " condition="${backupError == 0 AND mainError == 0}">

			<delete label="Delete files from Processing" inputFilesVariable="${allzipFiles}" version="1.0" onError="setVariable:backupError=1" />

		</if>

		<callModule label="callModule: OnError" module="OnError" version="1.0" />

	</module>


	<module name="OnError">
		<if label="if errors occur" condition="${backupError == 1 OR mainError == 1}">

			<sendEmail label="send Email to Admin" resourceId="Relay" toList="[email protected]" version="2.0">
				<from address="[email protected]" />
				<subject>
					<![CDATA[${system.project.name} ]]>
				</subject>
				<message>
					<![CDATA[Failed]]>
				</message>
			</sendEmail>

		</if>
	</module>

	<variable name="allzipFiles" value="nodata" />
	<variable name="mainError" value="0" />
	<variable name="backupError" value="0" />
	<variable name="zipCount" value="0" />
	<variable name="fileName" value="nodata" />
</project>
And here is the log:
Code: Select all
7/7/15 10:37:56 AM            INFO      Start Date and Time: 7/7/15 10:37:56 AM
7/7/15 10:37:56 AM            INFO      Job Number: 1000000000416 
7/7/15 10:37:56 AM            INFO      Project Name: /Development/SuddenLink CUSTOM BATCH EXPORT
7/7/15 10:37:56 AM            INFO      Submitted By: administrator
7/7/15 10:37:56 AM            INFO      GoAnywhere Director 4.7.0 running on Linux 3.16.0-30-generic (amd64)
7/7/15 10:37:56 AM            INFO      Executing project 'SuddenLink CUSTOM BATCH EXPORT' 
7/7/15 10:37:56 AM            INFO      Project location: /home/dsnt2/Linoma_Software/GoAnywhere/userdata/projects/Development/SuddenLink CUSTOM BATCH EXPORT.xml
7/7/15 10:37:56 AM            INFO      Executing module 'Main'
7/7/15 10:37:56 AM            INFO      Executing task 'createFileList 1.0 (Create Zip fileList)'
7/7/15 10:38:02 AM            INFO      FileList variable 'allzipFiles' was created containing 1 file(s)
7/7/15 10:38:02 AM            INFO      Finished task 'createFileList 1.0 (Create Zip fileList)'
7/7/15 10:38:02 AM            INFO      Entering loop 'forEachLoop (For Each zip File Loop)'
7/7/15 10:38:02 AM            INFO      Executing task 'createWorkspace 1.0 (Create Local Workspace)'
7/7/15 10:38:02 AM            INFO      Workspace directory for this job is set to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416'.
7/7/15 10:38:02 AM            INFO      Finished task 'createWorkspace 1.0 (Create Local Workspace)'
7/7/15 10:38:02 AM            INFO      Executing task 'mkdir 1.0 (Make In Directory)'
7/7/15 10:38:02 AM            INFO      Directory '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/In' was created successfully
7/7/15 10:38:02 AM            INFO      Finished task 'mkdir 1.0 (Make In Directory)'
7/7/15 10:38:02 AM            INFO      Executing task 'copy 1.0 (Copy Data Extract to Local)'
7/7/15 10:38:03 AM            INFO      File 'resource:smb://testclientprocessing/SC/P2P/DataExtract/Invoice_0622150053_9.zip' (200,249 bytes) was successfully copied to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/In/Invoice_0622150053_9.zip' (200,249 bytes)
7/7/15 10:38:03 AM            INFO      1 file(s) copied successfully
7/7/15 10:38:03 AM            INFO      Finished task 'copy 1.0 (Copy Data Extract to Local)'
7/7/15 10:38:03 AM            INFO      Executing task 'unzip 1.0 (Unzip Data Extract File)'
7/7/15 10:38:03 AM            INFO      Preparing to extract file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/In/Invoice_0622150053_9.zip'
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150045_1.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150045_1.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150045_1.pdf' (20,996 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150046_2.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150046_2.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150046_2.pdf' (32,801 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150047_3.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150047_3.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150047_3.pdf' (29,856 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150048_4.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150048_4.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150048_4.pdf' (22,468 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150049_5.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150049_5.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150049_5.pdf' (22,058 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150050_6.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150050_6.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150050_6.pdf' (25,151 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150051_7.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150051_7.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150051_7.pdf' (9,053 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150052_8.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150052_8.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150052_8.pdf' (10,759 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'Invoice_0622150053_9.pdf' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150053_9.pdf'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150053_9.pdf' (30,845 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      Extracting 'ProcessDocuments_07062015_111944.csv' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv' (2,275 bytes) was successfully extracted
7/7/15 10:38:03 AM            INFO      1 archive file(s) were processed and a total of 10 file(s) were extracted
7/7/15 10:38:03 AM            INFO      Finished task 'unzip 1.0 (Unzip Data Extract File)'
7/7/15 10:38:03 AM            INFO      Executing task 'readCSV 1.0 (Read Process Documents CSV)'
7/7/15 10:38:03 AM            INFO      Data parsed successfully and the rowset variable 'CSVRowset' was created
7/7/15 10:38:03 AM            INFO      Finished task 'readCSV 1.0 (Read Process Documents CSV)'
7/7/15 10:38:03 AM            INFO      Executing task 'createFileList 1.0'
7/7/15 10:38:03 AM            INFO      FileList variable 'pdfList' was created containing 9 file(s)
7/7/15 10:38:03 AM            INFO      Finished task 'createFileList 1.0'
7/7/15 10:38:03 AM            INFO      Executing task 'modifyRowSet 1.0 (Modify Rowset)'
7/7/15 10:38:03 AM            INFO      Opening file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'
7/7/15 10:38:03 AM            INFO      Finished task 'modifyRowSet 1.0 (Modify Rowset)'
7/7/15 10:38:03 AM            INFO      Executing task 'writeCSV 1.0'
7/7/15 10:38:03 AM            INFO      Opening file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'
7/7/15 10:38:03 AM            INFO      10 record(s) were written from rowset '${NewCSVRowset}' to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/New.csv' (2,257 bytes)
7/7/15 10:38:03 AM            INFO      Finished task 'writeCSV 1.0'
7/7/15 10:38:03 AM            INFO      Executing task 'move 1.0'
7/7/15 10:38:03 AM            WARN      Overwriting the output file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'.
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/New.csv' was successfully moved to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv' (2,257 bytes)
7/7/15 10:38:03 AM            INFO      1 file(s) were moved successfully
7/7/15 10:38:03 AM            INFO      Finished task 'move 1.0'
7/7/15 10:38:03 AM            INFO      Finished task 'move 1.0'
7/7/15 10:38:03 AM            INFO      Executing task 'rename 1.0 (Rename All PDFs)'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150053_9.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150053_9.pdf' (30,845 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150051_7.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150051_7.pdf' (9,053 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150048_4.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150048_4.pdf' (22,468 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150049_5.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150049_5.pdf' (22,058 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150045_1.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150045_1.pdf' (20,996 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150050_6.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150050_6.pdf' (25,151 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150052_8.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150052_8.pdf' (10,759 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150047_3.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150047_3.pdf' (29,856 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/Invoice_0622150046_2.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150046_2.pdf' (32,801 bytes)
7/7/15 10:38:03 AM            INFO      9 file(s) were renamed successfully
7/7/15 10:38:03 AM            INFO      Finished task 'rename 1.0 (Rename All PDFs)'
7/7/15 10:38:03 AM            INFO      Executing task 'rename 1.0'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150053_9.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150053.pdf' (30,845 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150051_7.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150051.pdf' (9,053 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150048_4.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150048.pdf' (22,468 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150049_5.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150049.pdf' (22,058 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150045_1.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150045.pdf' (20,996 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150050_6.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150050.pdf' (25,151 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150052_8.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150052.pdf' (10,759 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150047_3.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150047.pdf' (29,856 bytes)
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150046_2.pdf' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150046.pdf' (32,801 bytes)
7/7/15 10:38:03 AM            INFO      9 file(s) were renamed successfully
7/7/15 10:38:03 AM            INFO      Finished task 'rename 1.0'
7/7/15 10:38:03 AM            INFO      Executing task 'modifyRowSet 1.0'
7/7/15 10:38:03 AM            INFO      Opening file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'
7/7/15 10:38:03 AM            INFO      Finished task 'modifyRowSet 1.0'
7/7/15 10:38:03 AM            INFO      Entering loop 'forEachLoop (Loop Through CSV Names)'
7/7/15 10:38:03 AM            INFO      Executing task 'print 1.0 (Print Filename)'
7/7/15 10:38:03 AM            INFO      ProcessDocuments_07062015_111944.csv
7/7/15 10:38:03 AM            INFO      Finished task 'print 1.0 (Print Filename)'
7/7/15 10:38:03 AM            INFO      Executing task 'setVariable 2.0 (Set Filename Variable)'
7/7/15 10:38:03 AM            WARN      Variable 'fileName' was replaced with 'ProcessDocuments_07062015_111944.csv'.
7/7/15 10:38:03 AM            INFO      Finished task 'setVariable 2.0 (Set Filename Variable)'
7/7/15 10:38:03 AM            INFO      Exiting loop 'forEachLoop (Loop Through CSV Names)'
7/7/15 10:38:03 AM            INFO      Executing task 'sql 1.0 (XML Translation)'
7/7/15 10:38:03 AM            INFO      Executing sub-task 'query'
7/7/15 10:38:03 AM            INFO      Executing statement - TRUNCATE	TABLE master.dbo.fileSummary
                                        INSERT INTO fileSummary (invTotal)
                                        VALUES (?)
                                          
7/7/15 10:38:03 AM            INFO      Opening file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv'
7/7/15 10:38:03 AM            INFO      Query completed successfully and 9 row(s) were affected
7/7/15 10:38:03 AM            INFO      Finished sub-task 'query'
7/7/15 10:38:03 AM            INFO      Finished task 'sql 1.0 (XML Translation)'
7/7/15 10:38:03 AM            INFO      Executing task 'sql 1.0 (Select Rows and Invoice Total)'
7/7/15 10:38:03 AM            INFO      Executing sub-task 'query'
7/7/15 10:38:03 AM            INFO      Executing statement - SELECT COUNT(*) Cnt, SUM(cast(InvTotal as money)) InvTotal
                                        FROM fileSummary
7/7/15 10:38:03 AM            INFO      Query completed successfully and the rowset 'totalControl' was created
7/7/15 10:38:03 AM            INFO      Finished sub-task 'query'
7/7/15 10:38:03 AM            INFO      Finished task 'sql 1.0 (Select Rows and Invoice Total)'
7/7/15 10:38:03 AM            INFO      Executing task 'print 1.0 (Write the Control File)'
7/7/15 10:38:03 AM            INFO      Finished task 'print 1.0 (Write the Control File)'
7/7/15 10:38:03 AM            INFO      Executing task 'rename 1.0'
7/7/15 10:38:03 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/control.txt' was successfully renamed to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/control.csv' (48 bytes)
7/7/15 10:38:03 AM            INFO      1 file(s) were renamed successfully
7/7/15 10:38:03 AM            INFO      Finished task 'rename 1.0'
7/7/15 10:38:03 AM            INFO      Executing task 'zip 1.0 (Zip renamed)'
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150049.pdf' (22,058 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150050.pdf' (25,151 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150048.pdf' (22,468 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150051.pdf' (9,053 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150046.pdf' (32,801 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150053.pdf' (30,845 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150045.pdf' (20,996 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/ProcessDocuments_07062015_111944.csv' (2,257 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/control.csv' (48 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150047.pdf' (29,856 bytes)
7/7/15 10:38:03 AM            INFO      Archiving file '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Unzipped/0622150052.pdf' (10,759 bytes)
7/7/15 10:38:03 AM            INFO      11 file(s) were successfully archived to '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Testzip.zip' (200,274 bytes)
7/7/15 10:38:03 AM            INFO      Finished task 'zip 1.0 (Zip renamed)'
7/7/15 10:38:03 AM            INFO      Executing task 'copy 1.0 (Copy New Zipped File to Out Folder)'
7/7/15 10:38:03 AM            WARN      Overwriting the output file 'resource:smb://testclientprocessing/SC/P2P/Matching/Out/Invoice_0622150053_9.zip'.
7/7/15 10:38:04 AM            INFO      File '/home/dsnt2/Linoma_Software/GoAnywhere/userdata/workspace/1000000000416/Testzip.zip' (200,274 bytes) was successfully copied to 'resource:smb://testclientprocessing/SC/P2P/Matching/Out/Invoice_0622150053_9.zip' (200,274 bytes)
7/7/15 10:38:04 AM            INFO      1 file(s) copied successfully
7/7/15 10:38:04 AM            INFO      Finished task 'copy 1.0 (Copy New Zipped File to Out Folder)'
7/7/15 10:38:04 AM            INFO      Exiting loop 'forEachLoop (For Each zip File Loop)'
7/7/15 10:38:04 AM            INFO      Finished module 'Main'
7/7/15 10:38:04 AM            INFO      Finished project 'SuddenLink CUSTOM BATCH EXPORT'
7/7/15 10:38:04 AM            INFO      End Date and Time: 7/7/15 10:38:04 AM

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Wed Jul 08, 2015 2:01 pm
Please email me at [email protected] so we can setup a conversation to discuss. There are several things here we need to review to get you up and going.

Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
4 posts Page 1 of 1