The job involved building and testing the company product ("Converter") which took PL/1 modules (for the mainframe) with embedded SQL and converted them into Java. The Java modules would then run inside a Java Virtual Machine supported by a set of in-house built Java support libraries ("TechSupport") which handled the annotations, mappings, database access, etc in the generated code.  We were converting the last 3 major versions of Allianz Business System ("ABS") and the subsidiaries' specific overrides. I worked in the TechSupport team.

Day to day this meant running the Converter on the ABS code, modified with subsidiary code and running it through the simulator. This ran the tests in a VirtualBox environment and compared the results to the same run using the original PL/1 compiled modules instead. The PL/1 code was 500K to 11M LOCs depending on subsiduary, 60 years old and had had thousands of developers working on it over the years using many different styles, syntaxes and dialects of PL/1. As the converter came across a new scenario it would produce: invalid code that did not compile, code which compiled but crashed at runtime, compiled but produced the wrong results or code that was not compatible with the current version of TechSupport. We had to find the problem code, read the corresponding PL/1 code and work out what the correct Java should be and feed that back to the developers of the converter or update TechSupport ourselves. If the problem could be fixed by applying a patch to the PL/1 source pre-converter or a patch to the Java source post-converter then an assessment to determine the priority of adding it to the converter took place. We all got a nice feeling when we upgraded the converter as it meant we could drop a set of patches as maintaining all the patches as code shifted around was a bit of a nightmare! The goal was a Converter requiring no patches which converted all the code and produced the same results as the PL/1 run.

The process of checking the code was very time consuming. When I arrived it took about 12 hours to do 1 complete test run. By the time the project ended I had re-engineered the process down to taking only 1.5 hours by distributing the work across several VirtualBox nodes, using chained Jenkins tasks and inventing a branching strategy which allowed us to deal with differentials of changes when determining which task to run next.

The nature of the project meant that there was a lot of manually inspecting PL/1 source of different versions to see why the converter was no longer able to convert that module. There was an equal number of inspections that would happen on the Java side too as the converted code moved around. I wrote a side project using ExpressJs and ReactJs in order to simplify this process. Users could run the application locally and point it at the directories containing the different versions. It was more than just a diff application as it had different ways of searching for files, allowed bookmarks and could compare different subsidiary subfolders in the 2 main directories.

There were dependencies between the Converter version, TechSupport version and customer code versions so we needed to be very sure about our versioning, release procedures and documentation. I used Japicmp to ensure our semantic version numbers were being adhered to. The release notes had to contain the state-of-play i.e. which bugs had been fixed since the last version. I utilised GitLab APIs to query GitLab bug/milestone/etc information to do this and wrote a lot of smaller scripts to parse result files to build the final release documentation.

During the project I became the go-to guy for questions about Git and so when we had to split a 10GB repository into smaller pieces, remove directories of binaries that should never have been checked in while retaining all the history then everyone volunteered me for that job ;)

The project had expanded a lot since I started. We now had a Git repository for TechSupport, a different Git repository for each subsidiary, a host of versions which needed to be managed, our internal jFrog repository (that I managed), external jars released by the customer on an adhoc basis, peripheral software for generating release documentation and dealing with VirtualBox snapshots. We needed a new way of managing and releasing our code. I was in charge of defining and documenting a GitFlow which was specific for our set of projects. I produced detailed documentation of different use cases at pinnacle points in the project workflow. These described with diagrams how to interact with the source controller, when and where to create labels, branches and how they should be named. Workflow use cases went from what to do after you assign a bug to yourself, knowing where to branch from and what to call your branch in a simple situation. In a more complicated situation, creating a hotfix for TechSupport for just one subsidiary and ensuring that after each further release those hotfix patches could still be reapplied to make a tailored customer version to accompany each 'normal' version, until just time that we could upgrade all the customers on to the new major version.

I had demonstrated that my knowledge base was extensive and covered a lot of different and distinct technologies. As a result people started to invite me on to projects that weren't really anything to do with the TechSupport side of things. These included fixing an AngularJs program that someone had written ages ago for the customer but had left the company, re-writing the VirtualBox API layer to control taking snapshots, creating a JNDI module to interact with binary code, adding basic authentication to another webapp, noticing 3rd party jars had been updated, pulling them into our jFrog and updating settings files so that things were automatically upgraded, obfuscating the deliverables, etc.

There was quite a high churn of people on the project and so I often found myself mentoring new people and bringing them up to speed. At this point the Converter was finished enough that no more work was going to be done on it and it moved from a development project to a maintenance project at which point everyone was let go except for me. I was kept on for a little bit longer to handover to the maintenance team as I was the only person left from the original project and the only person who knew and understood the decisions we made at the beginning and why we made them. I imparted this knowledge on to the maintainance team and answered their questions about the history of the project.

I like computer art and so for fun I produced a set of graphviz diagrams to represent the nature of the data being used on the project - because that is fun for me :) In this case I graphed the interaction between all the modules i.e. which modules called which other modules. When I presented my findings at Friday Fun it showed that the customer was trying to get us to convert 2 source code bases for the price of one! It went quiet for a bit then suddenly there was a load more money from the customer!

Friday Fun was something I invented as a bit of fun after the Friday meeting. I demonstrated my art and the support applications I'd written and other people did things that they were passionate about, not necessarily about computing, just anything they thought would be fun. I've heard from one of my ex-colleagues that he set up Friday Fun at the company he worked at after this project :)

• Languages: Spring Framework/Java, Maven/Gradle, Tomcat, Japicmp, Microfocus/PL1/JCL, scripting in bash, python, Node, NextJs, React
• Platforms: Google Cloud Platform, JFrog admin, VirtualBox, Linux, RedHat, Windows 10, MSYS2
• Source controller: Gitlab+notifications/triggers, Git.
• Automation: Jenkins
• Press: Google Helping customers migrate their mainframe workloads to google cloud ; Examining Allianz Technologys Decision to Replatform

Original post blogged on b2evolution.

jQuery plugin that draws a box over an image.

The best way to demonstrate this jQuery plugin in action is with a demo. If you'd like to know more then checkout the README

Code

GitHub
Project page	https://github.com/davidnewcomb/jquery-imgbox
Clone	https://github.com/davidnewcomb/jquery-imgbox.git
Zip	https://github.com/davidnewcomb/jquery-imgbox/archive/master.zip

Information to help locate you

I'm listing all the information I have about you now in the hope that you (one day) Google yourself and find this page.

Educaton	Osaka University
Course	Human folksonomy
Date of birth	around 1973 similar age to me
Your business card read	Osaka Gakuin University Master Course

Where we met

We met at Minneapolis International Hostel at 2400 Stevens Avenue South in the Summer 1996. I think we had both graduated that year and were seeing a bit of America, me for a holiday and you to potentially come to study there.

Photos

I took this photo. We went cycling around Minneapolis on some bikes we had borrowed from the youth hostel. We found a lake and went boating. We stopped for orange juice on the way home and I was sick!

If any one knows anything about her then please contact me.

After Virgin Anytime (or whatever they are calling it now) was released I checked to see if there were any publicly available API's I could use. It seemed a bit pointless to contact them directly. Their current API is tuned (I hope) for their TV guide and I couldn't find any API's which had channel number and channel name in the same file.

I'm here again and there is still no API, and they have changed the format of their PDF so I get to throw away all the converting tools I wrote last time. This time however I discovered that someone have put the list on Wikipedia. It's all obviously in HTML so more tools needed, but at least the tools are simpler!

I can't let Virgin Media stand in the way of progress so I'm publishing the Virgin Media Channel Guide in JSON here. The format is pretty straight forward.

{"date":"2018-03","channels":[
{"num":100, "name":"Virgin Media Previews"},
...
]}

I'd never used AngularJS (version 1) before so I wrote the filter using it!

'B' indicates bytes and 'b' indicates bits so for example, if you want to find out how many megabytes of transfer you can get from a 100 megabit network card then:

1. Enter 100 in the In unit box.
2. Select Mb (Megabits) from the In unit drop down.
3. Select MB (Megabytes) from the Out unit drop down.

• Bugs
  • Change owner
  • Change date submitted
• Monitor
  • Add monitor to an issue
  • Delete monitor from issue
• Bugnotes
  • Add bugnote
  • Move bugnote
  • Modify time tracking
  • Modify time
  • Modify owner
• Categories
  • Modify category
  • Delete category

Confirmation is required before any changes will be made. The SQL which will be executed is displayed and the SQL needed to rollback the change is also given, just in case!

Requirements

1. Currently only tested using MantisBT 1.2.8 but may work with later versions.
2. Requires _mysql Python module to be available.

Installation

1. Download the file and place it in a directory on your PATH.
2. Edit and change the MySQL access credientials in the CONFIG section.
3. Save and run!

Example usage

MantisBT Database Tweaker v2.0
==============================

Bugs
----
1) Change owner

Monitor
-------
2) Add monitor to an issue
3) Delete monitor from issue

Bugnotes
--------
4) Add bugnote
5) Move bugnote
6) Modify time tracking
7) Modify time
8) Modify owner

Categories
----------
9) Modify category
10) Delete category

Enter selection (return to exit): 8

=====================
Change bugnote owner
---------------------

  4 Marcel       Wave                 user1
 32 Sid          Snot                 user2
 31 Cupid        Stunt                user3

Select user id:  32
Enter bugnote number:  123
Change owner of 'My email is broken' to 'Sid Snot (32)'
[y/n]: y

Rollback: UPDATE mantis_bugnote_table SET reporter_id = 4 WHERE id = 123
UPDATE mantis_bugnote_table SET reporter_id = 32 WHERE id = 123

Source

GitHub
Repo	https://github.com/davidnewcomb/mantisbtdatabasetweaker
Clone	https://github.com/davidnewcomb/mantisbt_database_tweaker.git
Zip	https://github.com/davidnewcomb/mantisbtdatabasetweaker/archive/master.zip

More information can be found in my blog: MantisBT Database Tweaker

GitHub
Repo	https://github.com/davidnewcomb/freephp_plugin
Clone	https://github.com/davidnewcomb/freephp_plugin.git
Zip	https://github.com/davidnewcomb/freephp_plugin/archive/master.zip

Take a look at my blog page B2evolution - FreePHP Widget Plugin for more information.

Do you need anyone to write a plugin for you? Then contact me.