Skip to content

Search found 9 matches

SQL Task: “When Data Not Found” Field

Question : What is the correct way of utilizing the “When No Data Found” field in the SQL Task? Answer : The SQL Task can connect to a database server for running SQL statements, which is useful for retrieving rows (records) from tables (physical files) or performing updates, inserts, etc. The data...

Resetting Passwords

Question : I have been locked out of my account. How do I reset my password? Answer : If you are a Web User who has been instructed to reset your password, you will need to contact a GoAnywhere administrator with the Security Officer role to do the following: - Navigate to Users > Web Users. Click ...

Promoting in GoAnywhere

Question : I see a Promote option on some items in GoAnywhere. What does Promote do and what features can I promote? Answer : Promotion is uploading a copy of an item from one GoAnywhere installation to another targeted installation. For example, after an item is tested, it could be promoted from t...

Web User permissions unchanged after removing them from the Web User Definition

Question: I have a Web User and I have removed the "Upload (Write)" permission directly from this Web User. Why is this User still able to upload files/folders? Answer: Is this Web User in a Web User Group? A Web User Group is an association of one or more Web Users. Each Web User Group c...

FileInfo function vs. fileName:fileAttribute syntax

Question: How do I utilize the FileInfo() function and the ${fileName:fileAttribute} syntax correctly? Answer: There is no real difference between these two methods. In fact, either one may be used to retrieve the attributes of a file. When using ${fileName:fileAttribute}, the fileName parameter can...

Set Variable Task 1.0 and 2.0

Question: What makes Set Variable Task 2.0 different from 1.0, and is there a way to change the version within a Project? Answer: Set Variable Task 1.0 The set variable task can set a variable's value to static text, to a variable previously defined in another task, to data from the first row of a R...

Regex Basics

A regular expression, commonly referred to as a "regex", is a pattern that can be used to search for and replace sets of characters in a given string of files. GoAnywhere supports the regex patterns available to the java.util.regex class. Example: Given the string "abc.txt", a se...

How to send an email from the "On Error" panel in a project

This document outlines the steps to send an email from a raised error. While it is not possible to configure tasks to perform from the On Error panel, it is possible to call a module where an email can be sent. First, create a new module (Project > Module) and give it a unique name. Next, create a S...

File Lists, RowSets, Email Lists

File Lists A File List references a set of Local File or Remote File objects and directories that were retrieved or processed by a task. A File List may be the result of one or more File Sets, which allows you to create a single File List that contains files from multiple directories and/or multipl...