CarLogger

Windows Desktop Application – Archived February 2022

I have created this project for the fun of it. The idea came from after I took my car for a service and had to have new tires fitted onto the front wheels. The idea was for a application to keep track of the things that happened and been done to the car, then there is always a history of the events, for example, when last you have rotated the tires or what the last km reading was when it went for a service.

I have created the project in Java with Swing for the graphical user interface. I’m using Git for the version control. For the IDE I’m using Eclipse Mars and storing the repository on GitHub (Public). I’m keeping the project plain and simple. Still a few things that I want to add to improve the project a little bit more.

I have added a folder to keep the compiled and prepared native files (in CarLogger-native folder) of the CarLogger program that connects to an SQLite3 database. You can download the repository and the folder ‘CarLogger-native’ can then be copied to a directory and can be run from that directory. No installation is required.

You can have a look at the repository and/or download CarLogger files at:
https://github.com/pieter-duplessis/CarLogger

Tech Stack:

• Language: Groovy/Java
• Framework: Grails
• Database: MySQL
• Hosting: AWS – Elastic Beanstalk, RDS MySQL

MSP Planning

Windows Desktop Application – Archived November 2018

With trying to improve the workflow and keeping better track of all the orders and scheduling of jobs for a department I worked in, I expanded a Excel document, that I started with, to a point where I was looking to make it more effective and practical and got the idea to write my own application.

Now I have a working application that is used on a daily basis at that department. The application has significantly improved workflow and reduced time of monotonous tasks through automating them.

The application launched end of May 2017. I wrote the application in Java (Desktop application) and used MySQL for the database. For ‘live’ data there is also a connection to Sage’s database to get live data on products and their status.

Features and Benefits:

• Have one file/application to access all the information in one place.
• Have the file/application accessible to everyone in the department.
• Auto-complete job cards just by selecting the job number.
• View ‘live’ data for a specific item, what is on hand and what is on order from overseas suppliers in conjunction with a connection to Sage’s Database.
• Generate monthly report with all open orders and completed orders for the previous month.
• List all of the items and their components that are on order with quantities.
• Searching for information.
• Statistics for orders placed on a unit or on a component (By month for the current and previous 3 years).
• Check availability of component showing currently on order, what

Tech Stack:

• Language: Java with Swing
• Database: MySQL, MS SQL

MSP Stock

Windows Desktop Application – Archived November 2018

Created to make it easier to view information from Sage x3 MS SQL database by having all the information in one place. The application was made available to the departments who used the information at a previous employer.

The idea for this application stem from one of my other applications, MSP Planning. The feature that inspired this is Component Status. After I improved the Component Status feature in the MSP Planning application to not only include information from my application, but also all the information that I required from Sage X3 to do quotes, estimates and checking pricing, all on one screen, I decided to share an similar concept with coworkers which is MSP Stock application.

I wrote the program in Java (Desktop Application) with the Eclipse IDE. MSP Stock gets data from Microsoft SQL Server and from MySQL.

Features:

Check Stock:

Search for part numbers with stock availability and then to show all the required information for the selected part number on one screen instead of jumping between different screens to get the required information, like on Sage X3 or other applications that were made available to us.

Link-Belt Component Status

This feature is an copy from the MSP Planning application, follow the link for more information on this feature.

Tech Stack:

• Language: Java with Swing
• Database: MS SQL

TransmissionCalc

Windows Desktop Application – Archived November 2018

I created this applications to use at a previous employer when I started to learn coding.

The idea behind the application was to ease up my work by having most information in one package, aiding in my day-to-day activity, and also adding some simplicity, instead of pulling a bunch of different catalogs to get the information that I needed. This included the standard part numbers with basic information about the part number with some calculations that were performed on a regular basis.

The first application was created with Python 2.7 (Console based), I created the runnable application file, exe, with the py2exe module in Python.

The Second one I created with Python 3.4 and TkInter for the graphical user interface. Created the runnable application file, exe with cx_Freeze and created MSI Installation package for the installation thereof.

Tech Stack:

• Language: Python 2.7 & 3.4
• Compiling and packages: py2exe and cx_Freeze

Employees Project

Windows Desktop Application – Archived November 2020

The project was created in Java with Swing using Eclipse Mars and used SQLite3 for the database. The exe application was compiled with Launch4J application.

This project was created on request to capture absenteeism, keep track of I.O.U’s and have lists of employees and contact information.

This was my first Java application that I have created.

Tech Stack:

• Language: Java with Swing
• Database: SQLite3
• Packaging: Launch4J