= ID Label Printing =

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

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.

== 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

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 BRU Shared Drive at the address:
X:\Cardiovascular Sciences\webaccess\BRU\BRICCS\IT Solutions\Label Design\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)