Search / Downloads

Suprtool/Open: our latest product offering, can go wherever you want to go:
With other products, migration may involve recoding and retesting with only a subset of functionality. But our new Suprtool/Open is a complete migration of Suprtool.
See the latest information at: Suprtool/Open.

News

Robelle's Neil Armstrong Wins National Title

As some of you may know Neil Armstrong, Robelle's Software Architect is an avid cyclist and
has recently started racing on the track. This past weekend, Neil won the
500m Time Trial for his age group 50+.

From a standing start he did the 500
meters in 36.830 seconds, which is 48.873 KM per hour. His last 250 after
getting up to speed was 15.2 seconds which is an average of 59 Km/hour.

He
was going for the Canadian record, but missed by .3 seconds. He says he made some
mistakes on the start and in one of the corners so the goal will be to get
the record in March 2018 at the Provincial Championships.

So not only is Suprtool fast but the Architect and programmer behind Suprtool is as well.

10/03/2017

Using a Variable on HP-UX in Suprtool

Added to the daily support issues page is a quick tip on using variables
inside suprtool and another tip on how to get the hour from the date command.

We have released a new Suprtool Pre-Release in the last week or so. Suprtool has a
few new text handling functions and some new features in the handling of leading zeroes. A final new feature is you can extract the input record number as a double integer and you can
also test via the if command.

03/09/2017

Daily Support Issues

We have started a new page which will outline Daily Support Issues
that come up. Hopefully what helps one customer will help another.

01/05/2017

Suprtool 5.9 and Qedit 6.2

A new version of Qedit 6.2
and Suprtool 5.9
have been installed into production. Qedit has a very important security update in the Qedit for
HP-UX server. Suprtool, has a new $month function, STExport has JSON support and other new features.

Although this may not be exactly what you need it certainly helped me compress down some data and get ride of a lot of extraneous spaces.

09/07/2016

Adding Months to a Given Date

There is a new feature in Suprtool 5.8.10 and higher which allows a user to add a number of months to a give date. Let's say you have to follow up with a customer in three months, a simple Suprtool task can do this:

This was done due to a direct request from one of our customers. One of the features of this is that if a month does not have the same number of days, Suprtool will find the
closest date. For Example, if the +1 is invoked for a date that is say August 31st, the resulting date would be "September 31", which is of course incorrect. Suprtool will adjust
the date to be a correct date of September 30th.

09/14/2016

Glueing Lines

Occasionally we get requests to summarize data or manipulate reports to be re-organized. One common manipulation is to stick the contents of one line onto the end of another based on the a value in the first line.
The commands to do this are fairly simple :

The Append command sticks a Tilde on the end of the line, and the glue command, glues the line after the Transaction line onto the end. Tilde is used since it isn't often in normal files, you can look to insure that
the tilde is not in the file with a simple: ch "~"~" @, to see if there are any occurences.

09/08/2016

Cleaning Your Data

Occasionally we get updates to customers e-mail addresses and often these e-mails have bad data in them. Over the past years I have tracked the bad data to be, Tab, Carriage Return or Line Feed. Luckily
we have Suprtool to fix the data in very few commands:

We specify Decimal Nine thru to Decimal 13, which is Tab thru to Line Feed, we use $findclean to find the entries and we update and run the extract of the e-mail address thru the $clean function and the data gets fixed and updated in one easy step.

09/07/2016

New Code Generation Pages

Have our website generate your Suprtool code for you. We three new forms to help generate code, Standard Suprlink Task, Select using a table, and Update using a Table. See our Code Generation Page.

09/06/2016

Suprtool 5.8.11 Available

Suprtool 5.8.11 is now available as a pre-release. You can read a summary of What is New, in What's New.

08/25/2016

Robelle WebSite Update

The Robelle Web Site has been updated using Bootstrap 4, to provide a more Mobile friendly look and feel. As always please send feedback to neil@robelle.com.

We are looking for anyone who has MYSQL data and knows a little about Suprtool. We are looking at
what to do with certain fields and how to handle some data types and the most common data types using
in MYSQL.

If you're interested in trying this new feature out or have any questions, let me know by e-mailing Neil@robelle.com.

Keep in mind that this products is currently just in our little wind tunnel, but it does extract data, list to the terminal
and output to link/SD files. We are interested in getting feedback to look at the direction of how to handle some data types.

05/02/2016

The Computer History Simulation Project

You may have read on HP3000-L about the Computer History Simulation Project and the Emulated HP3000 that you compile and build yourself.

I'm looking for people to test the code generation for for input from Oracle Form Output. This form will take in the output from a form command after the Open / Select commands have an active Oracle table.

You can try this new form out at Oracle Form to Code.
Any feedback can be addressed to neil at robelle.com.

7/17/2015

Adding a Line Before and a Line After a String

Recently I was asked how to find a line and add a line before the line and how to add a line after. This is always fairly easy using host based
commands, but since this customer did not have the host-based version of Qedit, but rather the
Server only version and Qedit for Windows. Therefore my other option was to Add Lines Before and After a Line using Qedit for Windows Scripting Language.

A number of customers have been requesting where to download Suprtool from for Amisys 6.7. The summary of
what changes have been made to Suprtool under What's New in Suprtool Section.

You can click on the link "Request a Download" at the end of the list of enhancements etc. You can also go directly to the form to
Request a Download and please note that at the end of the form you need to
scroll down and enter the captcha information in the box provided at the bottom of the page.

5/13/2015

Suprtool Code Generation ~ CSV file

A second form has been added to help generate Suprtool code. The purpose of this form is to generate code where it would take in a CSV file make it fixed
length and split the various fields into their intended native type. A form of a dataset or SD file can be used to generate the code.

This is currently just an experiment but we plan on expanding and already have a few ideas for some other code generation. You can try it out
by going to this form:
Form To Code

You enter a start position and paste in the form of the dataset you want define and extract commands for and you are taken to a page with then generated code on it.

4/24/2015

Suprtool Code Generation

A new form has been added to help generate Suprtool code. The purpose of this form was to help a customer with some code generation
where files would have some fields at the beginning and then an entire dataset in the file. So the dataset would start at a position
that was not the first position and was not in a self-describing file.

So the code generator form will take in a form from a dataset and a start position and generate all the coded defines and extracts.

This is currently just an experiment but we plan on expanding and already have a few ideas for some other code generation. You can try it out
by going to this form:
Form To Code

You enter a start position and paste in the form of the dataset you want define and extract commands for and you are taken to a page with then generated code on it.

More refinements will be done but at this time this is just a test project.

4/22/2015

Oracle 12 Compatibility

Oracle 12 has some changes in it that doesn't allow for older versions of Suprtool to connect to
databases using the Oracle 12 client. Suprtool 5.7 Build 6 and higher now properly connects to Oracle
databases using the Oracle 12 client.

This impacts Itanium and Open versions of Suprtool.

1/27/2015

Obfuscating Test Data (Follow-up)

In 2014, Robelle support was asked for a method to Obfiscate or make unreadable some
test data. We came up with a method and documented it in
this HowDoI article.

Taking this article and the need for many of our customers needing to do this, we enhanced Suprtool to have a function that would translate characters in
such a way as to make such fields as the Company Name, First/Last name of people etc to be unreadable in a quick and easy manner. This is
intended for when you make copies of test data and want to make some of these fields unreadable.

So instead of using the Table and having define each field, you can now do the following: