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

BAG LABEL PRINTER ZBR3688678

GENVASC PRINTER IN CRC LAB OFFICE ZBR3713388

Note that from February 2013 the UHL no longer allocates fixed IP addresses for printers. As a result, the printers must be referenced by their device name, as above.

Label Design and Test Printing

Instructions how to reverse engineer label formats 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

There are also manuals and documentation on how to create a label format control code text string for submission to the printer.

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.