Search found 591 matches

Search found 591 matches Page 2 of 60
by Support_Rick
Wed Apr 19, 2017 4:57 pm
Forum: Community Forum
Topic: count rowset error
Replies: 2
Views: 20231

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: 6446

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: 5216

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: 7191

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: 15214

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: 48376

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: 5944

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: 20966

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.
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: 48376

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: 5637

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...
Search found 591 matches Page 2 of 60