Getting Unused Kit Barcodes Report

1 Introduction
2 Prerequisite
3 Encrypting Passwords
4 Program files
5 How to run?
6 How to schedule the program in Windows?

Introduction

Repositories that create specimen kits distribute them across multiple collection sites. Over time, tracking unused kits becomes challenging. This Java program generates a CSV report of unutilized kit barcodes from the database and sends it via email.

Prerequisite

A. Create a file config.properties with the below attributes.
B. Configure all the values those are needed.

Attributes	Description

Attributes	Description
jdbcURL	Database connection string
dbUser	Username of the database.
dbPassword	Encrypted password of the database user.
accountId	Account ID that is used for authentication with the email server to send email.
fromEmailId	Address to use in the From header of the emails sent by program.
emailPassword	Encrypted password of the email account.
toEmailIds	Comma separated email ids. (e.g. a@test.com, b@test.com, c@test.com)
smtpServerHost	Hostname or IP address of the SMTP server to connect for sending email.
smtpServerPort	SMTP server port to connect for sending email messages.
startTLS	Enable if StartTLS is to be used for your email server. (Values: true/false)
environment	Add environment type. (e.g. TEST/TRAIN/DEV/PROD)

Encrypting Passwords

For the security purpose, we need to encrypt the passwords of DB and email. Use the below code to generate the encrypted password and update those in the config file.

Description	File

Description	File
Java code

How to run the above program:

javac PasswordEncryption.java
java PasswordEncryption '<PASSWORD_TO_ENCRYPT>'

Copy the encrypted password in the config file.

Program files

Description	Files

Description	Files
Jar File
Config file

How to run?

Download the above files to your computer.
Configure the config.properties file.
Command to run:
java -jar GetUnusedKitBarcodes.jar config.properties

How to schedule the program in Windows?

Open Task Scheduler (Win + R, then type taskschd.msc and press Enter).
Click Create Basic Task from the right panel.
Give a name and description, then click Next.
Select Weekly(Or any interval that you want), then click Next.
Choose the start date/time and repeat every 1 day/week/month, then click Next.
Select Start a Program and click Next. In the Program/script field, enter:
java -jar "C:\path\to\GetUnusedKitBarcodes.jar" "C:\path\to\config.properties" >> "C:\path\to\output.log" 2>&1

Replace "C:\path\to\..." with the actual paths of your files.
The >> "C:\path\to\output.log" 2>&1 will redirect both standard output and errors to output.log.

OpenSpecimen