Search found 75 matches

Search found 75 matches Page 2 of 8
by Support_Duane
Tue Feb 14, 2012 8:54 am
Forum: Community Forum
Topic: modifying variable values using regular expression
Replies: 1
Views: 3164

Before version 4.0, it was not possible to use a regular expression in a Set Variable task. At version 4.0 and beyond, the Replace(text, regex, replacement) function may be used.
by Support_Duane
Thu Oct 20, 2011 11:43 am
Forum: Community Forum
Topic: SetVariable
Replies: 1
Views: 3597

There are two versions of the SetVariable task. You can use the SetVariable Version 1 task anywhere but it will only get data from the first row of the rowset or fileset. If you want to loop thru the rows of a rowset or filest, you need to use the SetVariable version 2 task. If you are just changing...
by Support_Duane
Mon Aug 15, 2011 1:22 pm
Forum: Community Forum
Topic: Windows RUNPROJECT command
Replies: 2
Views: 3353

Port 8001 is usually reserved for https so you would either need to specify - https://as400uat:8001/goanywhere or change the port to read - http://as400uat:8000/goanywhere
by Support_Duane
Wed Aug 03, 2011 8:44 am
Forum: Community Forum
Topic: WRITE EXCEL TASK
Replies: 3
Views: 3383

There is no need to add it to any of the GoAnywhere folders, but it does need to be in a folder located on the same system in which GoAnywhere is running. Then you just reference it from the Write Excel file task.
by Support_Duane
Tue Aug 02, 2011 4:48 pm
Forum: Community Forum
Topic: WRITE EXCEL TASK
Replies: 3
Views: 3383

An Excel template file is nothing more than another Excel file with the headings and formatting that you want to specify for your file that you're creating in GoAnywhere Director. i.e. there is no specific requirement for a template file, it can be any Excel file you choose.
by Support_Duane
Mon Jun 27, 2011 11:18 am
Forum: Community Forum
Topic: retrieve file information?
Replies: 5
Views: 4902

Use the print statement to write the last changed date out to a file, then read it in as a delimited file using a space as the delimiter. You then have to do a set variable version 1.0 task to get the date out of the rowset. It will be in yyyy-MM-dd format. If you don’t want the dashes, you can do a...
by Support_Duane
Wed May 18, 2011 2:21 pm
Forum: Community Forum
Topic: How do I end a project when sql stmt returns 0 rows
Replies: 2
Views: 2851

You could also place an entry in the "When No Data Found" field. The options are "continue" (the default) and "error" which throws an error and, depending on how "on Error" is set, can end the project at that point.
by Support_Duane
Wed May 18, 2011 11:04 am
Forum: Community Forum
Topic: How do I end a project when sql stmt returns 0 rows
Replies: 2
Views: 2851

Add another query after the select statement query to count the rows selected. Something like : select count(*) from library.filename. If your select statement has a where clause, add that to this statement also. Add a Set Variable version 1.0 task (you’ll have to click the Include Prior Versions bo...
by Support_Duane
Mon Apr 04, 2011 9:15 am
Forum: Community Forum
Topic: transfer file via webdav?
Replies: 1
Views: 2432

As of version 3.5.1 GoAnywhere Director does not have a WebDAV extension.
by Support_Duane
Tue Mar 29, 2011 1:03 pm
Forum: Community Forum
Topic: LDAP Authentication
Replies: 2
Views: 5004

The certificate/chain needs to be imported into GAD/GAS's default trusted certificate store. When specifying the LDAP/Active Directory URL, type the URL using "ldaps://" instead of "ldap://" if secure connection is desired. A restart may be required after importing the certificates.
Search found 75 matches Page 2 of 8