= 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.3 - there is a version under development (1.0.4) as per ticket #132 which will allow for printing of bags only as well as specimen only.

== Technical info on printers ==

SAMPLE LABEL PRINTER
ZBR3687851
When on University: 143.210.247.156
When on Hospital: 125.200.4.45

BAG LABEL PRINTER
ZBR3688678
When on University: 143.210.247.187
When on Hospital: 125.200.4.46

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:

Note: For versions up to and including 1.0.4 the webapp must be deployed at '/labels' - this is hard-coded into the jsp form so other URLs will not work. This should be fixed at some point (#133).