Tel: 604-501-2001
Support: 289-480-1060
sales@robelle.com
support@robelle.com
Hours: 7am-3pm PST
July 3rd Canada Day
July 4th Independence Day
Aug 7th Civic Day
Sep 4th Labour Day
Oct 9th Canadian Thanksgiving
Nov 13th Remembrance Day
Nov 23 US Thanksgiving Day
Nov 24 US Tryptophan Recovery Day
Dec 25th Christmas
Dec 26th Boxing Day
Jan 1st, New Years Day
Suprtool and Qedit: still enhancing, always backwards compatible
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.
October Newsletter.
The latest Newsletter has been distributed and is available in the newsletter section.
2022/10/28
Our Fax Number is no More.
Much like the Parrot in the infamous Monty Python Dead Parrot sketch, our Fax machine will soon be no more. In all seriousness, though we will be getting rid of the separate fax number, you may still be able to send a fax, however, you would need to call in to the office beforehand.
2022/09/28
Qedit/ Open Now Supports Visual Mode
Qedit/Open now supports visual mode on HP terminals. We are looking for beta testers to play with Qedit on Linux and give us some feedback.
2022/08/25
Qedit and Suprtool 6.4 released.
Suprtool and Qedit 6.4 have been released, the big news on Qedit is that the majority of the code and features have been ported to Linux, just like Suprtool has. Rport, the report writer has had some spacing improvements. Suprtool/Open has had some bug fixes to the Big Endian to Little Endian transformation.
This is the biggest request we have had to add to Qedit in quite some time, mainly to port their applications from HP-UX to Linux. While, Qedit / Open doesn't currently have visual/screen mode or server mode, the line editor functions are all working as you would expect. So text/keep, change, delete, add, append, etc all work as expected.
If you're interested in trying out Qedit on Linux or need additional information? Contact Neil Armstrong.
10/05/2021
10/29/2020
03/29/2020
03/21/2020
03/01/2020
I was asked for a method/trick for roughly calculating age. The customer was finding sometimes they were off by one. I realized that this may be due to rounding and came up with the following calculation.
>in dates >list >xeq >IN DATES.NEIL.GREEN (0) >OUT $NULL (0) CURR-DATE = 20200121 BIRTH-DATE = 19480526 >in dates >item curr-date,date,ccyymmdd >item birth-date,date,ccyymmdd >def age,1,4,double >ext age=$truncate($abs($days(birth-date) - $days(curr-date)) / 365) >list >xeq >IN DATES.NEIL.GREEN (0) >OUT $NULL (0) AGE = 71In retrospect it might be worthwhile using 365.25 as the dividing factor, but it likely won't make much of a difference.
02/21/2020
Hello, I have a question for youis there a way to replace all nulls with spaces in Qedit?
Tq filename Set decimal on Cq '0 " " all Kq,yes ExitSo the set decimal on is the key which tells qedit that the single quote followed by a number will be treated as the decimal equivalent, which for null is a single quote, so the two key things here are:
Set decimal on Cq '0 " " all
01/21/2020
It is advisable to check your suprmgr files for the Set Date Cutoff Command value and increase it to be greater than 20. If not it is likely that you will have issues with dates in 2020, will end up with a century value of 19, instead of 20. For details on Set Date Cutoff please see: Set Date Cutoff.
01/01/2020
The latest Robelle Newsletter has been sent out and is available online.
11/20/2019
We received some sad news in the 3000 community, Alan Yeo, founder of Screenjet has passed away, details in a letter from Michael Marxmeier of MarxMeier Software:
It is with great sadness that we write to inform you that Alan Yeo, founder of Screenjet Ltd. has passed away. He will be greatly missed as a friend and colleague, having worked with many of us for decades.
ScreenJet and Marxmeier Software have had close ties for a long time. Alan Yeo was a valued board member for Marxmeier Software and Michael Marxmeier is a director at ScreenJet.
Marxmeier Software has assumed additional responsibilities to ensure the continuation of ScreenJet products and services. As of June 2019 all support, license renewals and upgrades are being administered by Marxmeier Software. This will not affect any ScreenJet customer product licenses or agreements which will remain with ScreenJet Ltd. The teams at ScreenJet and Marxmeier will combine there long time experience and resources to guarantee efficient and reliable ongoing support and services. We look forward to continue working with you in the future.
If you have any questions or concerns please feel free to contact us at anytime. You can reach us at mike@marxmeier.com or by phone at +49 202 243140.
Sincerely,
Michael Marxmeier
for the Marxmeier and ScreenJet team
10/17/2019
The first week of June is my work anniversary at Robelle, so to celebrate
I am putting out a call for Alpha testers of a new Report Writer.
If interested, please e-mail me at neil@robelle.com.
Primarily to start we can send MPE and HP-UX versions out, the Open version will be made available soon.
06/03/2019
The April 2019 Newsletter is out and has been distributed, with lots of good feedback.
04/18/2019
03/21/2019
03/21/2019
I got a chuckle when I read your chronology of the HP3000, and in particular this message on the webpage brought a smile.
Early in my career with HP (I started in 1975), I was attending training in Cupertino, and toured the area where the HP3000 units were in final test. These were the original HP3000 units, before the HP3000 CX. They had wire-wrapped boards, and all of the sudden, none of the machines would run for more than a short time.
When a wire wrap board is manufactured, the operator of the wire-wrap machine will insert a wire into the unit, then place the units small cylinder over a pin on the back of the board (the boards looked like a bed of nails onto back, with a pin for every connection that was possible). The operator would then pull a trigger to cause the wire to be wrapped around the pin, stripping the insulation from the wire as it was wrapped. The operator would then route the wire to the pin it was to be connected with, and repeated the process. You could wrap several wires on the same pin, so that the signal could be sent to other pins.
My memory was that there was one operator who did the wire wrapping for every HP3000 made. HP manufacturing engineering folks were in a panic, because none of the newly made HP3000 units would work, and no one knew why.
I remember the revelation when it was found that only the neat looking boards failed, the messy ones seemed to work OK. The wire-wrap operator had decided to improve the aesthetics of her work, and began to route the wires vertically and horizontally to make the resulting boards look neat and tidy. She did not realize that when two wires are routed side by side, interference will be transmitted from one wire to a neighboring wire. When the wires are routed point to point, and not vertically and horizontally, the wires typically cross one another, and no cross talk.
When we had new boards made, and requested that the wires be routed "point to point, everything started to work again. It was not very long until the wire wrap boards were replaced with printed circuit boards.
Ted Workman
Taunton, Mass
05/18/2018
I read with interest your article about the history of the 3000. Of particular interest was the part that said "The Alpha was announced as the HP 3000 with a fancy cabinet of pizza-oven doors, available in four colors.".
I once saw a HP 3000 which was multiple cabinets, each of which had many wood-grain doors which were the 19" width of the rack by perhaps 10" high, each of which had an Ace lock (round key, like on vending machines). I be- lieve that at least some of the compartments behind these doors held wire- wrap boards, not etched PCBs. The "console" was a table with a pair of CRTs in the middle, and to the left and right of these CRTs were large panels full of LEDs, with stenciled-and-varnished designations for each LED. I was told that one CRT was reserved for maintenance functions, while the other was the OS operator's console.
Does this ring any bells? Was this a prototype? It doesn't sound anything like any other description of a 3000 that I've read.
This would have been in 1974 or 1975..."
Thanks, Terry Kennedy (www.tmk.com)
05/09/2018
Dave Wiseman has announced a meeting of SIGBAR in June in Silicon Valley, funnily enough I had just signed up for the Silicon Valley Gran Fondo which will be on the same weekend.
We had such good times together for 25 years - I bought an HP3000 Series II for Commercial Union Assurance in the 1970s and stayed within the community until the early 2000s with Proactive and Millware - and it would be great to meet all our old friends again.
We are planning a social meeting in June 22-23 in the Santa Clara/Cupertino area, exact venue to be decided when we know numbers. There may be a small charge for the venue hire and we have two optional excursions we can organise for a small charge. Please use the link below to express your interest and book your flights NOW.
1. The Computer History Museum is in the vicinity and is on our list of potential venues. There will be an entrance fee and we can organise a group visit, even if it is not our meeting venue,
2. Remember the company at 19220 Pruneridge in Cupertino? Well, we have organised a tour of the address, which is now the Apple HQ visitor centre and will even hire a bus to and from the venue if enough people are interested. The charge will be around $10-$15 for the transportation.
Wherever the event is held, we will organise food and drinks to be available for purchase. Lastly, if a few vendors who made there money from the community could help sponsor the event we may be able to pay for all of this.
PLEASE share this email with anyone you know from the HP3000 community
Any questions? Please feel free to contact me directly - my email/Skype are below
https://form.jotformeu.com/80934801853359 Dave Wiseman
davebwiseman@googlemail.com
+44 777 555 7017
Skype: davebwiseman
04/09/2018
The latest newsletter has been posted to the Newsletter page, but you can read directly from this link.
07/11/2018
The January 2018 Newsletter has been send out to all our customers. It has some excellent articles, of note is an article on AI from Gavin Scott.
02/02/2018
Suprtool 6.0 has been released as the production release. This version contains many new features and bug fixes:
01/29/2018
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.
See the Daily Support Issues HPUX Variables.
03/10/2017
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
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
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.
11/30/2016
The Qedit for Windows Server has some important security updates, which helps improve the login security and error handling of Qedit and Qedit for Windows access. See What's New In Qedit for details and to request a download
11/08/2016
Our robelle.com mail service is currently down, but it is being worked on currently. You can reach me at: neilpatrickarmstrong@gmail.com for any and all questions.
This issue has since been resolved.10/06/2016
I recently needed to remove a bunch of spaces and needed to compress some data down and found that tr -s was exactly what I needed.
more taxref
6212301245700000123456 00000588005617512580 JOHN SMITH 0042158657802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042198757802577
6212301245700000123456 00000600005617512580 SHARON JONES 0042198757802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042158657802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042198757802577
6212301245700000123456 00000600005617512580 SHARON JONES 0042198757802577
tr -s " " >newtax
more newtax
6212301245700000123456 00000588005617512580 JOHN SMITH 0042158657802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042198757802577
6212301245700000123456 00000600005617512580 SHARON JONES 0042198757802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042158657802577
6212301245700000123456 00000588005617512580 JOHN SMITH 0042198757802577
6212301245700000123456 00000600005617512580 SHARON JONES 0042198757802577
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
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:
base custdb,1,;
get customers
if custno="12345"
item follow-up-date,date,ccyymmdd
update
ext follow-up-date=$month(follow-up-date,+3)
xeq
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
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 :
Append "~" "Transaction"
Glue "~"
ch "~" " @
Here is the data:
qux/lq all
Transaction Date: 20160908
Balance: 1245.85
Transaction Date: 20151213
Balance: 908.54
Transaction Date: 20121221
Balance 125.44
Here is the code in action:
qux/append "~" "Transaction"
1 Transaction Date: 20160908~
3 Transaction Date: 20151213~
5 Transaction Date: 20121221~
3 lines appended to
qux/glue "~"
1 Transaction Date: 20160908~Balance: 1245.85
3 Transaction Date: 20151213~Balance: 908.54
5 Transaction Date: 20121221~Balance 125.44
3 lines Glue-updated
qux/ch "~" " @
1 Transaction Date: 20160908 Balance: 1245.85
3 Transaction Date: 20151213 Balance: 908.54
5 Transaction Date: 20121221 Balance 125.44
3 lines changed
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
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:
base custdb,1,;
get d-custdata
clean "^9:^13"
if $findclean(e-mail-address)
update
ext e-mail-address=$clean(e-mail-address)
xeq
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
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 is now available as a pre-release. You can read a summary of What is New, in What's New.
08/25/2016
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.
08/01/2016
The latest Robelle Newsletter is now available.
06/27/2016
We've been busy adding new features to the Suprtool Suite of products, namely with the JSON option in STExport and more recently we've added access to MYSQL databases in Suprtool/Open.
>OPEN MYSQL robelle_4 Jz2xrwX tream_robelle dbserver.robelle.com
>SELECT * FROM ALL_TYPES
>FORM
Column Len Offset Type
TINYINT 4 0 Tiny
SMALLINT 6 3 Short
MEDIUMINT 9 9 INT24
INT 11 18 Long
BIGINT 20 29 LONGLONG
FLOAT 6 49 FLOAT
DOUBLE 8 55 Double
DECIMAL 10 63 NEWDECIMAL
CHAR 20 73 String
DATE 10 93 Date
DATETIME 19 103 DateTime
TIMESTAMP 19 122 TimeStamp
TIME 10 141 Time
YEAR 4 151 Year
>LIST
>XEQ
>SQL (1) >OUT $NULL (0)
TINYINT = 1 SMALLINT = 2
MEDIUMINT = 3 INT = 4
BIGINT = 5
FLOAT = 6.01 DOUBLE = 7.02
DECIMAL = 8.03 CHAR = MYCHAR
DATE = 2016-02-26 DATETIME = 2016-02-29 02:15:22
TIMESTAMP = 2016-02-26 15:06:39
TIME = 15:06:39 YEAR = 2016
>SQL (2) >OUT $NULL (1)
TINYINT = 1 SMALLINT = 2
MEDIUMINT = 3 INT = 4
BIGINT = 5
FLOAT = 6.01 DOUBLE = 7.02
DECIMAL = 8.03 CHAR = MYCHAR
DATE = 2016-02-26 DATETIME = 2016-02-29 02:15:22
TIMESTAMP = 2016-02-26 15:06:50
TIME = 15:06:50 YEAR = 2016
IN=2, OUT=2. CPU-Sec=1. Wall-Sec=1.
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
You may have read on HP3000-L about the Computer History Simulation Project and the Emulated HP3000 that you compile and build yourself.
Read the details at the top of the page about the SIMH Emulator.
04/05/2016
04/04/2016
02/02/2016
01/25/2016
01/19/2016
12/15/2015
11/24/2015
What do you do when you try downloading a file to your HP 3000 and you always get a single line file?
Read some suggested tips about One Line files.
9/17/2015
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
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.
You can refer to the Qedit For Windows Scripting Language manual for details.
5/21/2015
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
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 there 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
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 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
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:
run suprtool.pub.robelle BASE macord.macsdata.test,1,DOALL GET customers TRANSLATE TOUNREAD UPDATE EXTRACT name=$translate(name) EXIT
1/13//2015
Suprtool 5.7 is available as the production release, you can read about the various enhancements and bug fixes in the various change notices.
12/31//2014