Search found 34 matches

Search found 34 matches Page 3 of 4
by Support_Tim
Wed Jan 27, 2016 6:00 pm
Forum: Community Forum
Topic: Need to remove the last extra line from CSV file
Replies: 1
Views: 2203

Hello Sai, GoAnywhere will not add a blank line or empty record at the end of the file, so the blank/empty record is coming from somewhere. To find out, you can use a (temporary) print statement to write each record to the log or to a test file, then look there for the blanks. Setting the project to...
by Support_Tim
Mon Jan 25, 2016 5:38 pm
Forum: Community Forum
Topic: How to address a specfic cell in a rowset
Replies: 1
Views: 2540

Hi toniduquette, A Row Set variable is designed to be all inclusive to simplify the data translation process, but you can access data in a specific row of a rowset. You can create a forEach loop with a Current Item Variable and a Current Iteration Variable (Found on the Basic and Advanced tabs respe...
by Support_Tim
Mon Jan 25, 2016 5:35 pm
Forum: Community Forum
Topic: PDF To TIFF Conversion
Replies: 1
Views: 6561

Hi dhuesman,

If there is a product for your platform / OS that will allow you to convert a PDF to a TIFF that can be executed from a command line (not requiring interaction), then it should work from GoAnywhere by using the Execute Native Command (EXEC) task.
by Support_Tim
Mon Jan 25, 2016 3:39 pm
Forum: Community Forum
Topic: 'sqlcmd' is not recognized as an internal or external comman
Replies: 2
Views: 21846

Hi MPan20,

That was going to be the recommendation, so I am glad it worked out.

"It appears that GoAnywhere is not finding the command. Make sure that the SQL command is where GA can find it or you are using a qualified path name with your command."
by Support_Tim
Tue Jan 12, 2016 9:40 am
Forum: Community Forum
Topic: Using GoAnywhere Gateway as forward proxy
Replies: 2
Views: 1963

Hi AJ, If possible, I would start by making sure the SFTP server allows the user of a proxy by your SFTP client. I would also ask the following: Does your project and/or Resource test work without a proxy? Are you getting an external response at all? Does the outside firewall allow the outgoing conn...
by Support_Tim
Fri Dec 18, 2015 6:17 pm
Forum: Community Forum
Topic: Web users locked out, incorrect password
Replies: 2
Views: 4151

Hi Bob, Since the Secure Mail Plugin / Add-In for MS Outlook uses the web user account to send mail, whenever the password for this account changes, the settings for the plugin must be changed also. This is regardless of authentication method. Changing the Secure Mail Plugin password is simple. Just...
by Support_Tim
Tue Dec 15, 2015 5:41 pm
Forum: GoAnywhere OpenPGP Studio
Topic: No matching keys found in your keyring
Replies: 2
Views: 6210

Hi aclements, Do you have a file that was encrypted with a key pair elsewhere? IF the file was signed, you should have been provided a public key from the trading partner that sent you the file and imported it to your key ring. The most likely causes are either the public key you received from your ...
by Support_Tim
Thu Dec 10, 2015 9:20 am
Forum: Community Forum
Topic: ModifyRowSet
Replies: 1
Views: 1496

Hello bmuller, What type of file are your reading? Files that are read by GoAnywhere Director need to be data files and would not contain loops, but may contain segments (of sorts) if it is a XML file. Please also post the project XML code from your project. While in the project, click on SHOW XML t...
by Support_Tim
Thu Sep 24, 2015 2:55 pm
Forum: Community Forum
Topic: SQL Query is not returning results
Replies: 6
Views: 9742

Abarry81, When you access the current item variable of a rowset (version 2.0) you have to indicate the column index, even if there only one column. I meant to add it in the code but let it slip. Make your print statement look like this and it should work. ** This is the current item value: ${curItem...
by Support_Tim
Thu Sep 24, 2015 1:01 pm
Forum: Community Forum
Topic: Customize Logging to a Text file
Replies: 2
Views: 2428

Hello Emaestas, Yes, it is possible. Below you will see an example I created for this. It uses the Number of Files Copied variable ${fileCopyCount} and Destination Files variable ${destFiles}. These are specified on the Output Variables tab within a file creation task like Copy, Put or Get. To put t...
Search found 34 matches Page 3 of 4