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
- Posts: 17
- Joined: Thu May 08, 2014 2:07 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 Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
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!
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1