ID Label Printing

There is a webapp for generating BPt and BSa numbers and printing barcodes for both using two Zebra printers.

The war file is available for download from ​http://mvn.briccs.org.uk/org/bru/briccs/briccs-labels-webapp/

The output for a 'pack' is three bag labels and eight sample labels.

As of 09 June 2011 the label printing application and the two printers are housed on the HOSPITAL network. Prior to this date, the system was on the University network. The database of used numbers was migrated at this point so continuity was maintained.

The URL for accessing the label webapp, which is delivered through tomcat on the same servers as Onyx, is:

​http://briccs.xuhl-tr.nhs.uk:8080/labels/

But it is also accessible, thanks to an Apache 'redirect' on briccs-3.rcs.le.ac.uk, at:

​http://services.briccs.org.uk/labels - which is the same address that we used before on the University network. Nice!

This database needs to be backed up alongside the Onyx database. This is accomplished using the hourlydbdump.sh script in /home/nrh11 on the app server.

There is a comparable set of files on the hospital dev and devdb VMs.

Current version is 1.0.4 as per tickets #132 and #133 which allow for printing of bags only as well as specimen only, and also allow the webapp to be deployed at any path within tomcat.

Technical info on printers

SAMPLE LABEL PRINTER ZBR3687851 When on University: 143.210.247.156 When on Hospital: 125.200.4.45 or "ZBR3687851.xuhl-tr.nhs.uk"

BAG LABEL PRINTER ZBR3688678 When on University: 143.210.247.187 When on Hospital: 125.200.4.46 or "ZBR3688678.xuhl-tr.nhs.uk"

University: Subnet Mask: 255.255.255.000 Default Gateway: 143.210.247.001 WINS server IP: 000.000.000.000

Note that from February 2013 the UHL no longer allocates fixed IP addresses for printers. At some point, we may need to update this process so the printers can be addressed by hostname rather than IP address, but for the time being, it works.

Hospital: Subnet mask: 255.0.0.0 Default Gateway: 125.100.100.100 WINS server IP: 10.147.126.165

Label Design and Test Printing

Instructions how to edit labels and print them out on a Zebra test printer can be found on the BRU Shared Drive at the address: X:\Cardiovascular Sciences\webaccess\BRU\BRICCS\IT Solutions\Label Design\labeldevelopment\Label Editing and Test Printing.docx

MySQL configuration

+---------------------+
| Tables_in_briccsids |
+---------------------+
| identifiers         | 
| idranges            | 
+---------------------+
2 rows in set (0.01 sec)

mysql> describe identifiers;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| ID    | varchar(32) | NO   | PRI | NULL    |       | 
+-------+-------------+------+-----+---------+-------+
1 row in set (0.02 sec)

mysql> describe idranges;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| PK        | varchar(64) | NO   | PRI | NULL    |       | 
| PREFIX    | varchar(8)  | NO   |     | NULL    |       | 
| FROMVALUE | bigint(20)  | NO   |     | NULL    |       | 
| TOVALUE   | bigint(20)  | NO   |     | NULL    |       | 
| STATUS    | varchar(8)  | NO   |     | NULL    |       | 
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

Configuration

1. The briccs-labels-webapp is deployed into /usr/local/briccs-webapps on the server.

2. Database configuration is done in WEB-INF/classes/hibernate.cfg.xml

3. The template files should also be in the WEB-INF/classes/ directory

4. The printer configurations should be in the WEB-INF/classes/org/bru/briccs/labels/webapp/Printer.properties file.