Search found 75 matches
- by Support_Duane
- Tue Feb 14, 2012 8:54 am
- Forum: Community Forum
- Topic: modifying variable values using regular expression
- Replies: 1
- Views: 6392
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: 6597
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: 7058
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: 7768
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: 7768
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: 11769
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: 6518
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: 6518
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: 5290
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: 10131
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.