Question: How to create multiple sheets in a single excel file? Answer: Use the Write Excel task twice. Once for the first sheet and then on the second Write Excel Task use select Rename Sheet for the parameter, When Output File Exists. This creates a new sheet within the existing file. All other sh...

Yes we have customers connecting to WebSphere MQ. Please send an email to support@linoma.com so we can assist you with this issue. Thank you.

The instructions for running GoAnywhere on JAVA (JDK or JRE) version 1.6 is dependent on your operating system. Instructions for IBM i Customers: For IBM i customers on V5R3 of the operating system: IBM does not allow JRE 6 (JDK 6) to be installed on V5R3. To take advantage of future releases of GoA...

How to find and return the job number assigned by GoAnywhere to a project called from a CL program? The job number is printed in the job log. You will need to do a receive message in your CL (RCVMSG) to get the number. Here is a sample of the message: The job number is: 1292948216324. [2006 - Runtim...

How to determine the job name/user/number for a CL program called by a GoAnywhere Project. This sample project XML will allow you to get the user and job name as well as the job number from your called CL program. <project name="system i retrieve job d info " mainModule="Main" version="1.0" logLevel...

There are examples and tutorials as well as templates available to help you with this project. There are answers to commonly asked questions as well as project examples on our GoAnywhere Community Forum at https://www.goanywhere.com/forum To view the GoAnywhere web tutorials, click on https://www.go...

This project shows how to FTP a save file to the IFS and then send it to another System i. <project name="ftp save file" mainModule="Main" version="1.0"> <module name="Main"> <ftp label="FTP to IFS on Dev53" version="1.0" resourceId="Dev53"> <get sourceFile="/QSYS.LIB/DJOHNSON.LIB/TEMP1.SAVF" destin...

Is this something you need to do right away? Or is it something that can wait? We may be enhancing GoAnywhere Director with an option to include or exclude folders in the future.

We do have a temporary solution that may work for you but it will require more steps to exclude or include changes.

Yes you can create a GoAnywhere Project that uses the Surveyor/400 function to export a spool file. The Surveyor/400 command EXPSPL allows you to run a Surveyor/400 spooled file export without a GUI this allows you to embed it into your GoAnywhere Director project. Using this command you can export ...

Question: In /linoma/goanywhere/tomcat/logs there are a few hundred admin catalina host-manager localhost manager etc. logs. Can these be deleted? How long should we keep them? Is there a way to control retention within GoAnywhere? Answer: Yes the /linoma/goanywhere/tomcat/logs can be deleted. There...