Search found 591 matches
- by Support_Rick
- Fri Jan 20, 2017 9:35 am
- Forum: Community Forum
- Topic: .NET functions to encrypt and decrypt files in a folder
- Replies: 5
- Views: 10179
Steven,
The Free version is just a plain FTP Server/Client. All accessible tasks in the projects are only related to that usage. Encrypting/Decrypting and Zip/Unzip, etc ... all of the functionality outside of basic FTP isn't available without purchase.
The Free version is just a plain FTP Server/Client. All accessible tasks in the projects are only related to that usage. Encrypting/Decrypting and Zip/Unzip, etc ... all of the functionality outside of basic FTP isn't available without purchase.
- by Support_Rick
- Fri Jan 20, 2017 9:25 am
- Forum: Community Forum
- Topic: How to allow MKS Implementer to work with GoAnywhere?
- Replies: 4
- Views: 10460
Rob, How are you wanting to integrate with MKS? GAMFT can connect and transfer files between servers easily. It can insert records into a DB2 table as well as the IFS. Are you wanting GAMFT to do the transfers of updated files/tables? Are you wanting to just push data? What are you looking at doing?
- by Support_Rick
- Wed Jan 18, 2017 8:51 am
- Forum: Community Forum
- Topic: .NET functions to encrypt and decrypt files in a folder
- Replies: 5
- Views: 10179
GAMFT has an API interface so it can be called (trigger file movements) from external sources (programs, CLP, RPG, C#, .NET, etc). You define the file movement through a GAMFT Project (Copy, Encrypt, Decrypt, SFTP/FTP, etc) then trigger the movement from a Schedule, Monitor or external source, etc. ...
- by Support_Rick
- Tue Jan 17, 2017 5:37 pm
- Forum: Community Forum
- Topic: How to get Stored Procedure Out parameter values
- Replies: 1
- Views: 6060
The In/Out variables do not work that way through the JDBC connection.
You will need to write the "out" values into a temp table or CSV, then read them (select * from tempTable) or ReadCSV task from within your Project to return those values to your Project.
You will need to write the "out" values into a temp table or CSV, then read them (select * from tempTable) or ReadCSV task from within your Project to return those values to your Project.
- by Support_Rick
- Tue Jan 17, 2017 10:04 am
- Forum: Community Forum
- Topic: .NET functions to encrypt and decrypt files in a folder
- Replies: 5
- Views: 10179
GoAnywhere MFT does this for you automatically by designating any folder (that you have permissions to) as an encrypted folder. Then, any file put into or pulled from the folder through GAMFT is automatically encrypted when placed or decrypted when pulled.
- by Support_Rick
- Tue Jan 17, 2017 9:14 am
- Forum: Community Forum
- Topic: Error in SQL insert
- Replies: 10
- Views: 25579
Falak,
Please review the "READCSV" task. It reads the csv file into a Rowset. Then, you use that Rowset to insert data into your Database. You do not have to do the "load data" command.
Please review the "READCSV" task. It reads the csv file into a Rowset. Then, you use that Rowset to insert data into your Database. You do not have to do the "load data" command.
- by Support_Rick
- Mon Jan 16, 2017 8:19 am
- Forum: Community Forum
- Topic: Error in SQL insert
- Replies: 10
- Views: 25579
Doing a search on the GoAnywhere Forum for "CreateCSV" you'll find some articles that will help you with this... https://forum.goanywhere.com/can-i-change-the-headings-in-a-csv-file-635 https://forum.goanywhere.com/writing-to-csv-or-flat-file-without-rowset-852 Please review those and you should see...
- by Support_Rick
- Wed Jan 04, 2017 4:56 pm
- Forum: Community Forum
- Topic: Concatentation
- Replies: 1
- Views: 4904
For your output file under the Zip Task ... just put this as the parameter:
${Concat( 'zipfile ', currentDate( 'MM-dd-yyyy' ), '.zip' ) }
${Concat( 'zipfile ', currentDate( 'MM-dd-yyyy' ), '.zip' ) }
- by Support_Rick
- Wed Jan 04, 2017 4:54 pm
- Forum: Community Forum
- Topic: Issues with SFTP Get Files command
- Replies: 7
- Views: 15117
Please send me your full Project XML as well as the latest JobLog in DEBUG mode.
This way I can review it...
This way I can review it...
- by Support_Rick
- Wed Jan 04, 2017 4:35 pm
- Forum: Community Forum
- Topic: fileinfo with variable as filepath
- Replies: 3
- Views: 24567
The parameter for the FileInfo command has to be a STRING. Thus,
${ FileInfo(String( item ) ):exists }
Should get you what you're looking for!
${ FileInfo(String( item ) ):exists }
Should get you what you're looking for!