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?
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.
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Can't Extract Zipped CSV File
JLee,
Can you post a copy of the Project XML and JobLog so we can review what is happening?
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Re: Can't Extract Zipped CSV File
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.
And here is the log:
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>
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 Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Can't Extract Zipped CSV File
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!
Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696