Search found 591 matches
- by Support_Rick
- Wed Apr 19, 2017 4:57 pm
- Forum: Community Forum
- Topic: count rowset error
- Replies: 2
- Views: 21202
Can you show me your full project XML so i can see fully what you're trying to do?
- by Support_Rick
- Sat Apr 08, 2017 10:25 pm
- Forum: Community Forum
- Topic: Goanywhere FTP Uploaded Trigger Insert to SQL DB
- Replies: 2
- Views: 6547
This is a utility I created several years back... it should do what you're looking for. <project name="Write File Stats" mainModule="Main" version="2.0" logLevel="silent"> <variable name="trg_filename" value="" /> <variable name="trg_filesize" value="" /> <variable name="trg_filetype" value="" /> <v...
- by Support_Rick
- Thu Apr 06, 2017 4:20 pm
- Forum: Community Forum
- Topic: Question about projects
- Replies: 1
- Views: 5293
I'm not sure what you're asking ... can you please explain further?
- by Support_Rick
- Thu Apr 06, 2017 9:14 am
- Forum: Community Forum
- Topic: remove blank lines from text file
- Replies: 2
- Views: 7324
Have you tried the "ModifyRowSet" task?
- by Support_Rick
- Tue Apr 04, 2017 9:00 am
- Forum: Community Forum
- Topic: copying files based on rowset
- Replies: 8
- Views: 15445
Use the Current Item Variable, not the Rowset when accessing the information from within the excel spreadsheet.
- by Support_Rick
- Mon Apr 03, 2017 9:06 am
- Forum: GoAnywhere OpenPGP Studio
- Topic: How to create a seperate Public Key and Secret Key.
- Replies: 5
- Views: 49646
That's not how PGP Encryption works... You only ENCRYPT a file with the Public Key .. regardless. You only DECRYPT/SIGN a file with the Private Key .. regardless If you happen to have Both (Public & Private) and are wanting to encrypt with just the Public, that's what you're doing. You do not Encryp...
- by Support_Rick
- Fri Mar 31, 2017 8:29 pm
- Forum: Community Forum
- Topic: Database to excel 200 000 records, timing out
- Replies: 1
- Views: 6047
The biggest issue with creating an EXCEL file is that it is very memory intensive. If you only have 1GB or 2GB of JVM, you'll probably need to bump that up to around 6GB or 8GB to handle the memory needed to write 200k records to an EXCEL file. Keep in mind, a CSV does the same thing... opens in EXC...
- by Support_Rick
- Fri Mar 31, 2017 8:18 pm
- Forum: Community Forum
- Topic: big rowset
- Replies: 1
- Views: 21900
If the file is already in a "rowset", then you don't have to "split it up"... just loop through the RowSet (Use a For-Each loop)...
Then, if you need to "split" at each 65k limit, just put a counter inside your loop then change destination files as you write out each record to a target file.
Then, if you need to "split" at each 65k limit, just put a counter inside your loop then change destination files as you write out each record to a target file.
- by Support_Rick
- Fri Mar 31, 2017 8:14 pm
- Forum: GoAnywhere OpenPGP Studio
- Topic: How to create a seperate Public Key and Secret Key.
- Replies: 5
- Views: 49646
You'll have to provide more information as to what the issue is... You can only use a PUBLIC key to encrypt a file. PRIVATE keys are used for "signing" the file only. So, if you get the file from a Website ... and download it... you can encrypt it with any Public Key you have in your PGP Key Manager...
- by Support_Rick
- Fri Mar 31, 2017 8:07 pm
- Forum: Community Forum
- Topic: Question about projects
- Replies: 1
- Views: 5761
If the project is thread-safe ... then, under the Project level, set it to be Thread-Safe then they each will run concurrently. if the project is not thread-safe ... then, create a single-threaded job queue and submit the trigger to the job queue. It will run independently and in the order they were...