FTP Task

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

Shoma_Costco

Posts: 17
Joined: Thu May 08, 2014 2:07 am

Post by Shoma_Costco » Tue Dec 16, 2014 1:46 am
My below FTP task is not recognising the file name generated with variable from database file. It says no such file or directory. Please advise

Code: Select all
<project name="SEND_MBR_EXTRACT" mainModule="Main" version="1.0" logLevel="verbose">
	<description>Upload International PO Details to GW SFTP Server</description>

	<module name="Main">

		<sql label="Get Files" resourceId="Test DB" autoCommit="true" user="auissa" password="********" version="1.0">
			<query label="Read DB" outputVariable="Fileset">
				<statement>Select XFFLNM from MBTSTDTA.MBEXEFP</statement>
			</query>
		</sql>

		<forEachLoop label="For Each File" itemsVariable="${Fileset}" currentItemVariable="Row">

			<ftp label="Send File by FTP" resourceId="Media Merchant" version="1.0">
				<put label="Put File" sourceFile="/MEM/${Row[1]}" destinationDir="/Renewal EDMs" />
			</ftp>

		</forEachLoop>
	</module>

</project>

Support_Rick

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

Post by Support_Rick » Thu Dec 18, 2014 8:46 am
Shoma,

First .. when sending these to support, it truly helps if you send the full log file associated to your issue hopefully with DEBUG mode set for job logging. (Defined under the Project Level in the Control Tab)

Second .. I took a copy of this project, and created a table on my iSeries that matches the same you have here. Having it read the table and loop through the file names retrieved, it prints the Source FileName correctly, thus finding it for whatever task is necessary (as in FTP, etc).

Please send us your JobLog (in debug mode) so that we can get a further definition of what the issue is and we will reivew.

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